KnowledgeBase Content Details

June 13, 2019

Question:

How can I clear the Columbus cluster job status page?

Answer:

The cluster_jobstatus table can be found in the columbus_webapp database. You must first login to the Columbus server via ssh connection i.e. using PuTTY or Terminal.

You can erase the job status table through psql by connecting to the database and issuing the following commands *IMPORTANT* The command deletes all entries from the Columbus cluster job status page:

 

If logged in as the root user, switch to the 'columbus' account:

 

$ su columbus

 

Login to the columbus_webapp database:

 

$ psql columbus_webapp

 

Welcome to psql 8.3.11, the PostgreSQL interactive terminal.

 

Type:  \copyright for distribution terms

       \h for help with SQL commands

       \? for help with psql commands

       \g or terminate with semicolon to execute query

       \q to quit

 

Issue the following command *IMPORTANT* The command deletes all entries from the Columbus cluster job status page:

 

columbus_webapp=> delete from cluster_jobstatus;

 

Back to KnowledgeBase