)]}'
{"id":"openstack%2Fnova~837156","triplet_id":"openstack%2Fnova~master~I1355ac92202cb504a7814afaa1338a4a511f9b54","project":"openstack/nova","branch":"master","topic":"sqlalchemy-20","attention_set":{},"removed_from_attention_set":{"15334":{"account":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"last_update":"2022-04-20 15:52:29.000000000","reason":"stephenfin replied on the change"}},"hashtags":[],"change_id":"I1355ac92202cb504a7814afaa1338a4a511f9b54","subject":"db: Replace use of strings in join, defer operations","status":"MERGED","created":"2022-04-08 15:54:51.000000000","updated":"2022-04-20 16:23:13.000000000","submitted":"2022-04-20 16:21:00.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":15,"unresolved_comment_count":3,"has_review_started":true,"submission_id":"837156-sqlalchemy-20","meta_rev_id":"1afe88333b6a671bf51390225698b91dbd8ab2b8","_number":837156,"virtual_id_number":837156,"owner":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2022-04-20 16:20:59.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"}],"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":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"all":[{"value":2,"date":"2022-04-20 10:15:07.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":2,"date":"2022-04-20 14:46:16.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"}],"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":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"all":[{"value":0,"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":1,"date":"2022-04-20 14:46:16.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"recommended":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"all":[{"value":0,"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":1,"date":"2022-04-14 14:10:15.000000000","permitted_voting_range":{"min":1,"max":2},"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"}],"values":{" 0":"Default Priority","+1":"Contributor Review Promise","+2":"Core Review Promise"},"description":"","value":1,"default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"CC":[{"_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},{"_account_id":34420,"name":"openstack lightbits","display_name":"Lightbits CI","email":"openstack@lightbitslabs.com","username":"openstack_lightbits"}],"REVIEWER":[{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2022-04-08 15:55:14.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":"CC"},{"updated":"2022-04-08 17:34:45.000000000","updated_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"reviewer":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"state":"CC"},{"updated":"2022-04-08 17:40:02.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":"2022-04-08 18:08: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":"CC"},{"updated":"2022-04-08 18:46:56.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":"CC"},{"updated":"2022-04-14 14:10:08.000000000","updated_by":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"reviewer":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"state":"CC"},{"updated":"2022-04-14 14:10:15.000000000","updated_by":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"reviewer":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"state":"REVIEWER"},{"updated":"2022-04-14 16:16:16.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":"CC"},{"updated":"2022-04-14 16:42:05.000000000","updated_by":{"_account_id":34420,"name":"openstack lightbits","display_name":"Lightbits CI","email":"openstack@lightbitslabs.com","username":"openstack_lightbits"},"reviewer":{"_account_id":34420,"name":"openstack lightbits","display_name":"Lightbits CI","email":"openstack@lightbitslabs.com","username":"openstack_lightbits"},"state":"CC"},{"updated":"2022-04-20 10:15:07.000000000","updated_by":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"reviewer":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"state":"REVIEWER"}],"messages":[{"id":"e589a368b249a310907267eaaae0f811e27545b5","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2022-04-08 15:54:51.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"433e7d327ee0de863e2e7cc582d6e76819f9a24a","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},"date":"2022-04-08 15:55:14.000000000","message":"Patch Set 1:\n\nBuild Started http://p3-ci-int.eng.vmware.com:8080/job/ext-nova-zuul/41979/","accounts_in_message":[],"_revision_number":1},{"id":"4f9671129a4620e0dce1d7b3645034282810e8bf","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},"date":"2022-04-08 15:57:02.000000000","message":"Patch Set 1:\n\nBuild Failed \n\nhttp://p3-ci-int.eng.vmware.com:8080/job/ext-nova-zuul/41979/ : FAILURE","accounts_in_message":[],"_revision_number":1},{"id":"8da84f647de4a7ea996fa3c33ada783dcdd1d71d","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-08 17:34:45.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/a66d9a37173b4483b3c403832453317a : SUCCESS in 37m 04s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/74d981890319445cb13c20201b3601e6 : SUCCESS in 30m 56s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"a496de55f700a3423fd0a46c6301a9b26cfe7eb1","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-08 17:40:02.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- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/6a4df60f21c34f59b907e070e0622b40 : SUCCESS in 1h 36m 11s\n- tempest-integrated-compute-centos-8-stream https://zuul.opendev.org/t/openstack/build/37afca8407aa47c59e2eb02e1cb441e7 : SUCCESS in 1h 11m 39s (non-voting)\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/d5a7db033d344e4489b646d2309874e7 : SUCCESS in 48m 48s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/9a27f97b8d1041249819f1b1dd38d4a3 : SUCCESS in 18m 23s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/e67b8c124f4343a1beff620cf1f63b27 : SUCCESS in 14m 58s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/0fc0a62d35db451183add3937b52fe92 : SUCCESS in 14m 19s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/dbc6988e9fc14c448fbd7fc2efb3241c : SUCCESS in 14m 13s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/be6f43d70d814089afafc9b20a991894 : SUCCESS in 14m 50s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/0591da5fbaea4ab9af6f3c1e4ec66bd6 : RETRY_LIMIT in 4m 29s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/6bcc796bfd2f40029dc28ff301b1872c : SUCCESS in 11m 14s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/45d54cc575c54029b41851ef56d6cb2a : SUCCESS in 1h 00m 57s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/3be3171b21b348b68d4669b9c7e59cc7 : SUCCESS in 1h 10m 06s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/47b58e22ce7246a99bbb24a0197bcc0a : SUCCESS in 50m 39s\n- nova-live-migration-ceph https://zuul.opendev.org/t/openstack/build/5ed25d121e9a456eaa44eaab5bb1480a : SUCCESS in 47m 58s (non-voting)\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/5b12204b9623465981ba03b8cb3f3995 : SUCCESS in 1h 18m 57s\n- nova-next https://zuul.opendev.org/t/openstack/build/1bbd580dd34e4597b0a081a2d4079c32 : SUCCESS in 1h 30m 03s\n- nova-ovs-hybrid-plug https://zuul.opendev.org/t/openstack/build/4d5eb00f19824d5b844c562b70442bdd : SUCCESS in 55m 02s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/fb5d84fd5772409d8cc730036219cd62 : SUCCESS in 8m 15s (non-voting)\n- nova-tox-functional-centos8-py36 https://zuul.opendev.org/t/openstack/build/097caa09230c4e2193e9b3af281ca0fa : SUCCESS in 22m 32s\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/055fdac6bbeb4bc8bb542b269d5b95ac : FAILURE in 22m 42s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/f121545a93d2449b89a800323dcc83ca : SUCCESS in 21m 18s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/d02e7b2fa6fd493dad7fab308d5b1b47 : SUCCESS in 1h 08m 43s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/f7c3758e8f604f6b9982e06c7516508b : SUCCESS in 50m 22s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/bb59ae05959c4a13bb213f8ff00d8448 : SUCCESS in 34m 01s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/d3242ff1ea8546558ec88b4e60b22a4c : SUCCESS in 38m 09s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"8ec45820a3b99efd5b3fd4e4208366cc2c54bbf9","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2022-04-08 18:08:04.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-focal-py3 finger://zuul-v3-executor.novalocal/30e7db05fa1f45d6ab69b004d34726f0 : POST_FAILURE in 2h 09m 32s","accounts_in_message":[],"_revision_number":1},{"id":"521d63209f666613cc70625a7e95c671a93a295a","tag":"autogenerated:cloudbase-ci","author":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"date":"2022-04-08 18:46:56.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/837156/1/iscsi : FAILURE in 2h 48m 06s","accounts_in_message":[],"_revision_number":1},{"id":"bfaf6706f8529f9516e07bfe12ad304df6446219","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2022-04-13 09:11:32.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"bb6a50e5462123ee93b97c67bec6e8f94ad05d8c","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2022-04-13 09:45:21.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-focal-py3 finger://zuul-v3-executor.novalocal/88dd8b5ccb13426fafea2ecbd8d64ad1 : POST_FAILURE in 31m 41s","accounts_in_message":[],"_revision_number":1},{"id":"785342815b980c38faf9a9f3f7ca9d04d793ee38","tag":"autogenerated:cloudbase-ci","author":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"date":"2022-04-13 09:46:10.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/837156/1/iscsi : FAILURE in 32m 23s","accounts_in_message":[],"_revision_number":1},{"id":"050a43e62d7280163ba7a57d73a603b048106c61","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-13 09:49:13.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/fe1a084157014783b0593d478f4de8fc : SUCCESS in 32m 55s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/b5a4fc1df8b04d5696226c2f1a33ffde : SUCCESS in 35m 33s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"b46e6a25e4968e16d3e0d626a0763daeeb0be7df","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-13 11:01:43.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- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/5e38c9704b3a47b5ab9666eb00345a30 : FAILURE in 8m 52s\n- tempest-integrated-compute-centos-8-stream https://zuul.opendev.org/t/openstack/build/4170de5d031743bda8b6ee49fc0eb45d : SUCCESS in 1h 44m 16s (non-voting)\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/2eda28bd45b740ca9db668bff1094043 : POST_FAILURE in 19m 52s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/7eac091228e548a5a5c4aabef4e426f2 : SUCCESS in 18m 00s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/68af7e52643b4a48a9928a226b53f413 : SUCCESS in 14m 49s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/4815d805c684409f93823965c2f02b84 : SUCCESS in 13m 05s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/dc606bf8e06c416eb858d3f455c7d864 : SUCCESS in 12m 57s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/b124b07e8fb34a2d98d492bdef7d8926 : SUCCESS in 13m 37s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/3de264c7340c4d3498f520a71fea8bb7 : RETRY_LIMIT in 5m 01s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/38f4c5aba2534d779c8e1a37e86fddf1 : SUCCESS in 9m 49s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/a8199892d91448daa1ab904e089542f3 : FAILURE in 19m 22s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/c9cd0a9ddfee4a85af5856b1d67484d5 : FAILURE in 13m 42s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/15a4ea083e7841a0ba5f3dd6a9dca9f4 : POST_FAILURE in 21m 45s\n- nova-live-migration-ceph https://zuul.opendev.org/t/openstack/build/9c0f6dab82a94592aa5911dad4dcf4f4 : POST_FAILURE in 24m 06s (non-voting)\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/34d658709d574371b26a5a566f0cbca3 : FAILURE in 11m 51s\n- nova-next https://zuul.opendev.org/t/openstack/build/07fe1ff6089546a8b98a99d04ab5a0a4 : POST_FAILURE in 21m 24s\n- nova-ovs-hybrid-plug https://zuul.opendev.org/t/openstack/build/8d48c3f5eb594705b992b046e2d56923 : POST_FAILURE in 21m 05s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/1328674c9f744464817b7773c63d7f3d : SUCCESS in 6m 17s (non-voting)\n- nova-tox-functional-centos8-py36 https://zuul.opendev.org/t/openstack/build/ce9963e85d384e56aac50405bcf7ba0a : SUCCESS in 23m 10s\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/abd174462e374a42b88335afdd918140 : SUCCESS in 21m 22s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/4766f48e4ef24b2fb2bb067f0da64c11 : SUCCESS in 21m 51s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/991d27a9cd8b4e409c29294b1b9dd125 : FAILURE in 26m 03s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/7ca612109ab146b3a120ca75e1b2b9af : FAILURE in 18m 16s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/6527458c83834e0d800761d8f4eee73c : FAILURE in 17m 52s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/0e8c980302c94c4982a9a4b79394a752 : FAILURE in 17m 45s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"24fdedd42cc2e1c043404943827281391388fe4d","author":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"date":"2022-04-14 14:10:08.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"b018ee78f8f491471f69797072e1d296535722bf","author":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"date":"2022-04-14 14:10:15.000000000","message":"Patch Set 1: Review-Priority+1","accounts_in_message":[],"_revision_number":1},{"id":"70bf7ab6d500fd1072dac25ea6cbe7067808db01","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-14 14:44:49.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/551521028d87439eadacca7362b19e04 : SUCCESS in 30m 37s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/5e801f51b5b14c66974dc22b111fe694 : SUCCESS in 30m 17s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"59ae50b5f51465e95384f956a88049cdca6d6d73","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2022-04-14 15:51:27.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-focal-py3 https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/56/837156/1/check/tempest-dsvm-full-focal-py3/d9fbee4/ : SUCCESS in 1h 38m 57s","accounts_in_message":[],"_revision_number":1},{"id":"a2cb8243c6756522201a31a73522553f507c389b","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-14 16:15:30.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/0efb4744ff6943ecac46eddf26eabf40 : SUCCESS in 1h 32m 31s\n- tempest-integrated-compute-centos-8-stream https://zuul.opendev.org/t/openstack/build/555311c0f59141deacf3ecb67d767c55 : SUCCESS in 2h 02m 36s (non-voting)\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/07cc2fd27c9642af837fa23447c8724f : SUCCESS in 56m 07s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/735913143fa64805af0e9695198f69f5 : SUCCESS in 16m 18s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/f97b4a4bf5d64e0ab82dad342c3aa82a : SUCCESS in 16m 07s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/5c7bbe23fae54e83800478bb2975a9d2 : SUCCESS in 15m 07s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/3b2d6e940fd34881adfa64fe76f4b1c5 : SUCCESS in 15m 01s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/cdeff0e4b6d64c6ca23f9595be463bf7 : SUCCESS in 13m 10s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/464a75b3f94240128da74b5d8b0b8de0 : RETRY_LIMIT in 4m 46s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/1342fab1a0d840ea8f1fbc750a3d3171 : SUCCESS in 10m 45s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/7cfc8165b23548e0812778ade8324932 : SUCCESS in 1h 08m 18s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/7edeae610615437a96191862ef0864f6 : SUCCESS in 59m 52s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/60dd96d5ca734f3d9c08948d57a8990e : SUCCESS in 49m 01s\n- nova-live-migration-ceph https://zuul.opendev.org/t/openstack/build/50c0d48ee6c44c129181aefec4dd45b0 : SUCCESS in 54m 17s (non-voting)\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/6ae6a134a52845019c7c114248ceef8f : SUCCESS in 1h 29m 19s\n- nova-next https://zuul.opendev.org/t/openstack/build/73cb0b4bfcb2457b90e2a988ebbaca4c : SUCCESS in 1h 33m 28s\n- nova-ovs-hybrid-plug https://zuul.opendev.org/t/openstack/build/bb73ab7a7d3b4ddb84d9a0fa62577149 : SUCCESS in 50m 57s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/813d16aaa15b46568ba0c1bbec1c1928 : SUCCESS in 6m 12s (non-voting)\n- nova-tox-functional-centos8-py36 https://zuul.opendev.org/t/openstack/build/605678829fba43de8179e1c236688b13 : SUCCESS in 21m 44s\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/4e5d5bab5a48464a95fd9a3b87b67849 : SUCCESS in 20m 53s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/8f9a703c14804a28b6bd63dde1b16975 : SUCCESS in 21m 12s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/54905db27187444b8a7fefad6c168ce7 : SUCCESS in 1h 07m 20s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/a037af6cb47945fbb44f08a195b908f0 : SUCCESS in 56m 09s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/64525969b17b49f38bad5fde4112d8ae : SUCCESS in 30m 05s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/5b30890c572140598dc350537f1d4fdb : SUCCESS in 40m 56s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"a4c17f28e726cd4126dabb045f9ad7315e042b48","author":{"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},"date":"2022-04-14 16:16:16.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_PowerFlex_NOVA https://elab-os-logsrv.delllabs.net/56/837156/1/check/EMC_PowerFlex_NOVA/8020bfc/EMC_PowerFlex_NOVA/None : NOT_REGISTERED\n\nLeave a comment with \u0027run-DellEMC PowerFlex CI\u0027 to trigger a recheck. For more information about CI, please see https://wiki.openstack.org/wiki/ThirdPartySystems/DellEMC_PowerFlex_CI","accounts_in_message":[],"_revision_number":1},{"id":"6225c0f535a827fbcb899625fb90143f67f06395","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":34420,"name":"openstack lightbits","display_name":"Lightbits CI","email":"openstack@lightbitslabs.com","username":"openstack_lightbits"},"date":"2022-04-14 16:42:05.000000000","message":"Patch Set 1:\n\nBuild FAILED. log path: https://github.com/LightBitsLabs/logs/tree/main/14_04_2022_16_26_27\nLeave a comment with \u0027run-Lightbits CI\u0027 to trigger a recheck. \nFor more information about CI, please see https://wiki.openstack.org/wiki/ThirdPartySystems/LightbitsLabs_CI","accounts_in_message":[],"_revision_number":1},{"id":"ffce9237d07129317cf48d462adbb3e6f975686c","tag":"autogenerated:cloudbase-ci","author":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"date":"2022-04-14 16:53:03.000000000","message":"Patch Set 1:\n\nBuild succeeded. For checking Nova with Ceph, add a comment with run-Cloudbase Nova Ceph Hyper-V CI\n\n- nova http://cloudbase-ci.com/nova/837156/1/iscsi : SUCCESS in 2h 40m 55s","accounts_in_message":[],"_revision_number":1},{"id":"64598c70366f6a242c5562e29a1994fa979d67bc","author":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"date":"2022-04-20 10:15:07.000000000","message":"Patch Set 1: Code-Review+2\n\n(4 comments)","accounts_in_message":[],"_revision_number":1},{"id":"6de907587deae68460335ceaf21d84fe44cb5d1d","author":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"date":"2022-04-20 14:46:16.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1\n\n(6 comments)","accounts_in_message":[],"_revision_number":1},{"id":"f70e7d20f888f8541049ce928e5bf8c01dc1119c","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-20 14:47:10.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"4f1dfcc299e2b23b1f26f82fd6b62242032514cc","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2022-04-20 15:52:29.000000000","message":"Patch Set 1:\n\n(3 comments)","accounts_in_message":[],"_revision_number":1},{"id":"89d3abd3ff32d5b3c5eae2ea1c820a5f8e9b201f","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-20 16:20:59.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/39cc8bc12b4a43c3bf959c29949e3d2e : SUCCESS in 1h 07m 34s\n- tempest-integrated-compute-centos-8-stream https://zuul.opendev.org/t/openstack/build/cf1faab6444742ca8cc4582bc4a96cbc : FAILURE in 11m 40s (non-voting)\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/b5046874ac6e47e184033757e739bfd6 : SUCCESS in 44m 46s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/50ff576464584608bb428fa3c0d9fec9 : SUCCESS in 14m 10s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/c9084946b962405badb0d1e7727e7423 : SUCCESS in 12m 34s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/32c53b7688c44ca6a5fef418d83198c9 : SUCCESS in 12m 45s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/120b2399eb1f47b58e7fcbb82afc9199 : SUCCESS in 12m 43s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/7d0963481ba745dda822bdba03927fbb : SUCCESS in 10m 17s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/e5cec72e73be40f2a9162640daf9fb21 : SUCCESS in 44m 06s\n- nova-live-migration-ceph https://zuul.opendev.org/t/openstack/build/8658aa1740854ddaafae55fd36bd13e2 : SUCCESS in 47m 04s (non-voting)\n- nova-tox-functional-centos8-py36 https://zuul.opendev.org/t/openstack/build/cee103fd20a44feb89235cdc1eb81c09 : SUCCESS in 23m 58s\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/d7b85e183ede41bd90a73fa667553ba4 : SUCCESS in 20m 05s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/8a4662297eca4c128e336e4f856b8cf0 : SUCCESS in 22m 24s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/abc01394f342427da59f89e350612e71 : SUCCESS in 1h 24m 09s\n- nova-next https://zuul.opendev.org/t/openstack/build/f57a3165c26b43669554c95bd879d973 : SUCCESS in 1h 32m 54s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/2ac848b6b4b24d44bfce518546df6417 : SUCCESS in 7m 20s\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/cc153f7f46754b649927c4987df23723 : SUCCESS in 1h 04m 05s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/4821d16291634022a603164371d9a85b : SUCCESS in 1h 07m 51s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/99f94dd56508465b94e112c7330d269b : SUCCESS in 55m 49s","accounts_in_message":[],"_revision_number":1},{"id":"3408cd6f65ddaee09b03ad82b3e8819a127b3d26","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-20 16:21:00.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":1},{"id":"1afe88333b6a671bf51390225698b91dbd8ab2b8","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-20 16:23:13.000000000","message":"Patch Set 1:\n\nBuild succeeded (promote pipeline).\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/75689813cd0a4792820cd58f50a4684e : SUCCESS in 1m 23s","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"0939b3c4d17c5c810c3a38f89db263d7b933e477","revisions":{"0939b3c4d17c5c810c3a38f89db263d7b933e477":{"kind":"REWORK","_number":1,"created":"2022-04-08 15:54:51.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"ref":"refs/changes/56/837156/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/56/837156/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/56/837156/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/56/837156/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/56/837156/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/56/837156/1"}}},"commit":{"parents":[{"commit":"523297bdfa25bb0ddadc2320595c6b859be5e192","subject":"db: Trivial rewrapping of warning filters","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/523297bdfa25bb0ddadc2320595c6b859be5e192"}]}],"author":{"name":"Stephen Finucane","email":"sfinucan@redhat.com","date":"2022-04-07 16:34:52.000000000","tz":60},"committer":{"name":"Stephen Finucane","email":"sfinucan@redhat.com","date":"2022-04-08 14:56:47.000000000","tz":60},"subject":"db: Replace use of strings in join, defer operations","message":"db: Replace use of strings in join, defer operations\n\nResolve the following RemovedIn20Warning warnings:\n\n  Using strings to indicate column or relationship paths in loader\n  options is deprecated and will be removed in SQLAlchemy 2.0. Please\n  use the class-bound attribute directly.\n\n  Using strings to indicate relationship names in Query.join() is\n  deprecated and will be removed in SQLAlchemy 2.0. Please use the\n  class-bound attribute directly.\n\nThis is rather tricky to resolve. In most cases, we can simply make use\nof getattr to fetch the class-bound attribute, however, there are a\nnumber of places were we were doing \"nested\" joins, e.g.\n\u0027instances.info_cache\u0027 on the \u0027SecurityGroup\u0027 model. These need a little\nmore thought.\n\nChange-Id: I1355ac92202cb504a7814afaa1338a4a511f9b54\nSigned-off-by: Stephen Finucane \u003csfinucan@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/0939b3c4d17c5c810c3a38f89db263d7b933e477"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/0939b3c4d17c5c810c3a38f89db263d7b933e477"}]},"branch":"refs/heads/master"}},"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":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"}},{"label":"Workflow","status":"OK","applied_by":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"}},{"label":"Review-Priority","status":"MAY","applied_by":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"}}]}],"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":{}}}]}