You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ambari.apache.org by "Jonathan Hurley (JIRA)" <ji...@apache.org> on 2017/04/25 16:36:04 UTC

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

Jonathan Hurley created AMBARI-20847:
----------------------------------------

             Summary: 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


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)