My goal:
To run a Retool Workflow on a schedule without intermittent failures.
Issue:
The workflow fails every 1ā2 days. In the run history, it just shows Status: "Failure" with 0 errors and no explanation. Some blocks are not executed at all, and this same pattern happens every time it fails.
I've attached a screenshot of the run history to show exactly what Iām seeing.
Verified triggers and conditions are correctly set
I also found this topic from another user who seems to be experiencing a similar issue.
Would appreciate any insights or suggestions from the community or Retool team on how to debug this further.
The more workflows run in parallel, the more likely it is that the behaviour occurs.
I'm using Retool Self-hosted. Is there anything about the deployment I need to change?
For self hosted there may be some additional logs from the workflows container that we could look at to check for clues on what could be going wrong.
Apologies for the issue. Let me touch base with the workflows team and check with them on best steps to trouble shoot what could be causing these to fail
For users on the cloud, if you can share workflow ids and workflow run ids we can check our logs to see if there are more details we can find to clear things up.
We run the self-hosted setup with the provided docker compose file, a self-hosted temporal and an external PostgreSQL database. It's running a VPS with 14 cores and 36 GB of memory. We are running edge version 3.207.0.
Thank you so much for sharing these details! Very helpful @fibis
Can you share with me a dump of their workflows container logs? Would also confirm if they mean self managed or local cluster.
I also just want to confirm weather you meant self managed or local cluster As the answer to that will determine which steps from the set up docs here I would recommend for you to double check that you have set up correctly.
For testing purposes, if you can add a Response Block to the end the the workflow, that may be able to capture an error message for a failing workflow to give us more details.