prefect keeps losing connection to its database

DalgoT4D / prefect-proxy

GNU Affero General Public License v3.0

0 stars 7 forks source link

prefect keeps losing connection to its database #131

Open Ishankoradia opened 1 month ago

Ishankoradia commented 1 month ago

We see this error very frequently on production - sqlalchemy.dialects.postgresql.asyncpg.AsyncAdapt_asyncpg_dbapi.InterfaceError: <class 'asyncpg.exceptions._base.InterfaceError'>: connection is closed

Ishankoradia commented 1 month ago

Updated production with the following prefect settings parameters PREFECT_SQLALCHEMY_POOL_SIZE: 10 (currently 5) PREFECT_API_DATABASE_CONNECTION_TIMEOUT: 20 (currently 5) PREFECT_API_DATABASE_TIMEOUT: 20 (currently 10)

@fatchat

Ishankoradia commented 1 month ago

This didn't work. I still see connection errors in worker logs.