[AMBARI-20847] Remove Refresh Query Hint From Upgrade DAO

• Type: Task
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.4.0
• Fix Version/s: 2.5.1
• Component/s: ambari-server
• Assignee: Jonathan Hurley
• Reporter: Jonathan Hurley
• Created: 25/Apr/17 16:35
• Updated: 25/Apr/17 22:55
• Resolved: 25/Apr/17 22:55

Description

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.

Issue Links

• links to: Reviewboard