)]}'
{"id":"openstack%2Fneutron~693540","triplet_id":"openstack%2Fneutron~master~Ibe3034e93d3b6ee3a2b95fbb641f3a80d8e597c0","project":"openstack/neutron","branch":"master","hashtags":[],"change_id":"Ibe3034e93d3b6ee3a2b95fbb641f3a80d8e597c0","subject":"objects/agent: Remove group_by from agent query","status":"ABANDONED","created":"2019-11-08 14:08:23.000000000","updated":"2020-09-25 15:47:16.000000000","total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"c4bdbe860844422115ec666fde190e603071ab92","_number":693540,"virtual_id_number":693540,"owner":{"_account_id":27056,"name":"Sven Wegener","email":"sven.wegener@stealer.net","username":"swegener"},"actions":{},"labels":{"Verified":{"disliked":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"date":"2019-11-08 23:21:43.000000000","permitted_voting_range":{"min":-1,"max":1},"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},{"value":0,"date":"2019-11-08 15:18:56.000000000","permitted_voting_range":{"min":-1,"max":1},"_account_id":9845,"name":"Arista CI","email":"arista-openstack-test@aristanetworks.com","username":"arista-test","tags":["SERVICE_USER"]},{"date":"2020-09-25 15:47:16.000000000","_account_id":11975,"name":"Slawek Kaplonski","email":"skaplons@redhat.com","username":"slaweq"},{"date":"2019-11-08 14:40:04.000000000","_account_id":16376,"name":"Intel NFV CI","email":"openstack-nfv-ci@intel.com","username":"intel-nfv-ci","tags":["SERVICE_USER"]},{"tag":"autogenerated:zuul:check","value":-1,"date":"2019-11-08 16:26:48.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"date":"2019-11-08 15:47:15.000000000","_account_id":26622,"name":"Cloudbase Neutron Hyper-V CI","email":"neutron_hyperv_ci@cloudbasesolutions.com","username":"neutron_hyperv_ci"}],"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","value":-1,"default_value":0,"optional":true},"Code-Review":{"all":[{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":9845,"name":"Arista CI","email":"arista-openstack-test@aristanetworks.com","username":"arista-test","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-2,"max":2},"_account_id":11975,"name":"Slawek Kaplonski","email":"skaplons@redhat.com","username":"slaweq"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":16376,"name":"Intel NFV CI","email":"openstack-nfv-ci@intel.com","username":"intel-nfv-ci","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":26622,"name":"Cloudbase Neutron Hyper-V CI","email":"neutron_hyperv_ci@cloudbasesolutions.com","username":"neutron_hyperv_ci"}],"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":{"all":[{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},{"_account_id":9845,"name":"Arista CI","email":"arista-openstack-test@aristanetworks.com","username":"arista-test","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":11975,"name":"Slawek Kaplonski","email":"skaplons@redhat.com","username":"slaweq"},{"_account_id":16376,"name":"Intel NFV CI","email":"openstack-nfv-ci@intel.com","username":"intel-nfv-ci","tags":["SERVICE_USER"]},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":26622,"name":"Cloudbase Neutron Hyper-V CI","email":"neutron_hyperv_ci@cloudbasesolutions.com","username":"neutron_hyperv_ci"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},{"_account_id":9845,"name":"Arista CI","email":"arista-openstack-test@aristanetworks.com","username":"arista-test","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":2},"_account_id":11975,"name":"Slawek Kaplonski","email":"skaplons@redhat.com","username":"slaweq"},{"_account_id":16376,"name":"Intel NFV CI","email":"openstack-nfv-ci@intel.com","username":"intel-nfv-ci","tags":["SERVICE_USER"]},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":26622,"name":"Cloudbase Neutron Hyper-V CI","email":"neutron_hyperv_ci@cloudbasesolutions.com","username":"neutron_hyperv_ci"}],"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":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},{"_account_id":9845,"name":"Arista CI","email":"arista-openstack-test@aristanetworks.com","username":"arista-test","tags":["SERVICE_USER"]},{"_account_id":11975,"name":"Slawek Kaplonski","email":"skaplons@redhat.com","username":"slaweq"},{"_account_id":16376,"name":"Intel NFV CI","email":"openstack-nfv-ci@intel.com","username":"intel-nfv-ci","tags":["SERVICE_USER"]},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":26622,"name":"Cloudbase Neutron Hyper-V CI","email":"neutron_hyperv_ci@cloudbasesolutions.com","username":"neutron_hyperv_ci"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2019-11-08 14:40:04.000000000","updated_by":{"_account_id":16376,"name":"Intel NFV CI","email":"openstack-nfv-ci@intel.com","username":"intel-nfv-ci","tags":["SERVICE_USER"]},"reviewer":{"_account_id":16376,"name":"Intel NFV CI","email":"openstack-nfv-ci@intel.com","username":"intel-nfv-ci","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2019-11-08 15:18:56.000000000","updated_by":{"_account_id":9845,"name":"Arista CI","email":"arista-openstack-test@aristanetworks.com","username":"arista-test","tags":["SERVICE_USER"]},"reviewer":{"_account_id":9845,"name":"Arista CI","email":"arista-openstack-test@aristanetworks.com","username":"arista-test","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2019-11-08 15:47:15.000000000","updated_by":{"_account_id":26622,"name":"Cloudbase Neutron Hyper-V CI","email":"neutron_hyperv_ci@cloudbasesolutions.com","username":"neutron_hyperv_ci"},"reviewer":{"_account_id":26622,"name":"Cloudbase Neutron Hyper-V CI","email":"neutron_hyperv_ci@cloudbasesolutions.com","username":"neutron_hyperv_ci"},"state":"REVIEWER"},{"updated":"2019-11-08 16:26:48.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":"2019-11-08 23:21:43.000000000","updated_by":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"reviewer":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2020-09-25 15:47:16.000000000","updated_by":{"_account_id":11975,"name":"Slawek Kaplonski","email":"skaplons@redhat.com","username":"slaweq"},"reviewer":{"_account_id":11975,"name":"Slawek Kaplonski","email":"skaplons@redhat.com","username":"slaweq"},"state":"REVIEWER"}],"messages":[{"id":"e0ad00c42406a3e6c9b9057242e01ae4c406bedb","author":{"_account_id":27056,"name":"Sven Wegener","email":"sven.wegener@stealer.net","username":"swegener"},"date":"2019-11-08 14:08:23.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"6a612bc522dda6b075bddd6a34b5d789b97d2d11","author":{"_account_id":16376,"name":"Intel NFV CI","email":"openstack-nfv-ci@intel.com","username":"intel-nfv-ci","tags":["SERVICE_USER"]},"date":"2019-11-08 14:40:04.000000000","message":"Patch Set 1:\n\nBuild succeeded (check pipeline).\n\n- tempest-dsvm-ovsdpdk-nfv-networking-xenial http://52.27.155.124/portland/2019-11-08/693540/1/check/tempest-dsvm-ovsdpdk-nfv-networking-xenial/1cc47ec : FAILURE in 31m 17s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"c2c5a62de20f311d142ccc1530f75b3b97ccb5ee","author":{"_account_id":9845,"name":"Arista CI","email":"arista-openstack-test@aristanetworks.com","username":"arista-test","tags":["SERVICE_USER"]},"date":"2019-11-08 15:18:56.000000000","message":"Patch Set 1:\n\nArista third party testing FAILED [ http://arista-CI.arista.com:8000/November-2019/Arista_Tempest_Testrefs/changes/40/693540/1 ]\n\nFor testing details or any questions please check https://wiki.openstack.org/wiki/Arista-third-party-testing","accounts_in_message":[],"_revision_number":1},{"id":"448f05182e24a448817097e210709a1c8be90a98","author":{"_account_id":26622,"name":"Cloudbase Neutron Hyper-V CI","email":"neutron_hyperv_ci@cloudbasesolutions.com","username":"neutron_hyperv_ci"},"date":"2019-11-08 15:47:15.000000000","message":"Patch Set 1:\n\nBuild succeeded.\n\n- neutron http://cloudbase-ci.com/neutron/693540/1 : SUCCESS in 1h 38m 23s","accounts_in_message":[],"_revision_number":1},{"id":"96e686d90ee6376f33d8363dbbbc3ee8cb581644","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-11-08 16:26:48.000000000","message":"Patch Set 1: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttp://docs.openstack.org/infra/manual/developers.html#automated-testing\n\n\n- neutron-tempest-plugin-api https://zuul.opendev.org/t/openstack/build/e5e04a8c96344e43b24c0b344b3da6b2 : SUCCESS in 46m 28s\n- neutron-tempest-plugin-designate-scenario https://zuul.opendev.org/t/openstack/build/f055b48de5e94ca0a92789eda9d671fe : SUCCESS in 32m 34s\n- neutron-tempest-plugin-dvr-multinode-scenario https://zuul.opendev.org/t/openstack/build/09e89d435fe44b7abcd6a87f5de32d95 : FAILURE in 1h 45m 20s (non-voting)\n- neutron-tempest-plugin-scenario-linuxbridge https://zuul.opendev.org/t/openstack/build/9e06cf988e884d7682852edee0c86dcb : SUCCESS in 1h 29m 43s\n- neutron-tempest-plugin-scenario-openvswitch https://zuul.opendev.org/t/openstack/build/44180bfd1c034cf48a6899a0be43cb99 : SUCCESS in 55m 32s\n- neutron-tempest-plugin-scenario-openvswitch-iptables_hybrid https://zuul.opendev.org/t/openstack/build/1cbca5390ebc43d1919a1255863d912f : SUCCESS in 48m 46s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/0eca6d880ed7482a93dcd4e97905c3b6 : SUCCESS in 24m 54s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/e5cc992127504ab890484d50e5083b6d : SUCCESS in 27m 43s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/2dfe6e113a5648d89df6f49570c3e0e9 : SUCCESS in 11m 16s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/64daa6cd3eb8442697a93312350cbc10 : SUCCESS in 19m 04s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/f4368f5e714843e0b6d45a9863b645d1 : SUCCESS in 18m 17s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/4c7d47a3f6294c66a2804da69f911e8f : SUCCESS in 12m 50s\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/abf6f1bb43b547fbb9f39323c655a319 : SUCCESS in 52m 36s\n- tempest-integrated-networking https://zuul.opendev.org/t/openstack/build/154ee25f52544d0a87611ac65aeb8629 : SUCCESS in 1h 18m 57s\n- neutron-functional https://zuul.opendev.org/t/openstack/build/c1542dcd419f49a9909a0c5158ff6685 : SUCCESS in 40m 54s\n- neutron-fullstack https://zuul.opendev.org/t/openstack/build/2886b9e72bd2463899a66f5728dd5288 : SUCCESS in 1h 47m 18s\n- neutron-rally-task https://zuul.opendev.org/t/openstack/build/69060bb67dba443da135dd1611613825 : SUCCESS in 2h 01m 07s\n- neutron-tempest-dvr https://zuul.opendev.org/t/openstack/build/f56e450cb4894823a816c1bc392d5989 : SUCCESS in 2h 01m 44s\n- neutron-tempest-linuxbridge https://zuul.opendev.org/t/openstack/build/44c9358079004fef96891be602890191 : SUCCESS in 1h 06m 16s\n- neutron-grenade-multinode https://zuul.opendev.org/t/openstack/build/1dc7d6f4683044568ab274cae1e9a1dd : FAILURE in 1h 14m 52s\n- neutron-grenade-dvr-multinode https://zuul.opendev.org/t/openstack/build/61786c6c21ea4b1d8347590dbf752c6d : SUCCESS in 1h 10m 14s\n- tempest-multinode-full-py3 https://zuul.opendev.org/t/openstack/build/7c6bc3e81a6d4ca682c0c7dc457bbb6a : SUCCESS in 1h 36m 04s (non-voting)\n- neutron-tempest-dvr-ha-multinode-full https://zuul.opendev.org/t/openstack/build/a4f6f3a5e39e4781bfc03ecd226f7c85 : SUCCESS in 1h 40m 26s (non-voting)\n- neutron-tempest-iptables_hybrid https://zuul.opendev.org/t/openstack/build/d4eadd73884a4c3fb4fd8653d72b1831 : SUCCESS in 1h 07m 31s\n- neutron-tempest-iptables_hybrid-fedora https://zuul.opendev.org/t/openstack/build/dc99b249bc1748bab72549410d6f4108 : SUCCESS in 2h 07m 44s\n- neutron-grenade https://zuul.opendev.org/t/openstack/build/fb3ea96ca46441319323da323998b3fb : SUCCESS in 55m 44s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/ae4ff5c5ed9f4dbdbaf9284c09b68ed3 : FAILURE in 1h 31m 03s (non-voting)\n- tempest-slow-py3 https://zuul.opendev.org/t/openstack/build/3f8f3fb5de854aacbcae644b0351d1e3 : SUCCESS in 2h 13m 51s\n- networking-ovn-tempest-dsvm-ovs-release https://zuul.opendev.org/t/openstack/build/6f5c789a78364f55814002ddf4b25882 : SUCCESS in 2h 16m 45s\n- networking-midonet-tempest-aio-ml2-centos-7 https://zuul.opendev.org/t/openstack/build/850fd8184a8c4400b32fa410f848261b : FAILURE in 17m 13s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/cf05cd35a29b40498e3b751d305f7598 : SUCCESS in 1h 52m 28s\n- openstacksdk-functional-devstack-networking https://zuul.opendev.org/t/openstack/build/1cd8e24c1ef9409ea4c3f7e5c604664e : SUCCESS in 2h 11m 13s (non-voting)\n- neutron-functional-with-uwsgi https://zuul.opendev.org/t/openstack/build/ac6fc3323bd54c819fd67b8de66b5a99 : SUCCESS in 41m 21s (non-voting)\n- neutron-fullstack-with-uwsgi https://zuul.opendev.org/t/openstack/build/193e819d5a7948ae9d2821c4c7b132b1 : SUCCESS in 1h 00m 38s (non-voting)\n- neutron-tempest-with-uwsgi https://zuul.opendev.org/t/openstack/build/7efcdd88abfe48c78a47f23ae0d25fa1 : SUCCESS in 1h 54m 09s (non-voting)\n- neutron-centos-7-tripleo-standalone https://zuul.opendev.org/t/openstack/build/6e1eb3b285b0451ca42ed727e017b011 : SUCCESS in 1h 37m 41s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"9d44028b79ce0297a14c7b2825a4190c1da773c6","author":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"date":"2019-11-08 23:21:43.000000000","message":"Patch Set 1:\n\nBuild failed. To re-run the job please post a comment with \u0027recheck neutron-mlnx\u0027.\n\n- Neutron-ML2-Sriov http://13.74.249.42/40/693540/1/check-mlnx/Neutron-ML2-Sriov/5131e96 : FAILURE in 48m 27s\n- Neutron-MACVTAP-ML2-Sriov http://13.74.249.42/40/693540/1/check-mlnx/Neutron-MACVTAP-ML2-Sriov/1c661e6 : FAILURE in 1h 01m 01s\n\nTo re-run the job post \u0027recheck neutron-mlnx\u0027 comment. For more information visit https://wiki.openstack.org/wiki/ThirdPartySystems/Mellanox_CI","accounts_in_message":[],"_revision_number":1},{"id":"c4bdbe860844422115ec666fde190e603071ab92","author":{"_account_id":11975,"name":"Slawek Kaplonski","email":"skaplons@redhat.com","username":"slaweq"},"date":"2020-09-25 15:47:16.000000000","message":"Abandoned\n\nThis review is \u003e 4 weeks without comment, and failed Zuul jobs the last time it was checked. We are abandoning this for now. Feel free to reactivate the review by pressing the restore button and leaving a \u0027recheck\u0027 comment to get fresh test results.","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"c483d3a8069b15aa79d0d3672985ea9f96f6c18e","revisions":{"c483d3a8069b15aa79d0d3672985ea9f96f6c18e":{"kind":"REWORK","_number":1,"created":"2019-11-08 14:08:23.000000000","uploader":{"_account_id":27056,"name":"Sven Wegener","email":"sven.wegener@stealer.net","username":"swegener"},"ref":"refs/changes/40/693540/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/neutron","ref":"refs/changes/40/693540/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/neutron refs/changes/40/693540/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/neutron refs/changes/40/693540/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/neutron refs/changes/40/693540/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/neutron refs/changes/40/693540/1"}}},"commit":{"parents":[{"commit":"d15ad2e481b9b888079d55ba46d73ca5b7253285","subject":"Increase waiting time for network rescheduling","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/d15ad2e481b9b888079d55ba46d73ca5b7253285"}]}],"author":{"name":"Sven Wegener","email":"sven.wegener@inovex.de","date":"2019-11-08 12:30:41.000000000","tz":60},"committer":{"name":"Sven Wegener","email":"sven.wegener@inovex.de","date":"2019-11-08 14:07:58.000000000","tz":60},"subject":"objects/agent: Remove group_by from agent query","message":"objects/agent: Remove group_by from agent query\n\nThe query select all fields from the table and having a group by in this\ncase only works on MySQL, but breaks on PostgreSQL with:\n\nERROR neutron.pecan_wsgi.hooks.translation oslo_db.exception.DBError: (psycopg2.errors.GroupingError) column \"agents.id\" must appear in the GROUP BY clause or be used in an aggregate function\nERROR neutron.pecan_wsgi.hooks.translation LINE 1: SELECT agents.id AS agents_id, agents.agent_type AS agents_a...\n\nBased on the function\u0027s name it shouldn\u0027t do any grouping and return all\nagents. For the only caller this group by is kind of an optimization,\nbut the caller also does deduplication, so let\u0027s just remove it.\n\nChange-Id: Ibe3034e93d3b6ee3a2b95fbb641f3a80d8e597c0\nSigned-off-by: Sven Wegener \u003csven.wegener@inovex.de\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/c483d3a8069b15aa79d0d3672985ea9f96f6c18e"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/neutron/commit/c483d3a8069b15aa79d0d3672985ea9f96f6c18e"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}