[slurm-users] slurmdbd: mysql/accounting errors on 17.11.6 upgrade

[Tina Fora]

Hello,

I upgraded from 17.02.10 to 17.11.6 on EL6.9 and getting the errors below.
Database is on EL7 mariadb-5.5.

After yum update slurm:

# slurmdbd -D -vvv
slurmdbd: debug:  Log file re-opened
slurmdbd: debug:  Munge authentication plugin loaded
slurmdbd: debug2: mysql_connect() called for db slurmdbd_dev
slurmdbd: pre-converting job table for <removed>
slurmdbd: adding column pack_job_id after id_group in table
"<removed>_job_table"
slurmdbd: adding column pack_job_offset after pack_job_id in table
"<removed>_job_table"
slurmdbd: adding column mcs_label after kill_requid in table
"<removed>_job_table"
slurmdbd: adding column work_dir after wckey in table "<removed>_job_table"
slurmdbd: adding key old_tuple (id_job, id_assoc, time_submit) to table
"<removed>_job_table"
slurmdbd: adding key pack_job (pack_job_id) to table "<removed>_job_table"
slurmdbd: debug:  Table "<removed>_job_table" has changed.  Updating...
slurmdbd: error: mysql_query failed: 1062 Duplicate entry
'3508-1399520701' for key 'id_job'
alter table "<removed>_job_table" modify `job_db_inx` bigint unsigned not
null auto_increment, modify `mod_time` bigint unsigned default 0 not null,
modify `deleted` tinyint default 0 not null, modify <snip> add key
sacct_def2 (id_user, time_end, time_eligible);
slurmdbd: Accounting storage MYSQL plugin failed
slurmdbd: error: Couldn't load specified plugin name for
accounting_storage/mysql: Plugin init() callback failed
slurmdbd: error: cannot create accounting_storage context for
accounting_storage/mysql
slurmdbd: fatal: Unable to initialize accounting_storage/mysql accounting
storage plugin

Please advise.

Thank you,
Tina