Bug 1394369 - slow SQL query: UPDATE "architectures" SET "hosts_count" = COALESCE("hosts_count", 0) + 1 WHERE "architectures"."id" = 1;
Summary: slow SQL query: UPDATE "architectures" SET "hosts_count" = COALESCE("hosts_co...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Infrastructure
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
unspecified
medium vote
Target Milestone: Unspecified
Assignee: Tomer Brisker
QA Contact: Lukas Zapletal
URL:
Whiteboard:
Depends On: 1341338
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-11-11 19:56 UTC by Bryan Kearney
Modified: 2019-12-16 07:22 UTC (History)
13 users (show)

Fixed In Version: foreman-1.15.3-2
Doc Type: If docs needed, set a value
Doc Text:
Clone Of: 1341338
Environment:
Last Closed: 2018-02-21 16:51:07 UTC
Target Upstream Version:

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Foreman Issue Tracker 12193 0 None None None 2016-11-11 19:56:22 UTC

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
Note You need to log in before you can comment on or make changes to this bug.