[jira] [Updated] (AMBARI-20847) Remove Refresh Query Hint From Upgrade DAO

["Jonathan Hurley (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/AMBARI-20847?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jonathan Hurley updated AMBARI-20847:
-------------------------------------
    Attachment: AMBARI-20847.patch

> Remove Refresh Query Hint From Upgrade DAO
> ------------------------------------------
>
>                 Key: AMBARI-20847
>                 URL: https://issues.apache.org/jira/browse/AMBARI-20847
>             Project: Ambari
>          Issue Type: Task
>          Components: ambari-server
>    Affects Versions: 2.4.0
>            Reporter: Jonathan Hurley
>            Assignee: Jonathan Hurley
>            Priority: Critical
>             Fix For: 2.5.1
>
>         Attachments: AMBARI-20847.patch
>
>
> Repeated requests to the {{org.apache.ambari.server.orm.dao.UpgradeDAO}} methods during upgrades can cause large delays retrieving active upgrades. This is because the {{QueryHint.REFRESH}} is being used in almost every method. This causes a re-read on every {{UpgradeEntity -> UpgradeGroupEntity -> UpgradeItemEntity}} in the entire database for every query.
> These query hints should be removed.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)