Bug 1613391

Summary:	race condition on removing multiple organizations simultaneously
Product:	Red Hat Satellite	Reporter:	Roman Plevka <rplevka>
Component:	Organizations and Locations	Assignee:	Ondřej Pražák <oprazak>
Status:	CLOSED ERRATA	QA Contact:	Roman Plevka <rplevka>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	6.4	CC:	bkearney, egolov, jhutar, mmccune, oprazak, swadeley
Target Milestone:	6.8.0	Keywords:	AutomationBlocker, PrioBumpQA, Triaged
Target Release:	Unused
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	tfm-rubygem-katello-3.15.0	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:
Clones:	1901981 (view as bug list)		Environment:
Last Closed:	2020-10-27 12:57:24 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	1901981

Comment 3 Roman Plevka 2018-09-03 11:52:48 UTC

this also happens on creting new orgs just after sending out a request to delete another org:

2018-08-31T14:18:11 [I|app|] Started DELETE "/katello/api/v2/organizations/357"
...
2018-08-31T14:18:11 [I|app|ec227] Completed 202 Accepted in 530ms (Views: 21.4ms | ActiveRecord: 73.5ms)
...
2018-08-31T14:18:11 [I|app|] Started POST "/katello/api/v2/organizations"
...
2018-08-31T14:18:13 [E|bac|d4d50] PG::ForeignKeyViolation: ERROR:  insert or update on table "taxable_taxonomies" violates foreign key constraint "taxable_taxonomies_taxonomy_id_fk"
DETAIL:  Key (taxonomy_id)=(357) is not present in table "taxonomies".

Comment 5 Ondřej Pražák 2019-01-17 08:04:44 UTC

Created redmine issue http://projects.theforeman.org/issues/25876 from this bug

Comment 8 Roman Plevka 2019-07-30 08:10:46 UTC

Our automation also hit this on creating the Organization

Comment 10 Bryan Kearney 2019-08-22 08:06:41 UTC

Upstream bug assigned to oprazak

Comment 11 Bryan Kearney 2019-08-22 08:06:43 UTC

Upstream bug assigned to oprazak

Comment 12 Bryan Kearney 2019-11-05 20:33:25 UTC

Moving this bug to POST for triage into Satellite 6 since the upstream issue https://projects.theforeman.org/issues/25876 has been resolved.

Comment 18 errata-xmlrpc 2020-10-27 12:57:24 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 (Important: Satellite 6.8 release), 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-2020:4366