On 01/29/2013 11:47 PM, Guglielmi Matteo wrote: > I want to remove an unused account but the sacctmgr command returns 6 ghost > JobID which are not running anywhere on the system (note the 6 lower JobID > values). > > How can I purge these ghost jobs? > > ### > > sacctmgr remove account guest > > Error with request: Job(s) active, cancel job(s) before remove > JobID = 594676 C = superb A = guestlp U = bruijn P = batch > JobID = 594680 C = superb A = guestlp U = bruijn P = batch > JobID = 594686 C = superb A = guestlp U = bruijn P = batch > JobID = 594699 C = superb A = guestlp U = bruijn P = batch > JobID = 594703 C = superb A = guestlp U = bruijn P = batch > JobID = 594707 C = superb A = guestlp U = bruijn P = batch > JobID = 3563965 C = superb A = guestlp U = bruijn P = batch
Hi, This is how I do it (if jobID is 1655928): # mysql -u slurm -p slurm_acct_db mysql> delete from kalkyl_job_table where id_job=1655928; mysql> quit I have needed to do it several times. As others have said: If you need to keep these jobs in the database, e.g. for your accounting needs, you should instead repair them. Then, you could be interested in starting with these mysql command: mysql> describe kalkyl_job_table; mysql> select * from kalkyl_job_table where id_job=1655928; (if "kalkyl" is your cluster name). Cheers, -- Lennart Karlsson, UPPMAX, Uppsala University, Sweden
