[slurm-users] Slurm 20.02 Dry-Run DB upgrade - Question on the cloned DB

[Brian Andrus]

So if you run sshare on the head node, it shows your dummy user?


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.


Brian Andrus


On 2/7/2022 12:42 AM, Moshe Mergy wrote:
>
> Hi all
>
>
> I cloned the Slurm DB into a separated node, in order to test and run 
> a Dry-Run DB upgrade.
>
> Slurm 20.02.4 --> 21.08.5 on CentOS 7.6 / MariaDB 5.5.64-1.
>
> according to guide 
> https://wiki.fysik.dtu.dk/niflheim/Slurm_installation#make-a-dry-run-database-upgrade 
> <https://wiki.fysik.dtu.dk/niflheim/Slurm_installation#make-a-dry-run-database-upgrade>
>
>
> DB cloning: OK - mysql shows 2 differents DB with same data:
>
> the original DB on Head machine + the cloned DB on the Node.
>
>
> MY FEAR: destroying the original DB
>
>
> MY TEST: creating a dummy user on cloned DB and check that it is not 
> present in original DB
>
>
> Node: slurmdbd is running only (NO slurmd)
>
> Head: slurmdbd, slurmctld are running
>
>
> 1/ On Node "sacctmgr create user dummy" into cloned DB
>
> 2/ On Node "sacctmgr show user -s": user dummy is present in cloned 
> DB --> OK
>
> 3/ On Head "sacctmgr show user -s": user dummy is NOT present in 
> original DB --> OK
>
>
> PROBLEM:
>
> 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...!!
>
>
> QUESTIONS:
>
> It seems (from manual) that sshare uses slurmctld, which is related to 
> the original DB on Head machine.
>
> So user dummy should NOT be listed with "sshare" command from Head 
> machine. Neither from Node...?!
>
> (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...)
>
>
> Are the 2 DBs really separated ?
>
> So I can run the DB upgrade test on this cloned DB without destroying 
> the original DB ?
>
>
> Thanks a lot for your help!
>
> Regards,
>
>
> MosheM
>
> (Slurm & Mysql novice)
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.schedmd.com/pipermail/slurm-users/attachments/20220207/4864f9eb/attachment.htm>