Description of problem: While trying to upgrade from 2.5 to 2.6, I ran into a schema upgrade failure that caused me to revert to my database backup. Version-Release number of selected component (if applicable): 2.6 How reproducible: Steps to Reproduce: 1. /usr/bin/spacewalk-schema-upgrade 2. 3. Actual results: delete from rhnChannelArch where label = 'channel-i386-sun-solaris' * ERROR at line 1: ORA-02292: integrity constraint (SPACEWALK.RHN_CHANNEL_CAID_FK) violated - child record found Expected results: Successful upgrade. Additional info:
Hi Team, I see that this is assigned... is anyone looking at this? I have used this Spacewalk instance for about 6 years now... upgrading all the way up from early 1.x ... so, I suspect I have something REALLY old in my database that just wasn't cleaned up from previous upgrades. This problem is preventing me from really using my Spacewalk instance.
Hello, I was looking at this problem and there is broken upgrade script. I will try to prepare updated package.
Could you try to download and install one of following new spacewalk-schema builds which should have fixed this? Install this package before running spacewalk-schema-upgrade. RHEL6: http://koji.spacewalkproject.org/koji/buildinfo?buildID=45366 RHEL7: http://koji.spacewalkproject.org/koji/buildinfo?buildID=45367 FC23: http://koji.spacewalkproject.org/koji/buildinfo?buildID=45368
Yup, that fixed it for me. Nicely done!
According to comment #4 the issue has been fixed; closing. If you disagree feel free reopen the bug.