Bug 983994

Summary: Ugly error when creating org with initial env of "Library"
Product: Red Hat Satellite Reporter: Jeff Weiss <jweiss>
Component: Content ManagementAssignee: David Davis <daviddavis>
Status: CLOSED CURRENTRELEASE QA Contact: Kedar Bidarkar <kbidarka>
Severity: medium Docs Contact:
Priority: unspecified    
Version: NightlyCC: dajohnso, daviddavis, jmontleo, kbidarka, mmccune
Target Milestone: UnspecifiedKeywords: Regression, Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-04-24 17:10:21 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:
Attachments:
Description Flags
initial env library disallowed now none

Description Jeff Weiss 2013-07-12 13:36:34 UTC 
Description of problem:


Version-Release number of selected component (if applicable):
1.4.2-1.git.837.d2ca1b8.el6

How reproducible:


Steps to Reproduce:
1. Create org with initial env "Library"
2.
3.

Actual results:
ERROR: update or delete on table "organizations" violates foreign key constraint "environments_organization_id_fk" on table "environments" DETAIL: Key (id)=(44) is still referenced from table "environments". (PGError) 

Expected results:
Something about name already taken or "Library is not a valid environment name".

Additional info:
Comment 1 RHEL Program Management 2013-09-17 04:23:06 UTC 
Since this issue was entered in Red Hat Bugzilla, the release flag has been
set to ? to ensure that it is properly evaluated for this release.
Comment 5 Mike McCune 2013-10-10 04:36:51 UTC 
Can't reproduce this.  ON_QA
Comment 6 David Davis 2013-10-10 14:34:26 UTC 
I was able to reproduce. I get this error:

[FATAL 2013-10-10 10:33:45 app] 
 | PG::ForeignKeyViolation (ERROR:  update or delete on table "organizations" violates foreign key constraint "environments_organization_id_fk" on table "environments"
 | DETAIL:  Key (id)=(27) is still referenced from table "environments".
 | ):
 |   app/models/glue.rb:93:in `destroy'
 |   app/controllers/organizations_controller.rb:130:in `ensure in create'
 |   app/controllers/organizations_controller.rb:130:in `create'
 |   app/lib/util/thread_session.rb:110:in `thread_locals'
 |   config/initializers/quiet_paths.rb:11:in `call_with_quiet'
 |   lib/katello/middleware/log_request_uuid.rb:22:in `call'
 |   app/controllers/organizations_controller.rb:108:in `create'
 | 


I've opened a PR to address this:

https://github.com/Katello/katello/pull/3156
Comment 7 Mike McCune 2013-10-10 16:18:20 UTC 
*** Bug 1017629 has been marked as a duplicate of this bug. ***
Comment 8 David Davis 2013-10-14 16:49:43 UTC 
katello SHA 6e204be06eb836faf2b59139ec09b8847b842b59

983994: Fixing organization create with bad environment

Bug where organization was not getting deleted due to the library not being
deletable. The library is only deletable if the org is being destroyed (and has
a deletion task), therefore this was trigging a foreign key error.
Comment 11 Kedar Bidarkar 2013-10-21 13:13:28 UTC 
Created attachment 814597 [details]
initial env library disallowed now

We now do get a notification saying "Library" is a built-in env
Comment 12 Bryan Kearney 2014-04-24 17:10:21 UTC 
This was verified and delivered with MDP2. Closing it out.
Comment 13 Bryan Kearney 2014-04-24 17:11:39 UTC 
This was delivered and verified with MDP2. Closing the bug.