[slurm-users] Losing historical job information after upgrade from 16.05.6 to 17.11.7

[Barry Moore]

Hello All,

I am working on an upgrade from 16.05.6 -> 17.11.7. Everything went smoothly
and I can submit jobs, however I lost all of the historical information for jobs
submitted against the cluster I am testing. I was wondering if anyone has
experienced this and if there is any way around it?

Here is what is printed for the particular cluster when upgrading the DB:

```
$ grep knl /var/log/slurm/slurmdbd.log 
[2018-07-31T14:28:22.383] pre-converting job table for knl
[2018-07-31T14:28:40.037] adding column pack_job_id after id_group in table "knl_job_table"
[2018-07-31T14:28:40.037] adding column pack_job_offset after pack_job_id in table "knl_job_table"
[2018-07-31T14:28:40.037] adding column mcs_label after kill_requid in table "knl_job_table"
[2018-07-31T14:28:40.037] adding column work_dir after wckey in table "knl_job_table"
[2018-07-31T14:28:40.037] adding key old_tuple (id_job, id_assoc, time_submit) to table "knl_job_table"
[2018-07-31T14:28:40.037] adding key pack_job (pack_job_id) to table "knl_job_table"
[2018-07-31T14:28:40.085] adding column unused_wall after tres in table "knl_resv_table"
[2018-07-31T14:33:09.844] pre-converting job table for knl
[2018-07-31T14:33:09.858] dropping column pack_job_id from table "knl_job_table"
[2018-07-31T14:33:09.858] dropping column pack_job_offset from table "knl_job_table"
[2018-07-31T14:33:09.858] dropping column mcs_label from table "knl_job_table"
[2018-07-31T14:33:09.858] dropping column work_dir from table "knl_job_table"
[2018-07-31T14:33:09.858] dropping key old_tuple from table "knl_job_table"
[2018-07-31T14:33:09.858] dropping key pack_job from table "knl_job_table"
[2018-07-31T14:34:35.888] adding column pack_job_id after id_group in table "knl_job_table"
[2018-07-31T14:34:35.888] adding column pack_job_offset after pack_job_id in table "knl_job_table"
[2018-07-31T14:34:35.888] adding column mcs_label after kill_requid in table "knl_job_table"
[2018-07-31T14:34:35.888] adding column work_dir after wckey in table "knl_job_table"
[2018-07-31T14:34:35.888] adding key old_tuple (id_job, id_assoc, time_submit) to table "knl_job_table"
[2018-07-31T14:34:35.888] adding key pack_job (pack_job_id) to table "knl_job_table"
[2018-07-31T14:36:24.385] converting step table for knl
[2018-07-31T14:36:24.400] converting job table for knl
[2018-07-31T14:36:24.450] converting resv table for knl
[2018-07-31T14:36:24.452] converting cluster tables for knl
[2018-07-31T14:36:24.453] converting assoc table for knl
```

Any suggestions are appreciated.

Thanks,

Barry

-- 
Barry E Moore II, PhD
E-mail: bmooreii at pitt.edu

Technical Lead
Assistant Research Professor
Center for Research Computing
University of Pittsburgh
Pittsburgh, PA 15260