[Spacewalk-list] Error Upgrading from 1.6 -> 1.7

[Wojtak, Greg (Superfly)]

I've retried the schema upgrade to go from 1.6 -> 1.7.  The schema upgrade
makes it all the way through to the final sql file
(111-rhnPackageKey-data.sql) and dies with:

ERROR:  duplicate key value violates unique constraint "rhn_pkey_keyid_uq"

Looks like the rows partially exist already - the package_id field is
empty in these three cases.

Greg Wojtak
Sr. Unix Systems Engineer
Office: (313) 373-4306
Cell: (734) 718-8472





On 2012-10-12 1:00 PM, "Jan Pazdziora" <jpazdziora at redhat.com> wrote:

>On Fri, Oct 12, 2012 at 04:50:53PM +0000, Wojtak, Greg (Superfly) wrote:
>> I got an error doing an upgrade from 1.6 to 1.7 today.  The error
>>occurred doing the schema update.  From the log, I get:
>> 
>>                                  ?column?
>> 
>>-------------------------------------------------------------------------
>>--
>>  
>>spacewalk-schema-1.6-to-spacewalk-schema-1.7/007-rhnPackageGroup-trim.sql
>> (1 row)
>> 
>> UPDATE 41615
>> psql:/var/log/spacewalk/schema-upgrade/20121012-123027-script.sql:445:
>>ERROR:  update or delete on table "rhnpackagegroup" violates foreign key
>>constraint "rhn_pkgsrc_group_fk" on table "rhnpackagesource"
>> DETAIL:  Key (id)=(22) is still referenced from table
>>"rhnpackagesource".
>> 
>> Any help is greatly appreciated!
>
>Please restore the database from backup, replace the
>007-rhnPackageGroup-trim.sql file with the current version from
>
>	http://git.fedorahosted.org/cgit/spacewalk.git/tree/schema/spacewalk/upgr
>ade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/007-rhnPackageGroup-trim.
>sql
>
>and rerun the spacewalk-schema-upgrade.
>
>-- 
>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