[Spacewalk-list] Can't cancel pending actions
Coffman, Anthony J
Tony.Coffman at snapon.com
Wed Sep 25 12:25:53 UTC 2013
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: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Grant Gainey
Sent: Monday, September 23, 2013 2:13 PM
To: spacewalk-list at redhat.com
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 at 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
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
_______________________________________________
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