[slurm-users] sacctmgr - bug listing accounts?

[Ole Holm Nielsen]

Hi Loris,

On 04/30/2018 01:09 PM, Loris Bennett wrote:
> Your example of how to use 'Organisation' to setup separate groups
> within one department is illuminating.  However, I am still unable to
> set up 'geochemie' as a sibling of 'geophysik' and a child of 'geowiss':
> 
>    $ sacctmgr list acc where account=geophysik
>       Account                Descr                  Org
>    ---------- -------------------- --------------------
>     geophysik            geophysik              geowiss
>    $ sacctmgr list acc where account=geochemie
>       Account                Descr                  Org
>    ---------- -------------------- --------------------
>    $ sacctmgr add acc geochemie Description="Geochemie" Parent=geowiss Organization=geochemie
>     No associations created.
>    $ sacctmgr list acc where account=geochemie
>       Account                Descr                  Org
>    ---------- -------------------- --------------------
> 
> So how do I get sacctmgr to show 'geochemie'?  The dump created by
> 'sacctmgr' indicated that 'geochemie' exists and is a child of
> 'geowiss':
> 
>    Parent - 'geowiss'
>    Account - 'geochemie':Fairshare=2
>    Account - 'geographie':Description='geographie':Organization='geowiss':Fairshare=1
>    Account - 'geologie':Description='geologie':Organization='geowiss':Fairshare=4
>    Account - 'geophysik':Description='geophysik':Organization='geowiss':Fairshare=3
>    Account - 'meteorologie':Description='meteorologie':Organization='geowiss':Fairshare=20
> 
> This is borne out by the contents of the database:
> mysql> select user,acct,id_assoc,parent_acct from soroban_assoc_table where acct like 'geo%';
> +------+------------+----------+-------------+
> | user | acct       | id_assoc | parent_acct |
> +------+------------+----------+-------------+
> |      | geochemie  |      909 | geowiss     |
> |      | geographie |      163 | geowiss     |
> |      | geologie   |      223 | geowiss     |
> |      | geophysik  |      296 | geowiss     |
> |      | geowiss    |       56 | root        |
> +------+------------+----------+-------------+
> 
> So this looks like a bug to me.

Let's first check your account hierarchy:  The command:

   /usr/bin/sacctmgr -sor show accounts

will print the hierarchy for you.  The output may look confusing, so I 
recommend you to run my tool "slurmaccounts2conf" which you will find at 
https://github.com/OleHolmNielsen/Slurm_tools/tree/master/slurmaccounts. 
  You don't have to copy my account setup, but the tools can still be 
useful.

As a reference, slurmaccounts2conf prints our account hierarchy like this:

###
### Slurm accounts for cluster niflheim
###
### Syntax of the file is:
### account:parent:FairShare:Description
###
### Parent account root->external
external:root:parent:external groups
qwise:external:parent:quantumwise
qwisegst:external:parent:quantumwise guests
topsoe:external:parent:haldor topsoe
###
### Parent account root->external->ku_kemi
ku_kemi:external:parent:ku kemi
chemku:ku_kemi:parent:ku kemi
###
### Parent account root->dtu
dtu:root:parent:dtu departments
###
### Parent account root->dtu->energy
energy:dtu:parent:dtu energy
###
### Parent account root->dtu->energy->batteries
batteries:energy:parent:batteries section
ecsvip:batteries:parent:batteries vip
ecsguest:batteries:parent:batteries guests
ecsfac:batteries:parent:batteries faculty
ecsstud:batteries:parent:batteries students
...

/Ole