Steve Brasier

Needs something like this adding ``` grafana_datasources: - name: slurmdb ds_type: mysql ds_url: "{{ groups['control'] | first }}" # {{ openhpc_slurmdbd_host}} for some reason doesn't need port database: slurm_acct_db #...

See dashboard https://grafana.com/grafana/dashboards/15754/edit?pg=dashboards&plcmt=usr-upload which looks like  vs current slurm_stats->filebeat->opendistro one: 

To see the job data: ``` mysql -p -u slurm slurm_acct_db describe esearch_job_table; select * from esearch_job_table; exit; ``` Prom regex are re2: `https://github.com/google/re2/wiki/Syntax`

slurmdbd's "node range expressions" (from [slurm.conf](https://slurm.schedmd.com/slurm.conf.html#SECTION_NODE-CONFIGURATION)) , e.g. `linux[0-64,128]", or "lx[15,18,32-33]`. I /think/ these can be combined, e.g. a job might look like: ``` linux[0-64,128],lx[15,18,32-33] ``` Note that from the...

Confirmed as of slurm `22.05.11` that the mysql database does contain the node list in the short "hostlist expression" format, e.g. `slurm-v2-compute-standard-[0-1]` See https://github.com/stackhpc/slurm-openstack-tools/blob/09e347902a2603de0be05f01b8a343da23d3c330/slurm_openstack_tools/sacct.py#L73 for the steps to a) turn...

Did some investigatory work in https://github.com/sjpb/no-opensearch which demoed it is not trivial to directly hit the mysql db. As well as the hostlist expression expansion, sacct output expands uids/gids to...

Have rolled a fix for this as part of tests improvements - see b1896ae3ba90e39cc895b54bd23d38fde0d0b453

Fixed by #188, not merged to alaska yet

I think what happened here is exactly what you said - I added new functionality and it's changed the users :-( I think it means the playbooks need to create...

Or the roles chmod things as required, but that feels bad.