Hi Oe,

Found this error also in the logfile: slurmdbd: error: mysql_query failed: 1728 Cannot load from mysql.proc. The table is probably corrupted

started: mysql_upgrade -u root -pxxx and this fixes the problem. Went from mysql on 20.04 to mariadb on 24.04. and the database wasn't upgraded.

And I had to remove the DbdPort from my conifig file.

Thanks, Karl

-----Original Message----- From: karl--- via slurm-users slurm-users@lists.schedmd.com Sent: Monday, 27 January 2025 14:00 To: 'Ole Holm Nielsen' Ole.H.Nielsen@fysik.dtu.dk; slurm-users@lists.schedmd.com Subject: [slurm-users] Re: Problems with slurmdbd on Ubuntu 24.04

Hi Ole,

Thanks for the link. But then I'm back where I actually wanted to stay away from. Compiling slurm myself. If that's the only solution then that's what I'll do. But it still seems to me that there are more users with Ubuntu 24.04 who use a MySQL/MariaDB as a back-end for storing accounting data.

Regards, Karl

-----Original Message----- From: Ole Holm Nielsen via slurm-users slurm-users@lists.schedmd.com Sent: Monday, 27 January 2025 13:49 To: slurm-users@lists.schedmd.com Subject: [slurm-users] Re: Problems with slurmdbd on Ubuntu 24.04

Hi Karl,

I recommend to read the Slurm quickstart documentation at https://slurm.schedmd.com/quickstart_admin.html#debuild

Building Debian Packages

Beginning with Slurm 23.11.0, Slurm includes the files required to build Debian packages. These packages conflict with the packages shipped with Debian based distributions, and are named distinctly to differentiate them. After downloading the desired version of Slurm, the following can be done to build the packages:

IHTH, Ole

On 1/27/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

-- slurm-users mailing list -- slurm-users@lists.schedmd.com To unsubscribe send an email to slurm-users-leave@lists.schedmd.com

-- slurm-users mailing list -- slurm-users@lists.schedmd.com To unsubscribe send an email to slurm-users-leave@lists.schedmd.com