[Spacewalk-list] Spacewalk 1.4 and Oracle 11g

[Jan Pazdziora]

On Wed, May 04, 2011 at 12:54:49PM +0200, Mario Mikocevic wrote:
> Heya,
> 
> fresh install of CentOS 5.6, fully updated with additional repos spacewalk-repo-1.4 and epel.
> 
> Oracle11g (full) on another cluster, tablespace and user spacewalk with some grants created.
> 
> 
> spacewalk-setup --disconnected
> barfs ->
> 
> ** Database: Re-populating database.
> *** Progress: ##
> Could not populate database.
> 
> 
> /var/log/rhn/populate_db.log ->
> 
> insert into rhnPackageSyncBlacklist (package_name_id)
> *
> ERROR at line 1:
> ORA-02291: integrity constraint (SPACEWALK.RHN_PACKAGESYNCBL_PNID_FK) violated - parent key not found
> 
> 
> traint (SPACEWALK.RHN_PACKAGESYNCBL_PNID_FK) violated - parent key not found
> 
> 
> any help ?

The command which fails for you is likely the

	insert into rhnPackageSyncBlacklist (package_name_id)
	        values (lookup_package_name('gpg-pubkey'));

one. That lookup_package_name should create record in rhnPackageName
in separate transaction, commit, and return the id.

This looks like the commit did not go through.

Can you do

	select lookup_package_name('xxxxx') from dual

within a transaction and then check the rhnPackageName that it indeed
has the new record in it?

Are you by any chance using some non-standard isolation level in your
database?

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat