How to Prevent Pipedream from Leaving PostgreSQL Connections Open and Blocking Queries?

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

It seems Pipedream leaves the connection to postgres open after running a workflow, which is leading to my postgres instance reaching max connections and blocking any and all queries that come in. Basically rendering my application unusable. What do I need to do to make Pipedream close the connection? This seems to be happening since January 30 6PM UTC. See screenshot with open connections. I have confirmed that a new one gets added at 15 past the hour every hour, which is when I have a scheduled workflow running on pipedream.

Hi , may I ask which Postgres actions/sources you’re using?

Execute SQL Query (see attached). There are 3 of those in that workflow. Thing is I didn’t change that workflow over the past week and it was running every hour of every day and suddenly what you see in the graph started happening.

image.png

Got it. I’ll try to reproduce and get back to you soon.

Thanks!

quick question, are using the shared static IP address?

Yes I am. It’s pretty much a requirement to use Postgres.

FYI the engineering team is investigating this

Thanks

Posting an update – we’ve identified an issue and are working on a fix!

Ok thanks Andrew