KnowledgeBase Content Details

May 17, 2019

Question:

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

Answer:


- 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

Back to KnowledgeBase