[Spacewalk-list] Spacewalk 1.6 on Oracle

[Jan Pazdziora]

On Thu, Jan 19, 2012 at 01:15:56PM +0000, BUPE(Peter Burgstaller) wrote:
> I have the same issue and use the following patch to work around the problem:
> 
> -----
> # 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'));
> -----

We've seen this workaround before but until we understand the nature
of the issue and why these would make the problem go away, I'm
resitant to include them in the distribution. Since we were not able
to reproduce the issue locally, we really cannot bring it up to the
database vendor support -- that's why I was asking people to do that.

On Thu, Jan 19, 2012 at 02:36:28PM +0100, Jan Šoc wrote:
> Hi,
> it is working!
> it is realy something! ;-)

It is not working.

You made the schema population pass but if it did not pass on your
database server without this workaround, chances are the same
constructs will fail throughout the life of your Spacewalk operation
on that database server. In other words -- your Spacewalk will
probably start to fail with other strange errors eventually.

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