PostgreSQL - The SQL request was either invalid or rejected by the remote database : ERROR: canceling statement due to user request


Symptoms

Your Elements Connect fields configured with a PostgreSQL database fail with a similar error:

The SQL request was either invalid or rejected by the remote database : ERROR: canceling statement due to user request

Cause

This error is returned by your PostgreSQL client himself which stops the query execution, that means the query took too much time and its timeout has been reached.

The problem could be solved by changing your datasource configuration.


Resolution

In your Database configuration, increase your read timeout to let the server answer the query, or disable timeouts.

If the problem persists, then please feel free to contact our support team to further investigate this problem.