-
Bug
-
Resolution: Done
-
Critical
-
None
-
None
Noticed some legacy engine unit tests failing in upstream CI intermittenly with below traceback. This could be related to the switch to use native threads and probably somewhere we're not closing the connecton. This seems only related to sqlite (only used for unit tests) and has also been reported by other services like nova https://bugs.launchpad.net/nova/+bug/2002782 without any solution.
WARNING [oslo_db.sqlalchemy.exc_filters] DBAPIError exception wrapped. Traceback (most recent call last): File "/home/ramishra/work/openstack/heat/.tox/py310/lib64/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 1137, in fetchall rows = dbapi_cursor.fetchall() sqlite3.InterfaceError: Cursor needed to be reset because of commit/rollback and can no longer be fetched from. WARNING [oslo_db.sqlalchemy.exc_filters] DBAPIError exception wrapped. Traceback (most recent call last): File "/home/ramishra/work/openstack/heat/.tox/py310/lib64/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 1137, in fetchall rows = dbapi_cursor.fetchall() sqlite3.InterfaceError: Cursor needed to be reset because of commit/rollback and can no longer be fetched from. WARNING [oslo_db.sqlalchemy.exc_filters] DBAPIError exception wrapped. Traceback (most recent call last): File "/home/ramishra/work/openstack/heat/.tox/py310/lib64/python3.10/site-packages/sqlalchemy/engine/cursor.py", line 1137, in fetchall rows = dbapi_cursor.fetchall() sqlite3.InterfaceError: Cursor needed to be reset because of commit/rollback and can no longer be fetched from.
