hello everyone! i need your help. i am running a task that queries a postgresql database in amazon RDS. when the query is simple, the task runs successfully. when the query is heavier, I see “Process PID 61 returned non-zero exit code” in the shell, and the task gets cancelled after a while because there is no heartbeat. what can i do? btw, i tried this locally and it worked fine. now i uploaded my code to render.com and it fails.

Hi @Yanina Libenson, I have seen some users mention that long running queries get cancelled due to no heartbeat. I think the recommendation for now is to turn off heartbeats for the flow while we look into it.

how can i turn them off?

Click on the Flow then Settings then at the Bottom

thank you so much!

Just a note that heartbeats more often than not are there to tell you your task died, so if your task is indeed dying, this wouldn’t be able to know. If you know the query works, it should be fine though. I tried render.com out. It’s really nice

i turned off heartbeats. i still see “Process PID 59 returned non-zero exit code” in the shell, and the task doesn’t get cancelled.

A bit of a clarification on what I said earlier, the heartbeats are just there to inform you that the task fails. This task is likely failing and the heartbeat is just informing you. Does this happen on the simple query?

with the simple query it works fine