[slurm-dev] Re: Fixing corrupted slurm accounting?

2017-10-28 Thread Doug Meyer
Look up orphan jobs and lost.pl (quick script to find orphans) in https://groups.google.com/forum/#!forum/slurm-devel. Battling this myself right now. Thank you, Doug On Fri, Oct 27, 2017 at 9:00 PM, Bill Broadley wrote: > > > I noticed crazy high numbers in my reports, things like sreport use

[slurm-dev] Re: Fixing corrupted slurm accounting?

2017-10-28 Thread Douglas Jacobsen
Once you've got the end times fixed, youll need to manually update the timestamps in the _last_ran table to some time point before the start of the earliest job fixed. Then on the next hour mark, it'll start rerolling up the past data to reflect the new reality you've set in the database. Unfortu

[slurm-dev] Re: Fixing corrupted slurm accounting?

2017-10-28 Thread Douglas Jacobsen
A more complete response would be something like: MariaDB [slurm_acct_db]> select * from _last_ran_table; +---+--++ | hourly_rollup | daily_rollup | monthly_rollup | +---+--++ |1509206400 | 1509174000 | 15068