https://dagster.io/ logo
#ask-community
Title
# ask-community
a

Andrii Hedge

02/24/2024, 5:13 PM
Hello everyone, I'm reaching out to see if anyone else is encountering an issue where connecting to port 5432 results in the error: "sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server at "dagster_postgresql" (172.24.0.2), port 5432 failed: FATAL: sorry, too many clients already" I attempted to resolve this by increasing the maximum number of connections with the following command:
postgres -c 'max_connections=1000'
, but unfortunately, it hasn't resolved the problem. Interestingly, downgrading dagster-postgres seems to mitigate the issue. Has anyone experienced something similar, or does anyone have alternative solutions or insights into this problem? Thank you for any help or advice you can provide.
a

Andrea Giardini

02/26/2024, 8:38 AM
Which DB are you using? AWS RDS / Google CloudSQL / etc ?
a

Andrii Hedge

02/26/2024, 11:17 AM
I'm currently running a local Docker Compose setup with PostgreSQL on my M1 MacBook Pro.
a

Andrea Giardini

02/26/2024, 12:05 PM
mmm strange, how many user-deployments do you have?
a

Andrii Hedge

03/30/2024, 6:21 PM
Hi @Andrea Giardini, Sorry for delay with reply, after many experiments I found out that this is happening because of experimental feature
Global op/asset concurrency
when I turn this off, everything looks okay
a

Andrea Giardini

03/31/2024, 9:21 AM
Can you elaborate a bit? It might be worth investigating it a little more and opening a bug report. Can you post the non-working configuration?
7 Views