[Spacewalk-list] Can't cancel pending actions

Grant Gainey ggainey at redhat.com
Mon Sep 23 18:12:38 UTC 2013 


----- Original Message -----
> 
> 
> Has anybody else run into this? I’ve got two pending actions (package
> upgrades) that I simply can’t cancel.

Is there anything in /var/log/tomcat6/catalina.out, *before* the traceback below?  That traceback is postgres telling us "something bad happened prior to this, so I'm not going to let you do whatever it is you're trying to do".

Grant

> 
> 
> 
> I’m running Spacewalk 1.9 on CentOS 6 x84_64
> 
> 
> 
> I’ve tried cancelling them in spacecmd and also in the web GUI. Causes an
> exception either way
> 
> 
> 
> Restarting spacewalk makes no difference. Not sure where to go with this.
> 
> 
> 
> 
> 
> Thanks,
> 
> --Tony
> 
> 
> 
> 
> 
> The following exception occurred while executing this request:
> 
> POST /rhn/schedule/PendingActionsDeleteConfirm.do
> 
> 
> 
> Date:9/23/13 1:54:50 PM EDT
> 
> Headers:
> 
> host: rich-spwk-01-pv
> 
> connection: keep-alive
> 
> content-length: 351
> 
> Cache-Control: max-age=0
> 
> accept:
> text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
> 
> Origin: https://rich-spwk-01-pv
> 
> user-agent: Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML,
> like Gecko) Chrome/31.0.1636.2 Safari/537.36
> 
> content-type: application/x-www-form-urlencoded
> 
> DNT: 1
> 
> referer: https://rich-spwk-01-pv/rhn/schedule/PendingActionsDeleteConfirm.do
> 
> accept-encoding: gzip,deflate,sdch
> 
> accept-language: en-US,en;q=0.8
> 
> cookie: JSESSIONID=C4298062082FD92F522A12BAE645436F;
> DWRSESSIONID=I9cPk8AGBoHr5SUh4Z2cirTVIXj;
> pxt-session-cookie=16918x7263656fa1d97f45637269d9f3536102
> 
> 
> 
> Request:
> 
> Local Name = rich-spwk-01-pv
> 
> Server Name = rich-spwk-01-pv
> 
> Requested Session Id came from Cookie
> 
> Requested Session Valid = true
> 
> Session =
> org.apache.catalina.session.StandardSessionFacade at 46d07e5f[session=StandardSession[C4298062082FD92F522A12BAE645436F
> ]]
> 
> Protocol = https
> 
> Request Locale = en_US
> 
> Request Character Encoding = UTF-8
> 
> Attribute Names = rhnActiveLang, javax.servlet.jsp.jstl.fmt.timeZone.request,
> javax.servlet.request.key_size, requestedUri, list_1154021400_selected_amt,
> org.apache.struts.action.ACTION_MESSAGE, javax.servlet.request.ssl_session,
> org.apache.struts.action.MESSAGE, session,
> javax.servlet.request.cipher_suite,
> org.apache.struts.action.mapping.instance, org.apache.struts.action.MODULE,
> 
> 
> 
> Form Variables:
> 
> csrf_token: -8602929913674024731
> 
> list_1154021400_parent_is_an_element: true
> 
> list_1154021400_filterby: Action
> 
> list_1154021400_sortdir:
> 
> list_1154021400_sortby:
> 
> list_1154021400_search_child: false
> 
> list_1154021400_filterattr: actionName
> 
> list_1154021400_filterval:
> 
> submitted: true
> 
> list_1154021400_oldfilterval:
> 
> dispatch: Confirm
> 
> list_1154021400_search_parent: true
> 
> 
> 
> 
> 
> User Information:
> 
> User admin (id 1, org_id 1)
> 
> 
> 
> Exception:
> 
> javax.servlet.ServletException: com.redhat.rhn.common.db.WrappedSQLException:
> ERROR: current transaction is aborted, commands ignored until end of
> transaction block
> 
> at
> org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:520)
> 
> at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:427)
> 
> at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
> 
> at
> com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:102)
> 
> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
> 
> at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
> 
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
> 
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> 
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> 
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> 
> at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:127)
> 
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> 
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> 
> at
> com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)
> 
> at
> com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
> 
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> 
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> 
> at
> com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
> 
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> 
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> 
> at
> com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:100)
> 
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> 
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> 
> at
> com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:57)
> 
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> 
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> 
> at
> com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
> 
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> 
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> 
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> 
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> 
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> 
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> 
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> 
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> 
> at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
> 
> at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
> 
> at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
> 
> at
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
> 
> at
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
> 
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
> 
> at java.lang.Thread.run(Thread.java:679)
> 
> Caused by: com.redhat.rhn.common.db.WrappedSQLException: ERROR: current
> transaction is aborted, commands ignored until end of transaction block
> 
> at
> com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:54)
> 
> at
> com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:44)
> 
> at
> com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:143)
> 
> at
> com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:467)
> 
> at
> com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:443)
> 
> at
> com.redhat.rhn.common.db.datasource.CachedStatement.executeUpdate(CachedStatement.java:276)
> 
> at
> com.redhat.rhn.common.db.datasource.WriteMode.executeUpdate(WriteMode.java:33)
> 
> at
> com.redhat.rhn.domain.rhnset.RhnSetFactory.removeByLabel(RhnSetFactory.java:191)
> 
> at com.redhat.rhn.domain.rhnset.RhnSetFactory.save(RhnSetFactory.java:130)
> 
> at com.redhat.rhn.manager.rhnset.RhnSetManager.store(RhnSetManager.java:88)
> 
> at
> com.redhat.rhn.frontend.action.schedule.PendingActionsDeleteConfirmAction.cancelActions(PendingActionsDeleteConfirmAction.java:123)
> 
> at
> com.redhat.rhn.frontend.action.schedule.PendingActionsDeleteConfirmAction.execute(PendingActionsDeleteConfirmAction.java:62)
> 
> at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
> 
> ... 40 more
> 
> Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is
> aborted, commands ignored until end of transaction block
> 
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
> 
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
> 
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> 
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
> 
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
> 
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:360)
> 
> at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:362)
> 
> at
> com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:140)
> 
> ... 50 more
> 
> 
> 
> 
> 
> 
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list

More information about the Spacewalk-list mailing list