org.postgresql.util.PSQLException: ERROR: canceling statement due to user request


Samebug tips1

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>


7 months ago
Expert tip

Solutions on the web1782

Solution icon of github
via GitHub by simeonmalchev
, 8 months ago
ERROR: canceling statement due to user request

Solution icon of github
via GitHub by unix-junkie
, 5 months ago
ERROR: cached plan must not change result type

Solution icon of googlegroups
via Google Groups by Anthony Presley, 1 year ago
ERROR: canceling statement due to user request

Solution icon of googlegroups
via Google Groups by John Lister, 3 months ago
ERROR: canceling statement due to user request

Solution icon of web
ERROR: canceling statement due to user request

Solution icon of github
via GitHub by rdp
, 1 year ago
ERROR: canceling statement due to user request

Solution icon of web
via postgresql.org by Unknown author, 1 year ago
ERROR: canceling query due to user request

Solution icon of web
via nabble.com by Unknown author, 1 year ago
ERROR: canceling query due to user request

Solution icon of github
ERROR: canceling statement due to statement timeout

Solution icon of stackexchange-dba
ERROR: canceling statement due to conflict with recovery Detail: User query might have needed to see row versions that must be removed.

Stack trace

org.postgresql.util.PSQLException: ERROR: canceling statement due to user request
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
	at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Once, 4 months ago
11 times, 1 week ago
2 times, 4 months ago
4 times, 10 months ago
6 times, 1 year ago
98 more bugmates