Instead of using the archive files, couldn't you query the db directly for the info you need?

I would recommend sacct/sreport if those can get the info you need.

Brian Andrus

My organization needs to access historic job information records for metric reporting and resource forecasting. slurmdbd is archiving only the job information, which should be sufficient for our numbers, but is using the default archive script. In retrospect, this data should have been migrated to a secondary MariaDB instance, but that train has passed.

The format of the archive files is not well documented. Does anyone have a program (python/C/whatever) that will read a job_table_archive file and decode it into a parsable structure?

 

Douglas O’Neal, Ph.D. (contractor)

Manager, HPC Systems Administration Group, ITOG

Frederick National Laboratory for Cancer Research

Leidos Biomedical Research, Inc.

Phone: 301-228-4656

Email: Douglas.O’Neal@nih.gov