<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,
<br>
<br>
Our slurm accounting database is growing bigger and bigger (more
than 100Gb) and is never being purged. We are running slurm
15.08.0-0pre1. I would like to upgrade to a more recent version of
the slurmdbd, but my fear is that it may break everything during the
update of the database.
<br>
<br>
Here is our slurmdbd.conf :
<br>
<br>
AuthType=auth/munge
<br>
AuthInfo=/var/run/munge/munge.socket.2
<br>
DbdHost=localhost
<br>
DebugLevel=6
<br>
StorageHost=localhost
<br>
StorageLoc=slurm_acct_db
<br>
StoragePass=shazaam
<br>
StorageType=accounting_storage/mysql
<br>
StorageUser=slurm
<br>
LogFile=/var/log/slurm-llnl/slurmdbd.log
<br>
PidFile=/var/run/slurm-llnl/slurmdbd.pid
<br>
SlurmUser=slurm
<br>
ArchiveDir=/home/joule/archives
<br>
PurgeEventAfter=18
<br>
PurgeJobAfter=18
<br>
PurgeResvAfter=1
<br>
PurgeStepAfter=1
<br>
PurgeSuspendAfter=1
<br>
<br>
I tried to purge it manually using this command but the slurmdbd
daemon ends up crashing and it doesn't remove anything:
<br>
<br>
sacctmgr archive dump Directory=<i class="moz-txt-slash"><span
class="moz-txt-tag">/</span>home/joule/archives<span
class="moz-txt-tag">/</span></i> PurgeJobAfter=365days
<br>
<br>
sacctmgr: error: slurmdbd: Getting response to message type 1459
<br>
sacctmgr: error: slurmdbd: DBD_ARCHIVE_DUMP failure: No error
<br>
Problem dumping archive: Unspecified error
<br>
<br>
Sometimes I have to restart the mysql daemon (we are running mysql
5.5.39-1). The /var/log/slurm-llnl/slurmdbd.log shows nothings. The
mysql logs are empty.
<br>
<br>
I tried to increase these values in my.cnf but so far no success :
<br>
<br>
innodb_buffer_pool_size = 32G
<br>
innodb_lock_wait_timeout = 3600
<br>
<br>
Is there any way to solve this issue ? Otherwise, what would be the
procedure for deleting the database records altogether and starting
on a fresh new one ?
<br>
<br>
Thanks in advance.
<pre class="moz-signature" cols="72">--
Julien REY
Plate-forme RPBS
Modélisation Computationnelle des Interactions Protéines-Ligand (CMPLI)
Université Paris Diderot - Paris VII
tel : 01 57 27 83 95 </pre>
</body>
</html>