[
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)
