How do you check the corresponding Cluster Job ID from the Columbus Job ID and vice versa

How do you check the corresponding Cluster Job ID from the Columbus Job ID and vice versa

- Switch into the postgres user

$ su postgres

- Connect to the columbus_webapp database using the PostgreSQL interactive terminal

$ psql columbus_webapp

- Use the following query replacing XXX with the Job ID (you can get this from the Cluster Job Status page)

SELECT id, cluster_job_id FROM cluster_jobstatus WHERE id=XXX;

For example for a Job ID 254:

SELECT id, cluster_job_id FROM cluster_jobstatus WHERE id=254;

Returns

id | cluster_job_id

-----+----------------

254 | 4295+4296+4297

(1 row)

- As oppose to the id you can also use the cluster_job_id (you need to include this within '')

SELECT id, cluster_job_id FROM cluster_jobstatus WHERE cluster_job_id='4295+4296+4297';

Returns

id | cluster_job_id

-----+----------------

254 | 4295+4296+4297

(1 row)

If you do not know the complete cluster_job_id and wanted to search for one specific slurm task id you can use the following query to search for an individual task in this example 4295

SELECT id, cluster_job_id FROM cluster_jobstatus WHERE cluster_job_id LIKE '%4295%';

The above uses the LIKE operator with % wildcards (allowing multiple characters) to search for any values that have "4295" in any position

- Once finished exit from psql by typing \q