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

2018-05-07 Thread Ole Holm Nielsen
On 05/07/2018 10:19 PM, Tina Fora wrote: 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. Migrating to a new version of MySQL/MariaDB requires further steps on the database (unrelated to Slurm). You must run: mysql_upgrade a

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

2018-05-07 Thread Chris Samuel
On Tuesday, 8 May 2018 6:19:16 AM AEST Tina Fora wrote: > slurmdbd: error: mysql_query failed: 1062 Duplicate entry > '3508-1399520701' for key 'id_job' That doesn't look good, not sure what to advise there. Do you have a backup of the database from before you started? If you've got a support

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

2018-05-07 Thread 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 s