Hi Lee,
Just my 2 cents: Which database and OS versions do you run?
Furthermore, Slurm 23.02 is really old, so I'd recommend upgrading to 25.05 (or perhaps even 25.11). It just might be that your bug has been resolved in later versions of Slurm or MySQL/MariaDB.
You can find detailed upgrade instructions in [1]. Be especially mindful of the MySQL and slurmdbd upgrades, and perform a dry-run upgrade first on a test node.
On 1/7/26 13:22, Lee via slurm-users wrote:
I replicated this issue on a different cluster and determined that the root cause is that the time_eligible in the underlying MySQL database gets set to 0 when a running job is held. Let me demonstrate.
...
I am using slurm 23.02.6. I have a strange issue. I periodically use sacct to dump job data. I then generate reports based on the resource allocation of our users.
IHTH, Ole
[1] https://wiki.fysik.dtu.dk/Niflheim_system/Slurm_installation/#upgrading-slur...