WindmillWWindmill
Powered by
Ross CreightonR
Windmill•5mo ago•
3 replies
Ross Creighton

Error: Connecting to database: pool timed out while waiting for an open connection

Windmill server and worker containers deployed to ECS exit with the above error. The RDS postgres logs show
could not receive data from client: Connection reset by peer
could not receive data from client: Connection reset by peer
, suggesting a connection is being made but the client (server/worker containers) are killing the connection.

RDS instance is db.t4g.large. Confirmed the max connections setting is still the default (which allows ~900 connections for this instance size).

ECS tasks are deployed on Fargate with 2 vCPU and 4GB Memory. I don't see any evidence of memory or CPU constraints in monitoring.

I can successfully connect to the database via psql from an EC2 bastion using the same secrets and same security group configuration as the ECS Fargate tasks, but connections from the Fargate tasks are getting killed.

Tasks are using ghcr.io/windmill-labs/windmill image. I've tried redeploying the services with :main, :latest, and :1.547.0 tags.

Also tried rebooting the RDS database and deleting everything from the jobs tables, although this is a new windmill instance so there isn't much in the database.

I'm at a bit of a loss at the moment.
WindmillJoin
3,362Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements
Recent Announcements
henri-c

Weekly kenote to tell you about our latest updates https://discord.com/channels/930051556043276338/1278977038430240813 https://youtube.com/live/2dGd9TdT8xs?feature=share

henri-c · 4d ago

Pyra

### HTTP tracing (EE) Capture HTTP requests made by job scripts as observability spans Features: - View HTTP request traces (method, URL, status, timing) in the job details UI - Auto-instrumentation for Native TypeScript, MITM proxy for other languages - Integrates with external OpenTelemetry collectors changelog: https://www.windmill.dev/changelog/http-tracing docs: https://www.windmill.dev/docs/advanced/instance_settings#http-tracing Additionally jobs memory metrics are now fully OSS!

Pyra · 2w ago

henri-c

First keynote of the year here https://discord.com/channels/930051556043276338/1278977038430240813 🙂

henri-c · 4w ago

Similar Threads

Error when running a migration and connecting to external database
AnyaAAnya / help
11mo ago
Database migration error
RBlhazeRRBlhaze / help
2y ago
Database Manager JSONB Error
fooosieeeFfooosieee / help
2w ago
Database Studio Table - Error
cali (brazil)Ccali (brazil) / help
2y ago