Editing more than 4 apps/modules leads to loading screen being stuck

[Walli]

In our organization we run a self hosted Retool instance in version 3.75.0.

We are experiencing a bug, where the edit app/module mode gets stuck in a loading screen when a certain number of apps/modules have been opened in edit mode on a certain branch.

Steps to reproduce:

1. Create a new branch X
2. Open an app/module, press edit app/module and select branch X.
   • Wait for it to finish loading.
   • When clicking on the branch in the bottom, you should see 1 app/module in the list of apps/modules for the branch.
3. Repeat step 2 until the list shows 4 open apps/modules.
4. Open a 5th app/module, press edit app/module and select branch X.
   • The editor will be stuck on the loading screen as this is the fifth app.

The loading screen shows the message "Loading page on branch..." like this:

An admin in our organization found, that when opening the edit mode, that gets stuck, the retool pod, that tries to open the editor, crashes after multiple times logging errors like "Health check error Database connection timed out":

Is there anything to be done about this issue?

Thank you
Martin

[jmann]

Hey @Walli - Thanks for flagging! I was able to reproduce this on 3.75, and turns out to be a database transaction issue leading to the server hanging until they all time out. We're testing a fix now, but you can try upping the POSTGRES_POOL_SIZE_MAX environment variable from the default of 5 to unblock you in the meantime (would need to be about 1 per number of apps/modules on the development branch to work around for now).