[slurm-users] slurmdbd errors after MariaDB upgrade

[Peter Van Buren]

Hello,

I am running an old version of slurm (slurm 14.11.4). It's been working 
great up until there was a recent unintended upgrade of the MariaDB 
database.
The upgrade took MariaDB from 5.5.60 to 10.3.20. After that point, I am 
unable to use the sacct command. It reports an error:

sacct: error: Resource temporarily unavailable

The slurmdbd log shows:

[2020-09-30T14:35:44.878] debug2: Opened connection 8 from 127.0.0.1
[2020-09-30T14:35:44.881] debug:  DBD_INIT: CLUSTER:cluster VERSION:7168 
UID:1000 IP:127.0.0.1 CONN:8
[2020-09-30T14:35:44.881] debug2: acct_storage_p_get_connection: request 
new connection 1
[2020-09-30T14:35:44.924] debug2: DBD_GET_JOBS_COND: called
[2020-09-30T14:35:44.945] error: Processing last message from connection 
8(127.0.0.1) uid(1000)
[2020-09-30T14:35:44.985] debug2: Closed connection 8 uid(1000)

Some research shows this might be an incompatibility with newer versions 
of MariaDB and my version slurm due to a change in SQL code:

https://lists.schedmd.com/pipermail/slurm-users/2018-December/002475.html

Unfortunately I don't have a backup of this database from before the 
upgrade. I dumped the slurm_acct_db database, downgraded MariaDB and 
restored the database,
but the error still occurs. Is there any way for me to get slurmdbd 
working again without starting from scratch? I'd prefer not to lose all 
of the data in the database.

Thanks,
Peter.