)]}'
{"nova/tests/fixtures/nova.py":[{"author":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"change_message_id":"46e7c660ccd974ed40f143503c892645600bd51f","unresolved":true,"context_lines":[{"line_number":700,"context_line":"            self.useFixture("},{"line_number":701,"context_line":"                db_fixtures.ReplaceEngineFacadeFixture("},{"line_number":702,"context_line":"                    api_db_api.context_manager, new_engine))"},{"line_number":703,"context_line":"            CONF.set_override(\"connection\", \"sqlite:///foo.db\", group\u003d\"api_database\")"},{"line_number":704,"context_line":"            print(\"creating api DB\")"},{"line_number":705,"context_line":"            api_db_api.configure(CONF)"},{"line_number":706,"context_line":""}],"source_content_type":"text/x-python","patch_set":1,"id":"149e149f_eba86d84","line":703,"updated":"2026-04-10 09:49:15.000000000","message":"This single line changes the behavior of other sqlite connections used by the CellDatabases fixture. \n\nWhen we switch the api DB to be file based, suddenly the Cell DBs start to be accessed serially and the test nova.tests.unit.policies.test_availability_zone.AZScopeTypeNoLegacyPolicyTest.test_availability_zone_list_policy stabilized.\n\nIf I switch the api DB back to in memory then that testcase goes back to be unstable due to overlapping read transactions towards the cell DBs.\n\nSQLAlchemy uses different connection pooling for the file based and the in memory SQLite DBs but each SQLAlchemy seeming have its own Pool so they should not interfere.","commit_id":"a3f7bb924e13262604aa1958e2c5f0c58386df0f"}]}