Created attachment 757011 [details] populate.db.log Description of problem: Oracle database spacewalk-setup --disconnected --external-db the Spacewalk installation fails with the following error in /var/log/rhn/populate_db.log ORA-02291: integrity constraint (SPACEWALK.RHN_PACKAGESYNCBL_PNID_FK) violated - parent key Version-Release number of selected component (if applicable): Spacewalk 1.9 How reproducible: Yes every time clean database Steps to Reproduce: 1. spacewalk-setup --disconnected --external-db 2. 3. Actual results: ORA-02291: integrity constraint (SPACEWALK.RHN_PACKAGESYNCBL_PNID_FK) violated - parent key Expected results: spacewalk would build all tables without error out. Additional info: Here is the problem that oracle found. diff -u /etc/sysconfig/rhn/oracle/main.sql-20110504 /etc/sysconfig/rhn/oracle/main.sql --- main.sql-20110504 2011-04-08 21:40:53.000000000 +0200 +++ main.sql 2011-05-04 14:20:24.000000000 +0200 @@ -38940,6 +38940,12 @@ -- Source: data/common/rhnPackageSyncBlacklist.sql + +select lookup_package_name('gpg-pubkey') from dual; + +select lookup_package_name('rhns-ca-cert') from dual; + +select lookup_package_name('rhn-org-trusted-ssl-cert') from dual; insert into rhnPackageSyncBlacklist (package_name_id) values (lookup_package_name('gpg-pubkey'));
(In reply to ajohnson from comment #0) > > Additional info: > > Here is the problem that oracle found. > > diff -u /etc/sysconfig/rhn/oracle/main.sql-20110504 > /etc/sysconfig/rhn/oracle/main.sql > --- main.sql-20110504 2011-04-08 21:40:53.000000000 +0200 > +++ main.sql 2011-05-04 14:20:24.000000000 +0200 > @@ -38940,6 +38940,12 @@ > > > -- Source: data/common/rhnPackageSyncBlacklist.sql > + > +select lookup_package_name('gpg-pubkey') from dual; > + > +select lookup_package_name('rhns-ca-cert') from dual; > + > +select lookup_package_name('rhn-org-trusted-ssl-cert') from dual; > > insert into rhnPackageSyncBlacklist (package_name_id) > values (lookup_package_name('gpg-pubkey')); This patch is incomplete and incorrect.
Please see bug 965305 comment 8.
Addressed in Spacewalk master, d2e4546fe40ca153ae7711366c21b6cf9d84ef1a and 66f17625b25ff470743ac4b197c6a47ba18f392b.
Fix for this bug is present in Spacewalk 2.0, closing this bug as CURRENTRELEASE.