[Spacewalk-list] Cannot delete systems
Hagberg, Keith
Keith.Hagberg at FMR.com
Mon Dec 5 16:46:43 UTC 2011
Running sw 1.3 with oracle 11g backend database.
When I try to delete old systems from the web ui I receive an Internal Server Error and then a web traceback email.
The following exception occurred while executing this request:
POST /rhn/systems/details/DeleteConfirm.do
Date:12/5/11 11:33:57 AM EST
Headers:
host: myspacewalk.none.com
connection: keep-alive
content-length: 36
Cache-Control: max-age=0
Origin: https://myspacewalk.none.co
user-agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.121 Safari/535.2
content-type: application/x-www-form-urlencoded
accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
referer: https://myspacewalk.none.co/rhn/systems/details/DeleteConfirm.do?sid=1000011694
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=4D17674CB1401860CE2BDB5D7C2CD013; SMSESSION=Q/NEWYnL++4+DQq3DTV/pPylNcNuZl3jQ5jSYO6+12ewZk6WCjT1mNcGs269jprqYsWPtDNKJcfMAsaiGhM4nhGiPT+Kt5lGH5tddrXF6yJs55WK4E1ZpBLuij1ydJ7N07EC6jCp/BR/U4YYxRExwmCicxlTYbsq7P+6gu2ncI/RAQuy5ltqdlSvQtDTz8Z8PHOlVbodFUhl/Ic8C6hr1jXSPFW5I3kU0QA2184lvspM59biWEJYO8y/Sw7R6UrVzduvDQOJBgwMk5IT8NNQU43An+3DsTX2sw2S35n0wc1WL2snpvvm5NN+V+MDFBanJYl0eOmAusrYHRU17WifALQmF3ng5duVkObgKmbkKgdwzPeLY1LFaDj2v1XE4q7cqz/9GCaf7WAk7Dc6RVkLNcPRU+RZ0wq5Zug9ulSsMSPHe0gOk2KTi1YbP8oI0PIExrm59aCPmf2rt6/Qz6Qn5ToqQDsqjEDvVYOIkD99J0s8xAyLiP1Q7dcyPMRryiUloxTJfOMNjv5WxTo44DEP/Q07eP/doomgMMC9kyfQ4A+ZT/9KZRjqNMUfVUMJwCGFNn/E4k3UzufkMYHLiLzxzplQkrOre5aDVQdAHS+FsCjizimhIwnI6MB8/fTJSjPQNHLmStRBhgLzxfJ/lUL0j413pppOk8XaMMcl4S+XiOf25P8xOySuIolB7mi64BmvPLSLcvdELCGvygvC0FlScJ1AX5ZlBSA4qbo5E4gKsoGH626KDeIUXToTP5O+yGLVQk6Br/5E2GIWdmjaA8ipCxQMz5yIWuWVnvJ9csngzVY5IOoKjx7xJQX74J0hJijWISLj/UktRteBidQMcHpjuf1sUPoRi1Xd44mvBQeBz5dx2J43h/Kd/sW2CVjRRJ9j76E8GgH9gigTQxTv82ode87bB/PmXNBdWGZfBV5tSCDWpNbEiCCmNyGPNTcwgayA3vZD2EphsV/c/pos6AnQV1jNE1T8b5Xo1P3/NNUYDKEXVIlvfSg4Tvz9RN60BDFJtJJAAJEo2SpDxQFIaGTRSGbFcLoVh/MghZRiTU/4q+uQRMNhhOydDEXcQUdE3Fy0; pxt-session-cookie=369153xe82e395a65ec78e4c2f886b005a6cc6b
Request:
Local Name = myspacewalk.none.co
Server Name = myspacewalk.none.co
Requested Session Id came from Cookie
Requested Session Valid = true
Session = org.apache.catalina.session.StandardSessionFacade at 25201ad9[session=StandardSession[4D17674CB1401860CE2BDB5D7C2CD013]]
Protocol = https
Request Locale = en_US
Request Character Encoding = UTF-8
Attribute Names = rhnActiveLang, sid, __sitemesh__page, javax.servlet.jsp.jstl.fmt.timeZone.request, javax.servlet.error.status_code, javax.servlet.error.servlet_name, submittedForm, javax.servlet.request.key_size, requestedUri, javax.servlet.request.ssl_session, org.apache.struts.action.MESSAGE, system, javax.servlet.error.message, session, __sitemesh__filterapplied, javax.servlet.request.cipher_suite, javax.servlet.error.exception, javax.servlet.error.request_uri, org.apache.struts.action.mapping.instance, org.apache.struts.action.MODULE,
Form Variables:
submitted: true
sid: 1000011694
button: Delete Profile
User Information:
User swuser (id 2, org_id 1)
Exception:
javax.servlet.ServletException: ORA-20238: (channel_unsubscribe_no_family) - Attempt to unsubscribe from a channel with no family
ORA-06512: at "SPACEWALK.RHN_EXCEPTION", line 31
ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 514
ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 468
ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 415
ORA-06512: at "SPACEWALK.DELETE_SERVER", line 86
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(PageFilterjava: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:636)
Caused by: com.redhat.rhn.common.db.WrappedSQLException: ORA-20238: (channel_unsubscribe_no_family) - Attempt to unsubscribe from a channel with no family
ORA-06512: at "SPACEWALK.RHN_EXCEPTION", line 31
ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 514
ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 468
ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 415
ORA-06512: at "SPACEWALK.DELETE_SERVER", line 86
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.server.ServerFactory.delete(ServerFactory.java:373)
at com.redhat.rhn.manager.system.SystemManager.deleteServer(SystemManagerjava:269)
at com.redhat.rhn.frontend.action.systems.sdc.SystemDeleteConfirmAction.execute(SystemDeleteConfirmAction.java:81)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
... 40 more
Caused by: java.sql.SQLException: ORA-20238: (channel_unsubscribe_no_family) - Attempt to unsubscribe from a channel with no family
ORA-06512: at "SPACEWALK.RHN_EXCEPTION", line 31
ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 514
ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 468
ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 415
ORA-06512: at "SPACEWALK.DELETE_SERVER", line 86
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20111205/551bb3b2/attachment.htm>
More information about the Spacewalk-list
mailing list