Hi,
We'd like to move our Slurm database from its existing machine running mariadb-server-5.5.68 to another running mariadb-server-10.5.29-3, both of which are running slurm 24.11.7. We dumped the database successfully from the old server, reimported it into the new server using mysqldump and mysql < db_dump.sql. The new slurmdbd service was then started.
The clusters have different names so there were a few inconsistencies, but when we started the new slurm cluster, we could see the jobs according to sacct (using the -M option) matched those of the original cluster, but none of the associated job steps were shown. I manually logged into the new database and could see the jobs in the job_table but it looked like the foreign key link had been broken in the step table as there were entries in that table.
Am I missing some information about how to export and import properly? I was wondering if the import had triggered auto-increment on keys and that was breaking things?
Ideally, we'd like to change the name of the cluster as well. Is that just a matter of altering the prefix on the relevant tables, which is something I can do by hand on the database dump before reimporting? For instance, changing the table <old_name>_event_table to <new_cluster_name>_event_table.
Thanks
James
--
Dr James Allsopp | Research Platforms teamIT Services | University of Sheffield
I do not work Tuesday and Wednesday 3-5pm. I also send emails at odd times, but respond at your convenience.