Hi,

After reconfiguring slurm.conf to add script into the database, I have tried 
with a "normal" user to get that information (from a owned finished job). 
However, when I run "sacct -vvvv  -B -j 92656", I get:

sacct: Jobs Eligible in the time window from Epoch 0 to Wed Jun 18 15:33:03 2025
sacct: debug:  Options selected:
        opt_completion=no
        opt_dup=no
        
opt_field_list=User,JobID,Jobname%18,partition,state,time,submit,start,end,elapsed,nnodes,ncpus,nodelist,
        opt_help=0
        opt_no_steps=yes
        opt_whole_hetjob=(null)
sacct: debug:  accounting_storage/slurmdbd: _connect_dbd_conn: Sent PersistInit 
msg
sacct: debug2: Clusters requested:      mycluster
sacct: debug2: Userids requested:       all
sacct: debug2: Jobs requested:
sacct: debug2:  : 92656
sacct: error: Unknown error 1064

I have read that "sacct: error: Unknown error 1064" could be a error in the 
MySQL query syntax... but if I run same command "sacct -vvvv  -B -j 92656" as 
root, I get submit script.

I suppose problem is in database permissions, so I have added new permissions 
with "grant all on slurmdb.* TO 'user-sacct'@'localhost' identified by 
'..user-sacct..' with grant option;" (where user "user-sacct" is a user that 
acts as coordinator in SLURM). However, if I open a terminal with "user-sacct" 
and run "sacct -vvvv  -B -j 92656", result is the same: "sacct: error: Unknown 
error 1064"

How could give permissions to user-sacct to allow "sacct -B" command?

Thanks.
-- 
slurm-users mailing list -- slurm-users@lists.schedmd.com
To unsubscribe send an email to slurm-users-le...@lists.schedmd.com

Reply via email to