Thanks for this response. I think I may have figured out a workaround by accident.
I'm not positive since I haven't reproduced this scenario yet but the bug appear appears to be related to when you schedule a package upgrade and include a pre-upgrade arbitrary script to run. If the pre-roll arbitrary script succeeds and the package update fails then it looks like the package update action is left in a pending state where it can't be cancelled (because it is linked to the other action). The solution that I backed into was to delete the pre-roll script action at which point the package upgrade action disappeared (was deleted?) I'll try this scenario again to see if I can confirm this. --Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Grant Gainey Sent: Monday, September 23, 2013 2:13 PM To: [email protected] Subject: Re: [Spacewalk-list] Can't cancel pending actions ----- 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@46d07e5f[session=Sta > ndardSession[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(RequestProc > essor.java:520) > > at > org.apache.struts.action.RequestProcessor.processActionPerform(Request > Processor.java:427) > > at > org.apache.struts.action.RequestProcessor.process(RequestProcessor.jav > a:228) > > at > com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestP > rocessor.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(Appli > cationFilterChain.java:290) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi > lterChain.java:206) > > at > com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:1 > 27) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli > cationFilterChain.java:235) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi > lterChain.java:206) > > at > com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMesh > Filter.java:129) > > at > com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilte > r.java:77) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli > cationFilterChain.java:235) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi > lterChain.java:206) > > at > com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(L > ocalizedEnvironmentFilter.java:67) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli > cationFilterChain.java:235) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi > lterChain.java:206) > > at > com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(Environmen > tFilter.java:100) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli > cationFilterChain.java:235) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi > lterChain.java:206) > > at > com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter. > java:57) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli > cationFilterChain.java:235) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi > lterChain.java:206) > > at > com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(S > etCharacterEncodingFilter.java:97) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli > cationFilterChain.java:235) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi > lterChain.java:206) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVa > lve.java:233) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa > lve.java:191) > > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.ja > va:127) > > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.ja > va:102) > > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValv > e.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.jav > a:698) > > at > org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocke > t.java:891) > > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPo > ol.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.postgreSqlExc > eption(SqlExceptionTranslator.java:54) > > at > com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException( > SqlExceptionTranslator.java:44) > > at > com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedS > tatement.java:143) > > at > com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStat > ement.java:467) > > at > com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStat > ement.java:443) > > at > com.redhat.rhn.common.db.datasource.CachedStatement.executeUpdate(Cach > edStatement.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:8 > 8) > > at > com.redhat.rhn.frontend.action.schedule.PendingActionsDeleteConfirmAct > ion.cancelActions(PendingActionsDeleteConfirmAction.java:123) > > at > com.redhat.rhn.frontend.action.schedule.PendingActionsDeleteConfirmAct > ion.execute(PendingActionsDeleteConfirmAction.java:62) > > at > org.apache.struts.action.RequestProcessor.processActionPerform(Request > Processor.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(QueryExe > cutorImpl.java:2062) > > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorI > mpl.java:1795) > > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.jav > a:257) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State > ment.java:479) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJ > dbc2Statement.java:367) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State > ment.java:360) > > at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPre > paredStatement.java:362) > > at > com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedS > tatement.java:140) > > ... 50 more > > > > > > > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
