Removing job in error state
Hi - In the Manage Jobs admin job, I have a job from a user that never ran successfully. It shows: Job ID User Last Update Tool State Inputs Command Line Job Runner PID/Cluster ID 12772 user@company.com 654 hours ago cshl_fastx_collapser new 13653 error None None None How do I remove this job? I can't find a way to delete it.
Hi Ryan If the "Stop Jobs" option on the Admin page does not work, you can go for the direct way by manually interacting with the PostgreSQL database: Change the state to "error" in the 'job' table, eg: update job set state='error' where id=12772; As always, be very careful when you directly access the PostgreSQL database! Make sure your database is properly backed up. And you should only consider this as the very last option. Hans-Rudolf On 08/04/2016 06:02 AM, Ryan G wrote:
Hi - In the Manage Jobs admin job, I have a job from a user that never ran successfully. It shows: Job ID User Last Update Tool State Inputs Command Line Job Runner PID/Cluster ID 12772 user@company.com <mailto:user@company.com> 654 hours ago cshl_fastx_collapser new 13653 error None None None
How do I remove this job? I can't find a way to delete it.
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: https://lists.galaxyproject.org/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
Thanks. That fixed it. On Thu, Aug 4, 2016 at 3:19 AM, Hans-Rudolf Hotz <hrh@fmi.ch> wrote:
Hi Ryan
If the "Stop Jobs" option on the Admin page does not work, you can go for the direct way by manually interacting with the PostgreSQL database:
Change the state to "error" in the 'job' table, eg:
update job set state='error' where id=12772;
As always, be very careful when you directly access the PostgreSQL database! Make sure your database is properly backed up. And you should only consider this as the very last option.
Hans-Rudolf
On 08/04/2016 06:02 AM, Ryan G wrote:
Hi - In the Manage Jobs admin job, I have a job from a user that never ran successfully. It shows: Job ID User Last Update Tool State Inputs Command Line Job Runner PID/Cluster ID 12772 user@company.com <mailto:user@company.com> 654 hours ago cshl_fastx_collapser new 13653 error None None None
How do I remove this job? I can't find a way to delete it.
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: https://lists.galaxyproject.org/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
participants (2)
-
Hans-Rudolf Hotz -
Ryan G