[slurm-users] MariaDB lock problems for sacctmgr delete query

Christopher Samuel chris at csamuel.org
Fri Feb 16 05:44:03 MST 2018

Hi Ole,

On 16/02/18 22:23, Ole Holm Nielsen wrote:

> Question: Is it safer to wait for 17.11.4 where the issue will 
> presumably be solved?

I don't think the commit has been backported to 17.11.x to date.

It's in master (for 18.08) here:

commit 4a16541bf0e005e1984afd4201b97df482e269ee
Author: Tim Wickberg <tim at schedmd.com>
Date:   Tue Feb 13 21:34:33 2018 -0700

     Remove AUTO_INCREMENT resets when removing an association from the 

     These calls are apparently quite expensive on larger databases,
     and nothing requires that the association id number not have any
     skipped values. So stop doing this.

     Performance problems first reported by Jessica Nettelblad.

     Bug 4785.

All the best,

More information about the slurm-users mailing list