Bug 591384

Summary:	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
Product:	Gentoo Linux	Reporter:	David Klaftenegger <davidweb>
Component:	Current packages	Assignee:	Alexey Shvetsov <alexxy>
Status:	RESOLVED OBSOLETE
Severity:	normal	CC:	cluster, jlec
Priority:	Normal
Version:	unspecified
Hardware:	All
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---

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) gentoo-dev

2017-11-26 16:52:01 UTC

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