We are running 2.6.2, which is really old. I will upgrade to 14.03 or newer and see if it works. Thanks!
On Fri, Dec 18, 2015 at 1:06 PM, Bruce Roberts <[email protected]> wrote: > 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: > > 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 > > > -- 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
