Description of problem: When deleting a org that has records in the rhnContentSource a FK violation is thrown: 2012-03-27 08:20:15,324 [TP-Processor7] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[action] - Servlet.service() for servlet action threw exception java.sql.SQLException: ORA-02292: integrity constraint (RHNSAT.RHN_CS_ORG_FK) violated - child record found ORA-06512: at "RHNSAT.RHN_ORG", line 100 ORA-06512: at line 1 Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. Channels->Manage Software Channels->Manage Repos 2. create a repo 3. Login as admin and try to delete the org for above 4. FK contraint error in catalina.out Actual results: Expected results: Additional info: workaround is to manual delete the repository using UI before deleting org.
Created attachment 580267 [details] patch for rhn_org oracle package remove rhnContenSource record for corresponding org that is deleted
The patch was already committed to Spacewalk master by Tomáš, commit 7fa3c2c04cd6d09bcf1682797638ed26fe5fc73c, plus schema upgrades 2a4dccd5d80203c3af914d9adc89bb4109267708, plus my fix 6c233fa195ce033829a8752945884d800e4e5a06.
Moving ON_QA. Packages that address this bugzilla should now be available in yum repos at http://yum.spacewalkproject.org/nightly/
Spacewalk 1.8 has been released: https://fedorahosted.org/spacewalk/wiki/ReleaseNotes18