[Spacewalk-list] upgrade problems

[Jan Pazdziora]

On Sat, Nov 05, 2011 at 12:00:59AM +0100, rob morrien wrote:
> hello,
> 
> i got an upgrade problem from spacewalk 1.3 to 1.4
> 
> the message is ;
> 
> spacewalk-schema-upgrade
> No existing schema version info found in rhnVersionInfo.
> 
> I CHECKED THE 1.3 UPGRADE AND FOUND THE NEXT PROBLEM IN THE LOGFILE:
> 
> 'SPACEWALK-SCHEMA-1.2-TO-SPACEWALK-SCHEMA-1.3/017-RHNPACKAGEKEY-DATA.SQ
> -----------------------------------------------------------------------
> spacewalk-schema-1.2-to-spacewalk-schema-1.3/017-rhnPackageKey-data.sql
> 
> 
> 1 row created.
> 
> 
> 1 row created.
> 
> insert into rhnPackageKey (id, key_id, key_type_id, provider_id) values
> *
> ERROR at line 1:
> ORA-00001: unique constraint (SPACEWALK.RHN_PKEY_KEYID_UQ) violated

This means your schema upgrade from 1.2 to 1.3 never finished properly.

Did you insert something to rhnPackageKey manually?

> HOW CAN THIS BE FIXED SO I CAN UPGRADE FROM SPACEWALK TO 1.4 AND 1.5

I recommend you restore your 1.2 backup and proceed from there.

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