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
