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]> 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
