We're updating the issue view to help you get more done. 

Support slurm v19 schema change in gratia-probe

Description

Slurm changed its db schema again in v19.

This came up in:

https://support.opensciencegrid.org/a/tickets/10170

Bockjoo shared the sql he is using to work around the problem; we can work this into the slurm probe like we did for the v18 breakage.

Workaround code from Bockjoo:

1 2 3 GROUP BY j.id_job,j.exit_code,j.id_group,j.id_user,j.job_name,j.tres_alloc,j.partition,j.state,a.acct,a.user,j.job_db_inx instead of GROUP BY id_job

Environment

None

Target metrics

None

Personnel

None

Freshdesk Tickets

None

Status

Assignee

Carl Edquist

Reporter

Carl Edquist

Priority

Major

Labels

None

Components

Fix versions

None

Epic Link

None

Sprint

None