Gateway Timeout (504) – MS SQL queries time out after 20 seconds (Retool Cloud)

💬 Queries and Resources
,
1

Hi,

we are using Retool Cloud and experiencing an issue with MS SQL queries that used to work fine.

Since today, all longer-running queries fail with the following error after exactly 20 seconds:

statusCode: 504  
error: "Gateway Time-out"  
message: "Request failed to complete"  
data: null

Everything worked normally yesterday, and no changes were made on our side.

Based on other forum posts, it seems this could be related to DBCONNECTOR_QUERY_TIMEOUT_MS or NGINX timeouts like proxy_read_timeout. Since we are on Retool Cloud and cannot configure these ourselves, could someone from the Retool team check our instance and increase these timeouts if needed?

Thanks in advance!

PS: maybe system problem

https://community.retool.com/t/my-big-query-resource-queries-timeout-after-20-seconds/56742

2 Likes
2

We’ve verified that any query or stored procedure execution against MS SQL that takes longer than exactly 20 seconds results in a timeout. This happens consistently, even with queries that worked fine yesterday. It seems like there’s a fixed timeout limit somewhere on the infrastructure side.

1 Like
3

I'm having the same issue with BigQuery timing out after 20 seconds. This has only been happening in the last day. I'm on retool cloud version 3.182.0 which was rolled out very recently (last 1-2 days). I can confirm that this issue does not occur in 3.181.0 if I roll back my app to a previous version.

1 Like
4

It looks like the Retool team responded to this one:

5

Thanks for flagging this issue! We recently identified and reverted the breaking change, so your queries should no longer timeout after just 20 seconds. :+1:

Let us know if you're able to confirm this or if you notice any additional issues!

6

Update:

Issue resolved – the problem was on the infrastructure side, and the timeouts have been adjusted. Thanks for the support!

1 Like