Hello, all:
Details:
* slurm 20.02.6
* MariaDB 10.3.17
* RHEL 8.1
I have a fairshare setup. I went through a couple of iterations in testing of
manually creating accounts and users that I later deleted before putting in
what is to be the production setup.
One of the deleted accounts is named "urcfadm" - in the slurm_acct_db →
acct_table,
the row (?) for that account has a value 1 in the "deleted" column:
creation_time mod_time deleted name description organization
1607378518 1611091499 1 urcfadm urcf_sysadmins research
I also purged all Events, Jobs, Steps, Suspend, Usage that are older than 1
hour.
sacctmgr archive dump Directory=/data/Backups/Slurm PurgeEventAfter=1hour \
PurgeJobAfter=1hour PurgeStepAfter=1hour PurgeSuspendAfter=1hour \
PurgeUsageAfter=1hour Events Jobs Steps Suspend Usage
When I run
sreport cluster AccountUtilizationByUser Start=2021-02-09 End=2021-02-10 -T
billing
I get numbers which don't add up as one goes up to the root node of the tree.
And I
have a line for the account "urcfadm":
--------------------------------------------------------------------------------
Cluster Account Login Proper Name TRES Name Used
--------- --------------- --------- --------------- -------------- --------
...
picotte urcfadm billing 110708
...
In the report period, no jobs ran under the urcfadm account.
Is there a way to fix this without just purging all the data?
If there is no "graceful" fix, is there a way I can "reset" the slurm_acct_db,
i.e. actually purge all data in all tables?
Thanks in advance,
Dave
--
David Chin, PhD (he/him) Sr. SysAdmin, URCF, Drexel
dw...@drexel.edu 215.571.4335 (o)
For URCF support: urcf-supp...@drexel.edu
https://proteusmaster.urcf.drexel.edu/urcfwiki
github:prehensilecode
Drexel Internal Data
