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

[Christopher Samuel]

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 
database.

     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,
Chris