)]}'
{"id":"openstack%2Fneutron~892598","triplet_id":"openstack%2Fneutron~stable%2F2023.1~I05136302f7b8abc0a985b91c993008595234ad6b","project":"openstack/neutron","branch":"stable/2023.1","topic":"improve_get_scoped_floating_ips_performance-stable/2023.1","attention_set":{},"removed_from_attention_set":{"16688":{"account":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"last_update":"2024-01-15 10:40:55.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"}},"1131":{"account":{"_account_id":1131,"name":"Brian Haley","email":"haleyb.dev@gmail.com","username":"brian-haley"},"last_update":"2024-01-15 12:45:56.000000000","reason":"Change was submitted"}},"hashtags":[],"change_id":"I05136302f7b8abc0a985b91c993008595234ad6b","subject":"Remove duplicate rows in MySQL query output","status":"MERGED","created":"2023-08-24 21:33:08.000000000","updated":"2024-01-15 12:47:22.000000000","submitted":"2024-01-15 12:45:56.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":"892598-improve_get_scoped_floating_ips_performance-stable/2023.1","cherry_pick_of_change":876168,"cherry_pick_of_patch_set":4,"meta_rev_id":"f3e93be21048ee9f0fe8739481f40312fe23cc4a","_number":892598,"virtual_id_number":892598,"owner":{"_account_id":1131,"name":"Brian Haley","email":"haleyb.dev@gmail.com","username":"brian-haley"},"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":21798,"name":"Bernard Cafarelli","email":"bcafarel@redhat.com","username":"bcafarel"},{"value":0,"_account_id":36201,"name":"Shanjiayi","email":"shanjiayi@yovole.com","username":"Shanjiayi"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2024-01-15 12:45:56.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":"2024-01-15 10:40:55.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":"2024-01-02 14:20:09.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":21798,"name":"Bernard Cafarelli","email":"bcafarel@redhat.com","username":"bcafarel"},{"value":1,"date":"2024-01-12 01:51:58.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":36201,"name":"Shanjiayi","email":"shanjiayi@yovole.com","username":"Shanjiayi"},{"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":"2024-01-15 10:40:55.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":21798,"name":"Bernard Cafarelli","email":"bcafarel@redhat.com","username":"bcafarel"},{"value":0,"_account_id":36201,"name":"Shanjiayi","email":"shanjiayi@yovole.com","username":"Shanjiayi"},{"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":21798,"name":"Bernard Cafarelli","email":"bcafarel@redhat.com","username":"bcafarel"},{"value":0,"_account_id":36201,"name":"Shanjiayi","email":"shanjiayi@yovole.com","username":"Shanjiayi"},{"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":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},{"_account_id":21798,"name":"Bernard Cafarelli","email":"bcafarel@redhat.com","username":"bcafarel"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":36201,"name":"Shanjiayi","email":"shanjiayi@yovole.com","username":"Shanjiayi"}],"CC":[{"_account_id":35825,"name":"Adam Oswick","email":"adam@adamoswick.co.uk","username":"adamoswick","status":"GoDaddy"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2023-08-24 21:33:08.000000000","updated_by":{"_account_id":1131,"name":"Brian Haley","email":"haleyb.dev@gmail.com","username":"brian-haley"},"reviewer":{"_account_id":35825,"name":"Adam Oswick","email":"adam@adamoswick.co.uk","username":"adamoswick","status":"GoDaddy"},"state":"CC"},{"updated":"2023-08-24 22:06:14.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":"2023-08-24 23:48:27.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":"2024-01-02 14:20:09.000000000","updated_by":{"_account_id":21798,"name":"Bernard Cafarelli","email":"bcafarel@redhat.com","username":"bcafarel"},"reviewer":{"_account_id":21798,"name":"Bernard Cafarelli","email":"bcafarel@redhat.com","username":"bcafarel"},"state":"REVIEWER"},{"updated":"2024-01-11 22:46:26.000000000","updated_by":{"_account_id":1131,"name":"Brian Haley","email":"haleyb.dev@gmail.com","username":"brian-haley"},"reviewer":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"state":"REVIEWER"},{"updated":"2024-01-12 01:51:58.000000000","updated_by":{"_account_id":36201,"name":"Shanjiayi","email":"shanjiayi@yovole.com","username":"Shanjiayi"},"reviewer":{"_account_id":36201,"name":"Shanjiayi","email":"shanjiayi@yovole.com","username":"Shanjiayi"},"state":"REVIEWER"}],"messages":[{"id":"ac3558d7773ea1f05f6a5473f7cc668215daf008","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":1131,"name":"Brian Haley","email":"haleyb.dev@gmail.com","username":"brian-haley"},"date":"2023-08-24 21:33:08.000000000","message":"Patch Set 1: Cherry Picked from branch master.","accounts_in_message":[],"_revision_number":1},{"id":"5c428e1ce2390f1104d74e860107920d272b73da","tag":"autogenerated:gerrit:setWorkInProgress","author":{"_account_id":1131,"name":"Brian Haley","email":"haleyb.dev@gmail.com","username":"brian-haley"},"date":"2023-08-24 21:34:25.000000000","message":"Set Work In Progress","accounts_in_message":[],"_revision_number":1},{"id":"b77ab5d71e2083bddea6e70c32bb37964d629058","author":{"_account_id":1131,"name":"Brian Haley","email":"haleyb.dev@gmail.com","username":"brian-haley"},"date":"2023-08-24 21:56:17.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"bc0d89d5b446a938d6d4647df882d27cca7bd527","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-08-24 22:06:14.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/26d3b1c172c344f3be538bca512ec9ce\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/281aab871cd64aa5a8fbb194e0818bbe : SUCCESS in 21m 20s (non-voting)\n- openstack-tox-py310-arm64 https://zuul.opendev.org/t/openstack/build/e471dfef5f7847c3a4fb4bf834c80bd9 : SUCCESS in 32m 17s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"8382b966b1f48047d78b64cfb76b076cb3f34c2a","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-08-24 23:48:27.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/1b065836dec84a26969f4c7bcfde30d4\n\n- neutron-tempest-plugin-linuxbridge-2023-1 https://zuul.opendev.org/t/openstack/build/52bbfd93fea94d46a6e442bff2bc5db1 : SUCCESS in 2h 13m 12s\n- neutron-tempest-plugin-openvswitch-2023-1 https://zuul.opendev.org/t/openstack/build/ff7e5eb019564746a239ae6a06d6b229 : SUCCESS in 1h 37m 01s\n- neutron-tempest-plugin-openvswitch-iptables_hybrid-2023-1 https://zuul.opendev.org/t/openstack/build/c931c29c3669441596ca1022cb512c20 : SUCCESS in 2h 02m 34s\n- neutron-tempest-plugin-ovn-2023-1 https://zuul.opendev.org/t/openstack/build/b9bff6c319c44abab66bdb94f91571f8 : SUCCESS in 1h 41m 44s\n- neutron-tempest-plugin-designate-scenario-2023-1 https://zuul.opendev.org/t/openstack/build/f1f5d49685de497db88be93e78ca10d1 : SUCCESS in 33m 02s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/e86b53e2f464461c9929fd5662bceaf5 : SUCCESS in 36m 36s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/4181e346807d4ff385dcced5f272b186 : SUCCESS in 12m 56s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/bde9a173e5ad435d8174b4d83a3f4a3e : SUCCESS in 20m 22s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/7212d7e7770d45d49423a9f33cd14ad1 : SUCCESS in 25m 37s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/24366d0cb812478ea6cf3567e1dc5a41 : SUCCESS in 12m 09s\n- tox-py311 https://zuul.opendev.org/t/openstack/build/8a2c9fc3cd004e3aacfde5a588803af7 : SUCCESS in 19m 15s (non-voting)\n- neutron-functional-with-uwsgi https://zuul.opendev.org/t/openstack/build/2b597b3d7d06420eaf870588b8d8af60 : SUCCESS in 52m 00s\n- neutron-fullstack-with-uwsgi https://zuul.opendev.org/t/openstack/build/5ace037cb23046b8a7e9d8567c80493f : SUCCESS in 1h 59m 55s\n- neutron-ovs-grenade-multinode https://zuul.opendev.org/t/openstack/build/fe0a1402e00e4a08a7526bb6c4e0b2de : SUCCESS in 1h 03m 50s\n- neutron-ovs-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/0469d7aa090a49e5ada14591eaa98db3 : SUCCESS in 53m 33s (non-voting)\n- neutron-ovn-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/f53a274c20b54073b84d3c3254969e82 : SUCCESS in 1h 16m 59s (non-voting)\n- neutron-ovs-grenade-dvr-multinode https://zuul.opendev.org/t/openstack/build/d67f6343fdfd4907ae934b8c9cc809b0 : SUCCESS in 51m 26s\n- neutron-ovs-tempest-multinode-full https://zuul.opendev.org/t/openstack/build/f73425f69c5c4cdc8614b980281070b4 : SUCCESS in 1h 22m 19s\n- neutron-ovs-tempest-dvr-ha-multinode-full https://zuul.opendev.org/t/openstack/build/9e0dccda66ae485fa90ee512da770be1 : SUCCESS in 1h 34m 33s\n- neutron-ovn-tempest-ipv6-only-ovs-release https://zuul.opendev.org/t/openstack/build/43deb7b54295422384f320a0a594f3da : SUCCESS in 49m 04s\n- neutron-ovs-rally-task https://zuul.opendev.org/t/openstack/build/675ef8e85473464bab9f2f5f0e845cd4 : SUCCESS in 1h 15m 01s\n- neutron-ovn-rally-task https://zuul.opendev.org/t/openstack/build/691a317853c341719cff98fb501e4fc9 : SUCCESS in 1h 39m 58s\n- tempest-integrated-networking https://zuul.opendev.org/t/openstack/build/8c7a55ff60144979bacc07d9cd918b84 : SUCCESS in 55m 18s\n- neutron-ovn-tempest-ovs-release-ubuntu-old https://zuul.opendev.org/t/openstack/build/b3d34b2f5021419c9725e1fbe51b39d4 : SUCCESS in 1h 06m 50s","accounts_in_message":[],"_revision_number":1},{"id":"dc23f3f3d45e748291a7c71065ab13cd5c545e84","tag":"autogenerated:gerrit:newWipPatchSet","author":{"_account_id":1131,"name":"Brian Haley","email":"haleyb.dev@gmail.com","username":"brian-haley"},"date":"2023-11-08 19:12:07.000000000","message":"Patch Set 2: Patch Set 1 was rebased\n\nOutdated Votes:\n* Verified+1\n","accounts_in_message":[],"_revision_number":2},{"id":"560c49ab2add88046383de7a5f657dce09b1bc75","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-11-08 19:51:24.000000000","message":"Patch Set 2:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/e138ca17e4194c929d44e3050dfd70d7\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/33f751fee83741cba0a42128bb764787 : SUCCESS in 34m 04s (non-voting)\n- openstack-tox-py310-arm64 https://zuul.opendev.org/t/openstack/build/f5e87b8c48394ad8becb4075ed784303 : SUCCESS in 37m 10s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"26f1b0da879148824eefac685d3ab8d8a5340fcd","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-11-08 21:10:49.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/e268c0748da44cfaa24f1ed5cd01b848\n\n- neutron-tempest-plugin-linuxbridge-2023-1 https://zuul.opendev.org/t/openstack/build/b8ce7c11a5bc45aab3e0928bdaa058ff : SUCCESS in 1h 56m 12s\n- neutron-tempest-plugin-openvswitch-2023-1 https://zuul.opendev.org/t/openstack/build/27040407a8cb4cf0ad971ac947bc6b95 : SUCCESS in 1h 36m 06s\n- neutron-tempest-plugin-openvswitch-iptables_hybrid-2023-1 https://zuul.opendev.org/t/openstack/build/20c43d322df14161be99ebd227f75eba : SUCCESS in 1h 33m 02s\n- neutron-tempest-plugin-ovn-2023-1 https://zuul.opendev.org/t/openstack/build/917548a203b048fb90ff5b1fa453efa5 : SUCCESS in 1h 22m 55s\n- neutron-tempest-plugin-designate-scenario-2023-1 https://zuul.opendev.org/t/openstack/build/9c0221d3c16341888e039be370fd7f42 : SUCCESS in 37m 05s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/7354bd50bf1e4123a0059b126ee9ada9 : SUCCESS in 26m 21s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/d05ef3736ff64fb8b5b75255d73ba0bc : SUCCESS in 9m 47s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/461c297e746a4fbfbcffb535e2fcb3d9 : SUCCESS in 25m 43s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/4b6622d0d5894c1b8808e08210b30c8d : SUCCESS in 26m 05s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/7728f9a670854d15b36c7102b80ca804 : SUCCESS in 9m 08s\n- tox-py311 https://zuul.opendev.org/t/openstack/build/1f7a94f8bdbe47e9be7c978a9a2529f6 : SUCCESS in 21m 34s (non-voting)\n- neutron-functional-with-uwsgi https://zuul.opendev.org/t/openstack/build/ca52d174308f43878ae5a5986d0b984e : SUCCESS in 55m 22s\n- neutron-fullstack-with-uwsgi https://zuul.opendev.org/t/openstack/build/990e728954094493b567af748ce215e5 : SUCCESS in 1h 53m 48s\n- neutron-ovs-grenade-multinode https://zuul.opendev.org/t/openstack/build/443cced68f7544c1b9814d431c3eb388 : SUCCESS in 42m 13s\n- neutron-ovs-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/da7fee5bb38e4433bf653d65054cc627 : SUCCESS in 1h 06m 03s (non-voting)\n- neutron-ovn-grenade-multinode-skip-level https://zuul.opendev.org/t/openstack/build/22b4dfc583f040188a6aafc78363b546 : SUCCESS in 1h 17m 24s (non-voting)\n- neutron-ovs-grenade-dvr-multinode https://zuul.opendev.org/t/openstack/build/665b8832870b4b139af45543d9ad2523 : SUCCESS in 49m 59s\n- neutron-ovs-tempest-multinode-full https://zuul.opendev.org/t/openstack/build/cb5917e63083448c8fe632ca0d71a383 : SUCCESS in 1h 02m 53s\n- neutron-ovs-tempest-dvr-ha-multinode-full https://zuul.opendev.org/t/openstack/build/389373d417a6488a8a4c4f25c07e9e2c : SUCCESS in 1h 02m 43s\n- neutron-ovn-tempest-ipv6-only-ovs-release https://zuul.opendev.org/t/openstack/build/86964f0f60904abfb145733b8868612a : SUCCESS in 1h 07m 02s\n- neutron-ovs-rally-task https://zuul.opendev.org/t/openstack/build/213ff679c9574f0f8e8345574b46ad64 : SUCCESS in 1h 45m 12s\n- neutron-ovn-rally-task https://zuul.opendev.org/t/openstack/build/291e2ceed4d74dbca1f2d5ad115a5c5b : SUCCESS in 1h 21m 04s\n- tempest-integrated-networking https://zuul.opendev.org/t/openstack/build/9b8f350ef2834220beb97e4a91c48deb : SUCCESS in 1h 14m 39s\n- neutron-ovn-tempest-ovs-release-ubuntu-old https://zuul.opendev.org/t/openstack/build/2c70e19aac104c0c97bb10586bc7df5e : SUCCESS in 1h 09m 00s","accounts_in_message":[],"_revision_number":2},{"id":"97c1a9b897d8ac8e44c9155bd8df6b83f8d672ef","author":{"_account_id":1131,"name":"Brian Haley","email":"haleyb.dev@gmail.com","username":"brian-haley"},"date":"2023-11-30 23:13:45.000000000","message":"Patch Set 2:\n\nThis change is ready for review.","accounts_in_message":[],"_revision_number":2},{"id":"c80e076a5170304e2a665f1d02e1a2b55b4c9110","author":{"_account_id":21798,"name":"Bernard Cafarelli","email":"bcafarel@redhat.com","username":"bcafarel"},"date":"2024-01-02 14:20:09.000000000","message":"Patch Set 2: Code-Review+2\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"f33b15a4d25ee08136559e254dca1c076d26d814","author":{"_account_id":36201,"name":"Shanjiayi","email":"shanjiayi@yovole.com","username":"Shanjiayi"},"date":"2024-01-12 01:51:58.000000000","message":"Patch Set 2: Code-Review+1","accounts_in_message":[],"_revision_number":2},{"id":"d9cbf4d609669a3c916b1e8c73f664f281a1d8ed","author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"date":"2024-01-15 10:40:55.000000000","message":"Patch Set 2: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":2},{"id":"eddbebe31fb004723602deff7f37de3632e7b53e","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2024-01-15 10:41:39.000000000","message":"Patch Set 2: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":2},{"id":"1be1abfcbdac7d47716ebed83dd57e5c96fc98f2","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2024-01-15 12:45:56.000000000","message":"Patch Set 2: Verified+2\n\nBuild succeeded (gate pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/9f8888bfe5344a24b169871ad4e04673\n\n- neutron-tempest-plugin-ovn-2023-1 https://zuul.opendev.org/t/openstack/build/11d50f65dbab4c4e9173fbb7a561378e : SUCCESS in 1h 18m 19s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/2a5aff4a0274414e8a3a9c4f5b1c6b94 : SUCCESS in 11m 45s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/e04e465f003d488fbb4b163f72948445 : SUCCESS in 24m 53s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/1e986f19693148f8908f2c8b778d466b : SUCCESS in 24m 16s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/3bfd0b26ac55424fa3ec5e149950f0f1 : SUCCESS in 13m 10s\n- neutron-functional-with-uwsgi https://zuul.opendev.org/t/openstack/build/917b9dedafab416f956833d09a43f177 : SUCCESS in 42m 01s\n- neutron-fullstack-with-uwsgi https://zuul.opendev.org/t/openstack/build/6f01cbeef3874f23bc2925b8c6543897 : SUCCESS in 1h 42m 32s\n- neutron-ovs-tempest-multinode-full https://zuul.opendev.org/t/openstack/build/3a5597a0994f4a6498ac132c4711d600 : SUCCESS in 1h 29m 47s\n- neutron-ovs-grenade-multinode https://zuul.opendev.org/t/openstack/build/1e1b95aaa1bb41e3a267280aa5c4ea59 : SUCCESS in 1h 09m 38s\n- neutron-ovs-grenade-dvr-multinode https://zuul.opendev.org/t/openstack/build/f938d831baf44727bf334632aa4ce73f : SUCCESS in 1h 08m 58s\n- neutron-ovn-tempest-ipv6-only-ovs-release https://zuul.opendev.org/t/openstack/build/a49f7413048b4531a762822f4e7fc5f9 : SUCCESS in 59m 48s\n- tempest-integrated-networking https://zuul.opendev.org/t/openstack/build/46d0acfd3c0e471f8e9a764b9497a6a2 : SUCCESS in 1h 07m 44s\n- neutron-ovn-tempest-ovs-release-ubuntu-old https://zuul.opendev.org/t/openstack/build/8198f995230e4f25bf658c984da73135 : SUCCESS in 1h 08m 34s","accounts_in_message":[],"_revision_number":2},{"id":"5cd75bdfd1aff965c1aa86433c14e2c4d45bc235","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2024-01-15 12:45:56.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":2},{"id":"f3e93be21048ee9f0fe8739481f40312fe23cc4a","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2024-01-15 12:47:22.000000000","message":"Patch Set 2:\n\nBuild succeeded (promote pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/abe9beb6b1bd408e9865435dc9460bbe\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/73e756e7ece041bf807ec8609afcaefc : SUCCESS in 1m 02s","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"f96691b2088ac2a4a165d2d5281a8a891734acfd","revisions":{"4a82cb2a90287665cd5e6e44a8649a659122a84e":{"kind":"REWORK","_number":1,"created":"2023-08-24 21:33:08.000000000","uploader":{"_account_id":1131,"name":"Brian Haley","email":"haleyb.dev@gmail.com","username":"brian-haley"},"ref":"refs/changes/98/892598/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/neutron","ref":"refs/changes/98/892598/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/neutron refs/changes/98/892598/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/neutron refs/changes/98/892598/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/neutron refs/changes/98/892598/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/neutron refs/changes/98/892598/1"}}},"commit":{"parents":[{"commit":"6eaa2a01a0bd3c207eb8a172a193d19944711f37","subject":"Merge \"[OVN] Retry retrieving LSP hosting information\" into stable/2023.1","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/6eaa2a01a0bd3c207eb8a172a193d19944711f37"}]}],"author":{"name":"Adam Oswick","email":"adam@adamoswick.co.uk","date":"2023-03-02 13:26:50.000000000","tz":0},"committer":{"name":"Brian Haley","email":"haleyb.dev@gmail.com","date":"2023-08-24 21:33:08.000000000","tz":0},"subject":"Remove duplicate rows in MySQL query output","message":"Remove duplicate rows in MySQL query output\n\nPreviously we would expect duplicates rows from MySQL and then filter\nthem with _unique_floatingip_iterator. This means that we were\nconverting rows to ORM-mapped objects unnecessarily. This conversion is\nvery CPU intensive.\n\nInstead, we can remove the duplicates as a part of the query which means\nthat only unique rows are returned and the number of conversions from\nrows to ORM-mapped objects is reduced significantly. It also means that\nthe _unique_floatingip_iterator function is no longer needed.\n\nChange-Id: I05136302f7b8abc0a985b91c993008595234ad6b\nSigned-off-by: Adam Oswick \u003cadam@adamoswick.co.uk\u003e\n(cherry picked from commit 8946684fb2a8cc800b5decac95acc3106eb723d0)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/4a82cb2a90287665cd5e6e44a8649a659122a84e"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/4a82cb2a90287665cd5e6e44a8649a659122a84e"}]},"branch":"refs/heads/stable/2023.1"},"f96691b2088ac2a4a165d2d5281a8a891734acfd":{"kind":"TRIVIAL_REBASE","_number":2,"created":"2023-11-08 19:12:07.000000000","uploader":{"_account_id":1131,"name":"Brian Haley","email":"haleyb.dev@gmail.com","username":"brian-haley"},"ref":"refs/changes/98/892598/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/neutron","ref":"refs/changes/98/892598/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/neutron refs/changes/98/892598/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/neutron refs/changes/98/892598/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/neutron refs/changes/98/892598/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/neutron refs/changes/98/892598/2"}}},"commit":{"parents":[{"commit":"a680d580e8d83e7afaa331d74fc8f127b9c33120","subject":"[Stable Only] Fix parent for nftables job","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/a680d580e8d83e7afaa331d74fc8f127b9c33120"}]}],"author":{"name":"Adam Oswick","email":"adam@adamoswick.co.uk","date":"2023-03-02 13:26:50.000000000","tz":0},"committer":{"name":"Brian Haley","email":"haleyb.dev@gmail.com","date":"2023-11-08 19:12:07.000000000","tz":0},"subject":"Remove duplicate rows in MySQL query output","message":"Remove duplicate rows in MySQL query output\n\nPreviously we would expect duplicates rows from MySQL and then filter\nthem with _unique_floatingip_iterator. This means that we were\nconverting rows to ORM-mapped objects unnecessarily. This conversion is\nvery CPU intensive.\n\nInstead, we can remove the duplicates as a part of the query which means\nthat only unique rows are returned and the number of conversions from\nrows to ORM-mapped objects is reduced significantly. It also means that\nthe _unique_floatingip_iterator function is no longer needed.\n\nChange-Id: I05136302f7b8abc0a985b91c993008595234ad6b\nSigned-off-by: Adam Oswick \u003cadam@adamoswick.co.uk\u003e\n(cherry picked from commit 8946684fb2a8cc800b5decac95acc3106eb723d0)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/f96691b2088ac2a4a165d2d5281a8a891734acfd"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/f96691b2088ac2a4a165d2d5281a8a891734acfd"}]},"branch":"refs/heads/stable/2023.1","description":"Rebase"}},"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":21798,"name":"Bernard Cafarelli","email":"bcafarel@redhat.com","username":"bcafarel"}},{"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":{}}}]}