)]}'
{"id":"openstack%2Fnova~1002529","triplet_id":"openstack%2Fnova~master~Idb106a410308cc520851425f9264e0f290291707","project":"openstack/nova","branch":"master","topic":"bug/2165149","attention_set":{},"removed_from_attention_set":{"9708":{"account":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"last_update":"2026-08-26 21:14:53.000000000","reason":"Change was submitted"}},"hashtags":[],"change_id":"Idb106a410308cc520851425f9264e0f290291707","subject":"Lock on DB url in functional test","status":"MERGED","created":"2026-08-26 16:20:09.000000000","updated":"2026-08-26 21:43:12.000000000","submitted":"2026-08-26 21:14:53.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":2,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"1002529-bug/2165149","meta_rev_id":"180963524f1a7bb0a55738c273992fd8778a48a2","_number":1002529,"virtual_id_number":1002529,"owner":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"value":0,"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"value":0,"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2026-08-26 21:14:52.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","default_value":0,"optional":true},"Code-Review":{"approved":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"all":[{"value":2,"date":"2026-08-26 18:01:32.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"value":2,"date":"2026-08-26 16:59:30.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"value":1,"date":"2026-08-26 16:29:08.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-2":"Do not merge","-1":"This patch needs further work before it can be merged"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me (core reviewer)"},"description":"","default_value":0,"optional":true},"Workflow":{"approved":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"all":[{"value":1,"date":"2026-08-26 18:01:32.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"value":0,"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"value":0,"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"value":0,"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"value":0,"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{" 0":"Default Priority","+1":"Contributor Review Promise","+2":"Core Review Promise"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"}],"CC":[{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},{"_account_id":34420,"name":"openstack lightbits","display_name":"Lightbits CI","email":"openstack@lightbitslabs.com","username":"openstack_lightbits"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2026-08-26 16:25:20.000000000","updated_by":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"reviewer":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"state":"REVIEWER"},{"updated":"2026-08-26 16:29:08.000000000","updated_by":{"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"},"reviewer":{"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"},"state":"REVIEWER"},{"updated":"2026-08-26 16:59:30.000000000","updated_by":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"reviewer":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"state":"REVIEWER"},{"updated":"2026-08-26 17:17:49.000000000","updated_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"reviewer":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2026-08-26 17:17:57.000000000","updated_by":{"_account_id":34420,"name":"openstack lightbits","display_name":"Lightbits CI","email":"openstack@lightbitslabs.com","username":"openstack_lightbits"},"reviewer":{"_account_id":34420,"name":"openstack lightbits","display_name":"Lightbits CI","email":"openstack@lightbitslabs.com","username":"openstack_lightbits"},"state":"CC"},{"updated":"2026-08-26 17:18:30.000000000","updated_by":{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},"reviewer":{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},"state":"CC"}],"messages":[{"id":"678817fa2b7ed581c6e1848125667e421768ed2f","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"date":"2026-08-26 16:20:09.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"9abfe117006667d2086cd299c289b7cfad961835","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2026-08-26 16:25:20.000000000","message":"Patch Set 1: Code-Review+1\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"49a7b025c1f2e6b75acf85077e1c79a317d776b2","author":{"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"},"date":"2026-08-26 16:29:08.000000000","message":"Patch Set 1: Code-Review+1\n\nBuild succeeded (check pipeline).\nhttps://gateway-cloud-softwarefactory.apps.ocp.cloud.ci.centos.org/zuul/t/rdoproject.org/buildset/295d46cce7c242d5855a6ad56439668e\n\n- s2i-openstack-container-content-provider https://gateway-cloud-softwarefactory.apps.ocp.cloud.ci.centos.org/zuul/t/rdoproject.org/build/a0d54f87ef0f4773a9d0432534bc4ac7 : SUCCESS in 7m 46s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"0b6ddd5167d96962a6aaf433447eb7c1b240641e","author":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"date":"2026-08-26 16:59:30.000000000","message":"Patch Set 1: Code-Review+2","accounts_in_message":[],"_revision_number":1},{"id":"a22d47428ffc44a4d50a8168dcb3bc5c21f4bc6f","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-08-26 17:17:49.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/c13b81365d0c4b85965af07522c32aa8\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/3e9e050beb204e199cded73d3e95ae15 : SUCCESS in 54m 46s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/864dfaacd99a4511b425ba541286c466 : SUCCESS in 6m 02s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/851bcf2d50c348ac817fecd8b5e653d0 : SUCCESS in 13m 57s\n- openstack-tox-py313 https://zuul.opendev.org/t/openstack/build/4d86e2c191b54c609f5402643000dfea : SUCCESS in 16m 46s\n- openstack-tox-py314 https://zuul.opendev.org/t/openstack/build/a932f671763042458e6e37a3acb6d992 : SUCCESS in 18m 26s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/6719c882806d466ba9f48111cea08d72 : SUCCESS in 6m 40s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/4d91925ea08c4c7db9533067d824b6d4 : SUCCESS in 4m 58s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/4dbb699d4ccb44e0b72550219daedf0f : SUCCESS in 5m 55s (non-voting)\n- nova-tox-functional-py311 https://zuul.opendev.org/t/openstack/build/6ba5ef8acb3840d7be861130ef80e87f : SUCCESS in 28m 46s\n- nova-tox-functional-py313 https://zuul.opendev.org/t/openstack/build/3f374abfc7f4475bbbb7e9d5a8f158e1 : SUCCESS in 29m 42s\n- nova-tox-functional-py313-threading https://zuul.opendev.org/t/openstack/build/828fb321c8674d0583ef71e9e66318a6 : SUCCESS in 34m 32s\n- nova-tox-py313-threading https://zuul.opendev.org/t/openstack/build/72b7567378174a25a55445b6fd749ef9 : SUCCESS in 9m 44s","accounts_in_message":[],"_revision_number":1},{"id":"0c3328b9c97c64d76af4b35969488760b2a3f9c8","author":{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},"date":"2026-08-26 17:18:30.000000000","message":"Patch Set 1:\n\nBuild Successful \n\n* quobyteci:  nova_quobyteci : SUCCESS, logs at: https://oscilogs.quobyte.com/logs/Idb106a410308cc520851425f9264e0f290291707 .","accounts_in_message":[],"_revision_number":1},{"id":"e188d2493346495717376b8b62fcf8e5056acd68","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":34420,"name":"openstack lightbits","display_name":"Lightbits CI","email":"openstack@lightbitslabs.com","username":"openstack_lightbits"},"date":"2026-08-26 17:28:48.000000000","message":"Patch Set 1:\n\nBuild succeeded. log path: ${LOG_PATH}\nLeave a comment with","accounts_in_message":[],"_revision_number":1},{"id":"79d2f6c53aaa9b48deadc117f074df9559edebc0","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2026-08-26 18:01:32.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"96617f1e3e1a78de48a91001cb22fad1c053705c","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-08-26 19:42:56.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"cf88c97a228f13197585a8f3e48cc5a534d8fdcd","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-08-26 21:14:52.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/49a61be3dba24cf59be81ccd2a869174\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/70b68c40b8124e75bce468c82a1fbbb8 : SUCCESS in 8m 34s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/3cbbaa529249445fa608c5ea60d7289a : SUCCESS in 15m 25s\n- openstack-tox-py313 https://zuul.opendev.org/t/openstack/build/5a8cb53cd843432fbd5c44d90cadf933 : SUCCESS in 8m 52s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/426d5f7685a14f91b42668595e2e7841 : SUCCESS in 12m 50s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/b67c1b97077145e186167d1bb911bbe3 : SUCCESS in 9m 50s\n- nova-tox-functional-py311 https://zuul.opendev.org/t/openstack/build/996627103dc445bfaf8a79b1ae611d62 : SUCCESS in 26m 27s\n- nova-tox-functional-py313 https://zuul.opendev.org/t/openstack/build/22e6c2939f744a489148c5514bb0fd88 : SUCCESS in 29m 15s\n- nova-tox-functional-py313-threading https://zuul.opendev.org/t/openstack/build/f9cba6a489e648f48a4f3ee077df4eee : SUCCESS in 32m 46s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/12443a1d7ac94356a6923015a79756c9 : SUCCESS in 5m 27s\n- nova-tox-py313-threading https://zuul.opendev.org/t/openstack/build/b1b7059938f54e6f979bb007a47a8185 : SUCCESS in 10m 57s","accounts_in_message":[],"_revision_number":1},{"id":"a19a9b4c26e35f81de79862a5899ec06f71de731","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-08-26 21:14:53.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":1},{"id":"afc8fb3584f9a056d6982bdca1cedb178819b8c2","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-08-26 21:17:52.000000000","message":"Patch Set 1:\n\nBuild succeeded (promote pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/93ad1fe95af54a36901bfcd15395c940\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/5eddbdcb114149f3a1c9c7c9f700c2f6 : SUCCESS in 46s","accounts_in_message":[],"_revision_number":1},{"id":"180963524f1a7bb0a55738c273992fd8778a48a2","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-08-26 21:43:12.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/f9aace8b94fc41cf9ce56c02be0d9c5a\n\n- openstack-tox-py311-arm64 https://zuul.opendev.org/t/openstack/build/711a57af29e64f7cbbb6bc1ddbee397c : SUCCESS in 31m 01s (non-voting)\n- openstack-tox-py313-arm64 https://zuul.opendev.org/t/openstack/build/901918e7ebd74249959ade3b550dfcf9 : SUCCESS in 23m 11s (non-voting)\n- openstack-tox-py314-arm64 https://zuul.opendev.org/t/openstack/build/9aa19ea138214964be4912d099b16c32 : SUCCESS in 47m 53s (non-voting)","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"10249c06e121507faafa784346ab9c37540db1b4","revisions":{"10249c06e121507faafa784346ab9c37540db1b4":{"kind":"REWORK","_number":1,"created":"2026-08-26 16:20:09.000000000","uploader":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"ref":"refs/changes/29/1002529/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/29/1002529/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/29/1002529/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/29/1002529/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/29/1002529/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/29/1002529/1"}}},"commit":{"parents":[{"commit":"39eda47cdf664512cdbfd7b0d91fe1bb65eeee48","subject":"Stabilize live migration tests","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/39eda47cdf664512cdbfd7b0d91fe1bb65eeee48"}]}],"author":{"name":"Balazs Gibizer","email":"gibi@redhat.com","date":"2026-08-26 16:14:03.000000000","tz":120},"committer":{"name":"Balazs Gibizer","email":"gibi@redhat.com","date":"2026-08-26 16:14:03.000000000","tz":120},"subject":"Lock on DB url in functional test","message":"Lock on DB url in functional test\n\nIn the functional test we use SQLite and that only supports one writer\nper DB at a time. So we have a write lock injected into the DB handling\ncode path. So far this had a lock per TransactionContextManager to\nserialize write transactions. It seems that we can have multiple such\nmanagers per DB, for example when two services (api, conductor) writing\nto the same DB. These cases still can fail with \"database is locked\"\nerror.\n\nSo this patch changes the locking to apply one lock per DB url. So even\nif two services sharing a DB url their writing are serialized.\n\nI have to admit this is a bit speculative as I was not able to reproduce\nthe problem locally in a stable way (or in any way). So you just need to\ntrust my argument above.\n\nCloses-Bug: #2165149\nChange-Id: Idb106a410308cc520851425f9264e0f290291707\nSigned-off-by: Balazs Gibizer \u003cgibi@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/10249c06e121507faafa784346ab9c37540db1b4"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/10249c06e121507faafa784346ab9c37540db1b4"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~DefaultSubmitRule","status":"CLOSED","labels":[{"label":"Verified","status":"MAY","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"MAY","applied_by":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"}},{"label":"Workflow","status":"MAY","applied_by":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"}},{"label":"Review-Priority","status":"MAY"}]}],"submit_requirements":[{"name":"Verified","description":"Verified in gate by CI","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Verified\u003dMAX AND -label:Verified\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Verified\u003dMAX"],"failing_atoms":["label:Verified\u003dMIN"],"atom_explanations":{"label:Verified\u003dMAX":"","label:Verified\u003dMIN":""}}},{"name":"Code-Review","description":"Code reviewed by core reviewer","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Code-Review\u003dMAX AND -label:Code-Review\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Code-Review\u003dMAX"],"failing_atoms":["label:Code-Review\u003dMIN"],"atom_explanations":{"label:Code-Review\u003dMAX":"","label:Code-Review\u003dMIN":""}}},{"name":"Review-Priority","description":"Review Priority","status":"NOT_APPLICABLE","is_legacy":false,"applicability_expression_result":{"fulfilled":false,"status":"FAIL"},"submittability_expression_result":{"expression":"is:true","fulfilled":true,"status":"NOT_EVALUATED","passing_atoms":[],"failing_atoms":[],"atom_explanations":{}}},{"name":"Workflow","description":"Approved for gate by core reviewer","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Workflow\u003dMAX AND -label:Workflow\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Workflow\u003dMAX"],"failing_atoms":["label:Workflow\u003dMIN"],"atom_explanations":{"label:Workflow\u003dMAX":"","label:Workflow\u003dMIN":""}}}]}