<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" dir="ltr" style="font-size: 12pt; color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols;">
<p>Hi all</p>
<p><br>
</p>
<p>I cloned the Slurm DB into a separated node, in order to test and run a Dry-Run DB upgrade.</p>
<p>Slurm 20.02.4 --> 21.08.5 on CentOS 7.6 / MariaDB 5.5.64-1.</p>
<p>according to guide <a href="https://wiki.fysik.dtu.dk/niflheim/Slurm_installation#make-a-dry-run-database-upgrade" class="OWAAutoLink" id="LPlnk5158" previewremoved="true">https://wiki.fysik.dtu.dk/niflheim/Slurm_installation#make-a-dry-run-database-upgrade</a></p>
<p><br>
</p>
<p>DB cloning: OK - <span style="font-size: 12pt;">mysql shows 2 differents DB with same data: </span></p>
<p>the original DB on Head machine + the cloned DB on the Node.</p>
<p><br>
</p>
<p>MY FEAR: <span style="font-size: 12pt;">destroying the original DB</span></p>
<p><br>
</p>
<p>MY TEST: creating a dummy user on cloned DB and check that it is not present in original DB</p>
<p><br>
</p>
<p></p>
<p style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">
Node: slurmdbd is running only <span style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">(</span><span style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">NO </span><span style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">slurmd) </span></p>
<p style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">
Head: slurmdbd, slurmctld are running</p>
<br>
<p></p>
<p>1/ On Node "<span>sacctmgr create user dummy" into cloned DB</span></p>
<p><span>2/ On Node "<span>sacctmgr show user -s</span>": user dummy is present in cloned DB --> OK</span></p>
<p><span>3/ On Head "<span>sacctmgr show user -s</span>": user dummy is NOT present in original DB --> OK </span></p>
<p><span></span></p>
<p><span><br>
</span></p>
<p><span>PROBLEM:</span></p>
<p><span>But if I use command "sshare -al" to list the users, the user dummy appears to be present in cloned DB... AND in original DB too...!!</span></p>
<p><span><br>
</span></p>
<p><span>QUESTIONS: </span></p>
<p><span>It seems (from manual) that sshare uses slurmctld, which is related to the original DB on Head machine.</span></p>
<p><span>So user dummy should NOT be listed with "sshare" command from Head machine. Neither from Node...?!</span></p>
<p><span>(And on the other hand, in case sshare does not use slurmctld, but send direct requests to the DB, then the dummy user should be listed (with sshare) only on Node, but NOT on Head machine...)</span></p>
<p><span><br>
</span></p>
<p><span>Are the 2 DBs really separated ? </span></p>
<p><span>So I can run the DB upgrade test on this cloned DB without destroying the original DB ?</span></p>
<p><span><br>
</span></p>
<p>Thanks a lot for your help!</p>
<p>Regards,</p>
<p><br>
</p>
<p>MosheM </p>
<p><span style="font-size: 12pt;">(Slurm & Mysql novice)</span></p>
<p><span><br>
</span></p>
</div>
</body>
</html>