Bug 591384 – sys-cluster/slurm-16.05.2[mysql]: sacct: error: mysql_query failed: 1064 You have an error in your SQL syntax near 'partition, timelimit, starttime, endtime, nodelist, nodecnt, proc_cnt, connect_t' at line 1

• Status: RESOLVED OBSOLETE
• Product: Gentoo Linux

[Description David Klaftenegger 2016-08-16 09:41:15 UTC]

When USE="mysql" is set for sys-cluster/slurm-16.05.2, there is a bug in the sacct command:

sacct: error: mysql_query failed: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'partition, timelimit, starttime, endtime, nodelist, nodecnt, proc_cnt, connect_t' at line 1
select jobid, uid, user_name, gid, group_name, name, state, partition, timelimit, starttime, endtime, nodelist, nodecnt, proc_cnt, connect_type, reboot, rotate, maxprocs, geometry, start, blockid from jobcomp_table where (jobid=77)


This is documented in

https://bugs.schedmd.com/show_bug.cgi?id=1246

to be related to "partition" now being a reserved keyword (supposedly both in mariadb and mysql).
A patch is also linked there:

https://github.com/SchedMD/slurm/commit/75f4951157401ad08bac47a3397d591b2f327d37


Is it possible to get either this patch, or slurm-17-02-0-0pre1 into the tree?

[Comment 1 David Klaftenegger 2017-01-30 12:53:29 UTC]

my previous workaround of using an ancient version of mariadb seems to be broken now (as I cannot get emerge to actually re-install mariadb-5.5 anymore).

This means my slurm is broken.

Can we please get this more than two year old fix in gentoo?

[Comment 2 Justin Lecher (RETIRED) 2017-11-26 16:52:01 UTC]

Version dropped from tree. PLease reopen is still exists with newer versions