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

[Jason Ball]

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 <jason at ball.net> 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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100627/61cbe23b/attachment.htm>