[Spacewalk-list] Spacewalk 1.4 and Oracle 11g

[Mario Mikocevic]

Heya,

following patch fixed it and it works now with external Oracle11g ->

# pwd
/etc/sysconfig/rhn/oracle
# diff -u main.sql-20110504 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'));



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'));
> 
> 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

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