rbayer666 opened a new issue, #65010:
URL: https://github.com/apache/airflow/issues/65010

   ### Under which category would you file this issue?
   
   Airflow Core
   
   ### Apache Airflow version
   
   3.2.0
   
   ### What happened and how to reproduce it?
   
   ** Issue Description **
   After upgrading from Airflow 3.1.8 to 3.2.0 without changing the 
configuration we encountered the problem that the meta database (running on 
PostgreSQL) stops accepting connections. Or, if we increase the allowed 
connections on the database, the sql achemy pool fills up.
   
   The sql_alchemy settings are the default ones:
   - sql_alchemy_pool_enabled = True
   - sql_alchemy_pool_size = 5
   - sql_alchemy_max_overflow = 10
   
   The allowed parallel database connections on the postgresql is set to 100.
   
   We have 1x api server, 1 x scheduler, 1 x triggerer.
   
   Increasing the sql_alchemy pool and the postgresql connections does not 
solve the issue - it just takes more time until the connection pool is filled 
up or the database stops accepting connections.
   
   It looks like the database connections are not properly closed and left 
open. Over time the connections sum up.
   
   
   
   ### What you think should happen instead?
   
   All database connections should be closed when they are no longer needed.
   
   ### Operating System
   
   Debian GNU/Linux 12 (bookworm)
   
   ### Deployment
   
   Docker-Compose
   
   ### Apache Airflow Provider(s)
   
   _No response_
   
   ### Versions of Apache Airflow Providers
   
   _No response_
   
   ### Official Helm Chart version
   
   Not Applicable
   
   ### Kubernetes Version
   
   v1.31.13
   
   ### Helm Chart configuration
   
   _No response_
   
   ### Docker Image customizations
   
   _No response_
   
   ### Anything else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [x] I agree to follow this project's [Code of 
Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to