Jobs are stuck on UVB (hung jobs) - Clear all hung jobs

ISSUE

Archive jobs are stuck and do not complete.

RESOLUTION

NOTE: Before proceeding, please make sure that all other jobs have processed out of the queue, so that you only have the hung job in the queue still trying to process.  These commands will clear all jobs out of the queue, whether they are stuck or not.  
 

  1. Connect to the UVB with the Presentation (P) role via SSH
  2. Log in with username "admin" and password "password" (default)
  3. Execute the following commands:
    psql service=client;
    update client_job
    set job_status = 3,
    job_state = 7,
    timestamp = extract(epoch from now()),
    start_date = case when start_date is null then now() else start_date end,
    finish_date = now()
    where job_state < 6;
    update client_jobinventory
    set job_status = 3,
    job_state = 7,
    timestamp = extract(epoch from now()),
    start_date = case when start_date is null then now() else start_date end,
    finish_date = now()
    where job_state < 6;
This will clear all Jobs in the Active Jobs queue.

At this point, you should shut down all UVB VBAs and review the KB UVB Resources - Post processes are taking too long to complete. Once completed, you can resume your backups.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us