Did you change those values to a timestamp before May 2020 like I suggested? If you do that, then Slurm will regenerate the data needed for sreport to work properly.
Sean ________________________________ From: mshubham <mshub...@cdac.in> Sent: Tuesday, 19 October 2021 16:20 To: slurm-users@lists.schedmd.com <slurm-users@lists.schedmd.com>; Sean Crosby <scro...@unimelb.edu.au> Subject: Re: [EXT] Re: [slurm-users] Missing data in sreport for a time period in slurm External email: Please exercise caution ________________________________ 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 <scro...@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-boun...@lists.schedmd.com> on behalf of mshubham <mshub...@cdac.in> Sent: Tuesday, 19 October 2021 00:22 To: slurm-users@lists.schedmd.com <slurm-users@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 <mshub...@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. ------------------------------------------------------------------------------------------------------------
