)]}'
{"id":"openstack%2Fnova~837162","triplet_id":"openstack%2Fnova~master~I63208c7bd5f9f4c3d5e4a40bd0f6253d0f042a37","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-29 05:25:46.000000000","reason":"Change was submitted"}},"hashtags":[],"change_id":"I63208c7bd5f9f4c3d5e4a40bd0f6253d0f042a37","subject":"db: Resolve additional SAWarning warnings","status":"MERGED","created":"2022-04-08 15:54:51.000000000","updated":"2022-04-29 05:27:18.000000000","submitted":"2022-04-29 05:25:46.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":5,"unresolved_comment_count":1,"has_review_started":true,"submission_id":"837162-sqlalchemy-20","meta_rev_id":"536abf1f45a20ef49c56dc117f5b4770f88bc68b","_number":837162,"virtual_id_number":837162,"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":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"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-29 05:25:45.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":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"all":[{"value":2,"date":"2022-04-20 16:41:42.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"value":2,"date":"2022-04-20 10:36:45.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-22 10:16:59.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":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"all":[{"value":1,"date":"2022-04-20 16:41:42.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"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-22 10:16:59.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":{"all":[{"value":0,"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"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":0,"_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":"","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":32966,"name":"jiang guodao","email":"jguodao@vmware.com","username":"jguodao"},{"_account_id":34420,"name":"openstack lightbits","display_name":"Lightbits CI","email":"openstack@lightbitslabs.com","username":"openstack_lightbits"}],"REVIEWER":[{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"_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 17:47:16.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 17:48:14.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-08 18:03:06.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 18:13:31.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 19:16:07.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-08 19:40:59.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-12 01:58:02.000000000","updated_by":{"_account_id":32966,"name":"jiang guodao","email":"jguodao@vmware.com","username":"jguodao"},"reviewer":{"_account_id":32966,"name":"jiang guodao","email":"jguodao@vmware.com","username":"jguodao"},"state":"CC"},{"updated":"2022-04-20 10:36:45.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"},{"updated":"2022-04-20 16:41:42.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":"2022-04-22 10:16:59.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"}],"messages":[{"id":"be814ae6ce81d9e2bc1626dfb8534da5b18ed006","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":"89a90ef21571ba1be97a78464905a41a79f5370d","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-08 17:47:16.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/1478d58b40464cb29da8b2b2d7200341 : SUCCESS in 1h 17m 32s\n- tempest-integrated-compute-centos-8-stream https://zuul.opendev.org/t/openstack/build/44b4c0b9ee97495aad758e62d2558b0e : SUCCESS in 1h 24m 05s (non-voting)\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/a1059fd668fc4140b6365bf001d4295b : SUCCESS in 51m 39s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/eb8ebfa909e84a2d86b1e6379980fb2e : SUCCESS in 16m 55s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/4f5da9db27c24213903e9dd38269d1f3 : SUCCESS in 16m 15s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/2d009d4c0690486088af97bb13ff5412 : SUCCESS in 14m 17s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/58ac984822ea4b93914e1ab389a98ef0 : SUCCESS in 14m 19s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/bad239b769644c229debc10afb69c6f7 : SUCCESS in 13m 56s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/df9aa2ae1afb4b88a1a9d8bebcd39c3b : RETRY_LIMIT in 4m 31s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/8754506a6d8b46d69ec22a45b353d734 : SUCCESS in 11m 45s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/f256484f1a6948fd8ba7673085ca4223 : SUCCESS in 1h 14m 07s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/9b6a86fc120d4e12915b145fe06e2bf9 : SUCCESS in 1h 04m 56s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/4407a6dd3ee447a2a83a9d1adb1f1aff : SUCCESS in 52m 05s\n- nova-live-migration-ceph https://zuul.opendev.org/t/openstack/build/d1491efe93a34d04b8252d5146d3220b : SUCCESS in 53m 25s (non-voting)\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/af9a8cda710e4914827d70fdf5b66ba0 : SUCCESS in 1h 37m 08s\n- nova-next https://zuul.opendev.org/t/openstack/build/ad6b2e4b183144988f49af2cb751c9a4 : SUCCESS in 1h 29m 43s\n- nova-ovs-hybrid-plug https://zuul.opendev.org/t/openstack/build/327ec595a6924e368477860890c0e06c : SUCCESS in 52m 56s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/3f4744671f244ef8a012a6ab51e4fbb1 : SUCCESS in 7m 18s (non-voting)\n- nova-tox-functional-centos8-py36 https://zuul.opendev.org/t/openstack/build/5a668e5122824bf58d25e1d0cbd870a3 : SUCCESS in 21m 34s\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/4302cc167b764725957c6a0fd5c27186 : SUCCESS in 22m 20s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/f4eeffe3936c4ade90d05e1c0fa46c1a : SUCCESS in 21m 05s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/d9ffae87acfd4123b399d2b1548a26e8 : SUCCESS in 1h 11m 27s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/f3153b8b402844299be0b9dcde634793 : SUCCESS in 54m 41s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/bf0ba95ae91e4f63bfe8622429673db7 : SUCCESS in 36m 02s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/95caeaddea0e482cb6f85329da1cf1a4 : SUCCESS in 44m 03s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"081cef89b64712fb23dd7b3098e18f6f4dcf3d40","author":{"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},"date":"2022-04-08 17:48:14.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/62/837162/1/check/EMC_PowerFlex_NOVA/397ba1d/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":"1e10372610ad955246c427514e9ae4df63636d9f","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},"date":"2022-04-08 18:03:06.000000000","message":"Patch Set 1:\n\nBuild Started http://p3-ci-int.eng.vmware.com:8080/job/ext-nova-zuul/41986/","accounts_in_message":[],"_revision_number":1},{"id":"9ba434818d21c8a6e553ac0986929b44316bb1db","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},"date":"2022-04-08 18:04:53.000000000","message":"Patch Set 1:\n\nBuild Failed \n\nhttp://p3-ci-int.eng.vmware.com:8080/job/ext-nova-zuul/41986/ : FAILURE","accounts_in_message":[],"_revision_number":1},{"id":"ba7c30c8762736109999237e23a984fc9e4fcbc9","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2022-04-08 18:13:31.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/84036fa60a1c4a08a261c865799c9259 : POST_FAILURE in 2h 00m 44s","accounts_in_message":[],"_revision_number":1},{"id":"28d7848e496fab4e93a9c034160340806f6b741e","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-08 19:05:36.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/ea3600b1321d490693765df64f3a9d2e : SUCCESS in 38m 12s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/88ff07d45e30487a8365929f88c45032 : SUCCESS in 28m 17s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"6bc0ce7061a1b68126eb8cf209e9be9ca588fbee","author":{"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},"date":"2022-04-08 19:06:36.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/62/837162/1/check/EMC_PowerFlex_NOVA/28e3454/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":"bee7f311a1d13b0128f5dc2733d346baf2678593","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 19:16:07.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/837162/1/iscsi : FAILURE in 2h 44m 01s","accounts_in_message":[],"_revision_number":1},{"id":"31d5a030983e4446ce3d0654665958b0bc59340f","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-08 19:40:59.000000000","message":"Patch Set 1:\n\nBuild FAILED. log path: https://github.com/LightBitsLabs/logs/tree/main/08_04_2022_19_13_37\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":"9458737b81822530fee21943d265eac0ae67b07b","author":{"_account_id":32966,"name":"jiang guodao","email":"jguodao@vmware.com","username":"jguodao"},"date":"2022-04-12 01:58:02.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"388f7965582bc923594f127ee9e09f2ff9507b34","author":{"_account_id":9008,"name":"VMware NSX CI","username":"vmwareminesweeper","tags":["SERVICE_USER"]},"date":"2022-04-12 02:58:09.000000000","message":"Patch Set 1:\n\nBuild succeeded\n\n- dsvm-nova http://207.189.188.190/logs/837162/837162/1/check-not-vote/ext-nova-zuul/d240a8e : SUCCESS in 46m 28s","accounts_in_message":[],"_revision_number":1},{"id":"01e4acb5b048a60994691ba1dc5784e6bebf7885","author":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"date":"2022-04-20 10:36:45.000000000","message":"Patch Set 1: Code-Review+2\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"ece9dc3fe9bbe53b95a86f5d53e67d0e74c0a6e5","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2022-04-20 16:41:42.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1\n\n(2 comments)","accounts_in_message":[],"_revision_number":1},{"id":"2d904b213bad2212d3b4c0150a18702963ac5d02","author":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"date":"2022-04-22 10:16:59.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":1},{"id":"a67670cf6bfd36c6bf5ad425c9756dc3b873e5c4","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-22 15:49:50.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"1f81498e181937d485201593f57a87ea78c3f87e","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-22 17:47:48.000000000","message":"Patch Set 1: Verified-2\n\nBuild failed (gate pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/04c4b530098b421e8137e2a8278835f7 : SUCCESS in 1h 03m 50s\n- tempest-integrated-compute-centos-8-stream https://zuul.opendev.org/t/openstack/build/e50ecc9174024d769bddea49140b8fc2 : POST_FAILURE in 13m 25s (non-voting)\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/b491fde044a541c8afcfb7a951e21507 : SUCCESS in 42m 09s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/0bd9eaffa16a418d89ca1afb07deb944 : SUCCESS in 13m 45s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/16c7bc6d45d64a65b63615c23a49efb1 : SUCCESS in 12m 08s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/b19a2e154ce043058e37c542c036ab22 : SUCCESS in 11m 27s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/77f42014d9724d11a080f00f8f56a8cb : SUCCESS in 11m 50s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/c8a99736774a42c98322840314cf4f78 : SUCCESS in 10m 17s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/361f80f8c3294e84aafcb383bf868daa : POST_FAILURE in 52m 34s\n- nova-live-migration-ceph https://zuul.opendev.org/t/openstack/build/a4c2a413f8f04837aa329e05f516f765 : SUCCESS in 51m 15s (non-voting)\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/1c858dc42dfd4d1c9b1ca698fa23cbde : SUCCESS in 25m 46s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/e4f68455dd4b426eab551ee399a01207 : SUCCESS in 29m 15s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/efd20d4c0f3643adb069b6935ab5919a : SUCCESS in 1h 34m 25s\n- nova-next https://zuul.opendev.org/t/openstack/build/0ec1b8e4d5a744d8a802913839761813 : SUCCESS in 1h 51m 47s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/c75ac6904cb146a5bc7f7703d5543c01 : SUCCESS in 7m 29s\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/048442beaaaa432b9b965e15af594749 : SUCCESS in 1h 01m 55s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/72083563fc5946adb0d94e58bbdd94fb : SUCCESS in 1h 02m 39s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/4d08b01ca4b542fcae81b5d86ced720e : SUCCESS in 45m 04s","accounts_in_message":[],"_revision_number":1},{"id":"330d33cb4e83540bff23802a84de1e4ddbbb99ba","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2022-04-29 01:46:10.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"edbf5d9c98445cb94507e399f7407049fcdaf4e6","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-29 02:20:34.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/6ffccc35929f4e68ab2f8fe1742a20d5 : SUCCESS in 22m 24s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/4c1ba567f9da4bd49b28c770b99f36e7 : SUCCESS in 31m 55s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"486d53280b2ebf7892258ea9406f5253b020ee7d","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2022-04-29 03:22:26.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/62/837162/1/check/tempest-dsvm-full-focal-py3/dbe1b85/ : SUCCESS in 1h 34m 23s","accounts_in_message":[],"_revision_number":1},{"id":"7b56227dc37af9ec599bcb6e756f6c2b8f072081","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-29 03:26:23.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/4e36d73366974048bef38bea9f7b0cca : SUCCESS in 1h 24m 44s\n- tempest-integrated-compute-centos-9-stream https://zuul.opendev.org/t/openstack/build/27202758b5ee4e8b972c380dd3d0e885 : SUCCESS in 1h 13m 18s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/59c9774f09334cf9a86d5fccdce9e7db : SUCCESS in 46m 43s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/5711d4aaadb84e29afd479ea8dd60047 : SUCCESS in 13m 09s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/a434628b943d42d9ab0d25b83878557d : SUCCESS in 13m 04s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/3179e23188344ed5b5bee53a12ff9d41 : SUCCESS in 10m 28s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/5f7fe812da8a41be9b466931991f9b19 : SUCCESS in 11m 05s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/9a8d7a34f348428a8207183b9464c980 : SUCCESS in 12m 11s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/88df320cab3d49669b1710983f9955f2 : RETRY_LIMIT in 7m 07s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/e42819fb62604d91b1fd4f02f7fa656b : SUCCESS in 9m 32s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/7c561adf4f384ba8b61f382e36b0ba90 : SUCCESS in 56m 33s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/4fc3e9888de74ad59f988ceea3a85d84 : SUCCESS in 1h 02m 21s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/961f1e0dd23f43eb9489feeebcc6c4e7 : SUCCESS in 46m 31s\n- nova-live-migration-ceph https://zuul.opendev.org/t/openstack/build/ddb35c82e03a498aa4137bb2d95d404b : SUCCESS in 46m 56s (non-voting)\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/28ff0aa601c349928cdf33529375a103 : SUCCESS in 1h 25m 42s\n- nova-next https://zuul.opendev.org/t/openstack/build/6a262cbb94db41518fda73bf910a3d7b : SUCCESS in 1h 37m 56s\n- nova-ovs-hybrid-plug https://zuul.opendev.org/t/openstack/build/8a35d65feaa44c11a3506a6f8de776a6 : SUCCESS in 49m 27s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/c4ec6cc3922d4d339d2205d3583236c3 : SUCCESS in 5m 23s (non-voting)\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/71d69660c7444cd2bfc30735d1785691 : SUCCESS in 18m 12s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/7760876d8a8a4f248df48649daa426d6 : SUCCESS in 20m 02s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/4130b837967f4902950ac8fae2195d3d : SUCCESS in 1h 02m 00s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/2653a28587a041539a4e34bfb08aad63 : SUCCESS in 41m 35s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/9e313eeb1ccd4a73b1b85bc3f71e3c2e : SUCCESS in 24m 50s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/0d60a2b0901042f8aafd203828403adb : SUCCESS in 33m 44s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"394d8cda3beb763d35819c97e19a326436ba06a8","author":{"_account_id":15941,"name":"DellEMC PowerFlex CI","email":"emc.scaleio.ci@emc.com","username":"emc-scaleio-ci","tags":["SERVICE_USER"]},"date":"2022-04-29 03:26:59.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/62/837162/1/check/EMC_PowerFlex_NOVA/7636432/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":"25a8e3f51c327d80079e6ee4925f5410af7d35b7","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-29 03:27:25.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"7eca2c8d643c85caabcd6bca8f00105abc5d99c9","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-29 03:55:44.000000000","message":"Patch Set 1:\n\nBuild FAILED. log path: https://github.com/LightBitsLabs/logs/tree/main/29_04_2022_03_26_33\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":"973dbd2eddc6c33216ee0211636b79b4f5f7b906","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-29 04:24:17.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/837162/1/iscsi : SUCCESS in 2h 36m 55s","accounts_in_message":[],"_revision_number":1},{"id":"517d944907e38328f4dced7bebd34c7d8adf0d44","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-29 05:25:45.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/dfa3b17561c24c31a9eeab9cace64aa4 : SUCCESS in 1h 17m 50s\n- tempest-integrated-compute-centos-9-stream https://zuul.opendev.org/t/openstack/build/fd71c6a3cc6842939b71f407ae403e18 : SUCCESS in 1h 46m 53s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/98b9f45f755247f9a94738450e3570f3 : SUCCESS in 54m 27s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/a68d5c1a6dd1468783860db4c4bcd182 : SUCCESS in 16m 36s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/69b6e0b644cf4d3186118f584c93fa9c : SUCCESS in 14m 05s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/dd72f174c0fb447494eb8bfc03abfefb : SUCCESS in 12m 14s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/e466ff48b96c4005be4d1f09bbd5df9a : SUCCESS in 13m 40s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/04cb7c6b20c8498c98b1e4f0cfc3b172 : SUCCESS in 9m 56s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/ac10b061950d4d97b7c878c8ea9994bb : SUCCESS in 52m 28s\n- nova-live-migration-ceph https://zuul.opendev.org/t/openstack/build/62e1fd8d17ce4711842d5a75dbea2343 : SUCCESS in 50m 31s (non-voting)\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/b2d7727db7f741348cc33c260da80eeb : SUCCESS in 22m 42s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/7bf6dfd41e404561b837a16a9c6f9055 : SUCCESS in 23m 23s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/f2fc33b814d5411eae84cb689869e75f : SUCCESS in 1h 43m 09s\n- nova-next https://zuul.opendev.org/t/openstack/build/0beb08f82e94409484bf208632301c35 : SUCCESS in 1h 38m 22s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/8fd8084c502244d18779a8c2fb6b658f : SUCCESS in 6m 31s\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/3fd805890b1b47348b481075158f878b : SUCCESS in 1h 07m 23s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/3116c7d21581464bb4476f6eb184adeb : SUCCESS in 1h 15m 28s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/5e7c912242984ba3b7026d04b2ff1491 : SUCCESS in 52m 12s","accounts_in_message":[],"_revision_number":1},{"id":"a479d275f1a286a57f3f8bc6c39598d1d4644c37","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-29 05:25:46.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":1},{"id":"536abf1f45a20ef49c56dc117f5b4770f88bc68b","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-29 05:27:18.000000000","message":"Patch Set 1:\n\nBuild succeeded (promote pipeline).\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/03f43e9581ba409ca4975859f6eb83a4 : SUCCESS in 1m 07s","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"8142b9dc47b7096ab9d8180f0b5b1e52d513e2dc","revisions":{"8142b9dc47b7096ab9d8180f0b5b1e52d513e2dc":{"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/62/837162/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/62/837162/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/62/837162/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/62/837162/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/62/837162/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/62/837162/1"}}},"commit":{"parents":[{"commit":"612b83ee5dfe426a9bb9771d0e55cc13209565d5","subject":"db: Don\u0027t rely on autocommit behavior","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/612b83ee5dfe426a9bb9771d0e55cc13209565d5"}]}],"author":{"name":"Stephen Finucane","email":"sfinucan@redhat.com","date":"2022-04-08 10:38:54.000000000","tz":60},"committer":{"name":"Stephen Finucane","email":"sfinucan@redhat.com","date":"2022-04-08 14:57:10.000000000","tz":60},"subject":"db: Resolve additional SAWarning warnings","message":"db: Resolve additional SAWarning warnings\n\nResolving the following SAWarning warnings:\n\n  Coercing Subquery object into a select() for use in IN(); please pass\n  a select() construct explicitly\n\n  SELECT statement has a cartesian product between FROM element(s)\n  \"foo\" and FROM element \"bar\". Apply join condition(s) between each\n  element to resolve.\n\nWhile the first of these was a trivial fix, the second one is a little\nmore involved. It was caused by attempting to build a query across\ntables that had no relationship as part of our archive logic. For\nexample, consider the following queries, generated early in\n\u0027_get_fk_stmts\u0027:\n\n  SELECT instances.uuid\n  FROM instances, security_group_instance_association\n  WHERE security_group_instance_association.instance_uuid \u003d instances.uuid\n    AND instances.id IN (__[POSTCOMPILE_id_1])\n\n  SELECT security_groups.id\n  FROM security_groups, security_group_instance_association, instances\n  WHERE security_group_instance_association.security_group_id \u003d security_groups.id\n    AND instances.id IN (__[POSTCOMPILE_id_1])\n\nWhile the first of these is fine, the second is clearly wrong: why are\nwe filtering on a field that is of no relevance to our join? These were\ngenerated because we were attempting to archive one or more instances\n(in this case, the instance with id\u003d1) and needed to find related tables\nto archive at the same time. A related table is any table that\nreferences our \"source\" table - \u0027instances\u0027 here - by way of a foreign\nkey. For each of *these* tables, we then lookup each foreign key and\njoin back to the source table, filtering by matching entries in the\nsource table. The issue here is that we\u0027re looking up every foreign key.\nWhat we actually want to do is lookup only the foreign keys that point\nback to our source table. This flaw is why we were generating the second\nSELECT above: the \u0027security_group_instance_association\u0027 has two foreign\nkeys, one pointing to our \u0027instances\u0027 table but also another pointing to\nthe \u0027security_groups\u0027 table. We want the first but not the second.\n\nResolve this by checking if the table that each foreign key points to is\nactually the source table and simply skip if not. With this issue\nresolved, we can enable errors on SAWarning warnings in general without\nany filters.\n\nChange-Id: I63208c7bd5f9f4c3d5e4a40bd0f6253d0f042a37\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/8142b9dc47b7096ab9d8180f0b5b1e52d513e2dc"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/8142b9dc47b7096ab9d8180f0b5b1e52d513e2dc"}]},"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"}]}],"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":{}}}]}