Bug 838039 - Integrity constraint during installation
Summary: Integrity constraint during installation
Keywords:
Status: CLOSED DEFERRED
Alias: None
Product: Spacewalk
Classification: Community
Component: Installation
Version: 1.7
Hardware: x86_64
OS: Linux
unspecified
unspecified
Target Milestone: ---
Assignee: Jan Pazdziora
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space18
TreeView+ depends on / blocked
 
Reported: 2012-07-06 07:53 UTC by Gerhardus Geldenhuis
Modified: 2012-11-01 16:23 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-07-11 19:03:06 UTC
Embargoed:


Attachments (Terms of Use)

Description Gerhardus Geldenhuis 2012-07-06 07:53:02 UTC
OS: Oracle Linux 5.8 (with Red Hat kernel, I want to emphasize that it is not my choice of OS)
Spacewalk:1.7
DB: Oracle, external 11.2.0.3.0 - 64bit
Client: SQL*Plus: Release 11.2.0.2.0

The spacewalk installation is on a beefy virtual machine.

I go through the installation instructions and get up to the spacewalk-setup --disconnected step. After it connects to the database it starts creating and the taskbar seems to be almost reaching a 100% but then fails:


The log entry is:
...
1 row created.
1 row created.
Commit complete.
insert into rhnPackageSyncBlacklist (package_name_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (SPACEWALKDBUSER.RHN_PACKAGESYNCBL_PNID_FK) violated - parent key not found

Is this a bug or some restriction on the database? I have little to no control over the DB but can relay information to the DBA if required.

Comment 1 Jan Pazdziora 2012-07-11 19:03:06 UTC
This seems like some esoteric issue with some Oracle RDBMS 11g versions. Please contact your Oracle support about the behaviour of autonomous transactions. Also see

https://www.redhat.com/archives/spacewalk-list/2011-May/msg00024.html


Note You need to log in before you can comment on or make changes to this bug.