[slurm-users] [EXT] Re: Missing data in sreport for a time period in slurm

[Sean Crosby]

sreport keeps a track of when it has done the last rollup calculations in the database.

Open MySQL for your Slurm accounting database, do

select * from slurm_acct_db.clustername_last_ran_table;

where slurm_acct_db is your accounting database name (slurm_acct_db is default), and clustername is the name of your cluster in Slurm.

The numbers are UNIX timestamps. e.g for mine

select * from thespian_slurm_acct_db.thespian_last_ran_table;
+---------------+--------------+----------------+
| hourly_rollup | daily_rollup | monthly_rollup |
+---------------+--------------+----------------+
|    1634580000 |   1634562000 |     1633420706 |
+---------------+--------------+----------------+
1 row in set (0.00 sec)

1634580000 is Mon Oct 18 2021 18:00:00 GMT+0000

If you set those values to something before 26 May 2020, you can then either wait for the rollups to happen again, or you can trigger them to start by restarting slurmdbd. Once they start, you can monitor their progress by running that SQL query again. Once they have caught up again, sreport should be back to normal.

Sean
________________________________
From: slurm-users <slurm-users-bounces at lists.schedmd.com> on behalf of mshubham <mshubham at cdac.in>
Sent: Tuesday, 19 October 2021 00:22
To: slurm-users at lists.schedmd.com <slurm-users at lists.schedmd.com>
Subject: [EXT] Re: [slurm-users] Missing data in sreport for a time period in slurm

External email: Please exercise caution

________________________________
Dear all,
As i recall, there were some runaway jobs one month ago, and i used this command to fix it, and from that date only(from 15 Sept) , previous data from 26 May 2020 to Sept 14 2021
has been gone in sreport.
I hope there is no co-relation between using this command and data missing in sreport.

I have backup from that day of mysql, if you can suggest some way to integrate that data into slurm table in mysql.
Or is there any other way so that i can reinitialize the slurm utillization tables from initial.


On October 18, 2021 at 5:38 PM mshubham <mshubham at cdac.in> wrote:
Dear all,
 "sacctmgr show runawayjobs" doesnot show any problematic jobs.

On 10/18/21 12:41 PM, mshubham wrote:
> Dear all,
> I am facing a issue in slurm(v19.05.1) in which data from 26 May 2020 to
> Sept 14 2021 is missing in sreport but the same data is present through
> sacct command, It which was working fine few days ago.
> Right now, we have to get data utilization from sacct command for each user.
> It would be really helpful if this issue get resolved.

Does "sacctmgr show runawayjobs" reveal any problematic jobs?

Thanks and Regards,
Shubham


Thanks and Regards,
Shubham Mehta
HPC Technology
CDAC Pune

------------------------------------------------------------------------------------------------------------
[ C-DAC is on Social-Media too. Kindly follow us at:
Facebook: https://www.facebook.com/CDACINDIA & Twitter: @cdacindia ]

This e-mail is for the sole use of the intended recipient(s) and may
contain confidential and privileged information. If you are not the
intended recipient, please contact the sender by reply e-mail and destroy
all copies and the original message. Any unauthorized review, use,
disclosure, dissemination, forwarding, printing or copying of this email
is strictly prohibited and appropriate legal action will be taken.
------------------------------------------------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.schedmd.com/pipermail/slurm-users/attachments/20211018/d9eecfa9/attachment-0001.htm>