Bug #25876
closedRace condition on removing multiple organizations simultaneously
Description
Description of problem:
Hitting db constraints when trying to delete multiple organizations at the same time.
LANG=en_US.UTF-8 hammer -v -u admin -p changeme organization delete --name="\xe9\xbe\xa3\xe9\xbc\x84\xe8\xbe\xbd\xe6\x98\xb4"
Task ef128feb-1d73-4161-81c8-731d6b64789a planned: 0.0/1, 0%, elapsed: 00:00:00
Task ef128feb-1d73-4161-81c8-731d6b64789a running: 0.9090909090909091/1, 90%, 0.4/s, elapsed: 00:00:02
Task ef128feb-1d73-4161-81c8-731d6b64789a error: 0.9545454545454546/1, 95%, 0.2/s, elapsed: 00:00:04
Task ef128feb-1d73-4161-81c8-731d6b64789a error: 0.9545454545454546/1, 95%, 0.2/s, elapsed: 00:00:04
Error: PG::ForeignKeyViolation: ERROR: update or delete on table "taxonomies" violates foreign key constraint "taxable_taxonomies_taxonomy_id_fk" on table "taxable_taxonomies"
DETAIL: Key (id)=(28) is still referenced from table "taxable_taxonomies".
: DELETE FROM "taxonomies" WHERE "taxonomies"."type" IN ('Organization') AND "taxonomies"."id" = $1
Steps to Reproduce:
Try to delete multiple organizations at the same time. Not reproducible each time due to the nature of the bug.
Updated by Ondřej Pražák over 5 years ago
- Project changed from Foreman to Katello
- Subject changed from Race condition on removing multiple organizations simultaneously to Race condition on removing multiple organizations simultaneously
- Category changed from Organizations and Locations to Organizations and Locations
Updated by The Foreman Bot over 5 years ago
- Status changed from New to Ready For Testing
- Assignee set to Ondřej Pražák
- Pull request https://github.com/Katello/katello/pull/8291 added
Updated by James Jeffers over 5 years ago
- Target version set to Katello 3.14.0
- Triaged changed from No to Yes
Updated by Marek Hulán over 5 years ago
- Status changed from Ready For Testing to New
- Pull request deleted (
https://github.com/Katello/katello/pull/8291)
Updated by The Foreman Bot about 5 years ago
- Status changed from New to Ready For Testing
- Pull request https://github.com/Katello/katello/pull/8391 added
Updated by The Foreman Bot about 5 years ago
- Fixed in Releases Katello 3.15.0 added
Updated by John Mitsch about 5 years ago
- Status changed from Ready For Testing to Closed
Applied in changeset katello|4b596935cd9da45f5252d4f8856832467c0e73b6.