Bug 1394369

Summary: slow SQL query: UPDATE "architectures" SET "hosts_count" = COALESCE("hosts_count", 0) + 1 WHERE "architectures"."id" = 1;
Product: Red Hat Satellite Reporter: Bryan Kearney <bkearney>
Component: InfrastructureAssignee: Tomer Brisker <tbrisker>
Status: CLOSED ERRATA QA Contact: Lukas Zapletal <lzap>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: adprice, bbuckingham, cduryee, ehelms, inecas, jcallaha, jhutar, lzap, mmccune, nitthoma, psuriset, sthirugn, xdmoon
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: foreman-1.15.3-2 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: 1341338 Environment:
Last Closed: 2018-02-21 16:51:07 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 1341338    
Bug Blocks:    

Comment 2 Bryan Kearney 2016-11-11 21:03:50 UTC 
Upstream bug assigned to tbrisker
Comment 3 Bryan Kearney 2016-11-11 21:03:55 UTC 
Upstream bug component is Infrastructure
Comment 4 Bryan Kearney 2016-11-11 21:03:59 UTC 
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/12193 has been resolved.
Comment 5 Lukas Zapletal 2017-08-30 12:23:37 UTC 
Counter cache columns are all gone in foreman-1.15.3-2 or newer. It is impossible to hit this SQL error. If we run into deadlocks, it's a different BZ. VERIFIED

[root@zzzap ~]# rpm -q foreman katello
foreman-1.15.3-2.el7sat.noarch
katello-3.4.4-2.el7sat.noarch
Comment 6 Satellite Program 2018-02-21 16:51:07 UTC 
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA.
> 
> For information on the advisory, and where to find the updated files, follow the link below.
> 
> If the solution does not work for you, open a new bug report.
> 
> https://access.redhat.com/errata/RHSA-2018:0336