)]}'
{"id":"openstack%2Fnova~705850","triplet_id":"openstack%2Fnova~master~I267c6f772d514b442c8c3356c2babc1fe98a8b97","project":"openstack/nova","branch":"master","topic":"no_distinct_on","hashtags":[],"change_id":"I267c6f772d514b442c8c3356c2babc1fe98a8b97","subject":"remove DISTINCT ON SQL instruction that does nothing on MySQL","status":"MERGED","created":"2020-02-04 21:38:06.000000000","updated":"2020-03-26 11:17:20.000000000","submitted":"2020-03-25 23:18:58.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":4,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"705850-1585178338367-1d1e633c","meta_rev_id":"4f423fffc390d2792d55852a1f079c721fc736d2","_number":705850,"virtual_id_number":705850,"owner":{"_account_id":11816,"name":"mike bayer","display_name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","username":"zzzeek","status":"Red Hat"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"tag":"autogenerated:jenkins-gerrit-trigger","value":0,"date":"2020-03-25 20:32:03.000000000","_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},{"value":0,"date":"2020-03-25 20:57:11.000000000","_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},{"value":0,"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"value":0,"date":"2020-03-25 17:19:38.000000000","permitted_voting_range":{"min":0,"max":1},"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"value":0,"date":"2020-02-06 23:54:36.000000000","_account_id":11816,"name":"mike bayer","display_name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","username":"zzzeek","status":"Red Hat"},{"value":0,"date":"2020-03-25 22:35:22.000000000","permitted_voting_range":{"min":0,"max":1},"_account_id":23498,"name":"IBM zVM CI","email":"zvmosci@us.ibm.com","username":"zvmosci"},{"value":0,"date":"2020-03-25 18:08:37.000000000","_account_id":29963,"name":"Intel_Zuul","display_name":"Intel Corporation CI","email":"intel-openstack-ci@intel.com","username":"Intel_Zuul"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2020-03-25 23:18:56.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"date":"2020-03-25 04:32:30.000000000","_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},{"value":0,"date":"2020-03-25 18:21:15.000000000","_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},{"value":0,"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"value":0,"date":"2020-03-25 04:13:38.000000000","_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},{"value":0,"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"}],"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":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"all":[{"value":0,"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},{"value":0,"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},{"value":2,"date":"2020-02-10 16:40:33.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"value":0,"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"value":0,"_account_id":11816,"name":"mike bayer","display_name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","username":"zzzeek","status":"Red Hat"},{"value":0,"_account_id":23498,"name":"IBM zVM CI","email":"zvmosci@us.ibm.com","username":"zvmosci"},{"value":0,"_account_id":29963,"name":"Intel_Zuul","display_name":"Intel Corporation CI","email":"intel-openstack-ci@intel.com","username":"Intel_Zuul"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},{"value":0,"_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},{"value":2,"date":"2020-02-07 00:27:53.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"value":0,"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},{"value":0,"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"}],"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":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"all":[{"value":0,"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},{"value":0,"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},{"value":1,"date":"2020-02-10 16:40:33.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"value":0,"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"value":0,"_account_id":11816,"name":"mike bayer","display_name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","username":"zzzeek","status":"Red Hat"},{"value":0,"_account_id":23498,"name":"IBM zVM CI","email":"zvmosci@us.ibm.com","username":"zvmosci"},{"value":0,"_account_id":29963,"name":"Intel_Zuul","display_name":"Intel Corporation CI","email":"intel-openstack-ci@intel.com","username":"Intel_Zuul"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},{"value":0,"_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},{"value":0,"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"value":0,"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},{"value":0,"date":"2020-02-05 14:16:34.000000000","_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},{"value":0,"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},{"value":0,"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"value":0,"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"value":0,"_account_id":11816,"name":"mike bayer","display_name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","username":"zzzeek","status":"Red Hat"},{"value":0,"_account_id":23498,"name":"IBM zVM CI","email":"zvmosci@us.ibm.com","username":"zvmosci"},{"value":0,"_account_id":29963,"name":"Intel_Zuul","display_name":"Intel Corporation CI","email":"intel-openstack-ci@intel.com","username":"Intel_Zuul"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},{"value":0,"_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},{"value":0,"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"value":0,"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},{"value":0,"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"}],"values":{" 0":"Default Priority","+1":"Contributor Review Promise","+2":"Core Review Promise"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},{"_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"_account_id":11816,"name":"mike bayer","display_name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","username":"zzzeek","status":"Red Hat"},{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":23498,"name":"IBM zVM CI","email":"zvmosci@us.ibm.com","username":"zvmosci"},{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},{"_account_id":29963,"name":"Intel_Zuul","display_name":"Intel Corporation CI","email":"intel-openstack-ci@intel.com","username":"Intel_Zuul"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2020-02-05 14:16:34.000000000","updated_by":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"reviewer":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"state":"REVIEWER"},{"updated":"2020-02-07 00:27:53.000000000","updated_by":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"reviewer":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"state":"REVIEWER"},{"updated":"2020-02-10 16:40:33.000000000","updated_by":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"reviewer":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"state":"REVIEWER"},{"updated":"2020-03-25 04:13:38.000000000","updated_by":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"reviewer":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"state":"REVIEWER"},{"updated":"2020-03-25 04:32:30.000000000","updated_by":{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},"reviewer":{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2020-03-25 17:19:38.000000000","updated_by":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"reviewer":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2020-03-25 18:08:37.000000000","updated_by":{"_account_id":29963,"name":"Intel_Zuul","display_name":"Intel Corporation CI","email":"intel-openstack-ci@intel.com","username":"Intel_Zuul"},"reviewer":{"_account_id":29963,"name":"Intel_Zuul","display_name":"Intel Corporation CI","email":"intel-openstack-ci@intel.com","username":"Intel_Zuul"},"state":"REVIEWER"},{"updated":"2020-03-25 18:21:15.000000000","updated_by":{"_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},"reviewer":{"_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2020-03-25 20:32:03.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-03-25 20:57:11.000000000","updated_by":{"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},"reviewer":{"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2020-03-25 22:35:22.000000000","updated_by":{"_account_id":23498,"name":"IBM zVM CI","email":"zvmosci@us.ibm.com","username":"zvmosci"},"reviewer":{"_account_id":23498,"name":"IBM zVM CI","email":"zvmosci@us.ibm.com","username":"zvmosci"},"state":"REVIEWER"},{"updated":"2020-03-25 23:18:56.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"}],"messages":[{"id":"b323254ae911b81d15f1a88f4e710c38d3ac1839","author":{"_account_id":11816,"name":"mike bayer","display_name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","username":"zzzeek","status":"Red Hat"},"date":"2020-02-04 21:38:06.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"1a46bee844efa7b0b166562b7f557c1b9880827c","author":{"_account_id":29963,"name":"Intel_Zuul","display_name":"Intel Corporation CI","email":"intel-openstack-ci@intel.com","username":"Intel_Zuul"},"date":"2020-02-04 21:40:42.000000000","message":"Patch Set 1:\n\nBuild failed.\n\n- pmem-tempest-plugin-filtered finger://d0fe4b8af32b/3dd6c97bb62c4c6fb73a24b921df0e43 : RETRY_LIMIT in 7s","accounts_in_message":[],"_revision_number":1},{"id":"e8bf96d644350d99239a2fc4476f31d982da1cee","author":{"_account_id":23498,"name":"IBM zVM CI","email":"zvmosci@us.ibm.com","username":"zvmosci"},"date":"2020-02-04 22:38:24.000000000","message":"Patch Set 1:\n\nTesting completed on the zVM Driver CI system check-nova pipeline and failed.  To recheck only the zVM driver plugins, submit a comment with only  zvm: recheck in the comment.. Contact information: zvmosci@us.ibm.com. For information see https://wiki.openstack.org/wiki/ZVMDriver.\n\n- check-nova-master http://extbasicopstackcilog01.podc.sl.edst.ibm.com/test_logs/jenkins-check-nova-master-40740 : FAILURE in 59m 39s","accounts_in_message":[],"_revision_number":1},{"id":"29c58ae45a4008a41dd31214e7c575c821252114","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-02-04 23:16:47.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/560cf1f577964d8c991635356377b249 : SUCCESS in 54m 39s\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/94b5b00525874fdfbb195e62cb848640 : SUCCESS in 1h 17m 22s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/376636a6e05746e4aee8753b5bbb50d7 : SUCCESS in 20m 44s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/adc904a63b52480a9855d69ce2a3e5f6 : SUCCESS in 18m 20s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/6a7e233fe40841d0a6b17aaf651d2e94 : SUCCESS in 9m 58s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/12b58f567ce648a69dd1eb58f9c4fb65 : SUCCESS in 19m 01s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/9e68e5d111334d8c872fa85992c7676c : SUCCESS in 17m 22s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/7304e2bdd5f4497081cb3346e26d7926 : SUCCESS in 19m 45s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/9a1fd2d9c65443fe93fa7d50783b3b6e : SUCCESS in 15m 45s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/744e341e8c164fa684738554ebf6ff0c : SUCCESS in 1h 00m 27s (non-voting)\n- devstack-plugin-ceph-tempest-py3 https://zuul.opendev.org/t/openstack/build/11fb8283be444f83a20e9b6987e6485f : SUCCESS in 1h 06m 12s (non-voting)\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/3eb9c3bb3ad64824991e59aa96f4214a : SUCCESS in 1h 14m 56s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/5bc023fcd2104581bd7f8ab5256b7c48 : SUCCESS in 48m 14s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/af4c92d2e23848e2aabcf23c05a78ab1 : SUCCESS in 1h 22m 51s\n- nova-next https://zuul.opendev.org/t/openstack/build/79f9ba2b19f44ccfb5c5bc60a6d449e3 : SUCCESS in 1h 35m 12s\n- nova-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/8e42ad561aa54f2498b91945f0cdce98 : SUCCESS in 16m 20s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/7464a26fc3634a4b8acc61fa110d88dd : SUCCESS in 1h 25m 58s","accounts_in_message":[],"_revision_number":1},{"id":"8174ecde640f29ebe354523acb7dc3a2464e492d","author":{"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},"date":"2020-02-04 23:17:34.000000000","message":"Patch Set 1:\n\nBuild failed.  For information on how to proceed, see https://docs.openstack.org/infra/manual/developers.html\n\n- EMC_VxFlexOS_NOVA http://publiclogs.emc.com/50/705850/1/check/EMC_VxFlexOS_NOVA/30f6cbe/EMC_VxFlexOS_NOVA/None : NOT_REGISTERED\n\nLeave a comment with \u0027run-DellEMC VxFlexOS CI\u0027 to trigger a recheck. For more information about CI, please see https://wiki.openstack.org/wiki/ThirdPartySystems/DellEMC_VxFlexOS_CI","accounts_in_message":[],"_revision_number":1},{"id":"a20bd03ce0354e69a48bddf9e9f9b9e45bd86dc2","author":{"_account_id":11816,"name":"mike bayer","display_name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","username":"zzzeek","status":"Red Hat"},"date":"2020-02-04 23:28:32.000000000","message":"Patch Set 1: Code-Review-1\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"ba823239d22e5daee8d03911124e0a07bf5f0d0d","author":{"_account_id":11816,"name":"mike bayer","display_name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","username":"zzzeek","status":"Red Hat"},"date":"2020-02-04 23:30:37.000000000","message":"Uploaded patch set 2.","accounts_in_message":[],"_revision_number":2},{"id":"bc6acba05bd57449e510fb1225ad397c33e8fee2","author":{"_account_id":29963,"name":"Intel_Zuul","display_name":"Intel Corporation CI","email":"intel-openstack-ci@intel.com","username":"Intel_Zuul"},"date":"2020-02-04 23:33:05.000000000","message":"Patch Set 2:\n\nBuild failed.\n\n- pmem-tempest-plugin-filtered finger://d0fe4b8af32b/36d4e274131f46de82b57ba4f6201ef5 : RETRY_LIMIT in 7s","accounts_in_message":[],"_revision_number":2},{"id":"fc83522a49f41c432b081d5d942dfdf034e7fee6","author":{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},"date":"2020-02-05 00:15:40.000000000","message":"Patch Set 1:\n\n* nova-quobyteci-dsvm-volume http://78.46.57.153:8081/refs-changes-50-705850-1 : SUCCESS \n\nhttps://wiki.openstack.org/wiki/ThirdPartySystems/Quobyte_CI","accounts_in_message":[],"_revision_number":1},{"id":"830a7d012ea027356232b9a3c296ee04e1725b26","author":{"_account_id":23498,"name":"IBM zVM CI","email":"zvmosci@us.ibm.com","username":"zvmosci"},"date":"2020-02-05 00:24:50.000000000","message":"Patch Set 2:\n\nTesting completed on the zVM Driver CI system check-nova pipeline and failed.  To recheck only the zVM driver plugins, submit a comment with only  zvm: recheck in the comment.. Contact information: zvmosci@us.ibm.com. For information see https://wiki.openstack.org/wiki/ZVMDriver.\n\n- check-nova-master http://extbasicopstackcilog01.podc.sl.edst.ibm.com/test_logs/jenkins-check-nova-master-40742 : FAILURE in 53m 30s","accounts_in_message":[],"_revision_number":2},{"id":"0395c5dc47bd66690e22749fbd5f70a09d23f1f1","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-02-05 01:07:46.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\n\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/6529bf26205c44eb8dd3222134b13840 : SUCCESS in 1h 03m 40s\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/d45a791cb3084b359955ae4a2abb80ed : SUCCESS in 1h 27m 30s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/86e9b7bdfe384f1a91ef46b3eadf6f9e : SUCCESS in 16m 59s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/6c0d1098abf34e2ab520cecd0caad06b : SUCCESS in 14m 28s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/c7b7ba18d4bc49daaba95481ec9ec92d : SUCCESS in 7m 07s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/5cb6442589234551b7ebeec88fca4f80 : SUCCESS in 11m 47s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/ecf6a54a68fb4f26aa8107faebff6c4f : SUCCESS in 16m 55s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/a656cd5eaea54d3397ef21adbc3970b7 : SUCCESS in 12m 47s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/c1dc9c338ca143dd9844065414faa360 : SUCCESS in 10m 02s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/f054a9ec74d24ff88e5b1859380f2d60 : SUCCESS in 52m 28s (non-voting)\n- devstack-plugin-ceph-tempest-py3 https://zuul.opendev.org/t/openstack/build/6f18e4415d874fb0b26652beb9f0a8f6 : SUCCESS in 1h 04m 14s (non-voting)\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/69e173487dfd4b4884b8c36c163a867a : SUCCESS in 1h 21m 27s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/ff0b4a0458734a8a88c50163427e5e31 : SUCCESS in 54m 47s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/ab6003a1c9a84caabf8ffcbe9b9a1e69 : SUCCESS in 1h 29m 10s\n- nova-next https://zuul.opendev.org/t/openstack/build/88e604515693471baff312d61d5b7b6a : SUCCESS in 1h 27m 47s\n- nova-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/fbc6b9b749654621b07a5c7562251944 : SUCCESS in 20m 08s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/a51acb45a70443feb44d538c70c454e4 : SUCCESS in 1h 06m 58s","accounts_in_message":[],"_revision_number":2},{"id":"8ab68983241c871a31bfccb1772664ee4a05d797","author":{"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},"date":"2020-02-05 01:08:24.000000000","message":"Patch Set 2:\n\nBuild failed.  For information on how to proceed, see https://docs.openstack.org/infra/manual/developers.html\n\n- EMC_VxFlexOS_NOVA http://publiclogs.emc.com/50/705850/2/check/EMC_VxFlexOS_NOVA/8c7cfd3/EMC_VxFlexOS_NOVA/None : NOT_REGISTERED\n\nLeave a comment with \u0027run-DellEMC VxFlexOS CI\u0027 to trigger a recheck. For more information about CI, please see https://wiki.openstack.org/wiki/ThirdPartySystems/DellEMC_VxFlexOS_CI","accounts_in_message":[],"_revision_number":2},{"id":"2d7e3d77b4b48a6487f956de12c37b36b41e84c0","author":{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},"date":"2020-02-05 02:21:01.000000000","message":"Patch Set 2:\n\n* nova-quobyteci-dsvm-volume http://78.46.57.153:8081/refs-changes-50-705850-2 : FAILURE \n\nSee https://wiki.openstack.org/wiki/ThirdPartySystems/Quobyte_CI for rechecking and info.","accounts_in_message":[],"_revision_number":2},{"id":"8c06c64c6b4ec6a01d62794f17f865047e9a8f90","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"date":"2020-02-05 02:23:52.000000000","message":"Patch Set 2:\n\nBuild Successful \n\n* SRIOV-nova-direct http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-direct : SUCCESS\n\n* SRIOV-nova-macvtap http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-macvtap : SUCCESS","accounts_in_message":[],"_revision_number":2},{"id":"d07f63e41ed638f38b2f4d65e061bfca76a5a774","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2020-02-05 02:53:42.000000000","message":"Patch Set 2:\n\nBuild succeeded. Test completed on IBM PowerKVM platform. For rechecking only on the IBM PowerKVM CI, add a review comment with pkvm- recheck. For contact and more information, see https://wiki.openstack.org/wiki/PowerKVM\n\n- tempest-dsvm-full-bionic https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/50/705850/2/check/tempest-dsvm-full-bionic/95f6ffa/ : SUCCESS in 2h 11m 06s\n- tempest-dsvm-full-bionic-py3 https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/50/705850/2/check/tempest-dsvm-full-bionic-py3/ab1da35/ : SUCCESS in 1h 56m 12s (non-voting)\n- grenade-dsvm-bionic https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/50/705850/2/check/grenade-dsvm-bionic/03065c8/ : TIMED_OUT in 32m 33s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"2f8e3c4104bcc6dda506736481c9afed08e93257","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"date":"2020-02-05 04:04:44.000000000","message":"Patch Set 2:\n\nBuild Failed \n\n* SRIOV-nova-direct http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-direct : FAILURE\n\n* SRIOV-nova-macvtap http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-macvtap : SUCCESS","accounts_in_message":[],"_revision_number":2},{"id":"46ab143539f3f8b6537cab28d3443d42232f3490","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2020-02-06 23:42:17.000000000","message":"Patch Set 2:\n\n(2 comments)","accounts_in_message":[],"_revision_number":2},{"id":"6d9e7d3c440cf98fb4b86d0f09ff81452fc2349f","author":{"_account_id":11816,"name":"mike bayer","display_name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","username":"zzzeek","status":"Red Hat"},"date":"2020-02-06 23:54:36.000000000","message":"Patch Set 2:\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"fa7b835097ac7916f722290720abf4d98c9673a7","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2020-02-07 00:27:53.000000000","message":"Patch Set 2: Code-Review+2\n\nThis looks fine to me, noting that DISTINCT in this code isn\u0027t actually doing anything we want in the non-postgres case anyway, as far as we can tell. So I\u0027ll propose a follow up to remove it altogether.","accounts_in_message":[],"_revision_number":2},{"id":"c922fb76d4e993979eca31bdb14b3572bc77f83c","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2020-02-10 16:40:33.000000000","message":"Patch Set 2: Code-Review+2 Workflow+1\n\nLooks like there\u0027s a follow-up here but this is good as-is","accounts_in_message":[],"_revision_number":2},{"id":"e29caf194e8e786aac83bbf01578cbd85104ea55","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-02-10 16:41:00.000000000","message":"Patch Set 2: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":2},{"id":"74aa7ea9a841e34656b5caa8c366a77885b223a5","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-02-10 22:42:10.000000000","message":"Patch Set 2: Verified-2\n\nBuild failed (gate pipeline).  For information on how to proceed, see\nhttp://docs.openstack.org/infra/manual/developers.html#automated-testing\n\n\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/68f5c25bfc9544d983e2c75771d47dd7 : SUCCESS in 1h 00m 58s\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/57959dd57c6b4e72bfb08db6d333aea1 : SUCCESS in 1h 19m 39s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/7549c8beb9534f259ff6d9ed0af04bca : SUCCESS in 14m 32s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/0fbaffa75b0a477b828181f373eee458 : SUCCESS in 9m 08s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/2fdf9eb6476942dab7355f9c179fa09a : SUCCESS in 18m 36s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/d250c38c44804710aede7b6f1f204edf : SUCCESS in 14m 43s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/4ee71cc78aa440148706d4c139764ac5 : SUCCESS in 12m 01s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/ec7ba98700a7409b9ef6b5d0e5a11f9b : SUCCESS in 1h 24m 16s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/72fa27dfdb4d47bd907f0ed0405b337a : SUCCESS in 1h 01m 54s\n- nova-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/1d6f1b0bc7c642d9ad30caf44eaceecb : SUCCESS in 21m 55s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/1249d97164244753bb804a7a97587a68 : FAILURE in 1h 30m 00s\n- nova-next https://zuul.opendev.org/t/openstack/build/a42831b1532742e9990919171001e872 : SUCCESS in 1h 41m 50s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/82bd0c12f0c8406cbc7cd19f72d58043 : SUCCESS in 1h 14m 45s","accounts_in_message":[],"_revision_number":2},{"id":"89ace98b3dbed5432a41f73ea236d1418385a000","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2020-03-25 01:39:24.000000000","message":"Patch Set 2:\n\nrecheck","accounts_in_message":[],"_revision_number":2},{"id":"af883cc0b6ed9c80746fca337dffcbe80ecda4fb","author":{"_account_id":29963,"name":"Intel_Zuul","display_name":"Intel Corporation CI","email":"intel-openstack-ci@intel.com","username":"Intel_Zuul"},"date":"2020-03-25 01:39:54.000000000","message":"Patch Set 2:\n\nMerge Failed.\n\nThis change or one of its cross-repo dependencies was unable to be automatically merged with the current state of its repository. Please rebase the change and upload a new patchset.","accounts_in_message":[],"_revision_number":2},{"id":"fc1efaa706c58816cea4eacf56c14c9fbef32496","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2020-03-25 01:40:20.000000000","message":"Patch Set 2:\n\nUnable to freeze job graph: Decryption failed.","accounts_in_message":[],"_revision_number":2},{"id":"2bdd8e48f50dec025e6656b7f6c8cefade887282","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"date":"2020-03-25 02:43:42.000000000","message":"Patch Set 2:\n\nBuild Successful \n\n* SRIOV-nova-direct http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-direct : SUCCESS\n\n* SRIOV-nova-macvtap http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-macvtap : SUCCESS","accounts_in_message":[],"_revision_number":2},{"id":"e867a5b623280f3ba9c3747e067ff6c8517134ad","author":{"_account_id":23498,"name":"IBM zVM CI","email":"zvmosci@us.ibm.com","username":"zvmosci"},"date":"2020-03-25 02:43:48.000000000","message":"Patch Set 2:\n\nTesting completed on the zVM Driver CI system check-nova pipeline.  To recheck only the zVM driver plugins, submit a comment with only zvm: recheck in the comment. Contact information: zvmosci@us.ibm.com. For information see https://wiki.openstack.org/wiki/ZVMDriver.\n\n- check-nova-master http://extbasicopstackcilog01.podc.sl.edst.ibm.com/test_logs/jenkins-check-nova-master-42160 : SUCCESS in 1h 03m 54s","accounts_in_message":[],"_revision_number":2},{"id":"5bd75ebc798bc7017f93cf12799127a60f6d0abf","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-03-25 03:30:55.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\n\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/f2833e839e48477991eba35d60273c23 : SUCCESS in 58m 40s\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/3b07acd9acdb47818d2780d0529fbf6c : SUCCESS in 1h 31m 21s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/3b5bc19ca689447c98c33bff55598842 : SUCCESS in 22m 02s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/23663f82fd774c268dbdd3fe63b1520e : SUCCESS in 19m 18s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/789ff3d575c74d81b4c1d0b79c48a1fe : SUCCESS in 9m 06s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/ebb25e97b470413ea842e89feb86788d : SUCCESS in 16m 58s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/00935388af3a4d4bb1e0c87f295407ad : SUCCESS in 13m 24s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/0d8a3a159a1a4ee3a4756253ed24bfbf : SUCCESS in 11m 37s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/243486ee724c4fe08e513e4b602dd659 : SUCCESS in 13m 37s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/beaf31c4e7704e3681641045195c7f84 : SUCCESS in 53m 14s (non-voting)\n- devstack-plugin-ceph-tempest-py3 https://zuul.opendev.org/t/openstack/build/a90928ddf7d14864a485ef2c5e84e160 : SUCCESS in 1h 14m 50s (non-voting)\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/d0be8fe741e84e83bbcdd1cfac6cfdbb : SUCCESS in 1h 17m 40s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/95fe192db19a4216a6b3743c50d5a404 : SUCCESS in 49m 49s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/cd81c3e5caee452695891ca97ffff9a0 : SUCCESS in 1h 27m 26s\n- nova-next https://zuul.opendev.org/t/openstack/build/bc82bc11bd9c46ec92dddcd13340494d : SUCCESS in 1h 46m 10s\n- nova-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/6961ba3cb4884f5eb9770f14071351e8 : SUCCESS in 16m 01s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/da0a67b063534491803836428b1a22e7 : SUCCESS in 46m 18s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/c04b0d6bf14a4bf98c110289e4aeaa93 : SUCCESS in 53m 49s","accounts_in_message":[],"_revision_number":2},{"id":"88a956dccc0451a2c224f1b3cadcd7efc5dad2ea","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-03-25 03:31:24.000000000","message":"Patch Set 2: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":2},{"id":"13cb028cf29b75ddb1778bfd071ad3fc295c939f","author":{"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},"date":"2020-03-25 03:31:34.000000000","message":"Patch Set 2:\n\nBuild failed.  For information on how to proceed, see https://docs.openstack.org/infra/manual/developers.html\n\n- EMC_VxFlexOS_NOVA http://publiclogs.emc.com/50/705850/2/check/EMC_VxFlexOS_NOVA/f716f97/EMC_VxFlexOS_NOVA/None : NOT_REGISTERED\n\nLeave a comment with \u0027run-DellEMC VxFlexOS CI\u0027 to trigger a recheck. For more information about CI, please see https://wiki.openstack.org/wiki/ThirdPartySystems/DellEMC_VxFlexOS_CI","accounts_in_message":[],"_revision_number":2},{"id":"959451e728fd5a31d2647299b7d62b0e7c0f3df8","author":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"date":"2020-03-25 04:13:38.000000000","message":"Patch Set 2:\n\nBuild succeeded.\n\n- nova http://cloudbase-ci.com/nova/705850/2 : SUCCESS in 2h 33m 02s","accounts_in_message":[],"_revision_number":2},{"id":"d8f7ed90366b46315faedb4d6fd0af59f28f8a27","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"date":"2020-03-25 04:20:18.000000000","message":"Patch Set 2:\n\nBuild Successful \n\n* SRIOV-nova-direct http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-direct : SUCCESS\n\n* SRIOV-nova-macvtap http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-macvtap : SUCCESS","accounts_in_message":[],"_revision_number":2},{"id":"3e20d1013d7f8a90c09bb4784c434643041b2db1","author":{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},"date":"2020-03-25 04:32:30.000000000","message":"Patch Set 2:\n\n* nova-quobyteci-dsvm-volume http://78.46.57.153:8081/refs-changes-50-705850-2 : FAILURE \n\nSee https://wiki.openstack.org/wiki/ThirdPartySystems/Quobyte_CI for rechecking and info.","accounts_in_message":[],"_revision_number":2},{"id":"3927c191a362e76a1f7aa636d1f202418a5d7e92","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"date":"2020-03-25 06:14:27.000000000","message":"Patch Set 2:\n\nBuild Successful \n\n* SRIOV-nova-direct http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-direct : SUCCESS\n\n* SRIOV-nova-macvtap http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-macvtap : SUCCESS","accounts_in_message":[],"_revision_number":2},{"id":"8d3fcec128ab0eb150040ed7b345dea66cab806d","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-03-25 08:49:31.000000000","message":"Patch Set 2: 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\n\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/911d3bd98065488bb5af40cb09c041ed : SUCCESS in 1h 01m 34s\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/fcaa10ac93da42c890b8bdc4e0ea31a0 : POST_FAILURE in 1h 43m 39s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/d01eeb5889c04c0f8449ffc5985c6ebc : SUCCESS in 22m 13s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/347dbbc28f5540ffa8061283c1005b83 : SUCCESS in 10m 19s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/b88fdf05f0d24385a10b4a9a5dd13d22 : SUCCESS in 14m 24s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/b514821f45b54af7873ab8164dc2be47 : SUCCESS in 17m 33s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/ef72e71b09ce4ba684e196cb5b8037f9 : SUCCESS in 13m 51s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/16033a860a4641eb940d02e9d7972381 : SUCCESS in 1h 36m 24s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/72075297574b42afb419ec0912a9c373 : SUCCESS in 1h 03m 41s\n- nova-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/03338d2920c34b7cadab147069161002 : SUCCESS in 21m 44s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/60a4cd2d0d534714be3cefa569083031 : SUCCESS in 1h 32m 31s\n- nova-next https://zuul.opendev.org/t/openstack/build/4689c5ed34a9486299207ae38b45303a : SUCCESS in 1h 44m 55s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/04038cd59e8e4b42a33f56a2d39c0c4e : SUCCESS in 1h 10m 30s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/287d9f685db4441092365233ac6c47a9 : SUCCESS in 1h 00m 30s","accounts_in_message":[],"_revision_number":2},{"id":"3dcdef88656424779501aa4e388c92fbac56c406","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2020-03-25 17:19:38.000000000","message":"Patch Set 2:\n\nBuild succeeded. Test completed on IBM PowerKVM platform. For rechecking only on the IBM PowerKVM CI, add a review comment with pkvm- recheck. For contact and more information, see https://wiki.openstack.org/wiki/PowerKVM\n\n- tempest-dsvm-full-bionic https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/50/705850/2/check/tempest-dsvm-full-bionic/26e6eaf/ : SUCCESS in 1h 33m 06s\n- tempest-dsvm-full-bionic-py3 https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/50/705850/2/check/tempest-dsvm-full-bionic-py3/31fa21a/ : SUCCESS in 2h 19m 17s\n- grenade-dsvm-bionic https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/50/705850/2/check/grenade-dsvm-bionic/9a6be07/ : SUCCESS in 3h 09m 14s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"05b87ff84af32ea431c6d5cee4024f0d52791d2e","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2020-03-25 18:08:11.000000000","message":"Patch Set 2:\n\nrecheck","accounts_in_message":[],"_revision_number":2},{"id":"fea91593574fa0480d4b85faebbcdee0a58f55a6","author":{"_account_id":29963,"name":"Intel_Zuul","display_name":"Intel Corporation CI","email":"intel-openstack-ci@intel.com","username":"Intel_Zuul"},"date":"2020-03-25 18:08:37.000000000","message":"Patch Set 2:\n\nMerge Failed.\n\nThis change or one of its cross-repo dependencies was unable to be automatically merged with the current state of its repository. Please rebase the change and upload a new patchset.","accounts_in_message":[],"_revision_number":2},{"id":"8270894fe29399b892bdcf3924f84acd21af14d7","author":{"_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},"date":"2020-03-25 18:21:15.000000000","message":"Patch Set 2:\n\nBuild failed\n\n- dsvm-nova http://207.189.188.190/logs/50/705850/2/check-vote/ext-nova-zuul/4eb04dc : FAILURE in 25m 55s","accounts_in_message":[],"_revision_number":2},{"id":"b32269027fee9440ad7d81fa23bb61a5b8733743","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"date":"2020-03-25 20:32:03.000000000","message":"Patch Set 2:\n\nBuild Successful \n\n* SRIOV-nova-direct http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-direct : SUCCESS\n\n* SRIOV-nova-macvtap http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-macvtap : SUCCESS","accounts_in_message":[],"_revision_number":2},{"id":"ba584f6d5f4a21619e0790632cdf4500b71af593","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-03-25 20:56:31.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\n\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/92035a4c94f64843a6d9a8cb234cbaf1 : SUCCESS in 1h 01m 33s\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/96b5af3cd0bf41e18de1d05e03e890ba : SUCCESS in 1h 15m 17s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/7cb76907749e4e3a98dda8c424af10c0 : SUCCESS in 17m 02s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/471155fff745476ba7b9a549446d84a1 : SUCCESS in 14m 49s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/9cef7e8f26d44035a9940e84c4fc4dc2 : SUCCESS in 9m 23s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/83ffde4a93b842e6b09b0356af1f1284 : SUCCESS in 18m 26s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/b5af65746e984bb69737b97bce19dda3 : SUCCESS in 17m 22s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/ce00395cc26e4f4b8e0014e3533f7b88 : SUCCESS in 14m 39s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/0e64ffc4ea0b4066809f0a61be5fb048 : SUCCESS in 12m 59s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/88cd5108bf244ceeb478f9932d81cea5 : SUCCESS in 53m 46s (non-voting)\n- devstack-plugin-ceph-tempest-py3 https://zuul.opendev.org/t/openstack/build/5e2a3e8e2aae43958d4714651df99585 : SUCCESS in 1h 05m 18s (non-voting)\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/0d522105578a45fb917b9675cade8e8d : SUCCESS in 1h 25m 25s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/30acfdc60c28471e821cdaca1c6095c7 : SUCCESS in 1h 01m 03s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/b6ec5c94ad324270a623bd0473bc0e14 : SUCCESS in 1h 24m 12s\n- nova-next https://zuul.opendev.org/t/openstack/build/00db1dead1944876a311c061eed1ba3c : SUCCESS in 1h 30m 31s\n- nova-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/265f44514cb84506990b4e9cba8fb9a8 : SUCCESS in 18m 28s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/b2e43984fecb43779e6504acc5f8c3a7 : SUCCESS in 1h 12m 31s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/5e1c32b9d083480f8f1016ec440f6160 : SUCCESS in 52m 09s","accounts_in_message":[],"_revision_number":2},{"id":"f5c18512ba3f45cbff5bea97e957e59f4839372b","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-03-25 20:57:04.000000000","message":"Patch Set 2: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":2},{"id":"c2b9f586300663cd8f1dbba12e0922bda6e208ec","author":{"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},"date":"2020-03-25 20:57:11.000000000","message":"Patch Set 2:\n\nBuild failed.  For information on how to proceed, see https://docs.openstack.org/infra/manual/developers.html\n\n- EMC_VxFlexOS_NOVA http://publiclogs.emc.com/50/705850/2/check/EMC_VxFlexOS_NOVA/27b8e00/EMC_VxFlexOS_NOVA/None : NOT_REGISTERED\n\nLeave a comment with \u0027run-DellEMC VxFlexOS CI\u0027 to trigger a recheck. For more information about CI, please see https://wiki.openstack.org/wiki/ThirdPartySystems/DellEMC_VxFlexOS_CI","accounts_in_message":[],"_revision_number":2},{"id":"d4d753f1534de0295dd35f2898784732593c951d","author":{"_account_id":23498,"name":"IBM zVM CI","email":"zvmosci@us.ibm.com","username":"zvmosci"},"date":"2020-03-25 22:35:22.000000000","message":"Patch Set 2:\n\nTesting completed on the zVM Driver CI system check-nova pipeline.  To recheck only the zVM driver plugins, submit a comment with only zvm: recheck in the comment. Contact information: zvmosci@us.ibm.com. For information see https://wiki.openstack.org/wiki/ZVMDriver.\n\n- check-nova-master http://extbasicopstackcilog01.podc.sl.edst.ibm.com/test_logs/jenkins-check-nova-master-42244 : SUCCESS in 1h 18m 02s","accounts_in_message":[],"_revision_number":2},{"id":"d7256f41ad19b985d50564f873844cc420caaf7f","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-03-25 23:18:56.000000000","message":"Patch Set 2: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/fe4980a3e8fa460a899a7f6da14f5144 : SUCCESS in 57m 10s\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/dc2a6907d54445e888973ffeda96df6b : SUCCESS in 1h 15m 12s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/b7990d85625048dea81c3dcfff940e09 : SUCCESS in 15m 35s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/806dc99299c84b5f8eafcbb4afdd519e : SUCCESS in 9m 01s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/5926bcb0e4bb43e18a310e738a886f7a : SUCCESS in 13m 27s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/99be331b9b3544f69de8782232273857 : SUCCESS in 14m 29s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/a162cd2853ca411dbb195ea89b7825b4 : SUCCESS in 11m 12s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/5e34cbc688084652a423d9dd1dfd1437 : SUCCESS in 1h 24m 14s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/246a4baa2499442480e63f1b5a4357ed : SUCCESS in 55m 28s\n- nova-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/e1f4853a5fa04cabaa822b5d3444a628 : SUCCESS in 17m 06s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/ea1d59890ab44c13b202c64d6bf9e76d : SUCCESS in 1h 23m 48s\n- nova-next https://zuul.opendev.org/t/openstack/build/31e18d3d75604a9f8a7340f324218ae0 : SUCCESS in 1h 33m 26s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/670ff6e85dc24cb4a2f60ef5eca9a09b : SUCCESS in 1h 05m 03s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/2ecac39967094a71ba2500bb27fd3008 : SUCCESS in 1h 02m 37s","accounts_in_message":[],"_revision_number":2},{"id":"9a498b35ab4592f3f92914717fe8b8ed79347146","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-03-25 23:18:58.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":2},{"id":"18ed8e5ab8e58a759745645076d61738416b94c5","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-03-25 23:22:59.000000000","message":"Patch Set 2:\n\nBuild succeeded (promote pipeline).\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/17768bf09a8a4adcaadef39deff48bdc : SUCCESS in 1m 07s","accounts_in_message":[],"_revision_number":2},{"id":"2e895613a8e31ba1e257ec7313c806cf78b774e5","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"date":"2020-03-25 23:41:49.000000000","message":"Patch Set 2:\n\nBuild Successful \n\n* SRIOV-nova-direct http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-direct : SUCCESS\n\n* SRIOV-nova-macvtap http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-macvtap : SUCCESS","accounts_in_message":[],"_revision_number":2},{"id":"6edbbcf2cae6a6d424520819608000ba2f00d2ca","author":{"_account_id":14384,"name":"Quobyte CI","email":"openstack-ci-external@quobyte.com","username":"quobyteci","tags":["SERVICE_USER"]},"date":"2020-03-26 02:48:17.000000000","message":"Patch Set 2:\n\n* nova-quobyteci-dsvm-volume http://78.46.57.153:8081/refs-changes-50-705850-2 : FAILURE \n\nSee https://wiki.openstack.org/wiki/ThirdPartySystems/Quobyte_CI for rechecking and info.","accounts_in_message":[],"_revision_number":2},{"id":"ea0a6b0a0ba3d1385d35d7d8dd061975e5a09616","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"date":"2020-03-26 04:35:25.000000000","message":"Patch Set 2:\n\nBuild Successful \n\n* SRIOV-nova-direct http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-direct : SUCCESS\n\n* SRIOV-nova-macvtap http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-macvtap : SUCCESS","accounts_in_message":[],"_revision_number":2},{"id":"56aea695be1ec63608a86d09b4e2ec496e70eb90","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2020-03-26 09:23:21.000000000","message":"Patch Set 2:\n\nBuild succeeded. Test completed on IBM PowerKVM platform. For rechecking only on the IBM PowerKVM CI, add a review comment with pkvm- recheck. For contact and more information, see https://wiki.openstack.org/wiki/PowerKVM\n\n- tempest-dsvm-full-bionic https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/50/705850/2/check/tempest-dsvm-full-bionic/2ab27cf/ : SUCCESS in 1h 55m 35s\n- tempest-dsvm-full-bionic-py3 https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/50/705850/2/check/tempest-dsvm-full-bionic-py3/70b581f/ : SUCCESS in 1h 42m 11s\n- grenade-dsvm-bionic https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/50/705850/2/check/grenade-dsvm-bionic/1e17c30/ : SUCCESS in 3h 16m 00s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"f2beb872e1d5d8e9ceb18554d4e70e5b3947f4c6","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"date":"2020-03-26 11:17:20.000000000","message":"Patch Set 2:\n\nBuild Successful \n\n* SRIOV-nova-direct http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-direct : SUCCESS\n\n* SRIOV-nova-macvtap http://13.74.249.42/refs/changes/50/705850/2/SRIOV-nova-macvtap : SUCCESS","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"57b08f817a15b345ef09a85a753d548858cd79bb","revisions":{"8e41ffb6700fd1b889c2b10968de8426d7f03638":{"kind":"REWORK","_number":1,"created":"2020-02-04 21:38:06.000000000","uploader":{"_account_id":11816,"name":"mike bayer","display_name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","username":"zzzeek","status":"Red Hat"},"ref":"refs/changes/50/705850/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/50/705850/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/50/705850/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/50/705850/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/50/705850/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/50/705850/1"}}},"commit":{"parents":[{"commit":"b42c54752f4c7d66bde313bdc1e8053d76b5588a","subject":"Merge \"Avoid fetching metadata when no subnets found\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/b42c54752f4c7d66bde313bdc1e8053d76b5588a"}]}],"author":{"name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","date":"2020-02-04 21:31:56.000000000","tz":-300},"committer":{"name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","date":"2020-02-04 21:37:31.000000000","tz":-300},"subject":"remove DISTINCT ON SQL instruction that does nothing on MySQL","message":"remove DISTINCT ON SQL instruction that does nothing on MySQL\n\nThe SQLAlchemy ORM call ``.distinct(\u0027host\u0027)`` indicates that\nan expression such as \"DISTINCT ON host\" should be rendered.\nHowever, this syntax is only available on PostgreSQL.   When run\non any other backend, the expression delivers SQL \"DISTINCT\"\nand the additional expressions are ignored.\n\nAn upcoming version of SQLAlchemy will begin to warn when\n\"DISTINCT ON\" is called for on a backend that does not support it,\nas the semantics of \"DISTINCT ON \u003ccol\u003e\" are quite different from\n\"DISTINCT\".   As Openstack targets MySQL primarily with SQLite\nused for unit tests, it should already be guaranteed that\nthis query only needs to be rendering \"DISTINCT\" in order to pass\ncurrent tests and use cases, since that\u0027s all that\u0027s being rendered.\n\nChange-Id: I267c6f772d514b442c8c3356c2babc1fe98a8b97\nReferences: https://github.com/sqlalchemy/sqlalchemy/issues/4002\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/8e41ffb6700fd1b889c2b10968de8426d7f03638"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/8e41ffb6700fd1b889c2b10968de8426d7f03638"}]},"branch":"refs/heads/master"},"57b08f817a15b345ef09a85a753d548858cd79bb":{"kind":"REWORK","_number":2,"created":"2020-02-04 23:30:37.000000000","uploader":{"_account_id":11816,"name":"mike bayer","display_name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","username":"zzzeek","status":"Red Hat"},"ref":"refs/changes/50/705850/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/50/705850/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/50/705850/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/50/705850/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/50/705850/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/50/705850/2"}}},"commit":{"parents":[{"commit":"b42c54752f4c7d66bde313bdc1e8053d76b5588a","subject":"Merge \"Avoid fetching metadata when no subnets found\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/b42c54752f4c7d66bde313bdc1e8053d76b5588a"}]}],"author":{"name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","date":"2020-02-04 23:30:06.000000000","tz":-300},"committer":{"name":"Mike Bayer","email":"mike_mp@zzzcomputing.com","date":"2020-02-04 23:30:06.000000000","tz":-300},"subject":"remove DISTINCT ON SQL instruction that does nothing on MySQL","message":"remove DISTINCT ON SQL instruction that does nothing on MySQL\n\nThe SQLAlchemy ORM call ``.distinct(\u0027host\u0027)`` indicates that\nan expression such as \"DISTINCT ON host\" should be rendered.\nHowever, this syntax is only available on PostgreSQL.   When run\non any other backend, the expression delivers SQL \"DISTINCT\"\nand the additional expressions are ignored.\n\nAn upcoming version of SQLAlchemy will begin to warn when\n\"DISTINCT ON\" is called for on a backend that does not support it,\nas the semantics of \"DISTINCT ON \u003ccol\u003e\" are quite different from\n\"DISTINCT\".   As Openstack targets MySQL primarily with SQLite\nused for unit tests, it should already be guaranteed that\nthis query only needs to be rendering \"DISTINCT\" in order to pass\ncurrent tests and use cases, since that\u0027s all that\u0027s being rendered.\n\nChange-Id: I267c6f772d514b442c8c3356c2babc1fe98a8b97\nReferences: https://github.com/sqlalchemy/sqlalchemy/issues/4002\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/57b08f817a15b345ef09a85a753d548858cd79bb"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/57b08f817a15b345ef09a85a753d548858cd79bb"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}