[slurm-users] sreport cluster AccountUtilizationByUser showing utilization of a deleted account

[Chin,David]

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
dwc62 at drexel.edu                     215.571.4335 (o)
For URCF support: urcf-support at drexel.edu
https://proteusmaster.urcf.drexel.edu/urcfwiki
github:prehensilecode



Drexel Internal Data
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.schedmd.com/pipermail/slurm-users/attachments/20210210/b926e5b9/attachment.htm>