Doing a start clean on the slurmctld -c will clean things up for you as well. But it will remove all state including all other jobs in the system.
If you do choose to remove the jobs as Lennart describes you can use sacct to re-roll the data as described in older threads. Be careful using id_job as those are not always unique. Use the db index instead. Lennart Karlsson <[email protected]> wrote: > >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
