[Spacewalk-list] Channel Deletion Problem - v1.4

Mon Aug 1 15:50:14 UTC 2011

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 at 511ec571[session=StandardSession[07CC8125F8EDB3342D54D6C57FB75D5F<mailto:org.apache.catalina.session.StandardSessionFacade at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110801/66c68069/attachment.htm>