On 2012-10-12 1:00 PM, "Jan Pazdziora" <[email protected]> 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 >[email protected] >https://www.redhat.com/mailman/listinfo/spacewalk-list This fixed part of the issue, but one of the other updates fails. It's the first update after the delete, and the issue is that it is trying to strip newlines off of the rhnpackagegroup.name column. In my database, I have several instances of, say "System/Libraries" and "System/Libraries\n" so the unique naming constraint is being violated and the update fails (as it should). I only have five different groups, so I can go through and fix them in the rhnpackages and rhnpackagesource tables, but thought I'd let you know. Greg Wojtak Sr. Unix Systems Engineer Office: (313) 373-4306 Cell: (734) 718-8472 _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
