Image Artist: Removing Job Status page entries

Warning: Before interacting with the sima_webapp database, it is essential to take a database backup. This backup can be used to restore the Job Status page content in case of any issues. For detailed instructions on capturing a database backup, refer to the knowledge article:  Image Artist: Backing up the Postgres databases

Job Status Page Content

The Job Status page content in Image Artist is stored in the cluster_jobstatus table of the sima_webapp database, which is located in the SImA_postgres-server container service.

Querying the Database

You can list or remove individual Job Status page entries by querying the database directly via the Image Artist host's command line interface using the following syntax:

docker exec $(docker ps -qf "name=postgres") psql -U columbus -d sima_webapp -c "<psql_query>"

Replace <psql_query> with a valid SQL query.

Listing entries by job "State"

Jobs are listed in one of the following states, as reported by the "Status" column of Image Artists Job Status page:

• CO - Completed
• FA - Failed
• UN - Unknown
• PE - Pending
• RU - Running
• SU - Submitting

To list all jobs with a "Failed" state:

psql_query:

select id,state,created from cluster_jobstatus where state='FA';

Complete Command:

docker exec $(docker ps -qf "name=postgres") psql -U columbus -d sima_webapp -c "select id,state,created from cluster_jobstatus where state='FA';"

Deleting entries by job "State"

To delete all jobs with a "Unknown" state:

psql_query:

delete from cluster_jobstatus where state='UN';

Complete Command:

docker exec $(docker ps -qf "name=postgres") psql -U columbus -d sima_webapp -c "delete from cluster_jobstatus where state='UN';"

Listing entries by job "ID"

Jobs can also be listed by their Job Status page ID. For example, to list job with ID "402":

psql_query:

select id,state,created from cluster_jobstatus where id=402

Complete Command:

docker exec $(docker ps -qf "name=postgres") psql -U columbus -d sima_webapp -c "select id,state,created from cluster_jobstatus where id=402;"

Deleting entries by job "ID"

To delete job with ID "402":

psql_query:

delete from cluster_jobstatus where id=402;

Complete Command:

docker exec $(docker ps -qf "name=postgres") psql -U columbus -d sima_webapp -c "delete from cluster_jobstatus where id=402;"