Dear developpers, The last week, I have installed a database for a tool (blast2GO) with mysql and I encoutered a lot of problems because the blast2go database was too big and I didn't have space left on my device anymore (because I have a specific device for mysql databases of 100Gb). After that, I encountered a lot of problems with slurm, for example launching sview : < sview: error: slurmdbd: DBD_GET_CLUSTERS failure: Connection refused > And I was unable to restart slurmdbd.
I did a backup of my mysql databases (without blast2go database) and I reinstalled mysql-server/mysql. I created the < slurm > user, which have access to the slurm_acct_db database, with ALL PRIVILEGES. My slurmdbd.conf seems ok too with the good user and password. But when I launch < service slurmdbd restart > I get the error (from file /var/log/slurmdbd) : < [2017-07-18T10:01:57.309] auth plugin for Munge (http://code.google.com/p/munge/) loaded [2017-07-18T10:01:57.313] Accounting storage MYSQL plugin failed [2017-07-18T10:01:57.313] error: Couldn't load specified plugin name for accounting_storage/mysql: Plugin init() callback failed [2017-07-18T10:01:57.313] error: cannot create accounting_storage context for accounting_storage/mysql [2017-07-18T10:01:57.314] fatal: Unable to initialize accounting_storage/mysql accounting storage plugin > And I don't know how to solve this problem. Have you an idea to solve this problem ? Currently, we can no longer use slurm ... Supplementary informations : - I have centOS6 distribution (2.6.32-504.8.1.el6.x86_64). - Mysql version : > mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1 > - I can perform the manipulations as root. - I have Slurm 14.03.0 - ps aux | grep slurm : < slurmctld (pid 42411) is running... slurmd (pid 42420) is running... slurmdbd is stopped > - service --status-all | grep munge < munged (pid 4214) is running... > - service --status-all | grep mysql < mysqld (pid 9825) is running... > - I have installed mysql with following command : yum install mysql mysql-server mysql-libs mysql-devel My problem is really with the slurmdbd database, I think I have to reinstall it, but I will lost all the users informations ? In attachments, the slurm.conf and slurmdbd.conf files. Thank you in advance for your help. Best, Amandine
slurm.conf
Description: slurm.conf
slurmdbd.conf
Description: slurmdbd.conf
