Hi Chris, Thank you for your reply !
I have followed your suggestion. I kill slurmdbd process and drop all tables in slurm_acct_db. However when I try to run "sudo sacctmgr add cluster hpctesis", the error message "Database is busy or waiting for lock from other user." still appeared. Therefore, I decided to change my clustername to something else and it works ! I don't know why my first clustername is doesn't work. in addition, I have a new question. Does sacct command only displays jobs in current day ? I use sacct to display all jobs, but what I got is jobs in current day only. All jobs executed before current day are not appeared. I know I can use "sacct -c" to display job completion but this command doesn't display jobs in RUNNING states as it intends to do so. so, is there a way to change sacct behavior ? so that I can display all jobs (RUNNING, FAILED, CANCELLED,COMPLETED etc) from every days available in slurm database at once. Thank you in advance. Regards, Husen On Mon, May 23, 2016 at 12:25 PM, Christopher Samuel <[email protected]> wrote: > > On 23/05/16 14:08, Husen R wrote: > > > anyone can tell me how to solve this please ? > > Kill all your slurmdbd's first, and check that all the associated > processes are gone. > > Then as long as you've not got any important data there (and that seems > unlikely if you can't create your first cluser) drop all the tables in > that database by hand and then start one slurmdbd in debugging mode with: > > slurmdbd -D -v > > and see what happens. > > By the way is this is standard MySQL or MariaDB or is it a clustered > version (Galera/Percona-xtradb/etc)? > > All the best, > Chris > -- > Christopher Samuel Senior Systems Administrator > VLSCI - Victorian Life Sciences Computation Initiative > Email: [email protected] Phone: +61 (0)3 903 55545 > http://www.vlsci.org.au/ http://twitter.com/vlsci >
