<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif">10.4.22</div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Dec 4, 2021 at 1:35 AM Brian Andrus <<a href="mailto:toomuchit@gmail.com">toomuchit@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>Which version of Mariadb are you using?</p>
<p>Brian Andrus<br>
</p>
<div>On 12/3/2021 4:20 PM, Giuseppe G. A.
Celano wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div class="gmail_default" style="font-family:verdana,sans-serif">After installation of
libmariadb-dev, I have reinstalled the entire slurm with
./configure + options, make, and make install. Still,
accounting_storage_mysql.so is missing. </div>
<div>
<div dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr"><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Sat, Dec 4, 2021 at 12:24
AM Sean Crosby <<a href="mailto:scrosby@unimelb.edu.au" target="_blank">scrosby@unimelb.edu.au</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">Did
you run</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)"><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">./configure
(with any other options you normally use)</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">make</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">make
install</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)"><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">on
your DBD server after you installed the mariadb-devel
package?<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)"><br>
</div>
<hr style="display:inline-block;width:98%">
<div id="gmail-m_-719610467505871815gmail-m_-7843205292890378555divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri,
sans-serif" color="#000000"><b>From:</b> slurm-users
<<a href="mailto:slurm-users-bounces@lists.schedmd.com" target="_blank">slurm-users-bounces@lists.schedmd.com</a>>
on behalf of Giuseppe G. A. Celano <<a href="mailto:giuseppegacelano@gmail.com" target="_blank">giuseppegacelano@gmail.com</a>><br>
<b>Sent:</b> Saturday, 4 December 2021 10:07<br>
<b>To:</b> Slurm User Community List <<a href="mailto:slurm-users@lists.schedmd.com" target="_blank">slurm-users@lists.schedmd.com</a>><br>
<b>Subject:</b> [EXT] Re: [slurm-users] slurmdbd does
not work</font>
<div> </div>
</div>
<div>
<div dir="ltr">
<div dir="ltr">
<div style="font-family:verdana,sans-serif">
<div>
<div style="color:rgb(0,0,0);font-size:12px;text-align:left;font-family:Helvetica,Arial,sans-serif"><strong>
<table style="width:100%;float:left" cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td style="color:red"><b>External email:
</b>Please exercise caution</td>
</tr>
</tbody>
</table>
</strong><br>
</div>
<hr>
</div>
The problem is the lack of
/usr/lib/slurm/accounting_storage_mysql.so</div>
<div style="font-family:verdana,sans-serif"><br>
</div>
<div style="font-family:verdana,sans-serif">I have
installed many mariadb-related packages, but that
file is not created by slurm after installation: is
there a point in the documentation where the
installation procedure for the database is made
explicit?<br>
</div>
<div>
<div dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr"><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
<br>
<div>
<div dir="ltr">On Fri, Dec 3, 2021 at 5:15 PM Brian
Andrus <<a href="mailto:toomuchit@gmail.com" target="_blank">toomuchit@gmail.com</a>>
wrote:<br>
</div>
<blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>You will need to also reinstall/restart
slurmdbd with the updated binary.</p>
<p>Look in the slurmdbd logs to see what is
happening there. I suspect it had errors
updating/creating the database and tables. If
you have no data in it yet, you can just DROP
the database and restart slurmdbd.</p>
<p>Brian Andrus<br>
</p>
<div>On 12/3/2021 6:42 AM, Giuseppe G. A. Celano
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div style="font-family:verdana,sans-serif">Thanks
for the answer, Brian. I now added
--with-mysql_config=/etc/mysql/my.cnf, but
the problem is still there and now also
slurmctld does not work, with the error:</div>
<div style="font-family:verdana,sans-serif"><br>
</div>
<div style="font-family:verdana,sans-serif">[2021-12-03T15:36:41.018]
accounting_storage/slurmdbd:
clusteracct_storage_p_register_ctld:
Registering slurmctld at port 6817 with
slurmdbd<br>
[2021-12-03T15:36:41.019] error:
_conn_readable: persistent connection for
fd 9 experienced error[104]: Connection
reset by peer<br>
[2021-12-03T15:36:41.019] error:
_slurm_persist_recv_msg: only read 150 of
2613 bytes<br>
[2021-12-03T15:36:41.019] error: Sending
PersistInit msg: No error<br>
[2021-12-03T15:36:41.020] error:
_conn_readable: persistent connection for
fd 9 experienced error[104]: Connection
reset by peer<br>
[2021-12-03T15:36:41.020] error:
_slurm_persist_recv_msg: only read 150 of
2613 bytes<br>
[2021-12-03T15:36:41.020] error: Sending
PersistInit msg: No error<br>
[2021-12-03T15:36:41.020] error:
_conn_readable: persistent connection for
fd 9 experienced error[104]: Connection
reset by peer<br>
[2021-12-03T15:36:41.020] error:
_slurm_persist_recv_msg: only read 150 of
2613 bytes<br>
[2021-12-03T15:36:41.020] error: Sending
PersistInit msg: No error<br>
[2021-12-03T15:36:41.020] error:
DBD_GET_TRES failure: No error<br>
[2021-12-03T15:36:41.021] error:
_conn_readable: persistent connection for
fd 9 experienced error[104]: Connection
reset by peer<br>
[2021-12-03T15:36:41.021] error:
_slurm_persist_recv_msg: only read 0 of
2613 bytes<br>
[2021-12-03T15:36:41.021] error: Sending
PersistInit msg: No error<br>
[2021-12-03T15:36:41.021] error:
DBD_GET_QOS failure: No error<br>
[2021-12-03T15:36:41.021] error:
_conn_readable: persistent connection for
fd 9 experienced error[104]: Connection
reset by peer<br>
[2021-12-03T15:36:41.021] error:
_slurm_persist_recv_msg: only read 150 of
2613 bytes<br>
[2021-12-03T15:36:41.021] error: Sending
PersistInit msg: No error<br>
[2021-12-03T15:36:41.021] error:
DBD_GET_USERS failure: No error<br>
[2021-12-03T15:36:41.022] error:
_conn_readable: persistent connection for
fd 9 experienced error[104]: Connection
reset by peer<br>
[2021-12-03T15:36:41.022] error:
_slurm_persist_recv_msg: only read 0 of
2613 bytes<br>
[2021-12-03T15:36:41.022] error: Sending
PersistInit msg: No error<br>
[2021-12-03T15:36:41.022] error:
DBD_GET_ASSOCS failure: No error<br>
[2021-12-03T15:36:41.022] error:
_conn_readable: persistent connection for
fd 9 experienced error[104]: Connection
reset by peer<br>
[2021-12-03T15:36:41.022] error:
_slurm_persist_recv_msg: only read 0 of
2613 bytes<br>
[2021-12-03T15:36:41.022] error: Sending
PersistInit msg: No error<br>
[2021-12-03T15:36:41.022] error:
DBD_GET_RES failure: No error<br>
[2021-12-03T15:36:41.022] fatal: You are
running with a database but for some
reason we have no TRES from it. This
should only happen if the database is down
and you don't have any state files.</div>
<div style="font-family:verdana,sans-serif"><br>
</div>
<br>
</div>
<br>
<div>
<div dir="ltr">On Thu, Dec 2, 2021 at 10:36
PM Brian Andrus <<a href="mailto:toomuchit@gmail.com" target="_blank">toomuchit@gmail.com</a>>
wrote:<br>
</div>
<blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p><br>
</p>
<p>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</p>
<p>Brian Andrus<br>
</p>
<div>On 12/2/2021 12:40 PM, Giuseppe G.
A. Celano wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div><span style="font-family:verdana,sans-serif">Hi
everyone,<br>
</span></div>
<div><span style="font-family:verdana,sans-serif"><br>
</span></div>
<div><span style="font-family:verdana,sans-serif">I
am having trouble getting <i>
slurmdbd</i> to work. This
is the error I get:</span></div>
<div><span style="font-family:verdana,sans-serif"><br>
</span></div>
<div><span style="font-family:verdana,sans-serif"><i>error:
Couldn't find the specified
plugin name for
accounting_storage/mysql
looking at all files<br>
error: cannot find
accounting_storage plugin
for accounting_storage/mysql<br>
error: cannot create
accounting_storage context
for accounting_storage/mysql<br>
fatal: Unable to initialize
accounting_storage/mysql
accounting storage plugin</i></span></div>
<div><span style="font-family:verdana,sans-serif"><br>
</span></div>
<div><span style="font-family:verdana,sans-serif">I
have installed <i>mysql</i> (<i>apt
install mysql</i>) on Ubuntu
20.04.03 and followed the
instructions on the slurm
<a href="https://slurm.schedmd.com/accounting.html" target="_blank">website</a>;
<i>
mysql</i> is running (<i>port
3306</i>) and these are the
relevant parts in my <i>
.conf</i> files: <br>
</span></div>
<div><span style="font-family:verdana,sans-serif"><br>
</span></div>
<div><span style="font-family:verdana,sans-serif"><i>slurm.conf</i><br>
</span></div>
<div><span style="font-family:verdana,sans-serif"><br>
</span></div>
<div><span style="font-family:verdana,sans-serif">#
LOGGING AND ACCOUNTING<br>
AccountingStorageHost=</span><span style="font-family:verdana,sans-serif">localhost<br>
AccountingStoragePort=3306<br>
AccountingStorageType=</span><span style="font-family:verdana,sans-serif">accounting_storage/slurmdbd<br>
AccountingStorageUser=slurm<br>
JobCompType=jobcomp/none<br>
JobAcctGatherFrequency=30<br>
JobAcctGatherType=jobacct_</span><span style="font-family:verdana,sans-serif">gather/linux<br>
SlurmctldDebug=info<br>
SlurmctldLogFile=/var/log/</span><span style="font-family:verdana,sans-serif">slurmctld.log<br>
SlurmdDebug=info<br>
SlurmdLogFile=/var/log/slurmd.</span><span style="font-family:verdana,sans-serif">log</span></div>
<div><span style="font-family:verdana,sans-serif"><br>
</span></div>
<div><span style="font-family:verdana,sans-serif"><i>slurmdbd.conf</i><br>
</span></div>
<div><span style="font-family:verdana,sans-serif"><br>
</span></div>
<div><span style="font-family:verdana,sans-serif">AuthType=auth/munge<br>
DbdAddr=localhost<br>
DbdHost=localhost<br>
DbdPort=3306<br>
LogFile=/var/log/slurmdbd.log<br>
PidFile=/var/run/slurmdbd.pid<br>
PluginDir=/usr/lib/slurm<br>
SlurmUser=slurm<br>
StoragePass=password<br>
StorageType=accounting_</span><span style="font-family:verdana,sans-serif">storage/mysql<br>
StorageUser=slurm <br>
StorageLoc=slurm_acct_db</span></div>
<div><span style="font-family:verdana,sans-serif"><br>
</span></div>
<div><span style="font-family:verdana,sans-serif">I
changed the port to 3306
because otherwise
<i>slurmdbd </i>could not
communicate with <i>mysql</i>.
If I run <i>sacct</i>, for
example, I get:</span></div>
<div><span style="font-family:verdana,sans-serif"><br>
</span></div>
<div><span style="font-family:verdana,sans-serif"><i>sacct:
error:
_slurm_persist_recv_msg:
read of fd 3 failed: No
error<br>
sacct: error:
_slurm_persist_recv_msg:
only read 126 of 2616 bytes<br>
sacct: error:
slurm_persist_conn_open: No
response to persist_init<br>
sacct: error: Sending
PersistInit msg: No error<br>
JobID JobName
Partition Account
AllocCPUS State
ExitCode <br>
------------ ----------
---------- ----------
---------- ----------
-------- <br>
sacct: error:
_slurm_persist_recv_msg:
read of fd 3 failed: No
error<br>
sacct: error:
_slurm_persist_recv_msg:
only read 126 of 2616 bytes<br>
sacct: error: Sending
PersistInit msg: No error<br>
sacct: error:
DBD_GET_JOBS_COND failure:
Unspecified error</i></span></div>
<div><span style="font-family:verdana,sans-serif"><i><br>
</i></span></div>
<div><span style="font-family:verdana,sans-serif">Does
anyone have a suggestion to
solve this problem? Thank you
very much.</span></div>
<div><span style="font-family:verdana,sans-serif"><br>
</span></div>
<div><span style="font-family:verdana,sans-serif">Best,</span></div>
<div><span style="font-family:verdana,sans-serif">Giuseppe</span></div>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote></div>