# How to kill a failed job without gxadmin?
**URL:** https://help.galaxyproject.org/t/how-to-kill-a-failed-job-without-gxadmin/5188
**Category:** Uncategorized
**Tags:** devops-administration
**Created:** [January 14, 2021, 8:19pm UTC](https://help.galaxyproject.org/t/how-to-kill-a-failed-job-without-gxadmin/5188 "2021-01-14T20:19:13Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@KeelyDulmage](https://help.galaxyproject.org/u/KeelyDulmage)
#### Post date: [January 14, 2021, 8:19pm UTC](https://help.galaxyproject.org/t/how-to-kill-a-failed-job-without-gxadmin/5188/1 "2021-01-14T20:19:13Z")
Help! I’m running a local dev instance of Galaxy purely to write a wrapper for an in-house R script and I have a failed job preventing Galaxy from loading at all, at least I _think_ that’s the issue:
> galaxy.jobs.handler ERROR 2021-01-14 13:54:24,285 [p:90,w:1,m:0] [JobHandlerQueue.monitor\_thread] failure running job 621
> Traceback (most recent call last):
> File “lib/galaxy/jobs/handler.py”, line 408, in \_\_handle\_waiting\_jobs
> self.dispatcher.put(self.job\_wrappers.pop(job.id))
> File “lib/galaxy/jobs/handler.py”, line 1007, in put
> self.job\_runners[runner\_name].put(job\_wrapper)
> File “lib/galaxy/jobs/runners/ **init**.py”, line 152, in put
> job\_wrapper.enqueue()
> File “lib/galaxy/jobs/ **init**.py”, line 1456, in enqueue
> self.\_set\_object\_store\_ids(job)
> File “lib/galaxy/jobs/ **init**.py”, line 1478, in \_set\_object\_store\_ids
> object\_store\_populator.set\_object\_store\_id(dataset)
> File “lib/galaxy/objectstore/ **init**.py”, line 1082, in set\_object\_store\_id
> data.dataset.object\_store\_id = self.object\_store\_id
> AttributeError: ‘NoneType’ object has no attribute ‘dataset’
> galaxy.jobs.mapper DEBUG 2021-01-14 13:54:24,305 [p:90,w:1,m:0] [JobHandlerQueue.monitor\_thread] (622) Mapped job to destination id: local
> galaxy.jobs.handler DEBUG 2021-01-14 13:54:24,318 [p:90,w:1,m:0] [JobHandlerQueue.monitor\_thread] (622) Dispatching to local runner
> galaxy.jobs DEBUG 2021-01-14 13:54:24,464 [p:90,w:1,m:0] [JobHandlerQueue.monitor\_thread] (622) Persisting job destination (destination id: local)
> galaxy.jobs.handler ERROR 2021-01-14 13:54:24,473 [p:90,w:1,m:0] [JobHandlerQueue.monitor\_thread] failure running job 622
> Traceback (most recent call last):
> File “lib/galaxy/jobs/handler.py”, line 408, in \_\_handle\_waiting\_jobs
> self.dispatcher.put(self.job\_wrappers.pop(job.id))
> File “lib/galaxy/jobs/handler.py”, line 1007, in put
> self.job\_runners[runner\_name].put(job\_wrapper)
> File “lib/galaxy/jobs/runners/ **init**.py”, line 152, in put
> job\_wrapper.enqueue()
> File “lib/galaxy/jobs/ **init**.py”, line 1456, in enqueue
> self.\_set\_object\_store\_ids(job)
> File “lib/galaxy/jobs/ **init**.py”, line 1478, in \_set\_object\_store\_ids
> object\_store\_populator.set\_object\_store\_id(dataset)
> File “lib/galaxy/objectstore/ **init**.py”, line 1082, in set\_object\_store\_id
> data.dataset.object\_store\_id = self.object\_store\_id
> AttributeError: ‘NoneType’ object has no attribute ‘dataset’
As recommended here: [Killing jobs or dead processes after a database crash on galaxy - #3 by Slugger70](https://help.galaxyproject.org/t/killing-jobs-or-dead-processes-after-a-database-crash-on-galaxy/1360/3), I tried installing and running gxadmin but of course I haven’t set up a postgresql db for my dev instance, so I get this failure:
> gxadmin mutate fail-job 621
> /usr/bin/gxadmin: line 258: psql: command not found
I am completely stuck. Do I just need to install psql even though Galaxy is using SQLite? We’re going to have actual professionals help with Galaxy admin in about a month or two but I’d really like to use my local instance before then. Any recommendations would be great. I’m this close to gnawing off my own leg to get out of the Galaxy trap (i.e. clean reinstall).
---
### Author:  [@innovate-invent](https://help.galaxyproject.org/u/innovate-invent)
#### Post date: [January 14, 2021, 8:23pm UTC](https://help.galaxyproject.org/t/how-to-kill-a-failed-job-without-gxadmin/5188/2 "2021-01-14T20:23:00Z")
Have you tried using the Jobs tab under the Admin panel?
---
### Author:  [@KeelyDulmage](https://help.galaxyproject.org/u/KeelyDulmage)
#### Post date: [January 14, 2021, 8:30pm UTC](https://help.galaxyproject.org/t/how-to-kill-a-failed-job-without-gxadmin/5188/3 "2021-01-14T20:30:53Z")
Alas, the job does not show up. When I load the Galaxy website I get this error: “An error occurred while updating information with the server. Please contact a Galaxy administrator if the problem persists.” In general, no information at all shows up, even though I am logged in as admin (history is missing too.)
---
### Author:  [@hexylena](https://help.galaxyproject.org/u/hexylena)
#### Post date: [January 15, 2021, 9:09am UTC](https://help.galaxyproject.org/t/how-to-kill-a-failed-job-without-gxadmin/5188/4 "2021-01-15T09:09:45Z")
Hey @KeelyDulmage I think when we suggested gxadmin to you, we didn’t know you were running with sqlite! This makes a lot of sense.
I think for that specific error you’ll need to run the sql in your sqlite3 database potentially.
Something like
```auto
sqlite3 universe.sqlite # Or wherever your DB is
update job set state='failed' where id = 621;
```
---
### Author:  [@KeelyDulmage](https://help.galaxyproject.org/u/KeelyDulmage)
#### Post date: [January 15, 2021, 2:47pm UTC](https://help.galaxyproject.org/t/how-to-kill-a-failed-job-without-gxadmin/5188/5 "2021-01-15T14:47:42Z")
Thank you @hexylena, that did it!
In case other naïve people doing Galaxy dev have the same question some day, my default sqlite db was in galaxy/database.
---
### Author:  [@jennaj](https://help.galaxyproject.org/u/jennaj)
#### Post date: [December 22, 2023, 12:01am UTC](https://help.galaxyproject.org/t/how-to-kill-a-failed-job-without-gxadmin/5188/6 "2023-12-22T00:01:00Z")