Article Number: 524883

printer Print mail Email

DPA Jobmonitor requests in 'Queued for Processing' state

Primary Product: Data Protection Advisor

Product: Data Protection Advisor 18.1 more...

Last Published: 23 Mar 2020

Article Type: Break Fix

Published Status: Online

Version: 5

DPA Jobmonitor requests in 'Queued for Processing' state

Article Content

Issue


Several of the DPA Jobmonitor requests (for any Backup Application) are in a "Queued for Processing" state and do not change. 

Symptoms:
  • Incomplete Job Reports (e.g., missing clients)
  • Empty Reports which would result in scheduled reports not being published.
  • If alerting has been enabled, failure to get an alert of an event.


 
Cause
Although there are many scenarios on why requests are in a "Queued for Processing" state the most common reason is due to the DPA Servers being restarted without first stopping the DPA processes first.  This is commonly seen after an O/S level patch implementation.
Due to the incorrect restart procedure, it created an orphaned transaction which failed to close properly which causes a disruption to any future transactions leading to requests being in a "Queued for Processing" state.
 
Resolution
Run the following query against the DPA Datastore to verify if these orphaned transactions exist:

For WINDOWS:
  • dpa ds query "select * from pg_prepared_xacts;" > preparedxacts.txt
For UNIX:
  • ./dpa.sh ds query "select * from pg_prepared_xacts;" > preparedxacts.txt
If any prepared transaction do exist please contact Dell EMC Technical Support and provide the output file created from the above command.
They will be able to provide assistance on removing the orphaned transaction. 
Notes

Issue


Several of the DPA Jobmonitor requests (for any Backup Application) are in a "Queued for Processing" state and do not change. 

Symptoms:
  • Incomplete Job Reports (e.g., missing clients)
  • Empty Reports which would result in scheduled reports not being published.
  • If alerting has been enabled, failure to get an alert of an event.


 
Cause
Although there are many scenarios on why requests are in a "Queued for Processing" state the most common reason is due to the DPA Servers being restarted without first stopping the DPA processes first.  This is commonly seen after an O/S level patch implementation.
Due to the incorrect restart procedure, it created an orphaned transaction which failed to close properly which causes a disruption to any future transactions leading to requests being in a "Queued for Processing" state.
 
Resolution

Run the following query against the DPA Datastore to verify if these orphaned transactions exist:

For WINDOWS:
  • dpa ds query "select * from pg_prepared_xacts;" > preparedxacts.txt
For UNIX:
  • ./dpa.sh ds query "select * from pg_prepared_xacts;" > preparedxacts.txt
If any prepared transaction do exist please contact Dell EMC Technical Support and provide the output file created from the above command.
They will be able to provide assistance on removing the orphaned transaction. 

Notes

Article Attachments

Attachments

Attachments

Article Properties

First Published

Fri Dec 14 2018 08:32:09 GMT

First Published

Fri Dec 14 2018 08:32:09 GMT

Rate this article

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters