[Spacewalk-list] Spacewalk 1.4 and Oracle 11g
Mario Mikocevic
mario.mikocevic at t-com.hr
Wed May 4 12:31:37 UTC 2011
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
More information about the Spacewalk-list
mailing list