Product: Columbus
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