<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>So if you run sshare on the head node, it shows your dummy user?</p>
<p><br>
</p>
<p>At any rate, just do a db dump (also known as a backup) and you
can restore that if you have an issue of any sort.</p>
<p><br>
</p>
<p>Brian Andrus</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 2/7/2022 12:42 AM, Moshe Mergy
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:e47b6971eb5f447395e8f409aa797fac@weizmann.ac.il">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css" style="display:none;">P {margin-top:0;margin-bottom:0;}</style>
<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 moz-txt-link-freetext" id="LPlnk5158"
previewremoved="true" moz-do-not-send="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 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>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>
</blockquote>
</body>
</html>