[Spacewalk-list] FW: Issue with Spacewalk 0.8 install on CentOS 5 and Oracle 11G

[Hooker, Jonathan]

When we merged your change with our current deploy.sql that fixed the problem. Thanks!

Jonathan Hooker
Desktop Support
Garmin International
jonathan.hooker at garmin.com

-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Jan Pazdziora
Sent: Friday, April 09, 2010 9:32 AM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] FW: Issue with Spacewalk 0.8 install on CentOS 5 and Oracle 11G

On Fri, Apr 09, 2010 at 04:23:35PM +0200, Jan Pazdziora wrote:
> On Wed, Apr 07, 2010 at 01:28:19PM -0500, Hooker, Jonathan wrote:
> > I have attached more information on the issues we are having importing deploy.sql into our oracle 11g database. Does anyone have any ideas as to why we are seeing these errors?
>
> Well, if you rerun the deploy, you should really drop the whole
> schema. Otherwise the sequence which populates one table is already
> set to something above 1, and the foreign key will fail.
>
> Yes, we probably should not be having that 1 hardcoded, but you are
> still better off to drop the schema and start anew.

In fact, I've just pushed change
4377bb4578ab4602c744e526c4fb8f2ef2875bf8 which addresses this.

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

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

--------------------------------------------------------------------------------
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies.

Thank you for your cooperation.