)]}'
{"id":"openstack%2Fnova~761810","triplet_id":"openstack%2Fnova~stable%2Fussuri~I5c071f70f669966e9807b38e99077c1cae5b4606","project":"openstack/nova","branch":"stable/ussuri","topic":"bug/1799298","hashtags":[],"change_id":"I5c071f70f669966e9807b38e99077c1cae5b4606","subject":"Use subqueryload() instead of joinedload() for (system_)metadata","status":"MERGED","created":"2020-11-07 11:13:08.000000000","updated":"2021-02-03 19:52:25.000000000","submitted":"2021-02-03 19:50:46.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":1,"unresolved_comment_count":1,"has_review_started":true,"submission_id":"761810-bug/1799298","meta_rev_id":"f36e6425c3576b5473590835fa6dce9a8c074a5e","_number":761810,"virtual_id_number":761810,"owner":{"_account_id":9373,"name":"Vlad Gusev","email":"vlad.esten@gmail.com","username":"s10"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":29888,"name":"Sergey Slabnov","email":"sergey.slabnov@gmail.com","username":"nwton_ru"},{"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":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":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":"2021-02-03 19:50:43.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":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"all":[{"value":0,"_account_id":29888,"name":"Sergey Slabnov","email":"sergey.slabnov@gmail.com","username":"nwton_ru"},{"value":2,"date":"2021-02-03 01:46:32.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":2,"date":"2021-02-03 17:43:54.000000000","permitted_voting_range":{"min":2,"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":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"]}],"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":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"all":[{"value":0,"_account_id":29888,"name":"Sergey Slabnov","email":"sergey.slabnov@gmail.com","username":"nwton_ru"},{"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":1,"date":"2021-02-03 17:43:54.000000000","permitted_voting_range":{"min":1,"max":1},"_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":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"]}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"_account_id":29888,"name":"Sergey Slabnov","email":"sergey.slabnov@gmail.com","username":"nwton_ru"},{"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":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":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"]}],"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":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","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"},{"_account_id":29888,"name":"Sergey Slabnov","email":"sergey.slabnov@gmail.com","username":"nwton_ru"},{"_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-11-07 11:13:08.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-11-07 12:08:48.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-11-07 12:27:57.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-11-07 13:00:47.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":"2020-11-07 14:18:47.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-12-24 15:19:51.000000000","updated_by":{"_account_id":29888,"name":"Sergey Slabnov","email":"sergey.slabnov@gmail.com","username":"nwton_ru"},"reviewer":{"_account_id":29888,"name":"Sergey Slabnov","email":"sergey.slabnov@gmail.com","username":"nwton_ru"},"state":"REVIEWER"},{"updated":"2021-02-03 17:43:54.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"}],"messages":[{"id":"429e0e6549238e13b174368e470dd944b3b144f0","author":{"_account_id":9373,"name":"Vlad Gusev","email":"vlad.esten@gmail.com","username":"s10"},"date":"2020-11-07 11:13:08.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"9f871e781c5cbd0b8620a3d885ab878b9c8b22b2","author":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"date":"2020-11-07 12:08:48.000000000","message":"Patch Set 1:\n\nFor rechecking only on the Cloudbase Nova Hyper-V CI, add a review comment with run-Cloudbase Nova Hyper-V CI\n\n- nova http://cloudbase-ci.com/nova/761810/1 : FAILURE in 54m 44s","accounts_in_message":[],"_revision_number":1},{"id":"717ab3ecf0167634de2065adb6ce97dc44c33f85","author":{"_account_id":29963,"name":"Intel_Zuul","display_name":"Intel Corporation CI","email":"intel-openstack-ci@intel.com","username":"Intel_Zuul"},"date":"2020-11-07 12:27:57.000000000","message":"Patch Set 1:\n\nBuild failed.\n\n- pmem-tempest-plugin-filtered-multi-node http://52.27.155.124/10/761810/1/check/pmem-tempest-plugin-filtered-multi-node/4831c19/ : SUCCESS in 44m 04s\n- devstack-nfv-numa devstack-nfv-numa : NODE_FAILURE in 0s","accounts_in_message":[],"_revision_number":1},{"id":"7adb70c1033bb06751e8d92e4dfdc119cb2166e7","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-11-07 13:00:47.000000000","message":"Patch Set 1: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- grenade https://zuul.opendev.org/t/openstack/build/f2046f3db762437b8d25f440443d48a5 : SUCCESS in 1h 12m 05s\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/e67e2bd284b64cb2b65aab547d483cab : SUCCESS in 1h 03m 23s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/a8714c9007f44a96be0cc6cde1f6ee03 : SUCCESS in 15m 05s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/33eab2aad0d946dd9126bf9cafb66e9c : SUCCESS in 12m 54s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/133af8b4f0414cfbb49d64a610cb22d1 : FAILURE in 7m 06s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/7ffa7ac8b04f403a9596b2c54cfa8beb : SUCCESS in 11m 04s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/db1691d3121a474884bdc9846696e199 : SUCCESS in 13m 10s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/2f022c363dd5431d9d9fb927e74955fc : SUCCESS in 10m 45s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/8bed22a505c74d7eaccd2123e7b51c59 : SUCCESS in 1h 06m 22s (non-voting)\n- devstack-plugin-ceph-tempest-py3 https://zuul.opendev.org/t/openstack/build/4b93a2edcfcc442c9b8fb8df09f5d648 : SUCCESS in 1h 04m 02s (non-voting)\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/842e54c7bd6b409490f964aa3a65566d : SUCCESS in 1h 30m 21s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/27d8d00640964fb18185b94a96b5c9c1 : SUCCESS in 45m 07s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/e51246750b2246a6baf657d28256ebc7 : SUCCESS in 1h 21m 06s\n- nova-next https://zuul.opendev.org/t/openstack/build/c1dce87ad40848b78bced4989975bfa2 : FAILURE in 1h 20m 48s\n- nova-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/026f287519c54d1f865eab68c583d09c : SUCCESS in 17m 36s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/7f191ed8e8a349278b5563d5fddbab16 : SUCCESS in 53m 48s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/bbb43074e44347c19c2f853b726d128a : SUCCESS in 55m 39s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/417fb31505504638b02f206f63dd35d3 : FAILURE in 33m 02s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"b1398dfc344bf4316a223b16872817e045679a89","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2020-11-07 14:18:47.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-bionic https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/10/761810/1/check/tempest-dsvm-full-bionic/ffbde3f/ : SUCCESS in 1h 35m 41s\n- tempest-dsvm-full-bionic-py3 https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/10/761810/1/check/tempest-dsvm-full-bionic-py3/0416070/ : SUCCESS in 1h 30m 38s\n- grenade-py3 https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/10/761810/1/check/grenade-py3/4cfe9cb/ : POST_FAILURE in 1h 08m 02s","accounts_in_message":[],"_revision_number":1},{"id":"7ab6036f0bac22458dd61f6762909879a12b0a8d","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2020-11-09 23:05:13.000000000","message":"Topic changed from bug/1799298-stable/ussuri to bug/1799298","accounts_in_message":[],"_revision_number":1},{"id":"8ec917b87413e30e22d5201392c8b484d6792ffe","author":{"_account_id":29888,"name":"Sergey Slabnov","email":"sergey.slabnov@gmail.com","username":"nwton_ru"},"date":"2020-12-24 15:19:51.000000000","message":"Patch Set 1: Code-Review+1\n\nThis is a clear cherry-pick commit from the main branch that fix the bug.","accounts_in_message":[],"_revision_number":1},{"id":"a8b7e929b9176e92ac78131eafee995bf73aeb79","author":{"_account_id":29888,"name":"Sergey Slabnov","email":"sergey.slabnov@gmail.com","username":"nwton_ru"},"date":"2020-12-28 21:21:51.000000000","message":"Patch Set 1:\n\nrecheck","accounts_in_message":[],"_revision_number":1},{"id":"772358982f7d8bcb2a70f5cc9f6104ff131f5f1d","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-12-28 22:44:50.000000000","message":"Patch Set 1:\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- grenade https://zuul.opendev.org/t/openstack/build/6ccce78ad4144e3fa784ebe3a470685b : SUCCESS in 1h 02m 29s\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/fa515c62f4cd41649db476cc478b882b : SUCCESS in 1h 07m 24s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/8a8b0c4b7b444a83923ec829ee57b0b5 : SUCCESS in 17m 17s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/244d0c4c1d724072b3f3076a08d23365 : SUCCESS in 14m 59s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/0609214d2f0d4513b16c46831e04dec0 : FAILURE in 6m 52s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/98d4b9a8978c44108d0f96ed94a015ec : SUCCESS in 15m 16s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/edb81134bef54b6192171fb1c5cd5950 : SUCCESS in 13m 28s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/2571e9ca11844a8d9b53464e5c57f118 : SUCCESS in 9m 46s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/9f26c696ba2a4d2d87a3955e81323da5 : SUCCESS in 49m 16s (non-voting)\n- devstack-plugin-ceph-tempest-py3 https://zuul.opendev.org/t/openstack/build/e6b501c486254fcf92caf810b7c7209b : SUCCESS in 56m 23s (non-voting)\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/73583fa5a0be4e40a7df59b9da73a16e : SUCCESS in 1h 15m 35s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/0e0706975787477dbdba1f667f39b540 : SUCCESS in 41m 30s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/f8649a1dc542481d9741760e91cd2f5f : SUCCESS in 1h 14m 54s\n- nova-next https://zuul.opendev.org/t/openstack/build/abf5e51f679047d486eb240395d1d554 : FAILURE in 1h 20m 36s\n- nova-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/9ce85fa788014c7a95e00b53fc231b5c : SUCCESS in 19m 43s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/a317ad3c8cff40c8968acce01ea0e0a8 : SUCCESS in 47m 35s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/96aa90b5717345a1af419b337d52b033 : SUCCESS in 47m 50s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/5d4b74f5358c4feb9d0a82ced3e9a58c : FAILURE in 21m 49s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"c772394747e25a42fae5235cb88c2672eba2d77c","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2020-12-28 23:23:06.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-bionic https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/10/761810/1/check/tempest-dsvm-full-bionic/21e124e/ : SUCCESS in 1h 55m 46s\n- tempest-dsvm-full-bionic-py3 https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/10/761810/1/check/tempest-dsvm-full-bionic-py3/51b981c/ : SUCCESS in 1h 39m 07s","accounts_in_message":[],"_revision_number":1},{"id":"0dde4dabbcb3f0d7dd4f24ebc94f1d604644f54d","author":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"date":"2020-12-28 23:54:11.000000000","message":"Patch Set 1:\n\nBuild succeeded.\n\n- nova http://cloudbase-ci.com/nova/761810/1 : SUCCESS in 2h 31m 24s","accounts_in_message":[],"_revision_number":1},{"id":"d1f1c49a14faeee0fd3fdc8023664c26c66dd135","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2021-01-27 19:37:37.000000000","message":"Uploaded patch set 2: Commit message was updated.","accounts_in_message":[],"_revision_number":2},{"id":"6880b706d3965518da3f60f27a98062183ea7fee","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2021-01-27 19:38:44.000000000","message":"Patch Set 2:\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"61da138f3c437c928e136d5c7074928b942af01f","author":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"date":"2021-01-27 22:04:34.000000000","message":"Patch Set 2:\n\nFor rechecking only on the Cloudbase Nova Hyper-V CI, add a review comment with run-Cloudbase Nova Hyper-V CI\n\n- nova http://cloudbase-ci.com/nova/761810/2 : FAILURE in 9m 26s","accounts_in_message":[],"_revision_number":2},{"id":"bbeeec5efe0b99378e7126f5f15f665a8504dee5","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2021-01-27 23:35:26.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/10/761810/2/check/tempest-dsvm-full-bionic/697c149/ : SUCCESS in 2h 06m 47s\n- tempest-dsvm-full-bionic-py3 https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/10/761810/2/check/tempest-dsvm-full-bionic-py3/a45037f/ : SUCCESS in 2h 19m 04s","accounts_in_message":[],"_revision_number":2},{"id":"d4ef942c27affb7350320d990903eba6ca13e9cd","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-01-28 00:22:10.000000000","message":"Patch Set 2: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- grenade https://zuul.opendev.org/t/openstack/build/06ec536bb01847d5a0518f91d436425f : SUCCESS in 1h 12m 39s\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/bf693b8a19d44ae39aa716da0286ea60 : SUCCESS in 1h 17m 08s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/e88b6746331a415ea1e83f782e3d6c6c : SUCCESS in 18m 49s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/55e2422f126a4d66ad0baa617f3239ca : SUCCESS in 14m 54s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/04d438692ecf4f75acd2eb22343bf8aa : SUCCESS in 8m 02s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/e61cea0d839640ba94d2aa255c4d5c02 : SUCCESS in 12m 36s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/18df3f34006645d9bbfc9c27d7af730b : SUCCESS in 14m 12s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/ea59755b1dc0488397c9e981b9399ed5 : SUCCESS in 14m 07s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/b00b0de66ae74edc92e196cf0ba8f5dc : SUCCESS in 1h 00m 03s (non-voting)\n- devstack-plugin-ceph-tempest-py3 https://zuul.opendev.org/t/openstack/build/f34fcb0b9f554f10922efe6dc0498bfb : SUCCESS in 1h 07m 43s (non-voting)\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/eb950ed91cb447b3942d176c30682de7 : SUCCESS in 1h 25m 46s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/a671bb01cef847d0a37b28ef809c5c84 : SUCCESS in 45m 58s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/492ed08935e1488eb0a40cc6415c02fc : FAILURE in 1h 16m 04s\n- nova-next https://zuul.opendev.org/t/openstack/build/5227bd7f5fb949ba8f4a59d010a10881 : SUCCESS in 1h 23m 59s\n- nova-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/9d423a1185a74b3ea9a2bf3c7871a699 : SUCCESS in 17m 43s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/69d15b4313404781929c6efc8041c4b6 : SUCCESS in 57m 31s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/a561f0648a6e4bceba4cd42c20c1e0b9 : SUCCESS in 57m 49s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/df18bfaa3a14409193414f85f5b1d7b0 : FAILURE in 29m 16s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"cfec4c2455c5892d28d19e0963c55422cd312ab7","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2021-02-02 20:51:40.000000000","message":"Patch Set 2:\n\nrecheck Volume is not in LUKS format\n\nJan 27 23:53:10.926066 ubuntu-bionic-ovh-bhs1-0022752197 nova-compute[19535]: ERROR nova.compute.manager [instance: f2218cab-1957-419d-82a3-41aeeddee04f] libvirt.libvirtError: internal error: process exited while connecting to monitor: 2021-01-27T23:53:10.255296Z qemu-system-x86_64: -drive file\u003d/dev/disk/by-id/scsi-360000000000000000e00000000010001,key-secret\u003dvirtio-disk0-luks-secret0,format\u003dluks,if\u003dnone,id\u003ddrive-virtio-disk0,cache\u003dnone,aio\u003dnative: Volume is not in LUKS format","accounts_in_message":[],"_revision_number":2},{"id":"c685120782f5796ae58cd9deb567d9cbf49e0a87","author":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"date":"2021-02-02 21:03:19.000000000","message":"Patch Set 2:\n\nFor rechecking only on the Cloudbase Nova Hyper-V CI, add a review comment with run-Cloudbase Nova Hyper-V CI\n\n- nova http://cloudbase-ci.com/nova/761810/2/iscsi : FAILURE in 10m 18s","accounts_in_message":[],"_revision_number":2},{"id":"b5f445c7dbbc06116b7910b77c36b16a7e832bc0","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-02-03 01:26:32.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\n\n- grenade https://zuul.opendev.org/t/openstack/build/dee5f0215e934658a890ce1219bd635e : SUCCESS in 1h 09m 43s\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/7343d69ce1104a149324c6a3c6a13e26 : SUCCESS in 1h 18m 12s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/885c7e3195f549a0b409624fe6c6a608 : SUCCESS in 16m 00s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/eaee0c799b8a4f99a889f9488fcaab26 : SUCCESS in 15m 03s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/a726f4e8408b4b7b915acb845a718a4a : SUCCESS in 7m 10s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/dc9c1910edf24dfa97d92870afea4e8e : SUCCESS in 15m 15s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/c1bf4bfea75645d289513197869d3ec2 : SUCCESS in 13m 12s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/30fb3ad000864f8185a14b9dfea56f33 : SUCCESS in 9m 18s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/032f5fc9e540468b8e8fdaacfb56125d : SUCCESS in 57m 14s (non-voting)\n- devstack-plugin-ceph-tempest-py3 https://zuul.opendev.org/t/openstack/build/e7b90cb7ba52471f83cb57d4ab71469d : SUCCESS in 1h 01m 34s (non-voting)\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/563501517e3e41a6adab6d0c1e664636 : SUCCESS in 1h 34m 09s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/b91228737d2e4c19b7518d84455eb81d : SUCCESS in 53m 39s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/ea002f7bb3ca4259971d9411d238bc0f : SUCCESS in 1h 16m 00s\n- nova-next https://zuul.opendev.org/t/openstack/build/31f571985a8247c7b6f8b467256ac3df : SUCCESS in 1h 23m 00s\n- nova-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/4db14eca5d1f4e99bd0b1d860c22fe51 : SUCCESS in 17m 58s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/62c779421135424eaa7b460ad8a70831 : SUCCESS in 55m 33s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/726007d7d1b842a4af8f0f14c984751c : SUCCESS in 48m 28s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/cb3a8a04db484161ab34e4dc44982795 : FAILURE in 24m 31s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"87d6b0dccbcc0600c2c74bf1056a625d9db018fb","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2021-02-03 01:46:32.000000000","message":"Patch Set 2: Code-Review+2\n\nClean backport from stable/victoria where the patch is merged. LGTM","accounts_in_message":[],"_revision_number":2},{"id":"37e4c2959d1aaafb5060f5ad71d053b3b5082575","author":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"date":"2021-02-03 17:43:54.000000000","message":"Patch Set 2: Code-Review+2 Workflow+1\n\nI agree with Sergey and melwitt. LGTM.","accounts_in_message":[],"_revision_number":2},{"id":"4448a1afddece28a00c8e465094b5666b4266e28","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-02-03 17:47:47.000000000","message":"Patch Set 2: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":2},{"id":"ac7b0a7d93887ba4e9f1e2a1c3da4656f11cb675","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-02-03 19:50:43.000000000","message":"Patch Set 2: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- grenade https://zuul.opendev.org/t/openstack/build/0c5133acb6e24a1898e250afba515f14 : SUCCESS in 1h 18m 40s\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/217017b510c5454aa9856dd8d100d24a : SUCCESS in 1h 30m 31s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/dec3a1bc85d843f3bd7d8ffcdd5add5a : SUCCESS in 15m 57s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/5afa1fd0c35143a28ed124f142ad70fa : SUCCESS in 7m 06s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/16ecba4f88334b5aa32b549ac9c192da : SUCCESS in 14m 20s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/bee39526d60d4c0fb6901896c00c6e4c : SUCCESS in 12m 09s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/98102b95240e4a12bbdde5c2b7fca66c : SUCCESS in 12m 25s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/62c63a0552654666b7e0a97583556206 : SUCCESS in 1h 11m 13s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/0f1007d1e8a04fe288a88fb0015d47ba : SUCCESS in 45m 22s\n- nova-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/1b1a9221f64845cd81cbf7c0c2d41ef3 : SUCCESS in 18m 26s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/32d48bb4952e4a5ba223e9a9b7d01067 : SUCCESS in 1h 19m 38s\n- nova-next https://zuul.opendev.org/t/openstack/build/5dc0a16c2bcb4d7cb7fd0abd76e22a74 : SUCCESS in 1h 56m 43s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/b225fdd79e7444e494d4b7264e728382 : SUCCESS in 57m 11s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/79786e4acbd3464eaebcc1ec930f0f24 : SUCCESS in 57m 11s","accounts_in_message":[],"_revision_number":2},{"id":"3603b5440e3ae75f98852f865157349374a43e17","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-02-03 19:50:46.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":2},{"id":"f36e6425c3576b5473590835fa6dce9a8c074a5e","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-02-03 19:52:25.000000000","message":"Patch Set 2:\n\nBuild succeeded (promote pipeline).\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/0f2810d0333e4d628771da29fb6db955 : SUCCESS in 1m 00s","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"e7a45e0335e4cf44fec7f7b8d2505f5b95445cf9","revisions":{"12dbfec3ef4d1298a075bcd94ab3c5d8e7af5475":{"kind":"REWORK","_number":1,"created":"2020-11-07 11:13:08.000000000","uploader":{"_account_id":9373,"name":"Vlad Gusev","email":"vlad.esten@gmail.com","username":"s10"},"ref":"refs/changes/10/761810/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/10/761810/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/10/761810/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/10/761810/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/10/761810/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/10/761810/1"}}},"commit":{"parents":[{"commit":"29425d6fb64fa52a897c8d6c5aa8860877437d94","subject":"Merge \"Fix invalid assert_has_calls\" into stable/ussuri","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/29425d6fb64fa52a897c8d6c5aa8860877437d94"}]}],"author":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2020-10-20 21:46:13.000000000","tz":0},"committer":{"name":"Vlad Gusev","email":"vlad.esten@gmail.com","date":"2020-11-07 11:12:35.000000000","tz":180},"subject":"Use subqueryload() instead of joinedload() for (system_)metadata","message":"Use subqueryload() instead of joinedload() for (system_)metadata\n\nCurrently, when we \"get\" a single instance from the database and we\nload metadata and system_metadata, we do so using a joinedload() which\ndoes JOINs with the respective tables. Because of the one-to-many\nrelationship between an instance and (system_)metadata records, doing\nthe database query this way can result in a large number of additional\nrows being returned unnecessarily and cause a large data transfer.\n\nThis is similar to the problem addressed by change\nI0610fb16ccce2ee95c318589c8abcc30613a3fe9 which added separate queries\nfor (system_)metadata when we \"get\" multiple instances. We don\u0027t,\nhowever, reuse the same code for this change because\n_instances_fill_metadata converts the instance database object to a\ndict, and some callers of _instance_get_by_uuid need to be able to\naccess an instance database object attached to the session (example:\ninstance_update_and_get_original).\n\nBy using subqueryload() [1], we can perform the additional queries for\n(system_)metadata to solve the problem with a similar approach.\n\nCloses-Bug: #1799298\n\n[1] https://docs.sqlalchemy.org/en/13/orm/loading_relationships.html#subquery-eager-loading\n\nChange-Id: I5c071f70f669966e9807b38e99077c1cae5b4606\n(cherry picked from commit e728fe668a6de886455f2dbaf655c8a151462c8c)\n(cherry picked from commit e2dc0de478ed16c2a811cde4aaa52f756c758fb5)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/12dbfec3ef4d1298a075bcd94ab3c5d8e7af5475"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/12dbfec3ef4d1298a075bcd94ab3c5d8e7af5475"}]},"branch":"refs/heads/stable/ussuri"},"e7a45e0335e4cf44fec7f7b8d2505f5b95445cf9":{"kind":"NO_CODE_CHANGE","_number":2,"created":"2021-01-27 19:37:37.000000000","uploader":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"ref":"refs/changes/10/761810/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/10/761810/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/10/761810/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/10/761810/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/10/761810/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/10/761810/2"}}},"commit":{"parents":[{"commit":"29425d6fb64fa52a897c8d6c5aa8860877437d94","subject":"Merge \"Fix invalid assert_has_calls\" into stable/ussuri","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/29425d6fb64fa52a897c8d6c5aa8860877437d94"}]}],"author":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2020-10-20 21:46:13.000000000","tz":0},"committer":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2021-01-27 19:37:17.000000000","tz":0},"subject":"Use subqueryload() instead of joinedload() for (system_)metadata","message":"Use subqueryload() instead of joinedload() for (system_)metadata\n\nCurrently, when we \"get\" a single instance from the database and we\nload metadata and system_metadata, we do so using a joinedload() which\ndoes JOINs with the respective tables. Because of the one-to-many\nrelationship between an instance and (system_)metadata records, doing\nthe database query this way can result in a large number of additional\nrows being returned unnecessarily and cause a large data transfer.\n\nThis is similar to the problem addressed by change\nI0610fb16ccce2ee95c318589c8abcc30613a3fe9 which added separate queries\nfor (system_)metadata when we \"get\" multiple instances. We don\u0027t,\nhowever, reuse the same code for this change because\n_instances_fill_metadata converts the instance database object to a\ndict, and some callers of _instance_get_by_uuid need to be able to\naccess an instance database object attached to the session (example:\ninstance_update_and_get_original).\n\nBy using subqueryload() [1], we can perform the additional queries for\n(system_)metadata to solve the problem with a similar approach.\n\nCloses-Bug: #1799298\n\n[1] https://docs.sqlalchemy.org/en/13/orm/loading_relationships.html#subquery-eager-loading\n\nChange-Id: I5c071f70f669966e9807b38e99077c1cae5b4606\n(cherry picked from commit e728fe668a6de886455f2dbaf655c8a151462c8c)\n(cherry picked from commit 63d2e62c3a223f883ca810f4c66a2a236cf3d483)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/e7a45e0335e4cf44fec7f7b8d2505f5b95445cf9"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/e7a45e0335e4cf44fec7f7b8d2505f5b95445cf9"}]},"branch":"refs/heads/stable/ussuri"}},"requirements":[],"submit_records":[{"status":"CLOSED","labels":[{"label":"Verified","status":"OK","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"OK","applied_by":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"}},{"label":"Workflow","status":"OK","applied_by":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"}}]}],"submit_requirements":[{"name":"Verified","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Verified\u003dCustom-Rule","fulfilled":true,"status":"PASS","passing_atoms":["label:Verified\u003dCustom-Rule"],"failing_atoms":[],"atom_explanations":{}}},{"name":"Workflow","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Workflow\u003dCustom-Rule","fulfilled":true,"status":"PASS","passing_atoms":["label:Workflow\u003dCustom-Rule"],"failing_atoms":[],"atom_explanations":{}}},{"name":"Code-Review","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Code-Review\u003dCustom-Rule","fulfilled":true,"status":"PASS","passing_atoms":["label:Code-Review\u003dCustom-Rule"],"failing_atoms":[],"atom_explanations":{}}}]}