What version of Slurm are you using? I think this was fixed back in
14.03. I don't seem to have this issue anyway. I'm running mariadb
10.0.23.
On 12/17/15 14:58, Kai Song wrote:
Database Error after Upgrading from MariaDB-5.x to 10.x
Dear SLURM Community,
After we upgrade the database from MariaDB-5.x to 10.0.22, we are
having DB issues when adding new users. More specifically, there are
some problem running database "UPDATE".
The command I ran:
========================
/usr/bin/sacctmgr add user Name=foo Partition=batch Account=acct
AdminLevel=None
========================
Here is the error we see in the slurmdbd.log:
========================
[2015-12-17T14:30:22.024] 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='batch' order by lft FOR UPDATE' at line 1
========================
Have any of you seen the similar issues? If so, can you shine some
lights on how to resolve it?
Thanks!
Kai
--
Kai Song
<[email protected] <mailto:[email protected]>> 1.510.495.2180
1 Cyclotron Rd. Berkeley, CA94720, MS-50B 3209
High Performance Computing Services (HPCS)
Lawrence Berkeley National Laboratory - http://scs.lbl.gov
