Actions
Bug #26821
closedPG::TRDeadlockDetected: ERROR: deadlock detected when deleting an Organization
Status:
Closed
Priority:
High
Assignee:
Category:
Organizations and Locations
Target version:
Difficulty:
Triaged:
Yes
Bugzilla link:
Pull request:
Description
From time to time, I see the following error in our nightly pipelines:
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
Updated by Evgeni Golov over 5 years ago
- Related to Bug #25711: org delete sometimes fails on product/destroy.rb added
Updated by John Mitsch over 5 years ago
- Category set to Organizations and Locations
- Target version set to Katello 3.13.0
- Triaged changed from No to Yes
Updated by The Foreman Bot over 5 years ago
- Status changed from New to Ready For Testing
- Assignee set to Justin Sherrill
- Pull request https://github.com/Katello/katello/pull/8185 added
Updated by Justin Sherrill over 5 years ago
- Status changed from Ready For Testing to Closed
Applied in changeset katello|b20f298d3cebf4c19e6322f1e769939e5d3c749e.
Actions