[prev in list] [next in list] [prev in thread] [next in thread]
List: spacewalk-list
Subject: Re: [Spacewalk-list] Error Upgrading from 1.6 -> 1.7
From: "Wojtak, Greg (Superfly)" <GregWojtak () quickenloans ! com>
Date: 2012-10-23 14:40:01
Message-ID: CCAC2141.30969%gregwojtak () quickenloans ! com
[Download RAW message or body]
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@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@redhat.com
>https://www.redhat.com/mailman/listinfo/spacewalk-list
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic