Critical: Intermittent Connection Failures Across Multiple Resources (Google Sheets & Supabase)

💬 App Building
1
  1. My goal:To restore stable connectivity for my Retool application, which relies on both Google Sheets and Supabase (PostgreSQL) resources.
  2. Issue:Starting today, multiple queries have begun failing intermittently with "Unexpected error occurred while running query."

    • This is happening across two different resource types (Google Sheets and Supabase).

    • The failures are random; the same query may work once and then fail the next three times.

    • The Google Sheets resource was recently moved to a Shared Drive, but even after re-authorization, the intermittent errors persist.

  3. Steps I've taken to troubleshoot:
    Re-authorization: Performed OAuth re-authorization for the Google Sheets resource multiple times.
    Sheet Configuration: Verified the Spreadsheet ID and confirmed the sheet names are correct.
    Database Check: Verified Supabase connection settings; however, it is also failing sporadically like the Google Sheets queries.
    Environment Test: Cleared browser cache and tested in Incognito mode, but the issue remains.
    Resource Re-creation: Attempted to refresh the resource connection, yet the "red exclamation mark"/error status appears inconsistently.
  4. Additional info: (Cloud or Self-hosted, Screenshots)
    Retool Deployment: [Specify: Cloud / Self-hosted]
    App URL: [Insert your App URL here]
    Screenshots: (I have attached a screenshot showing the "Unexpected error" in the query editor and the red error state of the resource).
3

Hi Andrew, thanks for bringing this up. We’re able to reproduce the issue on our end and noticing the the intermittent query success. There seems to be an issue in our backend. I’m grabbing a few engineers on our team to quickly investigate. Thanks for holding tight while we look into resolving this!

4

Hi Kenny
I would like to provide some feedback regarding the platform's performance. Over the past month, we have experienced frequent instability with Retool, including one instance where the system was completely down (a total outage) :smiling_face_with_tear:.

To be honest, these recurring issues are becoming quite concerning and are significantly impacting our daily business operations. We rely heavily on Retool for our workflow, so platform stability is our top priority.

We truly hope to see improved reliability in the future. We appreciate your hard work and kindly ask you to look into the current issue and provide a fix as soon as possible.

5

I hear you Andrew. This is not the experience you should be having and understand the frustration here with Retool. I’ve shared your feedback with our eng team. Thank you for sharing your pain points.

On the bright side, the issue should be resolved now. You should be able to continue monitoring this from our status page as well: https://status.retool.com/.

Let us know if this is working for you too.