PostgreSQL's "canceling statement due to user request" error occurs when a statement receives an external termination signal, not necessarily from a human user. Common causes include client-side JDBC timeouts, server-side statement_timeout configuration, application restarts during query execution, manual cancellation via pg_cancel_backend(), and connection pool or proxy timeouts. The error message is the same regardless of the interruption source, making it important to understand the different layers (client driver, server configuration, connection pooling, application lifecycle) that can trigger statement cancellation.
Sort: