[Spacewalk-list] 0.7 to 0.8 upgrade error - in last step

[Jason Ball]

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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100627/93d8d302/attachment.htm>