Hello,
Last weekend, I updated my server to ubuntu 24.04 and instead of using my own compiled version of slurm, I switched to
the version (23.11.4) that comes with Ubuntu 24.04. Since then, I have been having problems with slurmdbd.
I get the following error message:
slurmdbd: error: issue making get_lineage procedure
slurmdbd: accounting_storage/as_mysql: init: Accounting storage MYSQL plugin failed
slurmdbd: debug2: wsrep_on=0
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
My /etc/slurm/slurmdbd.conf looks like this:
AuthType=auth/munge
DebugLevel=debug5
DbdHost=localhost
DbdPort=3306
StorageLoc=slurm_acct_db
StoragePass=<password>
StorageType=accounting_storage/mysql
StorageUser=slurm
SlurmUser=admina
PluginDir=/usr/lib/x86_64-linux-gnu/slurm-wlm
ArchiveEvents=yes
ArchiveJobs=yes
ArchiveResvs=yes
ArchiveSteps=no
ArchiveSuspend=no
ArchiveTXN=no
ArchiveUsage=no
AuthInfo=/var/run/munge/munge.socket.2
PurgeEventAfter=1month
PurgeJobAfter=12month
PurgeResvAfter=1month
PurgeStepAfter=1month
PurgeSuspendAfter=1month
PurgeTXNAfter=12month
PurgeUsageAfter=24month
LogFile=/var/log/slurm/slurmdbd.log
PidFile=/var/run/slurmdbd.pid
NOTE: Removing the PluginDir directive makes no difference.
And the Plugin directory contains the accounting/MySQL file:
ls -al /usr/lib/x86_64-linux-gnu/slurm-wlm/*mysql*
-rw-r--r-- 1 root root 3145992 Apr 1 2024 /usr/lib/x86_64-linux-gnu/slurm-wlm/accounting_storage_mysql.a
-rw-r--r-- 1 root root 1071 Apr 1 2024 /usr/lib/x86_64-linux-gnu/slurm-wlm/accounting_storage_mysql.la
-rw-r--r-- 1 root root 501848 Apr 1 2024 /usr/lib/x86_64-linux-gnu/slurm-wlm/accounting_storage_mysql.so
I checked already the threat on: https://groups.google.com/g/slurm-users/c/wRV8o7qqGi4
Any idea what is going on here?
Regards,
Karl