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@46d07e5f[session=StandardSession[C4298062082FD92F522A12BAE645436F<mailto:org.apache.catalina.session.StandardSessionFacade@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 [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
