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.
