[Spacewalk-list] Unable to cancel actions

[Grant Gainey]

Hey Maria -

----- Original Message -----
> A package upgrade was scheduled for several servers with a script to be
> run afterwards. Unfortunately, someone scheduled it twice and we need to
> cancel the second run. I think the package upgrade for the first server was
> canceled. Now we are unable to cancel the other upgrades and the run of the
> script. The repeated upgrades wouldn't be a problem, but the script
> reboots the server, so we'd rather not have it run twice.
> 
> I tried doing it through the api as well and had the same problem.

What version of SW are you running?  This sounds like it might be

https://bugzilla.redhat.com/show_bug.cgi?id=987977

which was fixed in 2.0.

Grant

> 
> We get this error in the postgresql log:
> 
> ERROR:  -20266 : (action_is_child) - The specified action is in a chain,
> but is not the first action in the chain
> CONTEXT:  SQL statement "SELECT
> rhn_exception.raise_exception('action_is_child')"
> 	PL/pgSQL function "remove_action" line 40 at PERFORM
> STATEMENT:  select * from rhn_server.remove_action($1, $2) as result
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> STATEMENT:  select 'c3p0 ping' from dual
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> STATEMENT:  DELETE
> 	      FROM  rhnSet
> 	     WHERE  user_id = $1
> 	       AND  label = $2
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
> STATEMENT:  select 'c3p0 ping' from dual
> 
> My guess is that the first action in the chain referred to there is the
> one that was canceled, but I don't know that.
> 
> If someone knows of a command that would cancel all pending actions I
> would really appreciate it.
> 
> Any suggestions?
> 
> Thanks,
> Maria
> 
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>