Query timeout with 504 error after 60 seconds

Self Hosted Retool
1

We are using the self-hosted version of Retool.
Currently installed version: 2.95.6
I noticed that since this version 2.95.6 (we upgraded 2 days ago), all queries timeout after 60 seconds with a 504 error message. The timeout setting of the query is set to 120 seconds, so it makes no sense that if fails after 60 seconds.
Due to that, since the update, many of our longer-running quality checks are currently not working anymore in production.

Here an example:

image
image1572×726 68.2 KB

2

Hey @Reboon would you mind writing into our support team so we can take a closer look at what's going on here? Once we have a solution we will go ahead and update this thread. Thank You!

3

Thanks to the Retool support, a solution was found.
It turned that the environment parameter DBCONNECTOR_QUERY_TIMEOUT_MS has to be increased first and second that the nginx settings roxy_read_timeout, proxy_connect_timeout, proxy_send_timeout had to be adjusted as well. After these adjustments, the problem was solved.

1 Like