Hi Joachim

I make increasingly use of the Galaxy Reports tool.  Until recently I
started it and shut it down again. Now I run it continuously. I have
noticed that a lot of the jobs listed in 'unfinished jobs' are actually
finished.

Any hint on how to clean up the database? Which table? Perhaps I can
make a Trello card: 'Provide a button to remove the jobs from the
unfinished jobs page' ?

Well, you can modify the entries in the 'job' table.....As always, be very careful when you directly access the MySQL or PostgreSQL database.

In your case I would set the state to 'error', eg:

update job set state='error' where id=123456789;


Once again be careful. I would examine each job individually. And try to figure out, why you consider the job as being finished, and Galaxy thinks the job is still running

Regards, Hans-Rudolf



Thanks for taking me further,
Joachim

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

 http://lists.bx.psu.edu/

Reply via email to