org.postgresql.util.PSQLException: ERROR: canceling statement
Work table query fails. The issue also occurs when a simple query is run through the Query Runner.
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
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.
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.
0% found this useful