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