[slurm-users] slurmdbd does not work

[Brian Andrus]

Your slurm needs built with the support. If you have mysql-devel 
installed it should pick it up, otherwise you can specify the location 
with --with-mysql when you configure/build slurm

Brian Andrus

On 12/2/2021 12:40 PM, Giuseppe G. A. Celano wrote:
> Hi everyone,
>
> I am having trouble getting /slurmdbd/ to work. This is the error I get:
>
> /error: Couldn't find the specified plugin name for 
> accounting_storage/mysql looking at all files
> error: cannot find accounting_storage plugin for accounting_storage/mysql
> error: cannot create accounting_storage context for 
> accounting_storage/mysql
> fatal: Unable to initialize accounting_storage/mysql accounting 
> storage plugin/
>
> I have installed /mysql/ (/apt install mysql/) on Ubuntu 20.04.03 and 
> followed the instructions on the slurm website 
> <https://slurm.schedmd.com/accounting.html>; /mysql/ is running (/port 
> 3306/) and these are the relevant parts in my /.conf/ files:
>
> /slurm.conf/
>
> # LOGGING AND ACCOUNTING
> AccountingStorageHost=localhost
> AccountingStoragePort=3306
> AccountingStorageType=accounting_storage/slurmdbd
> AccountingStorageUser=slurm
> JobCompType=jobcomp/none
> JobAcctGatherFrequency=30
> JobAcctGatherType=jobacct_gather/linux
> SlurmctldDebug=info
> SlurmctldLogFile=/var/log/slurmctld.log
> SlurmdDebug=info
> SlurmdLogFile=/var/log/slurmd.log
>
> /slurmdbd.conf/
>
> AuthType=auth/munge
> DbdAddr=localhost
> DbdHost=localhost
> DbdPort=3306
> LogFile=/var/log/slurmdbd.log
> PidFile=/var/run/slurmdbd.pid
> PluginDir=/usr/lib/slurm
> SlurmUser=slurm
> StoragePass=password
> StorageType=accounting_storage/mysql
> StorageUser=slurm
> StorageLoc=slurm_acct_db
>
> I changed the port to 3306 because otherwise /slurmdbd /could not 
> communicate with /mysql/. If I run /sacct/, for example, I get:
>
> /sacct: error: _slurm_persist_recv_msg: read of fd 3 failed: No error
> sacct: error: _slurm_persist_recv_msg: only read 126 of 2616 bytes
> sacct: error: slurm_persist_conn_open: No response to persist_init
> sacct: error: Sending PersistInit msg: No error
> JobID           JobName  Partition    Account  AllocCPUS      State 
> ExitCode
> ------------ ---------- ---------- ---------- ---------- ---------- 
> --------
> sacct: error: _slurm_persist_recv_msg: read of fd 3 failed: No error
> sacct: error: _slurm_persist_recv_msg: only read 126 of 2616 bytes
> sacct: error: Sending PersistInit msg: No error
> sacct: error: DBD_GET_JOBS_COND failure: Unspecified error/
> /
> /
> Does anyone have a suggestion to solve this problem? Thank you very much.
>
> Best,
> Giuseppe
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.schedmd.com/pipermail/slurm-users/attachments/20211202/a36859cd/attachment-0001.htm>