)]}'
{"id":"openstack%2Fneutron~974713","triplet_id":"openstack%2Fneutron~master~I6eca066d47503a15d46706b1f925fba5b2919e14","project":"openstack/neutron","branch":"master","attention_set":{},"removed_from_attention_set":{"16688":{"account":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"last_update":"2026-01-30 07:39:11.000000000","reason":"\u003cGERRIT_ACCOUNT_16688\u003e replied on the change","reason_account":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"}},"33742":{"account":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"last_update":"2026-03-16 08:19:05.000000000","reason":"\u003cGERRIT_ACCOUNT_33742\u003e replied on the change","reason_account":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"}}},"hashtags":[],"change_id":"I6eca066d47503a15d46706b1f925fba5b2919e14","subject":"Avoid subquery for object counts","status":"MERGED","created":"2026-01-26 11:57:41.000000000","updated":"2026-03-16 12:28:10.000000000","submitted":"2026-03-16 12:27:05.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":13,"unresolved_comment_count":1,"has_review_started":true,"submission_id":"974713","meta_rev_id":"3a278c15c5e2be9de36c63a7de027fa1eb07a12b","_number":974713,"virtual_id_number":974713,"owner":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},{"value":0,"_account_id":8313,"name":"Lajos Katona","display_name":"lajoskatona","email":"katonalala@gmail.com","username":"elajkat","status":"Ericsson Software Technology"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2026-03-16 12:27:04.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":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"all":[{"value":2,"date":"2026-01-30 07:39:11.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},{"value":2,"date":"2026-02-02 10:05:45.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":8313,"name":"Lajos Katona","display_name":"lajoskatona","email":"katonalala@gmail.com","username":"elajkat","status":"Ericsson Software Technology"},{"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":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"all":[{"value":1,"date":"2026-03-13 12:11:28.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},{"value":0,"_account_id":8313,"name":"Lajos Katona","display_name":"lajoskatona","email":"katonalala@gmail.com","username":"elajkat","status":"Ericsson Software Technology"},{"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":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},{"value":0,"_account_id":8313,"name":"Lajos Katona","display_name":"lajoskatona","email":"katonalala@gmail.com","username":"elajkat","status":"Ericsson Software Technology"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-1":"Branch Freeze"," 0":"No Priority","+1":"Important Change","+2":"Gate Blocker Fix / Urgent Change"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":8313,"name":"Lajos Katona","display_name":"lajoskatona","email":"katonalala@gmail.com","username":"elajkat","status":"Ericsson Software Technology"},{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2026-01-26 12:04:43.000000000","updated_by":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"reviewer":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"state":"CC"},{"updated":"2026-01-26 13:06:19.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-01-26 13:55:16.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-01-27 13:25:27.000000000","updated_by":{"_account_id":8313,"name":"Lajos Katona","display_name":"lajoskatona","email":"katonalala@gmail.com","username":"elajkat","status":"Ericsson Software Technology"},"reviewer":{"_account_id":8313,"name":"Lajos Katona","display_name":"lajoskatona","email":"katonalala@gmail.com","username":"elajkat","status":"Ericsson Software Technology"},"state":"CC"},{"updated":"2026-01-29 16:08:37.000000000","updated_by":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"reviewer":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"state":"REVIEWER"},{"updated":"2026-02-02 10:05:45.000000000","updated_by":{"_account_id":8313,"name":"Lajos Katona","display_name":"lajoskatona","email":"katonalala@gmail.com","username":"elajkat","status":"Ericsson Software Technology"},"reviewer":{"_account_id":8313,"name":"Lajos Katona","display_name":"lajoskatona","email":"katonalala@gmail.com","username":"elajkat","status":"Ericsson Software Technology"},"state":"REVIEWER"}],"messages":[{"id":"73c350b34d83e9466cb562a9be60725a574e76db","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"date":"2026-01-26 11:57:41.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"5454eaa60450ca18be0247983af031c574f07490","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-01-26 13:06:19.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/0de6324639ca4815b5be0d112c0898ab\n\n- openstack-tox-py310-arm64 https://zuul.opendev.org/t/openstack/build/0980ac3ab8014351870a15edfae52dc0 : FAILURE in 49m 12s (non-voting)\n- openstack-tox-py312-arm64 https://zuul.opendev.org/t/openstack/build/a5c67e90b6624e21bb87c02f047a2ab9 : FAILURE in 38m 07s (non-voting)\n- openstack-tox-py313-arm64 https://zuul.opendev.org/t/openstack/build/5a42d3247e434e818ba8b4e2ca28e3bb : RETRY_LIMIT in 4m 24s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"c379ca792643758e1f485515e2824c00a0e9cf4f","tag":"autogenerated:gerrit:setWorkInProgress","author":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"date":"2026-01-26 13:38:02.000000000","message":"Set Work In Progress","accounts_in_message":[],"_revision_number":1},{"id":"a04c0d4227b258e802c85dc2cad3611b7d225f55","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-01-26 13:55:16.000000000","message":"Patch Set 1: Verified-1\n\n(2 comments)\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/ed8ab012cb8144d29ae14b6c54a51193\n\n- neutron-tempest-plugin-openvswitch https://zuul.opendev.org/t/openstack/build/8f64054addef4a41b1c3b138dbf9a56d : SUCCESS in 1h 29m 18s\n- neutron-tempest-plugin-ovn https://zuul.opendev.org/t/openstack/build/1206e6465b254659aefdc2af47849d7e : SUCCESS in 1h 38m 19s\n- neutron-tempest-plugin-designate-scenario https://zuul.opendev.org/t/openstack/build/cf41ce45e3fc4ffab04c7afdb01e027b : SUCCESS in 31m 53s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/04b0aa870a4b42bfa508db1aa8ad054b : FAILURE in 37m 40s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/e861858048944e5f9155bb99b976e6e5 : FAILURE in 7m 56s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/d0dbcbbc62694193b3e474971e5e496b : FAILURE in 19m 38s\n- openstack-tox-py313 https://zuul.opendev.org/t/openstack/build/dc7ea52c97c843f9aaba7b60abd9906a : FAILURE in 19m 18s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/41b934a193ee40ed9f055c25fcf1bc90 : SUCCESS in 12m 13s\n- neutron-ovs-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/1eae96a9655946248b1c513e7d210ab1 : SUCCESS in 58m 20s\n- neutron-ovn-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/93a7a72dd84f4bcf96d6d946729c4db7 : SUCCESS in 37m 01s\n- neutron-functional https://zuul.opendev.org/t/openstack/build/b4503b1484164608b21e7648678d3b49 : SUCCESS in 1h 50m 34s\n- neutron-ovs-grenade-multinode https://zuul.opendev.org/t/openstack/build/8c7774f325af464b98bb7d515edd3c9a : SUCCESS in 1h 07m 48s\n- neutron-ovn-grenade-multinode https://zuul.opendev.org/t/openstack/build/a230f9923468492f818c5e2ed965cd67 : SUCCESS in 1h 08m 36s\n- neutron-ovs-tempest-multinode-full https://zuul.opendev.org/t/openstack/build/007a2d7af2c142c8a793ce1c36a93752 : SUCCESS in 1h 07m 29s\n- neutron-ovs-tempest-dvr-ha-multinode-full https://zuul.opendev.org/t/openstack/build/af3ca86aa8b846259987a789739d7a83 : SUCCESS in 1h 35m 58s\n- neutron-ovn-tempest-ipv6-only-ovs-release https://zuul.opendev.org/t/openstack/build/ab5a745850a949d495872fed18a84070 : SUCCESS in 58m 56s\n- neutron-ovs-rally-task https://zuul.opendev.org/t/openstack/build/80072bc79388407fb5066a05ddd21df0 : SUCCESS in 1h 06m 30s\n- neutron-ovn-rally-task https://zuul.opendev.org/t/openstack/build/5efa14263832475191d8319abd418161 : SUCCESS in 1h 21m 56s\n- tempest-integrated-networking https://zuul.opendev.org/t/openstack/build/413e20de3e634e5f97bd491c044bcd26 : SUCCESS in 1h 26m 27s","accounts_in_message":[],"_revision_number":1},{"id":"86e62e098c5d537a9a6ea2dbcb3e3b060742a7e4","tag":"autogenerated:gerrit:newWipPatchSet","author":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"date":"2026-01-26 14:22:38.000000000","message":"Uploaded patch set 2.\n\nOutdated Votes:\n* Verified-1\n","accounts_in_message":[],"_revision_number":2},{"id":"5422f6648e1a8b57022729a5a45f9ca4e6c47c77","tag":"autogenerated:gerrit:newWipPatchSet","author":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"date":"2026-01-26 14:41:12.000000000","message":"Uploaded patch set 3.","accounts_in_message":[],"_revision_number":3},{"id":"9635809c8394aa84fcc02dbf0e6f7144da188fef","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-01-26 16:38:52.000000000","message":"Patch Set 3: Verified-1\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/f0f8e081ad9f43079912b10e654ef921\n\n- neutron-tempest-plugin-openvswitch https://zuul.opendev.org/t/openstack/build/33f9e905a1cd49029f59fa3aaaf57775 : SUCCESS in 1h 22m 20s\n- neutron-tempest-plugin-ovn https://zuul.opendev.org/t/openstack/build/b2f7f98a00fd415eaa29ef9117cff469 : SUCCESS in 1h 49m 04s\n- neutron-tempest-plugin-designate-scenario https://zuul.opendev.org/t/openstack/build/70ecb3180062464a91ff914b8ab83392 : SUCCESS in 32m 26s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/c577f406d47a4cb68bfd808a80e23077 : TIMED_OUT in 1h 21m 28s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/a47fd73e38f84bffbeb2c40c30c1152c : SUCCESS in 23m 06s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/587286f2a02340a98208873394b5f121 : SUCCESS in 32m 15s\n- openstack-tox-py313 https://zuul.opendev.org/t/openstack/build/2b1e4a77061242b78f09693fd1459253 : SUCCESS in 30m 30s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/87c22487a73d449b878261756b33e553 : SUCCESS in 12m 09s\n- neutron-ovs-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/0d0e7dcbba49443087eac630782e1d2a : SUCCESS in 51m 37s\n- neutron-ovn-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/0cebfa261a5a40a1895b4a6c33318e79 : SUCCESS in 56m 06s\n- neutron-functional https://zuul.opendev.org/t/openstack/build/b3774bf9bf3f48b0bbe84325eaa1d753 : SUCCESS in 1h 46m 43s\n- neutron-ovs-grenade-multinode https://zuul.opendev.org/t/openstack/build/b63e49df6781498fbae3085b4595c2ec : SUCCESS in 1h 03m 34s\n- neutron-ovn-grenade-multinode https://zuul.opendev.org/t/openstack/build/8d789150b80e474caa490f658b9168c1 : SUCCESS in 1h 20m 31s\n- neutron-ovs-tempest-multinode-full https://zuul.opendev.org/t/openstack/build/a8dc1fa040c7492e99e112b2f0955515 : SUCCESS in 1h 55m 02s\n- neutron-ovs-tempest-dvr-ha-multinode-full https://zuul.opendev.org/t/openstack/build/1245c770bfa44d2eb1a6bb6584900e67 : SUCCESS in 53m 36s\n- neutron-ovn-tempest-ipv6-only-ovs-release https://zuul.opendev.org/t/openstack/build/10d0f693d630469fba8d47591dc735d4 : SUCCESS in 1h 00m 44s\n- neutron-ovs-rally-task https://zuul.opendev.org/t/openstack/build/b80deee1ded949d789beb4de219a0a77 : SUCCESS in 1h 09m 13s\n- neutron-ovn-rally-task https://zuul.opendev.org/t/openstack/build/d1912d8670674ba3ad333c652e8e61c1 : SUCCESS in 1h 44m 53s\n- tempest-integrated-networking https://zuul.opendev.org/t/openstack/build/728a02f650ff42c98063e3c79e710df8 : SUCCESS in 1h 04m 28s","accounts_in_message":[],"_revision_number":3},{"id":"3656d3386ac301a0924f78b56bdf0de26a1e3bd3","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-01-26 19:19:36.000000000","message":"Patch Set 3:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/3e8805dc4bf74dee8134bf984ea29eba\n\n- openstack-tox-py310-arm64 https://zuul.opendev.org/t/openstack/build/85c49eedf8c04c5b9578fd15a3f093ef : SUCCESS in 57m 06s (non-voting)\n- openstack-tox-py312-arm64 https://zuul.opendev.org/t/openstack/build/df42e5965c234a4d8fd3d2d6f9c9974a : SUCCESS in 45m 14s (non-voting)\n- openstack-tox-py313-arm64 https://zuul.opendev.org/t/openstack/build/18f49e08e77f477b9a18c41cf2f5e2c5 : RETRY_LIMIT in 4m 30s (non-voting)","accounts_in_message":[],"_revision_number":3},{"id":"50aca0d07df586766cf062c2e8b8e129f251998c","author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"date":"2026-01-27 07:19:33.000000000","message":"Patch Set 3:\n\n(1 comment)","accounts_in_message":[],"_revision_number":3},{"id":"948490e469b3cac29b7da8c79fe1d503aea6e740","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-01-27 08:15:23.000000000","message":"Patch Set 3:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/53f06fd0f2824e7f84c024a21bdc185e\n\n- openstack-tox-py310-arm64 https://zuul.opendev.org/t/openstack/build/aeb8d713cabe4196853ed3563632ff89 : SUCCESS in 54m 05s (non-voting)\n- openstack-tox-py312-arm64 https://zuul.opendev.org/t/openstack/build/4b31aa380c23487b890d7b2cd5b9f490 : SUCCESS in 42m 47s (non-voting)\n- openstack-tox-py313-arm64 https://zuul.opendev.org/t/openstack/build/b97b4968b57944088ea8e06afe33a3bc : RETRY_LIMIT in 4m 03s (non-voting)","accounts_in_message":[],"_revision_number":3},{"id":"212663871f719c3e779c19bc75278471da7f1e87","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-01-27 09:44:29.000000000","message":"Patch Set 3: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/438bdee4679640a986001df0f461ea96\n\n- neutron-tempest-plugin-openvswitch https://zuul.opendev.org/t/openstack/build/042ebb14bac047f7a761b347e90e0ec9 : SUCCESS in 1h 26m 37s\n- neutron-tempest-plugin-ovn https://zuul.opendev.org/t/openstack/build/5f707e9ad6f64941be0e8bcc3e31c4d1 : SUCCESS in 2h 22m 38s\n- neutron-tempest-plugin-designate-scenario https://zuul.opendev.org/t/openstack/build/e5b17a25228440f99648e8fcf52b3318 : SUCCESS in 33m 05s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/d89b59da5a164124802f9eb1aec92519 : SUCCESS in 1h 03m 48s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/e0478bc84bc84d959de25eabd4ece725 : SUCCESS in 12m 51s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/ed8eea425ff14fc1b139655827ee77bd : SUCCESS in 34m 58s\n- openstack-tox-py313 https://zuul.opendev.org/t/openstack/build/743ec628d4c84e808aa7f36499962abd : SUCCESS in 19m 11s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/3b78107755934aefbb6ae4756bb2ecc3 : SUCCESS in 11m 47s\n- neutron-ovs-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/f9faa9254678446c9984562545a666a1 : SUCCESS in 42m 19s\n- neutron-ovn-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/5380d3a443844416847018f6365281e5 : SUCCESS in 41m 17s\n- neutron-functional https://zuul.opendev.org/t/openstack/build/cd0bf02d96f2456382999be3654e890e : SUCCESS in 41m 19s\n- neutron-ovs-grenade-multinode https://zuul.opendev.org/t/openstack/build/300a7a99be0f4559889eef3b29cd9667 : SUCCESS in 57m 51s\n- neutron-ovn-grenade-multinode https://zuul.opendev.org/t/openstack/build/905c89d5dca5441b9cb8ccab02f5bd64 : SUCCESS in 1h 06m 47s\n- neutron-ovs-tempest-multinode-full https://zuul.opendev.org/t/openstack/build/72e4c84cd969438aa53495c37f5158b7 : SUCCESS in 1h 54m 11s\n- neutron-ovs-tempest-dvr-ha-multinode-full https://zuul.opendev.org/t/openstack/build/ee0f35050b734097b98613aeb1856cdb : SUCCESS in 1h 37m 15s\n- neutron-ovn-tempest-ipv6-only-ovs-release https://zuul.opendev.org/t/openstack/build/8c62d1128b764e2080b44a35448be76c : SUCCESS in 1h 16m 13s\n- neutron-ovs-rally-task https://zuul.opendev.org/t/openstack/build/9b4970098458451d8e9d7adc276ccec3 : SUCCESS in 1h 07m 31s\n- neutron-ovn-rally-task https://zuul.opendev.org/t/openstack/build/dacfe6a545ea41cb83bee0e823194fca : SUCCESS in 1h 29m 08s\n- tempest-integrated-networking https://zuul.opendev.org/t/openstack/build/4ba92b1032ef49d2a112df2501094d45 : SUCCESS in 1h 08m 26s","accounts_in_message":[],"_revision_number":3},{"id":"af334512b4182dec01b0afe2486e5da22e7de5ae","tag":"autogenerated:gerrit:newWipPatchSet","author":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"date":"2026-01-27 11:02:33.000000000","message":"Uploaded patch set 4: Commit message was updated.\n\nOutdated Votes:\n* Verified+1\n","accounts_in_message":[],"_revision_number":4},{"id":"6e3a8b7817f68fc9dc10eaddde771b195ff00c07","tag":"autogenerated:gerrit:setReadyForReview","author":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"date":"2026-01-27 12:13:56.000000000","message":"Set Ready For Review","accounts_in_message":[],"_revision_number":4},{"id":"4be48cfe6728d405574a374d5dafbacaa7d36fee","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-01-27 12:27:35.000000000","message":"Patch Set 4:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/06392d5d7a3a42f8bd255577c0702163\n\n- openstack-tox-py310-arm64 https://zuul.opendev.org/t/openstack/build/7ace0ce61bbd4635ab4099b562c4d87c : SUCCESS in 55m 06s (non-voting)\n- openstack-tox-py312-arm64 https://zuul.opendev.org/t/openstack/build/822b6eac025143aeb68e98740bb2a69f : SUCCESS in 42m 30s (non-voting)\n- openstack-tox-py313-arm64 https://zuul.opendev.org/t/openstack/build/174f98eea35c4e83aa644b2e04a287f0 : RETRY_LIMIT in 4m 16s (non-voting)","accounts_in_message":[],"_revision_number":4},{"id":"3d822e5efae6d44b43b384dd286e445b3d7d8dc1","author":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"date":"2026-01-27 12:34:03.000000000","message":"Patch Set 4:\n\n(1 comment)","accounts_in_message":[],"_revision_number":4},{"id":"7e6f4e2cb0a62c942525886a34fc801cda585c00","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-01-27 12:54:24.000000000","message":"Patch Set 4: Verified-1\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/43640a59ceb0482eb6e7e72502bf0b0f\n\n- neutron-tempest-plugin-openvswitch https://zuul.opendev.org/t/openstack/build/88b459c600384a29ab5ead0076798c5c : SUCCESS in 1h 20m 08s\n- neutron-tempest-plugin-ovn https://zuul.opendev.org/t/openstack/build/7d09b7a1841a44ce94b880509df2c5b1 : SUCCESS in 1h 48m 02s\n- neutron-tempest-plugin-designate-scenario https://zuul.opendev.org/t/openstack/build/7fbe798185844a3a8e1d3e476da68b01 : SUCCESS in 32m 31s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/5f802134f0484b358ff4d4770d0601ff : SUCCESS in 1h 03m 22s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/e523ed5f7e094d9caede45004bf8dcab : SUCCESS in 25m 34s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/2b8d23eb0b2a4830b45bee5c9e232650 : SUCCESS in 20m 58s\n- openstack-tox-py313 https://zuul.opendev.org/t/openstack/build/9b88089ae0a541e2903951aefaab2624 : SUCCESS in 21m 10s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/eac407dad6cc4028b8b89c00a1ae2218 : SUCCESS in 7m 05s\n- neutron-ovs-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/862979a47fe844b7ba78a9a0c9463281 : SUCCESS in 1h 06m 42s\n- neutron-ovn-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/7a29ec6cb6b0499d8513aed55cbe669d : SUCCESS in 36m 23s\n- neutron-functional https://zuul.opendev.org/t/openstack/build/0336899b6b6e4b8385ee1a84df8e222a : SUCCESS in 1h 18m 10s\n- neutron-ovs-grenade-multinode https://zuul.opendev.org/t/openstack/build/61547eca8c0c4ff694e9eacdbbbf6da1 : SUCCESS in 48m 54s\n- neutron-ovn-grenade-multinode https://zuul.opendev.org/t/openstack/build/0a51965966d14999b09da1c9e98e2cee : SUCCESS in 1h 01m 14s\n- neutron-ovs-tempest-multinode-full https://zuul.opendev.org/t/openstack/build/b8adb56a6f7f44678d3c62b2a065e9a9 : SUCCESS in 1h 47m 03s\n- neutron-ovs-tempest-dvr-ha-multinode-full https://zuul.opendev.org/t/openstack/build/97f48833a10c42d38474e858f96685cf : SUCCESS in 1h 49m 56s\n- neutron-ovn-tempest-ipv6-only-ovs-release https://zuul.opendev.org/t/openstack/build/389d7013fa7d49e894d9449a65f0cd6c : SUCCESS in 1h 08m 09s\n- neutron-ovs-rally-task https://zuul.opendev.org/t/openstack/build/095752928d2d4b79a088e8f5dd97ed17 : SUCCESS in 1h 13m 05s\n- neutron-ovn-rally-task https://zuul.opendev.org/t/openstack/build/4c78ad076ca049ffa93d0ebeb536a5f1 : FAILURE in 1h 26m 16s\n- tempest-integrated-networking https://zuul.opendev.org/t/openstack/build/5e1f0c5b758949e0bbcccf6ea3d24d50 : SUCCESS in 1h 29m 28s","accounts_in_message":[],"_revision_number":4},{"id":"aa7a6a275d537297738a955fc3e6ec81731fc6d0","author":{"_account_id":8313,"name":"Lajos Katona","display_name":"lajoskatona","email":"katonalala@gmail.com","username":"elajkat","status":"Ericsson Software Technology"},"date":"2026-01-27 13:25:27.000000000","message":"Patch Set 4:\n\n(1 comment)","accounts_in_message":[],"_revision_number":4},{"id":"d6db348e5845bd5cc9bfc1c1c4384c8202f76d2a","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-01-27 15:33:33.000000000","message":"Patch Set 4: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/43520fb5472f496f99d468ad60e12e08\n\n- neutron-tempest-plugin-openvswitch https://zuul.opendev.org/t/openstack/build/d7e9e06f11ff4fab99379d787f8abf00 : SUCCESS in 1h 20m 14s\n- neutron-tempest-plugin-ovn https://zuul.opendev.org/t/openstack/build/12cfd426ef7c47fba712102a09e4a9c5 : SUCCESS in 2h 05m 36s\n- neutron-tempest-plugin-designate-scenario https://zuul.opendev.org/t/openstack/build/142ec9a2df194897a0188249b01d68c4 : SUCCESS in 31m 19s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/12d0f6a39ba54dfbb719b3c350e8d963 : SUCCESS in 1h 01m 56s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/1ea3cd04c7a74f80af10916880ed4125 : SUCCESS in 18m 04s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/976627b6fcd44f28b3a30bd7a66f95cf : SUCCESS in 21m 02s\n- openstack-tox-py313 https://zuul.opendev.org/t/openstack/build/e76f80aef1394ba8ac6c294be026705b : SUCCESS in 27m 36s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/17499c0f53c84ea0bdbd87d780bce7fa : SUCCESS in 6m 05s\n- neutron-ovs-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/aaf866aa32444b88a54c4d6b83a4ea49 : SUCCESS in 59m 54s\n- neutron-ovn-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/d2dc30711c7747f18a0a66172531bb55 : SUCCESS in 50m 40s\n- neutron-functional https://zuul.opendev.org/t/openstack/build/f2f83094e157411c9f489d5a70907948 : SUCCESS in 1h 39m 37s\n- neutron-ovs-grenade-multinode https://zuul.opendev.org/t/openstack/build/ed3860869b344bd2ae0cf033c648196c : SUCCESS in 1h 00m 34s\n- neutron-ovn-grenade-multinode https://zuul.opendev.org/t/openstack/build/de43c12f7eb549d5b837919a09af37b6 : SUCCESS in 54m 53s\n- neutron-ovs-tempest-multinode-full https://zuul.opendev.org/t/openstack/build/290cc7b767294c848a6885b296888779 : SUCCESS in 1h 52m 35s\n- neutron-ovs-tempest-dvr-ha-multinode-full https://zuul.opendev.org/t/openstack/build/f757c70570b24948b69e9c2925a6ac50 : SUCCESS in 1h 25m 59s\n- neutron-ovn-tempest-ipv6-only-ovs-release https://zuul.opendev.org/t/openstack/build/a3b901b6a2da4715bb46600b120bc6af : SUCCESS in 1h 08m 01s\n- neutron-ovs-rally-task https://zuul.opendev.org/t/openstack/build/31697af3356b41feafedccab78973296 : SUCCESS in 31m 52s\n- neutron-ovn-rally-task https://zuul.opendev.org/t/openstack/build/1f4816dc8ad847d79be287a6bbd04cb1 : SUCCESS in 37m 42s\n- tempest-integrated-networking https://zuul.opendev.org/t/openstack/build/a81dc7ae928b46a3a9c881ca732f630b : SUCCESS in 1h 05m 44s","accounts_in_message":[],"_revision_number":4},{"id":"a4a27a56bdb62c84555bd1c0d3289eb973a6ff26","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-01-27 17:07:13.000000000","message":"Patch Set 4:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/71cf010c074b4c19a450d943b03c15f9\n\n- openstack-tox-py310-arm64 https://zuul.opendev.org/t/openstack/build/c9ce58c1f38a464aa6d1376da87bb8e8 : SUCCESS in 54m 18s (non-voting)\n- openstack-tox-py312-arm64 https://zuul.opendev.org/t/openstack/build/d5e49385768e4bf4b8597ac0bd750cda : SUCCESS in 46m 25s (non-voting)\n- openstack-tox-py313-arm64 https://zuul.opendev.org/t/openstack/build/171d11389ca2456e9803c14133b745f6 : RETRY_LIMIT in 4m 32s (non-voting)","accounts_in_message":[],"_revision_number":4},{"id":"8708c31d04f944075f91b661f9b7d3e40fe9936d","author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"date":"2026-01-29 16:08:37.000000000","message":"Patch Set 4: Code-Review-1\n\n(3 comments)","accounts_in_message":[],"_revision_number":4},{"id":"7622700e7049608c6841c09a046523336d79b55d","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"date":"2026-01-30 07:18:44.000000000","message":"Uploaded patch set 5.\n\nOutdated Votes:\n* Code-Review-1 (copy condition: \"changekind:TRIVIAL_REBASE OR is:MIN\")\n* Verified+1\n","accounts_in_message":[],"_revision_number":5},{"id":"694eee9357b1d6a0ee9d8e3616c1ec87e0d4380d","author":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"date":"2026-01-30 07:19:17.000000000","message":"Patch Set 4:\n\n(3 comments)","accounts_in_message":[],"_revision_number":4},{"id":"1bd63b88f3b14fa20c282b6a54f4ffacd4e381ca","author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"date":"2026-01-30 07:39:11.000000000","message":"Patch Set 5: Code-Review+2","accounts_in_message":[],"_revision_number":5},{"id":"c7cb96edf071d0b3d5676fcc8a95774a8236c156","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-01-30 08:14:10.000000000","message":"Patch Set 5:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/8d85ddac1d384c04a6f8e158bc1c6035\n\n- openstack-tox-py310-arm64 https://zuul.opendev.org/t/openstack/build/950a134bb4624e4a8323e2abee5232b9 : SUCCESS in 53m 29s (non-voting)\n- openstack-tox-py312-arm64 https://zuul.opendev.org/t/openstack/build/5a4aff4f112f43139f3fd0fac2e37eb7 : SUCCESS in 40m 44s (non-voting)\n- openstack-tox-py313-arm64 https://zuul.opendev.org/t/openstack/build/057c422ca8df48f6945f29c0a7359d4e : RETRY_LIMIT in 4m 05s (non-voting)","accounts_in_message":[],"_revision_number":5},{"id":"9ef0d869f6b0c5dd22b4b6b443c1f70c4e84c76d","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-01-30 09:51:30.000000000","message":"Patch Set 5: Verified-1\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/60bdb3d51cf9421780141c5ea8811593\n\n- neutron-tempest-plugin-openvswitch https://zuul.opendev.org/t/openstack/build/1fcb82b308a14da680502994fe9e7173 : FAILURE in 1h 26m 45s\n- neutron-tempest-plugin-ovn https://zuul.opendev.org/t/openstack/build/86cac0a401384ce3b49d66d9ce8d42e1 : SUCCESS in 2h 30m 10s\n- neutron-tempest-plugin-designate-scenario https://zuul.opendev.org/t/openstack/build/fb40ebddb41342fcb6270b73dbe29b6a : SUCCESS in 32m 42s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/9b5ffe86759344c082f920989000a1c8 : SUCCESS in 35m 57s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/ab3807732a04490bb6c0bee808f3c053 : SUCCESS in 26m 14s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/1b102097f7f5458cb1a0d4ab49b4f019 : SUCCESS in 35m 07s\n- openstack-tox-py313 https://zuul.opendev.org/t/openstack/build/5f62665dabf341038e9c57df916d9a35 : SUCCESS in 23m 05s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/492b8d2b9e064501a8e418ca77772fb1 : SUCCESS in 6m 23s\n- neutron-ovs-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/01a9a86d811346819494cfea55f9704c : SUCCESS in 31m 18s\n- neutron-ovn-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/2666e519e5a6468bb2057df174226849 : SUCCESS in 1h 09m 59s\n- neutron-functional https://zuul.opendev.org/t/openstack/build/148465885a3541afb89dfbd75980dff8 : FAILURE in 51m 24s\n- neutron-ovs-grenade-multinode https://zuul.opendev.org/t/openstack/build/c270b563c2524e569c084f19f4e3637c : SUCCESS in 39m 52s\n- neutron-ovn-grenade-multinode https://zuul.opendev.org/t/openstack/build/5d9f4949d68d4797b1d8a78b87e0ce20 : SUCCESS in 41m 14s\n- neutron-ovs-tempest-multinode-full https://zuul.opendev.org/t/openstack/build/532754fdef6a4c6882565920b8b64765 : SUCCESS in 1h 46m 23s\n- neutron-ovs-tempest-dvr-ha-multinode-full https://zuul.opendev.org/t/openstack/build/faee9d1b652e41b791449efd311b8e8a : SUCCESS in 1h 43m 44s\n- neutron-ovn-tempest-ipv6-only-ovs-release https://zuul.opendev.org/t/openstack/build/90e5f2fe7e4645eb87c2e857212a870b : SUCCESS in 57m 47s\n- neutron-ovs-rally-task https://zuul.opendev.org/t/openstack/build/ebd8694516a5493591de81fbb9a7f7ca : SUCCESS in 1h 13m 40s\n- neutron-ovn-rally-task https://zuul.opendev.org/t/openstack/build/0589606d3a7d4a20a11969526b3d87c7 : SUCCESS in 1h 26m 22s\n- tempest-integrated-networking https://zuul.opendev.org/t/openstack/build/dd351d36267549548683c7aae1864bc2 : SUCCESS in 1h 23m 36s","accounts_in_message":[],"_revision_number":5},{"id":"938a4b6d7e8ad8375147d2caf65b6089ded1f6aa","author":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"date":"2026-01-30 10:00:13.000000000","message":"Patch Set 5:\n\n(1 comment)","accounts_in_message":[],"_revision_number":5},{"id":"79737c352819a7a5756def30da389cdd7d575712","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-01-30 10:58:35.000000000","message":"Patch Set 5:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/0883dfdf68ba4751a5139ed7db842eed\n\n- openstack-tox-py310-arm64 https://zuul.opendev.org/t/openstack/build/92a9088014bb4dd8b344217e1070a585 : SUCCESS in 56m 27s (non-voting)\n- openstack-tox-py312-arm64 https://zuul.opendev.org/t/openstack/build/235fb63d96794a1496fb87ea4b7fba34 : SUCCESS in 44m 59s (non-voting)\n- openstack-tox-py313-arm64 https://zuul.opendev.org/t/openstack/build/7a20bf2272c045979297b3fd83b77f9a : RETRY_LIMIT in 4m 06s (non-voting)","accounts_in_message":[],"_revision_number":5},{"id":"85ee24c3275da491cf91d8650d22e1c06e9ca042","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-01-30 12:05:49.000000000","message":"Patch Set 5: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/187595f0d52146aab53772b2145e2200\n\n- neutron-tempest-plugin-openvswitch https://zuul.opendev.org/t/openstack/build/2887d242c61c4cf08dff29ec48637580 : SUCCESS in 1h 32m 06s\n- neutron-tempest-plugin-ovn https://zuul.opendev.org/t/openstack/build/9980888d5df14081ab1c4a13d1acd9a4 : SUCCESS in 1h 38m 21s\n- neutron-tempest-plugin-designate-scenario https://zuul.opendev.org/t/openstack/build/210a36bf25b94511a69d8889a8ee5ea8 : SUCCESS in 30m 11s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/107d2b7e55474b5099568d2750705d4d : SUCCESS in 1h 09m 02s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/055c11b6f3394f6fb1058d7cdd3ff023 : SUCCESS in 23m 59s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/2dfdf20bd4c24549a9e051e885a0aff3 : SUCCESS in 35m 19s\n- openstack-tox-py313 https://zuul.opendev.org/t/openstack/build/86d797a87e8b41679a5f55f13aeb8359 : SUCCESS in 30m 30s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/b98e9254768140a7b399ffd238cf8013 : SUCCESS in 10m 10s\n- neutron-ovs-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/d62e577e1102467cb2af0020d7807cb7 : SUCCESS in 58m 15s\n- neutron-ovn-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/d9439a4558444a419e311f4897f70220 : SUCCESS in 1h 16m 07s\n- neutron-functional https://zuul.opendev.org/t/openstack/build/e5440b32c4ea4f0bbb8b9c716931bb75 : SUCCESS in 1h 22m 42s\n- neutron-ovs-grenade-multinode https://zuul.opendev.org/t/openstack/build/91212b0f6f6f4c86aaee5cc336ac36fa : SUCCESS in 1h 12m 05s\n- neutron-ovn-grenade-multinode https://zuul.opendev.org/t/openstack/build/17c6565729374482a2d64cbfd73c84f7 : SUCCESS in 43m 10s\n- neutron-ovs-tempest-multinode-full https://zuul.opendev.org/t/openstack/build/ac6997d707234ed4966024705269ba1e : SUCCESS in 1h 52m 48s\n- neutron-ovs-tempest-dvr-ha-multinode-full https://zuul.opendev.org/t/openstack/build/8b186b0c255a4182a784d0090efa2754 : SUCCESS in 1h 39m 04s\n- neutron-ovn-tempest-ipv6-only-ovs-release https://zuul.opendev.org/t/openstack/build/639b93e15f794225937d5dfd23a843dc : SUCCESS in 1h 14m 20s\n- neutron-ovs-rally-task https://zuul.opendev.org/t/openstack/build/caa62ba8ca794bb6a0dcf73b3038c803 : SUCCESS in 1h 20m 04s\n- neutron-ovn-rally-task https://zuul.opendev.org/t/openstack/build/861524c9eac14f4982115251d351e599 : SUCCESS in 1h 39m 51s\n- tempest-integrated-networking https://zuul.opendev.org/t/openstack/build/703f044827b3444185721300bc48574f : SUCCESS in 1h 00m 58s","accounts_in_message":[],"_revision_number":5},{"id":"8220c98f525296c6e329843d22adcdda2c97bade","author":{"_account_id":8313,"name":"Lajos Katona","display_name":"lajoskatona","email":"katonalala@gmail.com","username":"elajkat","status":"Ericsson Software Technology"},"date":"2026-02-02 10:05:45.000000000","message":"Patch Set 5: Code-Review+2\n\n(1 comment)","accounts_in_message":[],"_revision_number":5},{"id":"383f9270c2187b1d946a895974209d58dbb6abf1","author":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"date":"2026-03-09 12:50:14.000000000","message":"Patch Set 5:\n\n(1 comment)","accounts_in_message":[],"_revision_number":5},{"id":"f4daf8eb17bbf69974b1b6aa4b2e1cfce5dcd4ff","author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"date":"2026-03-13 12:11:28.000000000","message":"Patch Set 5: Workflow+1","accounts_in_message":[],"_revision_number":5},{"id":"8246b0956992b6cbc66713641b1363d7606e9754","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-03-13 12:12:54.000000000","message":"Patch Set 5: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":5},{"id":"7a05ca366d5b01e8ea195afb580d500984f6686e","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-03-13 14:54:47.000000000","message":"Patch Set 5: Verified-2\n\nBuild failed (gate pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\nhttps://zuul.opendev.org/t/openstack/buildset/38ecf8b8c419491f81bb12a264a646dd\n\n- tempest-integrated-networking https://zuul.opendev.org/t/openstack/build/74bf32b0ca5e4768a2afadba6bd241fd : SUCCESS in 1h 33m 16s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/7966d1450ef949a4b11a7b92ff953c91 : SUCCESS in 35m 48s\n- neutron-tempest-plugin-openvswitch https://zuul.opendev.org/t/openstack/build/b3382248ab0b458c88accd4f51bf8d37 : SUCCESS in 1h 22m 27s\n- neutron-tempest-plugin-ovn https://zuul.opendev.org/t/openstack/build/3f76ee17ec4d4134abd6e8b70887b52a : SUCCESS in 2h 03m 07s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/746bdffc5fd24d7eb7a8aad9d25fdb44 : SUCCESS in 27m 09s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/aa2e28bb222a4472a99c385924ae5f3b : SUCCESS in 54m 33s\n- openstack-tox-py313 https://zuul.opendev.org/t/openstack/build/c45264121be443eaa105c798b9c743d5 : SUCCESS in 26m 07s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/75fb30de1248465bbed96b998d899651 : SUCCESS in 11m 43s\n- neutron-functional https://zuul.opendev.org/t/openstack/build/9e842bc35d3142389126d1c4b90e4b85 : SUCCESS in 49m 31s\n- neutron-ovs-tempest-multinode-full https://zuul.opendev.org/t/openstack/build/09f85f6e5d48444cba22dcd9e4409e68 : SUCCESS in 1h 11m 47s\n- neutron-ovn-grenade-multinode https://zuul.opendev.org/t/openstack/build/e6860c61e7e84df2ad210fc839deace7 : FAILURE in 31m 57s\n- neutron-ovs-grenade-multinode https://zuul.opendev.org/t/openstack/build/cb89c9f1ab8c4ba699190da6cb629140 : SUCCESS in 44m 16s\n- neutron-ovn-tempest-ipv6-only-ovs-release https://zuul.opendev.org/t/openstack/build/d19f4af86924407295900c1fcfe52543 : SUCCESS in 54m 07s","accounts_in_message":[],"_revision_number":5},{"id":"17cdcfec5e2b635a33c6c78333a35c378b0132af","author":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"date":"2026-03-16 08:19:05.000000000","message":"Patch Set 5:\n\n(1 comment)","accounts_in_message":[],"_revision_number":5},{"id":"3a5d60144a1714ec0af7f006d8e22106f596ac53","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-03-16 10:13:08.000000000","message":"Patch Set 5:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/8faaf40280c04e2ab4f86eaae94f0fd8\n\n- openstack-tox-py310-arm64 https://zuul.opendev.org/t/openstack/build/cb8836483ab840989ec90709cd94703c : SUCCESS in 1h 09m 54s (non-voting)\n- openstack-tox-py313-arm64 https://zuul.opendev.org/t/openstack/build/0329f05ae9a4411ab990d61d3786102b : SUCCESS in 17m 33s (non-voting)\n- openstack-tox-py314-arm64 https://zuul.opendev.org/t/openstack/build/1420c4f86d3f4e0083a916e02428fd7e : SUCCESS in 1h 14m 03s (non-voting)","accounts_in_message":[],"_revision_number":5},{"id":"4eb18a30b86a10608833da56fe104c5daa2293ed","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-03-16 10:13:16.000000000","message":"Patch Set 5: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/0126349ac5134274a5b194f866550efd\n\n- tempest-integrated-networking https://zuul.opendev.org/t/openstack/build/f923ea6d5f0f4e8696baa88e23f20d49 : SUCCESS in 1h 45m 24s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/f4cbda71c5044e3a9abc68b5f7fb8e8e : SUCCESS in 1h 02m 22s\n- neutron-tempest-plugin-openvswitch https://zuul.opendev.org/t/openstack/build/59af3cb0a4e4491db67e694b8c4beb77 : SUCCESS in 1h 29m 13s\n- neutron-tempest-plugin-ovn https://zuul.opendev.org/t/openstack/build/a084f36e291f461b89eea93cd5b9bb58 : SUCCESS in 1h 51m 16s\n- neutron-tempest-plugin-designate-scenario https://zuul.opendev.org/t/openstack/build/216048ad4d444490bebf09c06e7bc027 : SUCCESS in 33m 40s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/fa143d7acbc1425795d4117fbbc9f8df : SUCCESS in 1h 10m 35s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/fbb3d89fe8984645ae239255502cbc76 : SUCCESS in 29m 25s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/6569e466efe34ec7b5ecbc7d2f8ccfd8 : SUCCESS in 32m 33s\n- openstack-tox-py313 https://zuul.opendev.org/t/openstack/build/ffd37c7d1ec948508ad4203e9bd2ed27 : SUCCESS in 25m 04s\n- openstack-tox-py314 https://zuul.opendev.org/t/openstack/build/5c9643aea9644cb594cd4cdccbdd2b96 : SUCCESS in 32m 02s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/657e9ba827b9448892f3ebdee13e3756 : SUCCESS in 10m 12s\n- neutron-ovs-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/3749c0713ec14fa590f48cd60e6a8a97 : SUCCESS in 40m 51s\n- neutron-ovn-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/961f1c4d8b0541349ba94e23ea456a49 : SUCCESS in 1h 11m 06s\n- neutron-functional https://zuul.opendev.org/t/openstack/build/3c0c4965cf6c44909488f0bf4bf6ee2e : SUCCESS in 45m 58s\n- neutron-ovs-grenade-multinode https://zuul.opendev.org/t/openstack/build/51dee59a09d3494d8b288240235fd106 : SUCCESS in 1h 11m 47s\n- neutron-ovn-grenade-multinode https://zuul.opendev.org/t/openstack/build/cb966657ccb24f329b20925eec882b82 : SUCCESS in 1h 11m 32s\n- neutron-ovs-tempest-multinode-full https://zuul.opendev.org/t/openstack/build/1d50e77aa72c4889a97a87f3b2692060 : SUCCESS in 1h 48m 36s\n- neutron-ovs-tempest-dvr-ha-multinode-full https://zuul.opendev.org/t/openstack/build/13fcd40e89a94397a450187b8ffdb839 : SUCCESS in 1h 44m 03s\n- neutron-ovn-tempest-ipv6-only-ovs-release https://zuul.opendev.org/t/openstack/build/9bda0db325634a4aa9986ceab3b715d5 : SUCCESS in 1h 10m 30s\n- neutron-ovs-rally-task https://zuul.opendev.org/t/openstack/build/3feaa40f5c13486aac418c754a778e76 : SUCCESS in 1h 15m 31s\n- neutron-ovn-rally-task https://zuul.opendev.org/t/openstack/build/78e3ec8bfcab4bbc99b7c7b272f87e40 : SUCCESS in 1h 22m 22s","accounts_in_message":[],"_revision_number":5},{"id":"85c5f8e9c3f1887cad5771f67f79326c3dffaeba","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-03-16 10:14:04.000000000","message":"Patch Set 5: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":5},{"id":"a0d339cce3f1a4ef36e255b6be19b2af53743f45","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-03-16 12:27:04.000000000","message":"Patch Set 5: Verified+2\n\nBuild succeeded (gate pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/6342e3d7c37148a0a9487885a35a0d92\n\n- tempest-integrated-networking https://zuul.opendev.org/t/openstack/build/9bac2399b85344979b3fe078589de8ed : SUCCESS in 1h 25m 15s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/c98abd2d147840df92510b08e6e5785a : SUCCESS in 58m 23s\n- neutron-tempest-plugin-openvswitch https://zuul.opendev.org/t/openstack/build/1fd1edad019a46c5a72ab1a3ccdc4cb9 : SUCCESS in 1h 25m 13s\n- neutron-tempest-plugin-ovn https://zuul.opendev.org/t/openstack/build/8328aebffcbe4c598fdf3932f2891bb8 : SUCCESS in 1h 51m 38s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/e2e291fbd68d4f7e8f7d6fa704380799 : SUCCESS in 24m 24s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/7e26cb136de4469290827a568952bf96 : SUCCESS in 36m 30s\n- openstack-tox-py313 https://zuul.opendev.org/t/openstack/build/2faf4b3f6dcb492b9086901c0e782530 : SUCCESS in 26m 53s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/a0aac96e504c4576aa4853a46a56c829 : SUCCESS in 11m 33s\n- neutron-functional https://zuul.opendev.org/t/openstack/build/948a9ba040724b3d866e6810d0a258f2 : SUCCESS in 1h 27m 31s\n- neutron-ovs-tempest-multinode-full https://zuul.opendev.org/t/openstack/build/64d539eff2d64440a0cdeec09be93e82 : SUCCESS in 1h 51m 34s\n- neutron-ovn-grenade-multinode https://zuul.opendev.org/t/openstack/build/2b532c8e96f64490b8228574fdee4cb0 : SUCCESS in 58m 30s\n- neutron-ovs-grenade-multinode https://zuul.opendev.org/t/openstack/build/45671b74912f40a882ac4041f3f60953 : SUCCESS in 1h 14m 17s\n- neutron-ovn-tempest-ipv6-only-ovs-release https://zuul.opendev.org/t/openstack/build/f6212380a5bf473688b8d685d2d5258b : SUCCESS in 46m 09s","accounts_in_message":[],"_revision_number":5},{"id":"dc3974d64dbf35b39e4f51599c86e22a2e79ef5b","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-03-16 12:27:05.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":5},{"id":"3a278c15c5e2be9de36c63a7de027fa1eb07a12b","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-03-16 12:28:10.000000000","message":"Patch Set 5:\n\nBuild succeeded (promote pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/1e560cbfb39c410cb2382268fee90c2a\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/a072a9df12024779a3350add9c512e65 : SUCCESS in 47s","accounts_in_message":[],"_revision_number":5}],"current_revision_number":5,"current_revision":"e2938ddbaeeb2e0fab522462f0ade77fa1977b7d","revisions":{"6ddd2ecd02f7ed36832937a65c1a58080db29931":{"kind":"REWORK","_number":1,"created":"2026-01-26 11:57:41.000000000","uploader":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"ref":"refs/changes/13/974713/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/neutron","ref":"refs/changes/13/974713/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/neutron refs/changes/13/974713/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/neutron refs/changes/13/974713/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/neutron refs/changes/13/974713/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/neutron refs/changes/13/974713/1"}}},"commit":{"parents":[{"commit":"5974d8e36d8ca9640b5f91b8049006975e879136","subject":"Merge \"Drop old and unused target_tenant\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/5974d8e36d8ca9640b5f91b8049006975e879136"}]}],"author":{"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","date":"2026-01-23 10:21:11.000000000","tz":60},"committer":{"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","date":"2026-01-26 11:57:23.000000000","tz":60},"subject":"Avoid subquery for object counts","message":"Avoid subquery for object counts\n\nSubqueries can be expensive and they can be even more expensive when the\ntemporary table exceeds the limit for in-memory temporary tables.\n\nEven though mariadb optimizes these style of queries sometimes\n(`derived_merge` optimizer), we should not rely on this.\n\nSigned-Off-By: Jonas Schäfer \u003cjonas.schaefer@cloudandheat.com\u003e\nChange-Id: I6eca066d47503a15d46706b1f925fba5b2919e14\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/6ddd2ecd02f7ed36832937a65c1a58080db29931"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/6ddd2ecd02f7ed36832937a65c1a58080db29931"}]},"branch":"refs/heads/master"},"6ea5689d9ddeb0203af5d6ba325fd4b3e77e55b3":{"kind":"REWORK","_number":2,"created":"2026-01-26 14:22:38.000000000","uploader":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"ref":"refs/changes/13/974713/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/neutron","ref":"refs/changes/13/974713/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/neutron refs/changes/13/974713/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/neutron refs/changes/13/974713/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/neutron refs/changes/13/974713/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/neutron refs/changes/13/974713/2"}}},"commit":{"parents":[{"commit":"5974d8e36d8ca9640b5f91b8049006975e879136","subject":"Merge \"Drop old and unused target_tenant\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/5974d8e36d8ca9640b5f91b8049006975e879136"}]}],"author":{"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","date":"2026-01-23 10:21:11.000000000","tz":60},"committer":{"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","date":"2026-01-26 14:09:00.000000000","tz":60},"subject":"Avoid subquery for object counts","message":"Avoid subquery for object counts\n\nSubqueries can be expensive and they can be even more expensive when the\ntemporary table exceeds the limit for in-memory temporary tables.\n\nEven though mariadb optimizes these style of queries sometimes\n(`derived_merge` optimizer), we should not rely on this.\n\nSigned-Off-By: Jonas Schäfer \u003cjonas.schaefer@cloudandheat.com\u003e\nChange-Id: I6eca066d47503a15d46706b1f925fba5b2919e14\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/6ea5689d9ddeb0203af5d6ba325fd4b3e77e55b3"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/6ea5689d9ddeb0203af5d6ba325fd4b3e77e55b3"}]},"branch":"refs/heads/master"},"502434a1b96a55c97d25de90a90f6be26beef711":{"kind":"REWORK","_number":3,"created":"2026-01-26 14:41:12.000000000","uploader":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"ref":"refs/changes/13/974713/3","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/neutron","ref":"refs/changes/13/974713/3","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/neutron refs/changes/13/974713/3 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/neutron refs/changes/13/974713/3 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/neutron refs/changes/13/974713/3 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/neutron refs/changes/13/974713/3"}}},"commit":{"parents":[{"commit":"5974d8e36d8ca9640b5f91b8049006975e879136","subject":"Merge \"Drop old and unused target_tenant\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/5974d8e36d8ca9640b5f91b8049006975e879136"}]}],"author":{"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","date":"2026-01-23 10:21:11.000000000","tz":60},"committer":{"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","date":"2026-01-26 14:36:04.000000000","tz":60},"subject":"Avoid subquery for object counts","message":"Avoid subquery for object counts\n\nSubqueries can be expensive and they can be even more expensive when the\ntemporary table exceeds the limit for in-memory temporary tables.\n\nEven though mariadb optimizes these style of queries sometimes\n(`derived_merge` optimizer), we should not rely on this.\n\nSigned-Off-By: Jonas Schäfer \u003cjonas.schaefer@cloudandheat.com\u003e\nChange-Id: I6eca066d47503a15d46706b1f925fba5b2919e14\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/502434a1b96a55c97d25de90a90f6be26beef711"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/502434a1b96a55c97d25de90a90f6be26beef711"}]},"branch":"refs/heads/master"},"775fd1c664ce02d87b1dc56cca796a8dbe6c8cc4":{"kind":"NO_CODE_CHANGE","_number":4,"created":"2026-01-27 11:02:33.000000000","uploader":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"ref":"refs/changes/13/974713/4","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/neutron","ref":"refs/changes/13/974713/4","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/neutron refs/changes/13/974713/4 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/neutron refs/changes/13/974713/4 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/neutron refs/changes/13/974713/4 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/neutron refs/changes/13/974713/4"}}},"commit":{"parents":[{"commit":"5974d8e36d8ca9640b5f91b8049006975e879136","subject":"Merge \"Drop old and unused target_tenant\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/5974d8e36d8ca9640b5f91b8049006975e879136"}]}],"author":{"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","date":"2026-01-23 10:21:11.000000000","tz":60},"committer":{"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","date":"2026-01-27 10:59:40.000000000","tz":60},"subject":"Avoid subquery for object counts","message":"Avoid subquery for object counts\n\nSQLAlchemy transforms a query `$foo` into a\n`SELECT COUNT(*) FROM ($foo);` when `.count()` is called on that query.\nThat is the only way to do it correctly for an arbitrary query. However,\nit can also be very expensive and it can be even more expensive when\nthe temporary table (for the subquery) exceeds the limit for in-memory\ntemporary tables.\n\nEven though mariadb optimizes these style of queries sometimes\n(`derived_merge` optimizer), we should not rely on this.\n\nIn some cases, we can replace the entire select field list with\n`COUNT(*)`. This is only possible if the query has no `GROUP BY`\nclause, because otherwise the `COUNT(*)` aggregation would apply to the\ngroups instead of the entire result set.\n\nSigned-Off-By: Jonas Schäfer \u003cjonas.schaefer@cloudandheat.com\u003e\nChange-Id: I6eca066d47503a15d46706b1f925fba5b2919e14\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/775fd1c664ce02d87b1dc56cca796a8dbe6c8cc4"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/775fd1c664ce02d87b1dc56cca796a8dbe6c8cc4"}]},"branch":"refs/heads/master"},"e2938ddbaeeb2e0fab522462f0ade77fa1977b7d":{"kind":"REWORK","_number":5,"created":"2026-01-30 07:18:44.000000000","uploader":{"_account_id":33742,"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","username":"jssfr"},"ref":"refs/changes/13/974713/5","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/neutron","ref":"refs/changes/13/974713/5","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/neutron refs/changes/13/974713/5 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/neutron refs/changes/13/974713/5 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/neutron refs/changes/13/974713/5 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/neutron refs/changes/13/974713/5"}}},"commit":{"parents":[{"commit":"7a80f5afa7299a632ccc78eac92c6c040a9259ad","subject":"Merge \"Bump os-ken to 4.1.1\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/7a80f5afa7299a632ccc78eac92c6c040a9259ad"}]}],"author":{"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","date":"2026-01-23 10:21:11.000000000","tz":60},"committer":{"name":"Jonas Schäfer","email":"jonas.schaefer@cloudandheat.com","date":"2026-01-30 07:18:37.000000000","tz":60},"subject":"Avoid subquery for object counts","message":"Avoid subquery for object counts\n\nSQLAlchemy transforms a query `$foo` into a\n`SELECT COUNT(*) FROM ($foo);` when `.count()` is called on that query.\nThat is the only way to do it correctly for an arbitrary query. However,\nit can also be very expensive and it can be even more expensive when\nthe temporary table (for the subquery) exceeds the limit for in-memory\ntemporary tables.\n\nEven though mariadb optimizes these style of queries sometimes\n(`derived_merge` optimizer), we should not rely on this.\n\nIn some cases, we can replace the entire select field list with\n`COUNT(*)`. This is only possible if the query has no `GROUP BY`\nclause, because otherwise the `COUNT(*)` aggregation would apply to the\ngroups instead of the entire result set.\n\nSigned-Off-By: Jonas Schäfer \u003cjonas.schaefer@cloudandheat.com\u003e\nChange-Id: I6eca066d47503a15d46706b1f925fba5b2919e14\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/e2938ddbaeeb2e0fab522462f0ade77fa1977b7d"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/e2938ddbaeeb2e0fab522462f0ade77fa1977b7d"}]},"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":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"}},{"label":"Workflow","status":"MAY","applied_by":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"}},{"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":{}}},{"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":{}}},{"name":"Review-Priority","description":"Review priority","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"-label:Review-Priority\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":[],"failing_atoms":["label:Review-Priority\u003dMIN"],"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":{}}}]}
