never mind. Found a workaround by manually updating the rhnPackageEvr table, not sure why the stored procedure isn't working as I simply ran the same updates.
On Sun, Jun 27, 2010 at 8:04 PM, Jason Ball <[email protected]> wrote: > Hi all, > > I'm updating from 0.6 to 1.0 and have received the following error on the > schema upgrade: > > SQL> insert into rhnVersionInfo > ( label, name_id, evr_id, created, modified ) > values ('schema', lookup_package_name('spacewalk-schema'), > lookup_evr(null, '0.8.15' , '1.el5' ), > sysdate, sysdate ); > 2 3 4 5 lookup_evr(null, '0.8.15' , '1.el5' ), > * > ERROR at line 4: > ORA-00001: unique constraint (SPACEWALK.RHN_PE_ID_PK) violated > ORA-06512: at "SPACEWALK.LOOKUP_EVR", line 16 > ORA-01403: no data found > > > From what I can tell the rest of the schema upgrade has gone to plan > without error. Any suggestions before I spend hours on this one ? > > J. > > > > -- > The era of procrastination, of half measures of soothing and baffling > expedients, of delays, is coming to an end. In it's place we are entering a > period of consequences. - Winston Churchill > <a href= > http://www.climatecrisis.net/downloads/ecards/preview-glacier1.html>An > Inconvenient Truth</a> > -- The era of procrastination, of half measures of soothing and baffling expedients, of delays, is coming to an end. In it's place we are entering a period of consequences. - Winston Churchill <a href=http://www.climatecrisis.net/downloads/ecards/preview-glacier1.html>An Inconvenient Truth</a>
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
