[Spacewalk-list] Can't cancel pending actions

Coffman, Anthony J Tony.Coffman at snapon.com
Mon Sep 23 17:57:15 UTC 2013


Has anybody else run into this? I've got two pending actions (package upgrades) that I simply can't cancel.

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<mailto: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




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130923/1fd6ad4b/attachment.htm>


More information about the Spacewalk-list mailing list