[slurm-users] Slurm 23.11 - Unknown system variable 'wsrep_on'

62 views
Skip to first unread message

Russell Jones via slurm-users

unread,
Apr 2, 2024, 4:17:06 PMApr 2
to slurm...@schedmd.com
Hi all,

I am working on upgrading a Slurm cluster from 20 -> 23. I was successfully able to upgrade to 22, however now that I am trying to go from 22 to 23, starting slurmdbd results in the following error being logged:

error: mysql_query failed: 1193 Unknown system variable 'wsrep_on'


When trying to start slurmctld, I get:

[2024-04-02T15:09:52.439] Couldn't find tres gres/gpumem in the database, creating.
[2024-04-02T15:09:52.439] Couldn't find tres gres/gpuutil in the database, creating.
[2024-04-02T15:09:52.440] fatal: Problem adding tres to the database, can't continue until database is able to make new tres


Any ideas what could be causing these errors? Is MariaDB 5.5 still officially supported?

Timo Rothenpieler via slurm-users

unread,
Apr 3, 2024, 2:53:47 PMApr 3
to slurm...@lists.schedmd.com
On 02.04.2024 22:15, Russell Jones via slurm-users wrote:
> Hi all,
>
> I am working on upgrading a Slurm cluster from 20 -> 23. I was
> successfully able to upgrade to 22, however now that I am trying to go
> from 22 to 23, starting slurmdbd results in the following error being
> logged:
>
> error: mysql_query failed: 1193 Unknown system variable 'wsrep_on'

I get that error in my log every startup, and it's benign.
That variable only exists on a Galera Cluster, so seeing it on a simple
mariadb instance is to be expected and benign.

>
> When trying to start slurmctld, I get:
>
> [2024-04-02T15:09:52.439] Couldn't find tres gres/gpumem in the
> database, creating.
> [2024-04-02T15:09:52.439] Couldn't find tres gres/gpuutil in the
> database, creating.
> [2024-04-02T15:09:52.440] fatal: Problem adding tres to the database,
> can't continue until database is able to make new tres
>
>
> Any ideas what could be causing these errors? Is MariaDB 5.5 still
> officially supported?

Check permissions of your database user, it has to be able to create and
alter tables.

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

Russell Jones via slurm-users

unread,
Apr 4, 2024, 11:12:59 AMApr 4
to Timo Rothenpieler, slurm...@lists.schedmd.com
Thanks! I realized I made a mistake and had it still talking to an older slurmdbd system.
Reply all
Reply to author
Forward
0 new messages