Re: [slurm-users] slurmdbd: error: mysql_query failed: 1064

2018-10-30 Thread Chris Samuel
On Wednesday, 31 October 2018 5:08:13 AM AEDT 宋亚磊 wrote: > Dear Chris, Hi Yalei, > Thank you very much! > I downgraded the MySQL and reinstalled SLURM, it works now! Wonderful! So glad that fixed it for you. All the best, Chris -- Chris Samuel : http://www.csamuel.org/ : Melbourne, VIC

Re: [slurm-users] slurmdbd: error: mysql_query failed: 1064

2018-10-30 Thread 宋亚磊
Dear Chris, Thank you very much! I downgraded the MySQL and reinstalled SLURM, it works now! Best regards, Yalei > On Tuesday, 30 October 2018 6:38:59 PM AEDT 宋亚磊 wrote: > > > slurmdbd: error: mysql_query failed: 1064 You have an error in your SQL > > syntax; check the manual that corresponds

Re: [slurm-users] slurmdbd: error: mysql_query failed: 1064

2018-10-30 Thread Chris Samuel
On Tuesday, 30 October 2018 6:38:59 PM AEDT 宋亚磊 wrote: > slurmdbd: 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 'desc' at line 1 Unfortunately that seems to look like an in

[slurm-users] slurmdbd: error: mysql_query failed: 1064

2018-10-30 Thread 宋亚磊
Hello! I'm using slurm 18.08.3 and mysql 8.0. When I run sacct, following error will appear: # sacct JobIDJobName PartitionAccount AllocCPUS State ExitCode -- -- -- -- -- sacct: error: slurmdbd: Unknown error 106