Hi Danny,We had the same issue when we upgraded slurm to 20.11 but maybe the solution also works for you:
* https://bugs.schedmd.com/show_bug.cgi?id=12947
On 06/01/2022 15:36, Danny Marc Rotscher wrote:
Hello everyone, today we update our Slurm database daemon from 20.02.2 to 20.02.7 and everything works except when I try to delete a user it does not work. sacctmgr -i delete user name=xyz account=xyz sacctmgr: slurmdbd: No error Nothing deleted slurmdbd.log: slurmdbd_1 | slurmdbd: error: mysql_query failed: 1364 Field 'max_tres_pj' doesn't have a default value slurmdbd_1 | update "taurus_assoc_table" as t1 set mod_time=1641479365, deleted=1, def_qos_id=DEFAULT, shares=DEFAULT, max_jobs=DEFAULT, max_jobs_accrue=DEFAULT, min_prio_thresh=DEFAULT, max_submit_jobs=DEFAULT, max_wall_pj=DEFAULT, max_tres_pj=DEFAULT, max_tres_pn=DEFAULT, max_tres_mins_pj=DEFAULT, max_tres_run_mins=DEFAULT, grp_jobs=DEFAULT, grp_submit_jobs=DEFAULT, grp_jobs_accrue=DEFAULT, grp_wall=DEFAULT, grp_tres=DEFAULT, grp_tres_mins=DEFAULT, grp_tres_run_mins=DEFAULT, qos=DEFAULT, delta_qos=DEFAULT, priority=DEFAULT where (id_assoc=3527); slurmdbd_1 | slurmdbd: error: CONN:9 No error Does anyone knows what that mean? I also found out, that all *tres* fields in taurus_assoc_table are empty but not NULL. Kind regards, Danny Rotscher
-- Bas van der Vlies| HPCV Supercomputing | Internal Services | SURF | https://userinfo.surfsara.nl |
| Science Park 140 | 1098 XG Amsterdam | Phone: +31208001300 | | bas.vandervl...@surf.nl
smime.p7s
Description: S/MIME Cryptographic Signature
