Hello,

Since I migrate slurm 2.5 to 14.03 I am getting the next mysql errors when I 
submit a job in the slurmctld.log:


slurmctld: error: mysql_query failed: 1064 You have an error in your SQL 
syntax; check the manual that corresponds to your MySQL server version for the 
right syntax to use near 'partition, timelimit, starttime, endtime, nodecnt, 
nodelist) values (87, 0, 'roo' at line 1
insert into jobcomp_table (jobid, uid, user_name, gid, group_name, name, state, 
proc_cnt, partition, timelimit, starttime, endtime, nodecnt, nodelist) values 
(87, 0, 'root', 0, 'root', "hostname", 3, 1, 'test', "10080", 1401977650, 
1401977650, 1, 'bc03�)



And this is the part of �Jobcom" from my slurm.conf:

JobCompHost=dbprod
JobCompLoc=sqmdb
JobCompPass=XXXXXXXX
JobCompType=jobcomp/mysql
JobCompUser=XXXXXXXX
JobAcctGatherFrequency=30
JobAcctGatherType=jobacct_gather/linux



Any suggestion is welcome?



Thanks!
----------------------------
Confidencialidad: 
Este mensaje y sus ficheros adjuntos se dirige exclusivamente a su destinatario 
y puede contener informaci�n privilegiada o confidencial. Si no es vd. el 
destinatario indicado, queda notificado de que la utilizaci�n, divulgaci�n 
y/o copia sin autorizaci�n est� prohibida en virtud de la legislaci�n 
vigente. Si ha recibido este mensaje por error, le rogamos que nos lo comunique 
inmediatamente respondiendo al mensaje y proceda a su destrucci�n.

Disclaimer: 
This message and its attached files is intended exclusively for its recipients 
and may contain confidential information. If you received this e-mail in error 
you are hereby notified that any dissemination, copy or disclosure of this 
communication is strictly prohibited and may be unlawful. In this case, please 
notify us by a reply and delete this email and its contents immediately. 
----------------------------

Reply via email to