Support Article
org.postgresql.util.PSQLException: ERROR: canceling statement
SA-98128
Summary
Work table query fails. The issue also occurs when a simple query is run through the Query Runner.
Error Messages
There was a problem performing a database query: 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 or configuration issue in the operating environment.
The query took longer than 90 seconds to execute and timed out. The issue occurred because the statistics on the database table was not up to date. The ResetTableStats activity run by Pega Predictive Diagnostic Cloud (PDC) everyday impacted the auto-maintenance of the database tables on a Postgres database.
Resolution
Make the following change to the operating environment:
- Update the statistics on the database table. The query executes successfully without timing out.
- Update the Dynamic System Setting (DSS) record with the 'PegaAESRemote* ResetTableStats' key to a value of false.
- Restart the Util node to disable the ResetTableStats feature.
Published February 10, 2020 - 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.