)]}'
{"/PATCHSET_LEVEL":[{"author":{"_account_id":11816,"name":"mike_mp@zzzcomputing.com","display_name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","username":"zzzeek","status":"Red Hat"},"change_message_id":"3f678ad93f18f8a30c0c7c9302401c295065d2b4","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"a24a7ab4_e0eaa6b9","updated":"2023-07-18 13:44:08.000000000","message":"OK I have isolated the chain of events that is happening here.   I\u0027m not sure what to do about it yet, though, but probably the change here is what would work around this for now.\n\nfirst off, what\u0027s different in SQLAlchemy 2.0.  It\u0027s that 2.0 has added RETURNING support for SQLite and also ORM UPDATE/DELETE statements as are being run in this test will use RETURNING in many more cases.   that\u0027s part one.\n\nNext, the actual exception SQLite is raising here seems to be occurring not when the statement is executed but when the result set from the RETURNING is fetched.   maybe this is the ubuntu / fedora difference, but that\u0027s not established yet.    Generally, I have found it extremely difficult to run tests against the SQLAlchemy exception handler as it is invoked in result sets; db drivers don\u0027t really raise in that process except in very unusual circumstances.\n\nThird, this is then the source of the double filter call - the overall sqlalchemy.connection.execute() runs the statement and related steps, catches exceptions and runs them into handle_error().   Key here is \"related steps\", the engine then wants to pre-fetch the RETURNING rows, that fails here with SQLite, that also calls the handle_error().   so that\u0027s the issue.  ive added the stack traces to https://github.com/sqlalchemy/sqlalchemy/issues/10116 where we will probably do nothing about this, just document that very rare circumstances might have a reentrant call here, which seems to be partially because we are rewriting the exception to something SQLAlchemy doesn\u0027t know about.","commit_id":"8dcd47383d35a0f4e2283b09d70f34ad120a85f7"},{"author":{"_account_id":11816,"name":"mike_mp@zzzcomputing.com","display_name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","username":"zzzeek","status":"Red Hat"},"change_message_id":"36e4efd1e275053b996604fd48def290dc73489b","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"68c8e0f3_03fdef2c","updated":"2023-07-14 16:22:47.000000000","message":"hmmmmmm...can i see a stack trace on that ?     a little scary.  if tests pass here, that should be fine, but why exactly this would happen...unclear. do they have an exception handler that is itself accessing ORM objects or the database somehow?","commit_id":"8dcd47383d35a0f4e2283b09d70f34ad120a85f7"},{"author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"change_message_id":"3f67aa0f89e8ff4c893da7b9d3ae6ae494937044","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"322086b9_0b03d3d3","updated":"2023-07-17 09:39:00.000000000","message":"recheck timeout","commit_id":"8dcd47383d35a0f4e2283b09d70f34ad120a85f7"},{"author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"change_message_id":"209717e3bf29019a99e7737153c98e3e9a9bc456","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"ec16ba3e_0fdc9600","updated":"2023-07-18 17:29:34.000000000","message":"recheck unrelated failure","commit_id":"8dcd47383d35a0f4e2283b09d70f34ad120a85f7"},{"author":{"_account_id":11816,"name":"mike_mp@zzzcomputing.com","display_name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","username":"zzzeek","status":"Red Hat"},"change_message_id":"a87477b949f942b312e5dabf5b844dd26735da83","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"53e21575_102be4dc","in_reply_to":"3e14da3e_de689eb2","updated":"2023-07-17 15:03:35.000000000","message":"this doesn\u0027t reproduce for me locally, and I am scratching my head trying to guess how the OS type would affect this - the only thing that changes on OSes is the specific SQLite version, but the test here is correctly producing the right exception.\n\nI know very little about ubuntu and tried to run a container, but there is no python3-tox package:\n\npodman run -it ubuntu:22.04 bash\nResolved \"ubuntu\" as an alias (/etc/containers/registries.conf.d/000-shortnames.conf)\nTrying to pull docker.io/library/ubuntu:22.04...\nroot@575ddfbce3f0:/# apt update\nGet:1 http://archive.ubuntu.com/ubuntu jammy InRelease [270 kB]\nGet:2 http://archive.ubuntu.com/ubuntu jammy-updates InRelease [119 kB]               \nGet:3 http://security.ubuntu.com/ubuntu jammy-security InRelease [110 kB]\nGet:4 http://archive.ubuntu.com/ubuntu jammy-backports InRelease [108 kB]\nGet:5 http://archive.ubuntu.com/ubuntu jammy/restricted amd64 Packages [164 kB]\nGet:6 http://archive.ubuntu.com/ubuntu jammy/main amd64 Packages [1792 kB]\nGet:7 http://archive.ubuntu.com/ubuntu jammy/multiverse amd64 Packages [266 kB]\nGet:8 http://archive.ubuntu.com/ubuntu jammy/universe amd64 Packages [17.5 MB]\nGet:9 http://security.ubuntu.com/ubuntu jammy-security/restricted amd64 Packages [720 kB]\nGet:10 http://security.ubuntu.com/ubuntu jammy-security/universe amd64 Packages [949 kB]\nGet:11 http://security.ubuntu.com/ubuntu jammy-security/main amd64 Packages [722 kB]\nGet:12 http://security.ubuntu.com/ubuntu jammy-security/multiverse amd64 Packages [44.0 kB] \nGet:13 http://archive.ubuntu.com/ubuntu jammy-updates/universe amd64 Packages [1205 kB]       \nGet:14 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 Packages [1008 kB]\nGet:15 http://archive.ubuntu.com/ubuntu jammy-updates/multiverse amd64 Packages [49.8 kB]\nGet:16 http://archive.ubuntu.com/ubuntu jammy-updates/restricted amd64 Packages [732 kB]\nGet:17 http://archive.ubuntu.com/ubuntu jammy-backports/universe amd64 Packages [25.6 kB]\nGet:18 http://archive.ubuntu.com/ubuntu jammy-backports/main amd64 Packages [49.4 kB]\nFetched 25.8 MB in 3s (7816 kB/s)                      \nReading package lists... Done\nBuilding dependency tree... Done\nReading state information... Done\nAll packages are up to date.\nroot@575ddfbce3f0:/# apt install -y python3 python3-tox\nReading package lists... Done\nBuilding dependency tree... Done\nReading state information... Done\nE: Unable to locate package python3-tox\n\ncan you reproduce this in a container setup that I can run?\n\nthe thing about exceptions here is that the behavior should be deterministic, there\u0027s no opportunity for a race condition normally","commit_id":"8dcd47383d35a0f4e2283b09d70f34ad120a85f7"},{"author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"change_message_id":"4fa290e93ff78b04469ed0f5981fa8f10f375d38","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"3e14da3e_de689eb2","in_reply_to":"3f9c6fdf_1c832a9d","updated":"2023-07-17 09:38:51.000000000","message":"To be clear, a reproducer looks like:\n\n```bash\n# create an Ubuntu 22.04 VM and install dependencies\n# (there may be more than this necessary, I\u0027d already installed DevStack in mine)\nsudo apt update\nsudo apt install -y python3 python3-tox\n\n# checkout barbican with changes\ngit clone https://opendev.org/openstack/barbican\ngit fetch https://review.opendev.org/openstack/barbican refs/changes/08/888308/2 \u0026\u0026 git checkout FETCH_HEAD\n\n# create tox venv with sqlalchemy 2.x and other deps\ntox -e py310 -- --notest\nsource .tox/py310/bin/activate\npip install --upgrade \u0027sqlalchemy\u003e\u003d2\u0027 \u0027oslo.db\u003e\u003d13\u0027 \u0027alembic\u003e\u003d1.11\u0027\ndeactivate\n\n# run failing test\ntox -e py310 -n barbican.tests.cmd.test_db_cleanup.WhenTestingDBCleanUpCommand.test_db_cleanup_raise_integrity_error\n```","commit_id":"8dcd47383d35a0f4e2283b09d70f34ad120a85f7"},{"author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"change_message_id":"c51b242c3c56f935acadf2c5e2162a6d58f52c60","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"692ae59a_9ff8f446","in_reply_to":"53e21575_102be4dc","updated":"2023-07-18 11:03:22.000000000","message":"Sorry Mike, that should have just read `tox`. Here\u0027s a containerised reproducer. First, the `Dockerfile`:\n\n```\nFROM ubuntu:22.04\nSHELL [\"/bin/bash\", \"-c\"]\n\nRUN apt-get update \u0026\u0026 apt-get install -y python3 tox git\n\nWORKDIR /root\nRUN git clone --depth 1 https://opendev.org/openstack/barbican\n\nWORKDIR /root/barbican\nRUN git fetch https://review.opendev.org/openstack/barbican refs/changes/08/888308/2 \u0026\u0026 \\\n    git checkout FETCH_HEAD\nRUN tox -e py310 --notest\nRUN . .tox/py310/bin/activate \u0026\u0026 \\\n    pip install --upgrade \u0027sqlalchemy\u003e\u003d2\u0027 \u0027oslo.db\u003e\u003d13\u0027 \u0027alembic\u003e\u003d1.11\u0027\n\nENTRYPOINT [\"/bin/bash\"]\n```\n\nTo run the container:\n\n```\n$ docker run -it $(docker build -q .)\n```\n\nTo run the failing test (inside the container, naturally):\n\n```\n# tox -e py310 -- -n barbican.tests.cmd.test_db_cleanup.WhenTestingDBCleanUpCommand.test_db_cleanup_raise_integrity_error\n```\n\nTo be clear, the checked out branch is necessary so we don\u0027t see unrelated failures with sqlalchemy 2.0 but I don\u0027t think it\u0027s the cause of the issue. The test *does not* fail if I downgrade sqlalchemy to 1.4.x (`pip install sqlalchemy\u003c2`) so I suspect it\u0027s actually a sqlalchemy 2.x thing. I just can\u0027t figure out how to reproduce it in general.","commit_id":"8dcd47383d35a0f4e2283b09d70f34ad120a85f7"},{"author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"change_message_id":"34436192136bdff7633eebd434bddb2f68064786","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"3f9c6fdf_1c832a9d","in_reply_to":"68c8e0f3_03fdef2c","updated":"2023-07-17 09:34:06.000000000","message":"Sure. It\u0027s happening [here](https://review.opendev.org/c/openstack/barbican/+/888308). I\u0027ve included the traceback below. I was able to reproduce the issue in an Ubuntu 22.04 VM but not in my local Fedora 38 environment.\n\n```\nbarbican.tests.cmd.test_db_cleanup.WhenTestingDBCleanUpCommand.test_db_cleanup_raise_integrity_error\n----------------------------------------------------------------------------------------------------\n\nCaptured traceback:\n~~~~~~~~~~~~~~~~~~~\n    Traceback (most recent call last):\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py\", line 1135, in fetchall\n    rows \u003d dbapi_cursor.fetchall()\n\n    sqlite3.IntegrityError: FOREIGN KEY constraint failed\n\n\nThe above exception was the direct cause of the following exception:\n\n\n    Traceback (most recent call last):\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/base.py\", line 1981, in _exec_single_context\n    result \u003d context._setup_result_proxy()\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/default.py\", line 1781, in _setup_result_proxy\n    result \u003d self._setup_dml_or_text_result()\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/default.py\", line 1926, in _setup_dml_or_text_result\n    rows \u003d result.all()\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/result.py\", line 1390, in all\n    return self._allrows()\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/result.py\", line 554, in _allrows\n    rows \u003d self._fetchall_impl()\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py\", line 2102, in _fetchall_impl\n    return self.cursor_strategy.fetchall(self, self.cursor)\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py\", line 1139, in fetchall\n    self.handle_exception(result, dbapi_cursor, e)\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py\", line 1080, in handle_exception\n    result.connection._handle_dbapi_exception(\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/base.py\", line 2336, in _handle_dbapi_exception\n    raise newraise.with_traceback(exc_info[2]) from e\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py\", line 1135, in fetchall\n    rows \u003d dbapi_cursor.fetchall()\n\n    oslo_db.exception.DBReferenceError: (sqlite3.IntegrityError) FOREIGN KEY constraint failed\n(Background on this error at: https://sqlalche.me/e/20/gkpj)\n\n\nThe above exception was the direct cause of the following exception:\n\n\n    Traceback (most recent call last):\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/barbican/tests/cmd/test_db_cleanup.py\", line 34, in project_wrapper\n    test_result \u003d test_func(self, *args, **kwargs)\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/barbican/tests/cmd/test_db_cleanup.py\", line 436, in test_db_cleanup_raise_integrity_error\n    self.assertRaises(db_exc.DBReferenceError, clean.cleanup_all)\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/testtools/testcase.py\", line 468, in assertRaises\n    self.assertThat(our_callable, matcher)\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/testtools/testcase.py\", line 479, in assertThat\n    mismatch_error \u003d self._matchHelper(matchee, matcher, message, verbose)\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/testtools/testcase.py\", line 531, in _matchHelper\n    mismatch \u003d matcher.match(matchee)\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/testtools/matchers/_exception.py\", line 104, in match\n    mismatch \u003d self.exception_matcher.match(exc_info)\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/testtools/matchers/_higherorder.py\", line 62, in match\n    mismatch \u003d matcher.match(matchee)\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/testtools/testcase.py\", line 458, in match\n    reraise(*matchee)\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/testtools/compat.py\", line 26, in reraise\n    raise exc_obj.with_traceback(exc_tb)\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/testtools/matchers/_exception.py\", line 97, in match\n    result \u003d matchee()\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/testtools/testcase.py\", line 1040, in __call__\n    return self._callable_object(*self._args, **self._kwargs)\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/barbican/model/clean.py\", line 164, in cleanup_all\n    total +\u003d cleanup_parent_with_no_child(models.Secret, models.Order,\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/barbican/model/clean.py\", line 100, in cleanup_parent_with_no_child\n    delete_count \u003d query.delete(synchronize_session\u003d\u0027fetch\u0027)\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/orm/query.py\", line 3182, in delete\n    self.session.execute(\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/orm/session.py\", line 2246, in execute\n    return self._execute_internal(\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/orm/session.py\", line 2141, in _execute_internal\n    result: Result[Any] \u003d compile_state_cls.orm_execute_statement(\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/orm/bulk_persistence.py\", line 1936, in orm_execute_statement\n    return super().orm_execute_statement(\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/orm/context.py\", line 293, in orm_execute_statement\n    result \u003d conn.execute(\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/base.py\", line 1412, in execute\n    return meth(\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/sql/elements.py\", line 483, in _execute_on_connection\n    return connection._execute_clauseelement(\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/base.py\", line 1635, in _execute_clauseelement\n    ret \u003d self._execute_context(\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/base.py\", line 1844, in _execute_context\n    return self._exec_single_context(\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/base.py\", line 1984, in _exec_single_context\n    self._handle_dbapi_exception(\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/base.py\", line 2336, in _handle_dbapi_exception\n    raise newraise.with_traceback(exc_info[2]) from e\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/base.py\", line 1981, in _exec_single_context\n    result \u003d context._setup_result_proxy()\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/default.py\", line 1781, in _setup_result_proxy\n    result \u003d self._setup_dml_or_text_result()\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/default.py\", line 1926, in _setup_dml_or_text_result\n    rows \u003d result.all()\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/result.py\", line 1390, in all\n    return self._allrows()\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/result.py\", line 554, in _allrows\n    rows \u003d self._fetchall_impl()\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py\", line 2102, in _fetchall_impl\n    return self.cursor_strategy.fetchall(self, self.cursor)\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py\", line 1139, in fetchall\n    self.handle_exception(result, dbapi_cursor, e)\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py\", line 1080, in handle_exception\n    result.connection._handle_dbapi_exception(\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/base.py\", line 2336, in _handle_dbapi_exception\n    raise newraise.with_traceback(exc_info[2]) from e\n\n      File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py\", line 1135, in fetchall\n    rows \u003d dbapi_cursor.fetchall()\n\n    oslo_db.exception.DBError: (sqlite3.IntegrityError) FOREIGN KEY constraint failed\n(Background on this error at: https://sqlalche.me/e/20/gkpj)\n\n\nCaptured pythonlogging:\n~~~~~~~~~~~~~~~~~~~~~~~\n    2023-07-13 09:48:57,943 INFO [barbican.model.repositories] Setting up database engine and session factory\n2023-07-13 09:48:57,948 INFO [barbican.model.repositories] Auto-creating barbican registry DB\n2023-07-13 09:48:57,997 WARNING [barbican.model.migration.commands] !!! Limited support for migration commands using sqlite databases; This operation may not succeed.\n2023-07-13 09:48:58,003 INFO [alembic.runtime.migration] Context impl SQLiteImpl.\n2023-07-13 09:48:58,003 INFO [alembic.runtime.migration] Will assume non-transactional DDL.\n2023-07-13 09:48:58,021 INFO [alembic.runtime.migration] Running stamp_revision  -\u003e 8c74e2d7f1ff\n2023-07-13 09:48:58,039 INFO [barbican.model.clean] Cleaned up 0 entries for TransportKey\n2023-07-13 09:48:58,040 INFO [barbican.model.clean] Cleaned up 0 entries for OrderBarbicanMetadatum\n2023-07-13 09:48:58,042 INFO [barbican.model.clean] Cleaned up 0 entries for OrderRetryTask\n2023-07-13 09:48:58,043 INFO [barbican.model.clean] Cleaned up 0 entries for OrderPluginMetadatum\n2023-07-13 09:48:58,047 INFO [barbican.model.clean] Cleaned up 0 entries for Order with no children in OrderRetryTask\n2023-07-13 09:48:58,050 INFO [barbican.model.clean] Cleaned up 0 entries for EncryptedDatum\n2023-07-13 09:48:58,051 INFO [barbican.model.clean] Cleaned up 0 entries for SecretUserMetadatum\n2023-07-13 09:48:58,053 INFO [barbican.model.clean] Cleaned up 0 entries for SecretStoreMetadatum\n2023-07-13 09:48:58,054 INFO [barbican.model.clean] Cleaned up 0 entries for ContainerSecret\n2023-07-13 09:48:58,055 INFO [barbican.model.clean] Cleaned up 0 entries for SecretConsumerMetadatum\n2023-07-13 09:48:58,060 WARNING [oslo_db.sqlalchemy.exc_filters] DB exception wrapped.\nTraceback (most recent call last):\n  File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py\", line 1135, in fetchall\n    rows \u003d dbapi_cursor.fetchall()\nsqlite3.IntegrityError: FOREIGN KEY constraint failed\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n  File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/base.py\", line 1981, in _exec_single_context\n    result \u003d context._setup_result_proxy()\n  File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/default.py\", line 1781, in _setup_result_proxy\n    result \u003d self._setup_dml_or_text_result()\n  File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/default.py\", line 1926, in _setup_dml_or_text_result\n    rows \u003d result.all()\n  File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/result.py\", line 1390, in all\n    return self._allrows()\n  File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/result.py\", line 554, in _allrows\n    rows \u003d self._fetchall_impl()\n  File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py\", line 2102, in _fetchall_impl\n    return self.cursor_strategy.fetchall(self, self.cursor)\n  File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py\", line 1139, in fetchall\n    self.handle_exception(result, dbapi_cursor, e)\n  File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py\", line 1080, in handle_exception\n    result.connection._handle_dbapi_exception(\n  File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/base.py\", line 2336, in _handle_dbapi_exception\n    raise newraise.with_traceback(exc_info[2]) from e\n  File \"/home/zuul/src/opendev.org/openstack/barbican/.tox/py310/lib/python3.10/site-packages/sqlalchemy/engine/cursor.py\", line 1135, in fetchall\n    rows \u003d dbapi_cursor.fetchall()\noslo_db.exception.DBReferenceError: (sqlite3.IntegrityError) FOR\n    EIGN KEY constraint failed\n(Background on this error at: https://sqlalche.me/e/20/gkpj)\n```","commit_id":"8dcd47383d35a0f4e2283b09d70f34ad120a85f7"}]}