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

[Russell Jones via slurm-users]

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]

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]

Thanks! I realized I made a mistake and had it still talking to an older slurmdbd system.