)]}'
{"id":"openstack%2Fnova~664271","triplet_id":"openstack%2Fnova~stable%2Fstein~I53d4b38d12404a1641f667c537404effa837a83d","project":"openstack/nova","branch":"stable/stein","topic":"bug/1830234","hashtags":[],"change_id":"I53d4b38d12404a1641f667c537404effa837a83d","subject":"Avoid unnecessary joins in InstanceGroup.get_hosts","status":"MERGED","created":"2019-06-10 15:15:23.000000000","updated":"2019-06-28 19:17:05.000000000","submitted":"2019-06-28 19:17:05.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"664271-1561749425859-a45a0009","meta_rev_id":"5accdeab92b83504a2550e23de62407b156662d1","_number":664271,"virtual_id_number":664271,"owner":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},{"value":0,"date":"2019-06-10 17:13:51.000000000","_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},{"value":0,"date":"2019-06-17 20:42:18.000000000","_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},{"value":0,"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},{"value":0,"date":"2019-06-17 17:57:04.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,"_account_id":10135,"name":"Lee Yarwood","display_name":"Lee Yarwood","email":"lyarwood@redhat.com","username":"lyarwood"},{"value":0,"date":"2019-06-17 16:36:16.000000000","_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},{"value":2,"date":"2019-06-28 19:17:05.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":10135,"name":"Lee Yarwood","display_name":"Lee Yarwood","email":"lyarwood@redhat.com","username":"lyarwood"},"recommended":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"all":[{"value":1,"date":"2019-06-19 07:50:50.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},{"value":0,"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},{"value":0,"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},{"value":1,"date":"2019-06-18 14:10:48.000000000","permitted_voting_range":{"min":1,"max":2},"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},{"value":0,"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"value":2,"date":"2019-06-28 16:22:08.000000000","_account_id":10135,"name":"Lee Yarwood","display_name":"Lee Yarwood","email":"lyarwood@redhat.com","username":"lyarwood"},{"value":0,"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},{"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":"","value":1,"default_value":0,"optional":true},"Workflow":{"approved":{"_account_id":10135,"name":"Lee Yarwood","display_name":"Lee Yarwood","email":"lyarwood@redhat.com","username":"lyarwood"},"all":[{"value":0,"_account_id":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},{"value":0,"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},{"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":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},{"value":0,"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"value":1,"date":"2019-06-28 16:22:08.000000000","_account_id":10135,"name":"Lee Yarwood","display_name":"Lee Yarwood","email":"lyarwood@redhat.com","username":"lyarwood"},{"value":0,"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},{"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":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},{"value":0,"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},{"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":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},{"value":0,"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"value":0,"_account_id":10135,"name":"Lee Yarwood","display_name":"Lee Yarwood","email":"lyarwood@redhat.com","username":"lyarwood"},{"value":0,"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{" 0":"Default Priority","+1":"Contributor Review Promise","+2":"Core Review Promise"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},{"_account_id":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"_account_id":10135,"name":"Lee Yarwood","display_name":"Lee Yarwood","email":"lyarwood@redhat.com","username":"lyarwood"},{"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2019-06-10 17:13:51.000000000","updated_by":{"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},"reviewer":{"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2019-06-17 17:57:04.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":"2019-06-17 20:42:18.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":"2019-06-18 14:10:48.000000000","updated_by":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"reviewer":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"state":"REVIEWER"},{"updated":"2019-06-19 07:50:50.000000000","updated_by":{"_account_id":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},"reviewer":{"_account_id":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},"state":"REVIEWER"},{"updated":"2019-06-28 16:22:08.000000000","updated_by":{"_account_id":10135,"name":"Lee Yarwood","display_name":"Lee Yarwood","email":"lyarwood@redhat.com","username":"lyarwood"},"reviewer":{"_account_id":10135,"name":"Lee Yarwood","display_name":"Lee Yarwood","email":"lyarwood@redhat.com","username":"lyarwood"},"state":"REVIEWER"},{"updated":"2019-06-28 19:17:05.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":"21acd1ea86510c57a4fe3737d1195c8d21034b4c","author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"date":"2019-06-10 15:15:23.000000000","message":"Patch Set 1: Cherry Picked from branch master.","accounts_in_message":[],"_revision_number":1},{"id":"2016a8c061ad4b6ccf67720ac8cadeba9b808a91","author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"date":"2019-06-10 15:15:30.000000000","message":"Topic changed from bug/1830234-stable/stein to bug/1830234","accounts_in_message":[],"_revision_number":1},{"id":"c308c660d9ed69c8daa2894b04d29c2972395390","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2019-06-10 16:43:18.000000000","message":"Patch Set 1:\n\nBuild failed. 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-xenial https://dal05.objectstorage.softlayer.net/v1/AUTH_3d8e6ecb-f597-448c-8ec2-164e9f710dd6/pkvmci/nova/71/664271/1/check/tempest-dsvm-full-xenial/f5eb3c4/ : FAILURE in 1h 27m 04s\n- tempest-dsvm-full-xenial-py3 https://dal05.objectstorage.softlayer.net/v1/AUTH_3d8e6ecb-f597-448c-8ec2-164e9f710dd6/pkvmci/nova/71/664271/1/check/tempest-dsvm-full-xenial-py3/b818233/ : SUCCESS in 1h 21m 19s (non-voting)\n- grenade-dsvm-xenial https://dal05.objectstorage.softlayer.net/v1/AUTH_3d8e6ecb-f597-448c-8ec2-164e9f710dd6/pkvmci/nova/71/664271/1/check/grenade-dsvm-xenial/75bdda1/ : FAILURE in 1h 06m 14s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"d0491804f5b53bdfb68bf31fba1e16b3810022aa","author":{"_account_id":14595,"name":"z Systems KVM","email":"zkvm-ci@linux.vnet.ibm.com","username":"ibm-zkvm-ci","tags":["SERVICE_USER"]},"date":"2019-06-10 17:13:51.000000000","message":"Patch Set 1:\n\nTesting succeeded on ubuntu-xenial-s390x. For rechecking only on the ubuntu-xenail-s390x CI, add a review comment with recheck-zkvm. Contact info: zkvm-ci@linux.vnet.ibm.com. For more information, see https://wiki.openstack.org/wiki/ThirdPartySystems/IBM_zKVM_CI\n\n- check-tempest-dsvm-neutron-full-ubuntu-xenial-s390x http://sng01.objectstorage.softlayer.net/v1/AUTH_1940ea10-6e82-4501-b2f9-eb236510e575/ibmzkvmci/production/664271/1/check-tempest-dsvm-neutron-full-ubuntu-xenial-s390x/ec3e174 : SUCCESS in 1h 47m 28s","accounts_in_message":[],"_revision_number":1},{"id":"9142c610522ff8aa61e5567b661b04c360baea5b","author":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"date":"2019-06-10 17:20:13.000000000","message":"Patch Set 1:\n\nBuild succeeded.\n\n- nova http://cloudbase-ci.com/nova/664271/1 : SUCCESS in 2h 03m 49s","accounts_in_message":[],"_revision_number":1},{"id":"eaf83ffbd1fbae3ba87b992a53f7595692f84373","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-06-10 21:51:17.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- grenade-py3 http://logs.openstack.org/71/664271/1/check/grenade-py3/2295887/ : SUCCESS in 59m 12s\n- tempest-full-py3 http://logs.openstack.org/71/664271/1/check/tempest-full-py3/9817409/ : SUCCESS in 1h 34m 56s\n- openstack-tox-cover http://logs.openstack.org/71/664271/1/check/openstack-tox-cover/54435c1/cover/ : SUCCESS in 15m 53s\n- openstack-tox-lower-constraints http://logs.openstack.org/71/664271/1/check/openstack-tox-lower-constraints/0b9dfaa/ : SUCCESS in 13m 13s\n- openstack-tox-pep8 http://logs.openstack.org/71/664271/1/check/openstack-tox-pep8/b5196ba/ : SUCCESS in 12m 43s\n- openstack-tox-py27 http://logs.openstack.org/71/664271/1/check/openstack-tox-py27/7541df3/ : SUCCESS in 11m 43s\n- openstack-tox-py35 http://logs.openstack.org/71/664271/1/check/openstack-tox-py35/32b6968/ : SUCCESS in 15m 19s\n- openstack-tox-py36 http://logs.openstack.org/71/664271/1/check/openstack-tox-py36/a70eb98/ : SUCCESS in 14m 54s\n- openstack-tox-py37 http://logs.openstack.org/71/664271/1/check/openstack-tox-py37/d399da5/ : SUCCESS in 14m 11s\n- openstack-tox-docs http://logs.openstack.org/71/664271/1/check/openstack-tox-docs/e7aaf6d/html/ : SUCCESS in 7m 57s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa http://logs.openstack.org/71/664271/1/check/ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa/15d538a/ : SUCCESS in 57m 35s (non-voting)\n- devstack-plugin-ceph-tempest http://logs.openstack.org/71/664271/1/check/devstack-plugin-ceph-tempest/e10f68e/ : SUCCESS in 1h 47m 40s (non-voting)\n- neutron-grenade-multinode http://logs.openstack.org/71/664271/1/check/neutron-grenade-multinode/5e52cf7/ : SUCCESS in 1h 14m 05s\n- nova-grenade-live-migration http://logs.openstack.org/71/664271/1/check/nova-grenade-live-migration/e7d74aa/ : FAILURE in 52m 03s\n- nova-live-migration http://logs.openstack.org/71/664271/1/check/nova-live-migration/fe867fb/ : SUCCESS in 47m 40s\n- nova-next http://logs.openstack.org/71/664271/1/check/nova-next/fe1259b/ : SUCCESS in 1h 18m 53s\n- nova-tox-functional http://logs.openstack.org/71/664271/1/check/nova-tox-functional/88d6945/ : SUCCESS in 17m 50s\n- nova-tox-functional-py35 http://logs.openstack.org/71/664271/1/check/nova-tox-functional-py35/330f620/ : SUCCESS in 17m 49s\n- tempest-multinode-full http://logs.openstack.org/71/664271/1/check/tempest-multinode-full/5f69966/ : SUCCESS in 2h 05m 20s (non-voting)\n- tempest-slow-py3 http://logs.openstack.org/71/664271/1/check/tempest-slow-py3/ca4f5bc/ : SUCCESS in 2h 34m 18s","accounts_in_message":[],"_revision_number":1},{"id":"66574dcdd2d7ee212a38b98472008b44cafa9107","author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"date":"2019-06-17 16:36:16.000000000","message":"Patch Set 1:\n\nrecheck grenade job ssh test failure","accounts_in_message":[],"_revision_number":1},{"id":"3d382eb66ae809f9de0a79beeb80646cb1b590b7","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2019-06-17 17:57:04.000000000","message":"Patch Set 1:\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-xenial https://dal05.objectstorage.softlayer.net/v1/AUTH_3d8e6ecb-f597-448c-8ec2-164e9f710dd6/pkvmci/nova/71/664271/1/check/tempest-dsvm-full-xenial/099f04e/ : SUCCESS in 1h 14m 34s\n- tempest-dsvm-full-xenial-py3 https://dal05.objectstorage.softlayer.net/v1/AUTH_3d8e6ecb-f597-448c-8ec2-164e9f710dd6/pkvmci/nova/71/664271/1/check/tempest-dsvm-full-xenial-py3/6fced6c/ : SUCCESS in 1h 19m 55s (non-voting)\n- grenade-dsvm-xenial https://dal05.objectstorage.softlayer.net/v1/AUTH_3d8e6ecb-f597-448c-8ec2-164e9f710dd6/pkvmci/nova/71/664271/1/check/grenade-dsvm-xenial/d692256/ : SUCCESS in 1h 05m 31s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"d442ace0ade05613ef06916a88773ae2fede9803","author":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"date":"2019-06-17 20:42:18.000000000","message":"Patch Set 1:\n\nBuild succeeded.\n\n- nova http://cloudbase-ci.com/nova/664271/1 : SUCCESS in 2h 14m 01s","accounts_in_message":[],"_revision_number":1},{"id":"31f33184bd35dfd4365daad429f043ba07e1fb90","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-06-17 21:58:21.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- grenade-py3 http://logs.openstack.org/71/664271/1/check/grenade-py3/30e1516/ : SUCCESS in 56m 20s\n- tempest-full-py3 http://logs.openstack.org/71/664271/1/check/tempest-full-py3/7d1b2a5/ : SUCCESS in 1h 39m 01s\n- openstack-tox-cover http://logs.openstack.org/71/664271/1/check/openstack-tox-cover/66e8fe3/cover/ : SUCCESS in 14m 46s\n- openstack-tox-lower-constraints http://logs.openstack.org/71/664271/1/check/openstack-tox-lower-constraints/0e39834/ : SUCCESS in 13m 32s\n- openstack-tox-pep8 http://logs.openstack.org/71/664271/1/check/openstack-tox-pep8/7477650/ : SUCCESS in 9m 30s\n- openstack-tox-py27 http://logs.openstack.org/71/664271/1/check/openstack-tox-py27/f57e02a/ : SUCCESS in 11m 49s\n- openstack-tox-py35 http://logs.openstack.org/71/664271/1/check/openstack-tox-py35/b1fd287/ : SUCCESS in 15m 27s\n- openstack-tox-py36 http://logs.openstack.org/71/664271/1/check/openstack-tox-py36/b25fb5b/ : SUCCESS in 12m 17s\n- openstack-tox-py37 http://logs.openstack.org/71/664271/1/check/openstack-tox-py37/2ada03c/ : SUCCESS in 13m 02s\n- openstack-tox-docs http://logs.openstack.org/71/664271/1/check/openstack-tox-docs/18b5c38/html/ : SUCCESS in 6m 14s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa http://logs.openstack.org/71/664271/1/check/ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa/3d52a95/ : SUCCESS in 1h 21m 32s (non-voting)\n- devstack-plugin-ceph-tempest http://logs.openstack.org/71/664271/1/check/devstack-plugin-ceph-tempest/83c17d5/ : SUCCESS in 1h 23m 15s (non-voting)\n- neutron-grenade-multinode http://logs.openstack.org/71/664271/1/check/neutron-grenade-multinode/d37d804/ : SUCCESS in 1h 15m 38s\n- nova-grenade-live-migration http://logs.openstack.org/71/664271/1/check/nova-grenade-live-migration/68d3e73/ : SUCCESS in 1h 04m 37s\n- nova-live-migration http://logs.openstack.org/71/664271/1/check/nova-live-migration/c200ea9/ : SUCCESS in 47m 43s\n- nova-next http://logs.openstack.org/71/664271/1/check/nova-next/1da6265/ : SUCCESS in 2h 00m 35s\n- nova-tox-functional http://logs.openstack.org/71/664271/1/check/nova-tox-functional/b140523/ : SUCCESS in 19m 11s\n- nova-tox-functional-py35 http://logs.openstack.org/71/664271/1/check/nova-tox-functional-py35/0e84552/ : SUCCESS in 20m 26s\n- tempest-multinode-full http://logs.openstack.org/71/664271/1/check/tempest-multinode-full/9789f70/ : SUCCESS in 2h 02m 07s (non-voting)\n- tempest-slow-py3 http://logs.openstack.org/71/664271/1/check/tempest-slow-py3/249246a/ : SUCCESS in 2h 17m 15s","accounts_in_message":[],"_revision_number":1},{"id":"f39facb3ac69a5181011c130abcadaaa555c1d3c","author":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"date":"2019-06-18 14:10:48.000000000","message":"Patch Set 1: Code-Review+1\n\nClean backport.","accounts_in_message":[],"_revision_number":1},{"id":"0930d3c4292e5a8d419c9b08cab8f062d515b93a","author":{"_account_id":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},"date":"2019-06-19 07:50:50.000000000","message":"Patch Set 1: Code-Review+1\n\nlgtm","accounts_in_message":[],"_revision_number":1},{"id":"b66539177d5cc9c4b5bd0670c62e388123c69198","author":{"_account_id":10135,"name":"Lee Yarwood","display_name":"Lee Yarwood","email":"lyarwood@redhat.com","username":"lyarwood"},"date":"2019-06-28 16:22:08.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1\n\nLGTM, clean, trivial but useful and merged in master. Approving as this was proposed by another Nova stable core.","accounts_in_message":[],"_revision_number":1},{"id":"2cc9d66f905e9deb6ce2ff3ec5247d260d951f1a","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-06-28 16:25:26.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"7dfa31c14f61d64af1b99e21599879d9181996a0","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-06-28 19:17:05.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- grenade-py3 http://logs.openstack.org/71/664271/1/gate/grenade-py3/349bc7e/ : SUCCESS in 1h 02m 32s\n- tempest-full-py3 http://logs.openstack.org/71/664271/1/gate/tempest-full-py3/2bc6624/ : SUCCESS in 1h 30m 12s\n- openstack-tox-lower-constraints http://logs.openstack.org/71/664271/1/gate/openstack-tox-lower-constraints/351b348/ : SUCCESS in 14m 03s\n- openstack-tox-pep8 http://logs.openstack.org/71/664271/1/gate/openstack-tox-pep8/8212a79/ : SUCCESS in 9m 41s\n- openstack-tox-py27 http://logs.openstack.org/71/664271/1/gate/openstack-tox-py27/521b816/ : SUCCESS in 19m 31s\n- openstack-tox-py35 http://logs.openstack.org/71/664271/1/gate/openstack-tox-py35/a6a99c2/ : SUCCESS in 14m 40s\n- openstack-tox-py36 http://logs.openstack.org/71/664271/1/gate/openstack-tox-py36/3074c66/ : SUCCESS in 11m 20s\n- openstack-tox-py37 http://logs.openstack.org/71/664271/1/gate/openstack-tox-py37/806ea5a/ : SUCCESS in 13m 16s\n- openstack-tox-docs http://logs.openstack.org/71/664271/1/gate/openstack-tox-docs/90f8d44/html/ : SUCCESS in 6m 35s\n- nova-grenade-live-migration http://logs.openstack.org/71/664271/1/gate/nova-grenade-live-migration/c595a2d/ : SUCCESS in 1h 03m 05s\n- nova-live-migration http://logs.openstack.org/71/664271/1/gate/nova-live-migration/e9240a2/ : SUCCESS in 52m 15s\n- nova-tox-functional http://logs.openstack.org/71/664271/1/gate/nova-tox-functional/82089da/ : SUCCESS in 19m 32s\n- nova-tox-functional-py35 http://logs.openstack.org/71/664271/1/gate/nova-tox-functional-py35/4d22da6/ : SUCCESS in 20m 00s\n- nova-next http://logs.openstack.org/71/664271/1/gate/nova-next/fb06454/ : SUCCESS in 1h 12m 10s\n- tempest-slow-py3 http://logs.openstack.org/71/664271/1/gate/tempest-slow-py3/1ea18f8/ : SUCCESS in 2h 33m 53s","accounts_in_message":[],"_revision_number":1},{"id":"5accdeab92b83504a2550e23de62407b156662d1","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-06-28 19:17:05.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"74e66fe8d4353be95868a68d21d882020cb40f4b","revisions":{"74e66fe8d4353be95868a68d21d882020cb40f4b":{"kind":"REWORK","_number":1,"created":"2019-06-10 15:15:23.000000000","uploader":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"ref":"refs/changes/71/664271/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/71/664271/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/71/664271/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/71/664271/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/71/664271/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/71/664271/1"}}},"commit":{"parents":[{"commit":"105e6238dd536ac869276c38b5c76fefeb729b40","subject":"Merge \"Workaround missing RequestSpec.instance_group.uuid\" into stable/stein","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/105e6238dd536ac869276c38b5c76fefeb729b40"}]}],"author":{"name":"Matt Riedemann","email":"mriedem.os@gmail.com","date":"2019-05-23 15:14:55.000000000","tz":-240},"committer":{"name":"Matt Riedemann","email":"mriedem.os@gmail.com","date":"2019-06-10 15:15:23.000000000","tz":0},"subject":"Avoid unnecessary joins in InstanceGroup.get_hosts","message":"Avoid unnecessary joins in InstanceGroup.get_hosts\n\nThe InstanceList.get_by_filters query is joining on\ninfo_cache, security_groups, metadata and system_metadata\nbecause of how instance_get_all_by_filters_sort in the DB API\nworks if columns_to_join (expected_attrs) is None. The get_hosts\nmethod only cares about the instance.host value of its members\nso those joins are unnecessarily expensive.\n\nThis change simply passes expected_attrs\u003d[] to get_by_filters\nto avoid the joins. A follow up change can further optimize this\ncode by adding a new query method to just get the host values\nfor a list of instance uuids, so a TODO is left in place for that.\nNote that a new query method would need to be remotable and thus\nnot something we can backport.\n\nChange-Id: I53d4b38d12404a1641f667c537404effa837a83d\nPartial-Bug: #1830234\n(cherry picked from commit 15ccf2ddfbf857186fc05f77a7881243c6311062)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/74e66fe8d4353be95868a68d21d882020cb40f4b"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/74e66fe8d4353be95868a68d21d882020cb40f4b"}]},"branch":"refs/heads/stable/stein"}},"requirements":[],"submit_records":[],"submit_requirements":[]}