Hi Team,
I seem to be unable to delete a software channel. The traceback seems to suggest that this channel has a child... but it's actually this other way around. This channel IS a child channel for another. I made sure to manually remove this channel from any activation keys. I even manually unsubscribed all systems from this channel, but I still cannot remove it. I've included the traceback. Can someone give me a hint on this one? ----- The following exception occurred while executing this request: POST /rhn/channels/manage/Delete.do Date:8/1/11 10:45:31 AM CDT Headers: host: spacewalk.wichita.edu connection: keep-alive referer: https://spacewalk.wichita.edu/rhn/channels/manage/Delete.do?cid=741 content-length: 51 Cache-Control: max-age=0 Origin: https://spacewalk.wichita.edu user-agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.122 Safari/534.30 content-type: application/x-www-form-urlencoded accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 accept-encoding: gzip,deflate,sdch accept-language: en-US,en;q=0.8 accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.3 cookie: JSESSIONID=07CC8125F8EDB3342D54D6C57FB75D5F; __utmz=84591263.1307474425.1.2.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=wichita%20state%20university%20associate%20degree; __utma=84591263.2005276547.1307474370.1307474370.1307474370.1; usid=1rp6kKJtIYtzCD2rNmTUSw__; usidsec=S3axVjZlIR8+FX/Bkj9yMw__; BANSSO=SSYLJZCjAIEyYOUWJ0Q35N1z6YF6TO0nPNA13YY24tUh2RJjIADwJT1AZ=P=; CPSESSID=AQARMjAxMTA3MjYwODQyMzkDAA8zU05GSk4zNTA3OTI=; pxt-session-cookie=196373x63be94d47ada29c09b9c5fc72b67d6ba Request: Local Name = spacewalk.wichita.edu Server Name = spacewalk.wichita.edu Requested Session Id came from Cookie Requested Session Valid = true Session = org.apache.catalina.session.StandardSessionFacade@511ec571[session=StandardSession[07CC8125F8EDB3342D54D6C57FB75D5F<mailto:org.apache.catalina.session.StandardSessionFacade@511ec571[session=StandardSession[07CC8125F8EDB3342D54D6C57FB75D5F>]] Protocol = https Request Locale = en_US Request Character Encoding = UTF-8 Attribute Names = rhnActiveLang, subscribedSystemsCount, javax.servlet.jsp.jstl.fmt.timeZone.request, javax.servlet.request.key_size, requestedUri, javax.servlet.request.ssl_session, org.apache.struts.action.MESSAGE, session, channelDeleteForm, __sitemesh__filterapplied, trustedSystemsCount, javax.servlet.request.cipher_suite, org.apache.struts.action.mapping.instance, channel, org.apache.struts.action.MODULE, Form Variables: submitted: true delete_button: Delete Channel cid: 741 User Information: User f229m776 (id 21, org_id 1) Exception: javax.servlet.ServletException: ORA-02292: integrity constraint (SPACEWALK.RHN_ENQUEUE_CID_FK) violated - child record found ORA-06512: at "SPACEWALK.DELETE_CHANNEL", line 15 ORA-06512: at line 1 at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237) at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:82) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:101) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:662) Caused by: com.redhat.rhn.common.db.WrappedSQLException: ORA-02292: integrity constraint (SPACEWALK.RHN_ENQUEUE_CID_FK) violated - child record found ORA-06512: at "SPACEWALK.DELETE_CHANNEL", line 15 ORA-06512: at line 1 at com.redhat.rhn.common.translation.SqlExceptionTranslator.oracleSQLException(SqlExceptionTranslator.java:84) at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:42) at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:118) at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:511) at com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34) at com.redhat.rhn.domain.channel.ChannelFactory.remove(ChannelFactory.java:273) at com.redhat.rhn.manager.channel.ChannelManager.deleteChannel(ChannelManager.java:904) at com.redhat.rhn.frontend.action.channel.manage.DeleteChannelAction.execute(DeleteChannelAction.java:78) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) ... 40 more Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (SPACEWALK.RHN_ENQUEUE_CID_FK) violated - child record found ORA-06512: at "SPACEWALK.DELETE_CHANNEL", line 15 ORA-06512: at line 1 at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759) at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:661) at oracle.jdbc.driver.T2CCallableStatement.executeForDescribe(T2CCallableStatement.java:544) at oracle.jdbc.driver.T2CCallableStatement.executeForRows(T2CCallableStatement.java:727) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4714) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374) at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2706) at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:115) ... 46 more ----- Andy Speagle System & Storage Administrator UCATS - Wichita State University P: 316.978.3869 C: 316.617.2431
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
