Matteo, I suspect something happened that prevented the state change for your jobs below from being propagated to the database. You are going to have to modify them manually in mysql. Change the state for these jobs to 3 (JOB_COMPLETE). I would also update the time_end field to something greater than time_start and less than now, though this second step may not be necessary for sacctmgr to remove the account.
Don > From: Guglielmi Matteo [mailto:[email protected]] > Sent: Tuesday, January 29, 2013 2:48 PM > To: slurm-dev > Subject: [slurm-dev] Ghost JobID in Database? > 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
