Re: [galaxy-dev] Removing job in error state

[Ryan G]

Thanks.   That fixed it.

On Thu, Aug 4, 2016 at 3:19 AM, Hans-Rudolf Hotz  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  UserLast Update ToolState   Inputs  Command Line
>> Job Runner
>> PID/Cluster ID
>> 12772   u...@company.com   654
>> hours ago
>> cshl_fastx_collapsernew 13653 error NoneNoneNone
>>
>>
>> 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/
>>
>>
___
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/

Re: [galaxy-dev] Removing job in error state

[Hans-Rudolf Hotz]

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  UserLast Update ToolState   Inputs  Command LineJob 
Runner
PID/Cluster ID
12772   u...@company.com 654 hours ago
cshl_fastx_collapsernew 13653 error NoneNoneNone


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/


___
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/

[galaxy-dev] Removing job in error state

[Ryan G]

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 u...@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/