Bug 1726683 - PG::TRDeadlockDetected: ERROR: deadlock detected when deleting an Organization
Summary: PG::TRDeadlockDetected: ERROR: deadlock detected when deleting an Organization
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Organizations and Locations
Version: 6.4
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: 6.6.0
Assignee: Justin Sherrill
QA Contact: Peter Dragun
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2019-07-03 12:32 UTC by Evgeni Golov
Modified: 2019-10-22 19:48 UTC (History)
1 user (show)

Fixed In Version: tfm-rubygem-katello-3.12.0.7-1
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2019-10-22 19:48:35 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Foreman Issue Tracker 26821 0 High Closed PG::TRDeadlockDetected: ERROR: deadlock detected when deleting an Organization 2020-06-15 14:51:48 UTC

Description Evgeni Golov 2019-07-03 12:32:57 UTC
From time to time, I see the following error in our nightly pipelines:

<pre>
not ok 1 Delete an Organization
# (in test file fb-destroy-organization.bats, line 15)
#   `hammer organization delete --name="${ORGANIZATION}"' failed with status 70
# Task fdb90a4d-89fc-4509-9bee-b87f7fbb5e89 planned: 0.0/1, 0%, elapsed: 00:00:00
# Task fdb90a4d-89fc-4509-9bee-b87f7fbb5e89 running: 0.021739130434782608/1, 2%, 0.0/s, elapsed: 00:00:02, ETA: 00:01:55
# Task fdb90a4d-89fc-4509-9bee-b87f7fbb5e89 running: 0.16304347826086957/1, 16%, 0.0/s, elapsed: 00:00:05, ETA: 00:00:28
# Task fdb90a4d-89fc-4509-9bee-b87f7fbb5e89 running: 0.2391304347826087/1, 23%, 0.0/s, elapsed: 00:00:07, ETA: 00:00:25
# Task fdb90a4d-89fc-4509-9bee-b87f7fbb5e89 running: 0.32608695652173914/1, 32%, 0.0/s, elapsed: 00:00:09, ETA: 00:00:20
# Task fdb90a4d-89fc-4509-9bee-b87f7fbb5e89 running: 0.4782608695652174/1, 47%, 0.0/s, elapsed: 00:00:12, ETA: 00:00:12
# Task fdb90a4d-89fc-4509-9bee-b87f7fbb5e89 running: 0.6739130434782609/1, 67%, 0.0/s, elapsed: 00:00:14, ETA: 00:00:06
# Task fdb90a4d-89fc-4509-9bee-b87f7fbb5e89 error: 0.75/1, 75%, 0.1/s, elapsed: 00:00:16, ETA: 00:00:04
# Task fdb90a4d-89fc-4509-9bee-b87f7fbb5e89 error: 0.75/1, 75%, 0.1/s, elapsed: 00:00:16, ETA: 00:00:04
# Error: PG::TRDeadlockDetected: ERROR:  deadlock detected
# DETAIL:  Process 20568 waits for ShareLock on transaction 18434; blocked by process 23406.
# Process 23406 waits for ShareLock on transaction 18406; blocked by process 20568.
# HINT:  See server log for query details.
# : DELETE FROM "katello_pool_products" WHERE "katello_pool_products"."id" = $1
</pre>

Comment 1 Evgeni Golov 2019-07-03 12:33:00 UTC
Created from redmine issue https://projects.theforeman.org/issues/26821

Comment 2 Evgeni Golov 2019-07-03 12:33:02 UTC
Upstream bug assigned to jsherril

Comment 5 Bryan Kearney 2019-07-03 14:02:52 UTC
Moving this bug to POST for triage into Satellite 6 since the upstream issue https://projects.theforeman.org/issues/26821 has been resolved.

Comment 7 Peter Dragun 2019-08-26 13:00:15 UTC
Verified on Satellite 6.6 snap 17. Trying to reproduce bug by deleting multiple organizations. Everything works fine, no error occurred in logs.

Comment 8 Bryan Kearney 2019-10-22 19:48:35 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-2019:3172


Note You need to log in before you can comment on or make changes to this bug.