[slurm-users] Extreme long db upgrade 16.05.6 -> 17.11.3

[Chris Samuel]

On Monday, 1 April 2019 7:55:09 AM PDT Lech Nieroda wrote:

> Further analysis of the query has shown that the mysql optimizer has choosen
> the wrong execution plan. This may depend on the mysql version, ours was
> 5.1.69.

I suspect this is the issue documented in the release notes for 17.11:

https://github.com/SchedMD/slurm/blob/slurm-17.11/RELEASE_NOTES

NOTE FOR THOSE UPGRADING SLURMDBD: The database conversion process from
      SlurmDBD 16.05 or 17.02 may not work properly with MySQL 5.1 (as was the
      default version for RHEL 6).  Upgrading to a newer version of MariaDB or
      MySQL is strongly encouraged to prevent this problem.

-- 
  Chris Samuel  :  http://www.csamuel.org/  :  Berkeley, CA, USA