MySQL - The SQL request was either invalid or rejected by the remote database : Statement cancelled due to timeout or client request


Symptoms

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

The SQL request was either invalid or rejected by the remote database : Statement cancelled due to timeout or client request

Cause

This error is returned by your MySQL 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.