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):
Steps to Reproduce:
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
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.
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.
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.