zhenghanyang opened a new issue, #34950: URL: https://github.com/apache/airflow/issues/34950
### Apache Airflow version 2.7.2 ### What happened When I set sql_alchemy_pool_enabled to false https://airflow.apache.org/docs/apache-airflow/stable/configurations-ref.html#config-database-sql-alchemy-pool-enabled The airflow web report following error: ``` TypeError: Invalid argument(s) 'pool_size' sent to create_engine(), using configuration AuroraMySQLDataAPIDialect/NullPool/Engine. Please check that the keyword arguments are appropriate for this combination of components. ``` ### What you think should happen instead This is a known issue of flask-sqlalchemy before Flask-SQLAlchemy 3.0.0 https://github.com/pallets-eco/flask-sqlalchemy/issues/803 Already fixed at v3.0.0, can airflow upgrade the version of Flask-SQLAlchemy to 3.0.0 or higher? https://flask-sqlalchemy.palletsprojects.com/en/3.0.x/changes/ The lastest airflow is still using Flask-SQLAlchemy 2.5.1 https://raw.githubusercontent.com/apache/airflow/constraints-2.7.2/constraints-3.8.txt I try to comment the three lines in flask-sqlalchemy, then airflow web works fine ```python # if sa_url.drivername != 'mysql+gaerdbms': # options.setdefault('pool_size', 10) # options.setdefault('pool_recycle', 7200) ``` ### How to reproduce Using mysql as airflow meta db, set set sql_alchemy_pool_enabled to false, then open airflow web page, it will report error ### Operating System Redhat 8.4 ### Versions of Apache Airflow Providers https://raw.githubusercontent.com/apache/airflow/constraints-2.7.2/constraints-3.8.txt Flask-SQLAlchemy==2.5.1 ### Deployment Official Apache Airflow Helm Chart ### Deployment details _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: commits-unsubscr...@airflow.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
