Hi Stpehan,
It is there:
root@vrfcanalyzer:/usr/lib/x86_64-linux-gnu/slurm-wlm# ls -al *mysql*
-rw-r--r-- 1 root root 3145992 Apr 1 2024 accounting_storage_mysql.a
-rw-r--r-- 1 root root 1071 Apr 1 2024 accounting_storage_mysql.la
-rw-r--r-- 1 root root 501848 Apr 1 2024 accounting_storage_mysql.so
-rw-r--r-- 1 root root 213700 Apr 1 2024 jobcomp_mysql.a
-rw-r--r-- 1 root root 994 Apr 1 2024 jobcomp_mysql.la
-rw-r--r-- 1 root root 44240 Apr 1 2024 jobcomp_mysql.so
dpkg -S jobcomp_mysql.so
slurm-wlm-mysql-plugin: /usr/lib/x86_64-linux-gnu/slurm-wlm/jobcomp_mysql.so
root@vrfcanalyzer:/usr/lib/x86_64-linux-gnu/slurm-wlm#
-----Original Message-----
From: Stephan Roth <stephan.r...@isg.ee.ethz.ch>
Sent: Monday, 27 January 2025 13:23
To: k...@lovink.net; slurm-users@lists.schedmd.com
Subject: Re: [slurm-users] Problems with slurmdbd on Ubuntu 24.04
Hello Karl,
I quickly downloaded
slurm-wlm-mysql-plugin_23.11.4-1.2ubuntu5_amd64.deb, unpacked it and saw
these contents:ä
usr/
├── lib
│ └── x86_64-linux-gnu
│ └── slurm-wlm
│ ├── accounting_storage_mysql.so
│ └── jobcomp_mysql.so
└── share
├── doc
│ └── slurm-wlm-mysql-plugin
│ ├── changelog.Debian.gz ->
../slurm-wlm-basic-plugins/changelog.Debian.gz
│ └── copyright
└── lintian
└── overrides
└── slurm-wlm-mysql-plugin
So it seems to me you're somehow missing
/usr/lib/x86_64-linux-gnu/slurm-wlm/jobcomp_mysql.so
Does that help?
Best,
Stephan
On 27.01.25 12:00, karl--- via slurm-users wrote:
> 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 <https://groups.google.com/g/slurm-users/c/wRV8o7qqGi4>
>
> Any idea what is going on here?
>
> Regards,
>
> Karl
>
>
>
--
ETH Zurich
Stephan Roth
Systems Administrator
IT Services Group (ISG) D-ITET
ETF D 104
Sternwartstrasse 7
8092 Zurich
Phone +41 44 632 30 59
stephan.r...@isg.ee.ethz.ch
www.isg.ee.ethz.ch
Working days: Mon, Tue, Thu, Fri
--
slurm-users mailing list -- slurm-users@lists.schedmd.com
To unsubscribe send an email to slurm-users-le...@lists.schedmd.com
