[Spacewalk-list] Spacewalk 1.4 and Oracle 11g

[Mario Mikocevic]

Heya,

On 05/04/2011 01:20:11 PM, Jan Pazdziora wrote:
> On Wed, May 04, 2011 at 12:54:49PM +0200, Mario Mikocevic wrote:
> > 
> > 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'));

Yes, it is, just checked, 18 rows of '1 row created' and 'Commit complete.' corresponds with sql statement before.

> 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?

Yes, it has values 1, 2 and 3.

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

DBA says no.

-- 
T-Com
Odjel za upravljanje mrežom i uslužnim platformama /
/ Network and Service Platform Operations Department.
Radna jedinica za servisne mreže - T5.1.7
Mario Mikočević
Draškovićeva 26, Zagreb, 10000
+385  1 4913 800
+385  1 4913 860 (fax)
+385 98  470 801 (GSM)
mario dot mikocevic at t-com dot hr
http://www.t-com.hr