How to Prevent Pipedream from Terminating SQL Query Running Over One Minute in Postgres?

Help
1

This topic was automatically generated from Slack. You can find the original thread here.

Hi Guys, I am new to Pipedream and converting my workflows from a different tool, I am getting my query terminated when it runs for more than one minute, the less than 1-minute works fine, the step is Execute SQL Query, the database is Postgres, please help

image.png
image.png1149×611 81.2 KB

2

Hi , welcome to Pipedream!
I don’t see any timeout configuration from our side. I wonder if there’s a timeout configuration set in the database?

3

I think there might be a shorter timeout when building and testing compared to running your workflow in production

4

I will try run in deployment mode and see if it improves

5

Hello Dan and Andrew, I have run the workflow in production after deploying over the weekend but I still got the same issue of the query terminating after 1 minute running, I have checked if there is a timeout in the database but there is none, see screenshot below

image.png
image.png1429×1270 168 KB

image.png

image.png
image.png708×128 18.9 KB

6

Hm, and just to confirm, are you connecting to the same database in that step above this one, in the screenshot?

7

I was wondering if it’s related to an IP restriction on the db

8

yes its the same database, previous step working just fine