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

   ### Body
   
   Observed in 
https://github.com/apache/airflow/actions/runs/5835505313/job/15827357798?pr=33309
   
   ```
   ___________________ ERROR at teardown of test_trigger_firing 
___________________
   
   self = <sqlalchemy.future.engine.Connection object at 0x7f92d3327910>
   
       def _rollback_impl(self):
           assert not self.__branch_from
       
           if self._has_events or self.engine._has_events:
               self.dispatch.rollback(self)
       
           if self._still_open_and_dbapi_connection_is_valid:
               if self._echo:
                   if self._is_autocommit_isolation():
                       self._log_info(
                           "ROLLBACK using DBAPI connection.rollback(), "
                           "DBAPI should ignore due to autocommit mode"
                       )
                   else:
                       self._log_info("ROLLBACK")
               try:
   >               self.engine.dialect.do_rollback(self.connection)
   
   /usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1062: 
   _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
_ _ 
   
   self = <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 
0x7f92d9698650>
   dbapi_connection = <sqlalchemy.pool.base._ConnectionFairy object at 
0x7f92d33839d0>
   
       def do_rollback(self, dbapi_connection):
   >       dbapi_connection.rollback()
   E       sqlite3.ProgrammingError: SQLite objects created in a thread can 
only be used in that same thread. The object was created in thread id 
140269149157120 and this is thread id 140269532822400.
   
   /usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py:683: 
ProgrammingError
   
   The above exception was the direct cause of the following exception:
   
       @pytest.fixture(autouse=True, scope="function")
       def close_all_sqlalchemy_sessions():
           from sqlalchemy.orm import close_all_sessions
       
           close_all_sessions()
           yield
   >       close_all_sessions()
   
   tests/conftest.py:953: 
   _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
_ _ 
   /usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py:4315: in 
close_all_sessions
       sess.close()
   /usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py:1816: in 
close
       self._close_impl(invalidate=False)
   /usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py:1858: in 
_close_impl
       transaction.close(invalidate)
   /usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py:926: in 
close
       transaction.close()
   /usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2426: in 
close
       self._do_close()
   /usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2649: in 
_do_close
       self._close_impl()
   /usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2635: in 
_close_impl
       self._connection_rollback_impl()
   /usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2627: in 
_connection_rollback_impl
       self.connection._rollback_impl()
   /usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1064: in 
_rollback_impl
       self._handle_dbapi_exception(e, None, None, None, None)
   /usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py:2134: in 
_handle_dbapi_exception
       util.raise_(
   /usr/local/lib/python3.11/site-packages/sqlalchemy/util/compat.py:211: in 
raise_
       raise exception
   /usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py:1062: in 
_rollback_impl
       self.engine.dialect.do_rollback(self.connection)
   _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
_ _ 
   
   self = <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 
0x7f92d9698650>
   dbapi_connection = <sqlalchemy.pool.base._ConnectionFairy object at 
0x7f92d33839d0>
   
       def do_rollback(self, dbapi_connection):
   >       dbapi_connection.rollback()
   E       sqlalchemy.exc.ProgrammingError: (sqlite3.ProgrammingError) SQLite 
objects created in a thread can only be used in that same thread. The object 
was created in thread id 140269149157120 and this is thread id 140269532822400.
   E       (Background on this error at: https://sqlalche.me/e/14/f405)
   
   /usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py:683: 
ProgrammingError
   ------------------------------ Captured log call 
-------------------------------
   INFO     airflow.jobs.triggerer_job_runner:triggerer_job_runner.py:171 
Setting up TriggererHandlerWrapper with handler <FileTaskHandler (NOTSET)>
   INFO     airflow.jobs.triggerer_job_runner:triggerer_job_runner.py:227 
Setting up logging queue listener with handlers [<LocalQueueHandler (NOTSET)>, 
<TriggererHandlerWrapper (NOTSET)>]
   INFO     
airflow.jobs.triggerer_job_runner.TriggerRunner:triggerer_job_runner.py:596 
trigger test_dag/test_run/test_ti/-1/1 (ID 1) starting
   INFO     
airflow.jobs.triggerer_job_runner.TriggerRunner:triggerer_job_runner.py:600 
Trigger test_dag/test_run/test_ti/-1/1 (ID 1) fired: TriggerEvent<True>
   Level 100 
airflow.triggers.testing.SuccessTrigger:triggerer_job_runner.py:633 trigger end
   INFO     
airflow.jobs.triggerer_job_runner.TriggerRunner:triggerer_job_runner.py:622 
trigger test_dag/test_run/test_ti/-1/1 (ID 1) completed
   ```
   
   ### 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: [email protected]

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

Reply via email to