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.