[slurm-users] SlurmDBD 20.02.7

[Bas van der Vlies]

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.vandervlies at surf.nl
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2329 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.schedmd.com/pipermail/slurm-users/attachments/20220106/bb11954e/attachment-0001.bin>