Support Article
Large number of queue items are not processed
SA-79529
Summary
Queue items are not processed when there are about 2 million queue items per day.
Error Messages
An error occurred on executing the query for the report definition -
com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 0 SQLState: 57014 Message: ERROR: canceling statement due to user request
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: canceling statement due to user request
| SQL Code: 0 | SQL State: 57014
Steps to Reproduce
Not Applicable
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
As a local-change, enable the AUTOVACUUM setting.
Published August 15, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.