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

Tue Oct 19 05:20:05 UTC 2021

Dear All,
By checking the value of last ran table, hourly rollup shows today's date.
+---------------+--------------+----------------+-------------
| hourly_rollup | daily_rollup | monthly_rollup        |
+---------------+--------------+----------------+-------------
|    1634617800 |   1634581800 |     1634581785 |
+---------------+--------------+----------------+-------------
As we can see the data from last 1 month in sreport but not the data from may
2020 to sept 21, but the same can be visible through sacct.

On October 19, 2021 at 12:27 AM Sean Crosby <scrosby at unimelb.edu.au> wrote:

>  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.
> 
> ------------------------------------------------------------------------------------------------------------
> 

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/20211019/75241e4a/attachment-0001.htm>