You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "jason810496 (via GitHub)" <gi...@apache.org> on 2026/03/03 07:27:29 UTC
[I] Flaky MySQL connections in unit tests [airflow]
jason810496 opened a new issue, #62768:
URL: https://github.com/apache/airflow/issues/62768
### Body
## What
The test sometimes fails due to `sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (2013, 'Lost connection to server during query')`
For example: https://github.com/apache/airflow/actions/runs/22609497337/job/65509753041?pr=62758
## Traceback Logs
Summary:
```python
ERROR airflow-core/tests/unit/jobs/test_triggerer_job.py::test_trigger_can_call_variables_connections_and_xcoms_methods - sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (2013, 'Lost connection to server during query')
[SQL: SELECT 1
FROM connection
WHERE connection.conn_id = %s]
[parameters: ('presto_default',)]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
```
<details>
<summary>full traceback:</summary>
```python
================================================================================================= ERRORS =================================================================================================
____________________________________________________________ ERROR at setup of test_trigger_can_call_variables_connections_and_xcoms_methods _____________________________________________________________
/usr/python/lib/python3.10/site-packages/sqlalchemy/engine/base.py:1967: in _exec_single_context
self.dialect.do_execute(
/usr/python/lib/python3.10/site-packages/sqlalchemy/engine/default.py:952: in do_execute
cursor.execute(statement, parameters)
/usr/python/lib/python3.10/site-packages/MySQLdb/cursors.py:179: in execute
res = self._query(mogrified_query)
/usr/python/lib/python3.10/site-packages/MySQLdb/cursors.py:330: in _query
db.query(q)
/usr/python/lib/python3.10/site-packages/MySQLdb/connections.py:286: in query
_mysql.connection.query(self, query)
E MySQLdb.OperationalError: (2013, 'Lost connection to server during query')
The above exception was the direct cause of the following exception:
airflow-core/tests/unit/jobs/test_triggerer_job.py:87: in clean_database
clear_db_connections()
devel-common/src/tests_common/test_utils/db.py:326: in clear_db_connections
create_default_connections(session)
airflow-core/src/airflow/utils/session.py:98: in wrapper
return func(*args, **kwargs)
airflow-core/src/airflow/utils/db.py:192: in create_default_connections
merge_conn(c, session)
airflow-core/src/airflow/utils/session.py:98: in wrapper
return func(*args, **kwargs)
airflow-core/src/airflow/utils/db.py:165: in merge_conn
if not session.scalar(select(1).where(conn.__class__.conn_id == conn.conn_id)):
/usr/python/lib/python3.10/site-packages/sqlalchemy/orm/session.py:2399: in scalar
return self._execute_internal(
/usr/python/lib/python3.10/site-packages/sqlalchemy/orm/session.py:2249: in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
/usr/python/lib/python3.10/site-packages/sqlalchemy/orm/context.py:306: in orm_execute_statement
result = conn.execute(
/usr/python/lib/python3.10/site-packages/sqlalchemy/engine/base.py:1419: in execute
return meth(
/usr/python/lib/python3.10/site-packages/sqlalchemy/sql/elements.py:527: in _execute_on_connection
return connection._execute_clauseelement(
/usr/python/lib/python3.10/site-packages/sqlalchemy/engine/base.py:1641: in _execute_clauseelement
ret = self._execute_context(
/usr/python/lib/python3.10/site-packages/sqlalchemy/engine/base.py:1846: in _execute_context
return self._exec_single_context(
/usr/python/lib/python3.10/site-packages/sqlalchemy/engine/base.py:1986: in _exec_single_context
self._handle_dbapi_exception(
/usr/python/lib/python3.10/site-packages/sqlalchemy/engine/base.py:2363: in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
/usr/python/lib/python3.10/site-packages/sqlalchemy/engine/base.py:1967: in _exec_single_context
self.dialect.do_execute(
/usr/python/lib/python3.10/site-packages/sqlalchemy/engine/default.py:952: in do_execute
cursor.execute(statement, parameters)
/usr/python/lib/python3.10/site-packages/MySQLdb/cursors.py:179: in execute
res = self._query(mogrified_query)
/usr/python/lib/python3.10/site-packages/MySQLdb/cursors.py:330: in _query
db.query(q)
/usr/python/lib/python3.10/site-packages/MySQLdb/connections.py:286: in query
_mysql.connection.query(self, query)
E sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (2013, 'Lost connection to server during query')
E [SQL: SELECT 1
E FROM connection
E WHERE connection.conn_id = %s]
E [parameters: ('presto_default',)]
E (Background on this error at: https://sqlalche.me/e/20/e3q8)
```
</details>
### Committer
- [x] I acknowledge that I am a maintainer/committer of the Apache Airflow project.
--
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-unsubscribe@airflow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Flaky MySQL connections in unit tests [airflow]
Posted by "Lee-W (via GitHub)" <gi...@apache.org>.
Lee-W closed issue #62768: Flaky MySQL connections in unit tests
URL: https://github.com/apache/airflow/issues/62768
--
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-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Flaky MySQL connections in unit tests [airflow]
Posted by "Pyasma (via GitHub)" <gi...@apache.org>.
Pyasma commented on issue #62768:
URL: https://github.com/apache/airflow/issues/62768#issuecomment-3991199054
hey @jason810496 is this a a connection pool / idle timeout issue in CI ?
--
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-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org