)]}'
{"id":"openstack%2Fnova~1003586","triplet_id":"openstack%2Fnova~master~I4e4e2e64e0afd992bb376e9489fc530bccf2827d","project":"openstack/nova","branch":"master","topic":"bug/2165149","attention_set":{"11604":{"account":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"last_update":"2026-09-03 08:48:48.000000000","reason":"\u003cGERRIT_ACCOUNT_9708\u003e replied on the change","reason_account":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"}}},"removed_from_attention_set":{"9708":{"account":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"last_update":"2026-09-03 08:48:48.000000000","reason":"\u003cGERRIT_ACCOUNT_9708\u003e replied on the change","reason_account":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"}}},"hashtags":[],"change_id":"I4e4e2e64e0afd992bb376e9489fc530bccf2827d","subject":"[func]Avoid WAL checkpointing","status":"NEW","created":"2026-09-02 17:46:15.000000000","updated":"2026-09-03 08:48:48.000000000","submit_type":"MERGE_IF_NECESSARY","mergeable":true,"submittable":false,"total_comment_count":3,"unresolved_comment_count":1,"has_review_started":true,"meta_rev_id":"f3049551a34ed4476299355554c69bdcb3781382","_number":1003586,"virtual_id_number":1003586,"owner":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"actions":{},"labels":{"Verified":{"disliked":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"tag":"autogenerated:zuul:check","value":-1,"date":"2026-09-02 19:30:55.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":"","value":-1,"default_value":0,"optional":true},"Code-Review":{"all":[{"value":0,"permitted_voting_range":{"min":-2,"max":2},"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_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":{"rejected":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"all":[{"value":-1,"date":"2026-09-03 08:48:48.000000000","permitted_voting_range":{"min":-1,"max":1},"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"_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,"permitted_voting_range":{"min":0,"max":2},"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"value":0,"permitted_voting_range":{"min":0,"max":1},"_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":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"CC":[{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2026-09-02 17:58:36.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"},{"updated":"2026-09-02 18:54:45.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":"CC"},{"updated":"2026-09-02 19:30:55.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-09-03 01:13:58.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":"CC"}],"messages":[{"id":"e3b68dfbc1f2a503f596c80f5f52ec18871e068c","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"date":"2026-09-02 17:46:15.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"0121c31d6c310780cc9b522308ab304570387f5b","author":{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},"date":"2026-09-02 17:58:36.000000000","message":"Patch Set 1:\n\nBuild Failed \n\n* quobyteci:  nova_quobyteci : FAILURE, logs at: https://oscilogs.quobyte.com/logs/I4e4e2e64e0afd992bb376e9489fc530bccf2827d .","accounts_in_message":[],"_revision_number":1},{"id":"20e7b616d4ba40eaa8fc4222661c64ae434979bb","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-09-02 18:54:45.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/16b6c0a245e648cdaa2e2f529efd3693\n\n- openstack-tox-py311-arm64 https://zuul.opendev.org/t/openstack/build/3eb552ea40b144949fdcaf1936b67529 : SUCCESS in 29m 21s (non-voting)\n- openstack-tox-py313-arm64 https://zuul.opendev.org/t/openstack/build/35f0751044034cac9e01b7d0e966f4bb : SUCCESS in 15m 35s (non-voting)\n- openstack-tox-py314-arm64 https://zuul.opendev.org/t/openstack/build/69a43c92a32444dfb74922effa55e5ee : SUCCESS in 19m 56s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"105edacf1ebbe24928009bf1ce623ec9923159e3","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-09-02 19:30:55.000000000","message":"Patch Set 1: Verified-1\n\n(1 comment)\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\nand https://docs.openstack.org/project-team-guide/testing.html#how-to-handle-test-failures\n\nhttps://zuul.opendev.org/t/openstack/buildset/1a4be2ef71d347fbb782f103fab1f9fa\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/dffd50d4df7a450995d216c5b70ef8c6 : SUCCESS in 1h 04m 44s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/258e1bc7f32f419cbabb3220c99f832e : FAILURE in 7m 56s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/978995a2240b4326a19481262a061761 : SUCCESS in 16m 27s\n- openstack-tox-py313 https://zuul.opendev.org/t/openstack/build/1130ade7481e496d8a11c85cfb9e6230 : SUCCESS in 9m 00s\n- openstack-tox-py314 https://zuul.opendev.org/t/openstack/build/54de64776d5d4a9aaa37f4600200a491 : SUCCESS in 20m 50s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/c1d639cb90da4d938972ab6be383ce14 : SUCCESS in 12m 53s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/baed852ee31f4025b1a9b31478ec19d5 : SUCCESS in 8m 41s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/6dc7e0b8e3e6461795b0a79720eb0a8e : SUCCESS in 3m 35s (non-voting)\n- nova-tox-functional-py311 https://zuul.opendev.org/t/openstack/build/e0e2fc8661034fdea98bc9d13347f623 : SUCCESS in 34m 31s\n- nova-tox-functional-py313 https://zuul.opendev.org/t/openstack/build/1c35942b88b84e019e5e759e2fdf20b9 : SUCCESS in 33m 56s\n- nova-tox-functional-py313-threading https://zuul.opendev.org/t/openstack/build/7487b8bbface44efb0195ec9c818d718 : FAILURE in 1h 06m 33s\n- nova-tox-py313-threading https://zuul.opendev.org/t/openstack/build/80459d311ea84fa8971f746eae29824f : SUCCESS in 15m 49s","accounts_in_message":[],"_revision_number":1},{"id":"65d24939cb9eceba6b7a558dc60a41385be6fe7e","author":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"date":"2026-09-03 01:13:58.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"f3049551a34ed4476299355554c69bdcb3781382","author":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"date":"2026-09-03 08:48:48.000000000","message":"Patch Set 1: Workflow-1\n\n(1 comment)","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"f057c372bbf53b140ca62f3b2ddbd2c1941a9334","revisions":{"f057c372bbf53b140ca62f3b2ddbd2c1941a9334":{"kind":"REWORK","_number":1,"created":"2026-09-02 17:46:15.000000000","uploader":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"ref":"refs/changes/86/1003586/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/86/1003586/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/86/1003586/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/86/1003586/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/86/1003586/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/86/1003586/1"}}},"commit":{"parents":[{"commit":"bedddec1f1a7dd84ed6c9408cdadc7f860be043a","subject":"[DNM]reproduce \"database is locked\" error","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/bedddec1f1a7dd84ed6c9408cdadc7f860be043a"}]}],"author":{"name":"Balazs Gibizer","email":"gibi@redhat.com","date":"2026-09-02 17:36:43.000000000","tz":120},"committer":{"name":"Balazs Gibizer","email":"gibi@redhat.com","date":"2026-09-02 17:45:16.000000000","tz":120},"subject":"[func]Avoid WAL checkpointing","message":"[func]Avoid WAL checkpointing\n\nSQLite used in the functional test supports one write transaction per DB\nfile. We have a fixture that serializes all write transaction happening\nduring the test case per DB file. But there is an SQLite behavior\ncalled WAL checkpointing that runs when the last connection to a DB is\nclosed and this takes a write lock on the DB.\n\nWe use file based SQLite and SQLAchemy uses NullPool for connection\npooling for this setup meaning each transaction is happening in a\nseparate connection and the connection is closed when the transaction\nfinishes. This means we have a lot of connection opening and closing\nduring the test. So we trigger a lot of checkpointing. As this happens\nafter the connection is closed it happens outside of our python DB write\nlock. This allows for the next connection with a write transaction to\nenter this race window where the checkpointing holding the DB write\nlock. This causes that the new write transaction fails with a DB locked\nerror.\n\nThe fix here is to keep an idle connection open to the DB and therefore\navoid the situation that the last connection is closed and triggering\nthe checkpointing until the end of the test case.\n\nCloses-Bug: #2165149\nChange-Id: I4e4e2e64e0afd992bb376e9489fc530bccf2827d\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/f057c372bbf53b140ca62f3b2ddbd2c1941a9334"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/f057c372bbf53b140ca62f3b2ddbd2c1941a9334"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~DefaultSubmitRule","status":"OK","labels":[{"label":"Verified","status":"MAY","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"MAY"},{"label":"Workflow","status":"MAY","applied_by":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"}},{"label":"Review-Priority","status":"MAY"}]}],"submit_requirements":[{"name":"Verified","description":"Verified in gate by CI","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Verified\u003dMAX AND -label:Verified\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Verified\u003dMAX","label:Verified\u003dMIN"],"atom_explanations":{"label:Verified\u003dMAX":"","label:Verified\u003dMIN":""}}},{"name":"Code-Review","description":"Code reviewed by core reviewer","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Code-Review\u003dMAX AND -label:Code-Review\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Code-Review\u003dMAX","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":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Workflow\u003dMAX AND -label:Workflow\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":["label:Workflow\u003dMIN"],"failing_atoms":["label:Workflow\u003dMAX"],"atom_explanations":{"label:Workflow\u003dMAX":"","label:Workflow\u003dMIN":""}}}]}