Infinitely loading Queries when using retool with ssh tunnel

💬 Queries and Resources
1

  • Goal:
    I want the queries to run as expected and not time out, and if they time out to respect set timeouts not always use 120s.

  • Steps:
    I tried changing postgres parameters and Disable converting queries to prepared statements
    None have worked

  • Details:
    Queries timeout randomly. they get started but never finish.
    We use sshtunneling for a lotof our setups but never have experienced these issues.
    Timeouts set under advanced - timeout are just ignored and we need to wai 120s for it to timeout and restart.
    This makes the tool absolutely unsusable.

  • Screenshots:

image
image
from the same query, how can that be?

2

May I also note that during the loading time no connection is open on our DB

3

Hi @Stable_AshenJon,

Do you have Retool self hosted or on the cloud?

What type of database/resource are you querying? Is there any middleware on the server that you are querying?

So the issue is you want queries that are not working to time out sooner, so you can make tweaks/restart them but instead they are hanging on the connection and can't be exited early?