Project

General

Profile

Actions

Bug #26821

closed

PG::TRDeadlockDetected: ERROR: deadlock detected when deleting an Organization

Added by Evgeni Golov over 5 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
High
Category:
Organizations and Locations
Target version:
Difficulty:
Triaged:
Yes
Fixed in Releases:
Found in Releases:

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

Related issues 1 (0 open1 closed)

Related to Katello - Bug #25711: org delete sometimes fails on product/destroy.rbClosedJustin SherrillActions
Actions

Also available in: Atom PDF