)]}'
{"id":"openstack%2Fnova~874065","triplet_id":"openstack%2Fnova~stable%2Fyoga~I63208c7bd5f9f4c3d5e4a40bd0f6253d0f042a37","project":"openstack/nova","branch":"stable/yoga","attention_set":{},"removed_from_attention_set":{"4690":{"account":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"last_update":"2023-04-04 19:34:28.000000000","reason":"Change was submitted"},"15334":{"account":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"last_update":"2023-02-16 10:30:27.000000000","reason":"\u003cGERRIT_ACCOUNT_15334\u003e replied on the change","reason_account":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"}}},"hashtags":[],"change_id":"I63208c7bd5f9f4c3d5e4a40bd0f6253d0f042a37","subject":"db: Resolve additional SAWarning warnings","status":"MERGED","created":"2023-02-16 08:51:59.000000000","updated":"2023-04-04 19:35:38.000000000","submitted":"2023-04-04 19:34:28.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":4,"unresolved_comment_count":1,"has_review_started":true,"submission_id":"874065","meta_rev_id":"ea46c150c25c8d466322b899db21fc5aeafa67ba","_number":874065,"virtual_id_number":874065,"owner":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"value":0,"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"value":0,"_account_id":34860,"name":"Amit Uniyal","email":"auniyal@redhat.com","username":"auniyal"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2023-04-04 19:34:28.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"}],"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":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"all":[{"value":2,"date":"2023-04-04 16:35:08.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"value":2,"date":"2023-02-16 10:30:27.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"value":1,"date":"2023-03-22 14:48:24.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":34860,"name":"Amit Uniyal","email":"auniyal@redhat.com","username":"auniyal"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":1,"date":"2023-02-19 05:28:39.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"}],"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":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"all":[{"value":1,"date":"2023-04-04 16:35:08.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"value":0,"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"value":0,"_account_id":34860,"name":"Amit Uniyal","email":"auniyal@redhat.com","username":"auniyal"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"value":0,"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"value":0,"_account_id":34860,"name":"Amit Uniyal","email":"auniyal@redhat.com","username":"auniyal"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"}],"values":{" 0":"Default Priority","+1":"Contributor Review Promise","+2":"Core Review Promise"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"CC":[{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]}],"REVIEWER":[{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":34860,"name":"Amit Uniyal","email":"auniyal@redhat.com","username":"auniyal"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2023-02-16 08:51:59.000000000","updated_by":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"reviewer":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"state":"REVIEWER"},{"updated":"2023-02-16 09:36:59.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":"2023-02-16 10:56: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":"2023-02-18 09:32:43.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":"2023-02-19 05:28:39.000000000","updated_by":{"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"},"reviewer":{"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"},"state":"REVIEWER"},{"updated":"2023-03-22 12:57:56.000000000","updated_by":{"_account_id":34860,"name":"Amit Uniyal","email":"auniyal@redhat.com","username":"auniyal"},"reviewer":{"_account_id":34860,"name":"Amit Uniyal","email":"auniyal@redhat.com","username":"auniyal"},"state":"CC"},{"updated":"2023-03-22 14:48:24.000000000","updated_by":{"_account_id":34860,"name":"Amit Uniyal","email":"auniyal@redhat.com","username":"auniyal"},"reviewer":{"_account_id":34860,"name":"Amit Uniyal","email":"auniyal@redhat.com","username":"auniyal"},"state":"REVIEWER"},{"updated":"2023-04-04 16:35:08.000000000","updated_by":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"reviewer":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"state":"REVIEWER"}],"messages":[{"id":"9e63883e86f61e4cc3a572548186ea4fee3d1f6c","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2023-02-16 08:51:59.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"44d474ad3a3ce4a03ea574552fa9e656b77f19d2","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-02-16 09:36:59.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/0561e6f6f7b34a69aa48f7ea27803d91\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/9033c1f6a66c4e69b6192ee458c2053b : SUCCESS in 42m 58s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/f15c0ed8e446424ab4def5870c10bfc9 : SUCCESS in 36m 52s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"32c2ed402935d1d71a628338d73c639b407519b5","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2023-02-16 10:30:27.000000000","message":"Patch Set 1: Code-Review+2\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"785065deb2a17a7baecc0bbf04c123387dd6f1bd","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-02-16 10:56:16.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\nhttps://zuul.opendev.org/t/openstack/buildset/1c375794466841fc8d615d674da858af\n\n- grenade-skip-level https://zuul.opendev.org/t/openstack/build/cbfe5ab336a949b194e7cc298c86c942 : SUCCESS in 1h 08m 01s (non-voting)\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/cfc80d641ca644dfbb725099e679bc1f : SUCCESS in 1h 43m 09s\n- tempest-integrated-compute-centos-8-stream https://zuul.opendev.org/t/openstack/build/e2efa7858c924fcbb2a9991dd2079c19 : FAILURE in 44m 30s (non-voting)\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/16bd702ef0a24d5c82ffe9b9dce04574 : SUCCESS in 59m 04s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/4c6462ae96d445dc8697f412a533a20e : SUCCESS in 16m 38s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/34a298239cc44811b5d89f2ce497d98d : SUCCESS in 13m 28s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/668a454758144f6fb9bbfd7bfef69e7b : SUCCESS in 12m 00s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/7bc8b2f293104da380f9e3a23eb495c0 : SUCCESS in 12m 35s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/5131b09a096c4914b4436159881aa0b4 : SUCCESS in 12m 23s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/1afa980ec78845cd973db78d268a9d86 : SUCCESS in 1h 01m 00s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/c0d3cd2bc21145c28d32a1ed5c55204b : SUCCESS in 1h 11m 35s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/c699c5d81810470d9636d5c5b508e10e : SUCCESS in 55m 03s\n- nova-live-migration-ceph https://zuul.opendev.org/t/openstack/build/038a30745520435a9fe196f09777d36c : SUCCESS in 53m 09s (non-voting)\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/e01d925038724c67a9ed3964f791c883 : SUCCESS in 1h 38m 33s\n- nova-next https://zuul.opendev.org/t/openstack/build/8c443c83f6484f899d4e126f29da2dcd : SUCCESS in 1h 39m 48s\n- nova-ovs-hybrid-plug https://zuul.opendev.org/t/openstack/build/81e7b9856d274a4ea7376308389509af : SUCCESS in 55m 20s\n- nova-emulation https://zuul.opendev.org/t/openstack/build/1dcb7d4368254f8ba3d8e579b6de597a : FAILURE in 35m 20s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/86f43b7b190c4771976d708a2415d3ae : SUCCESS in 5m 24s (non-voting)\n- nova-tox-functional-centos8-py36 https://zuul.opendev.org/t/openstack/build/0f7863eef21348ad809c685870a37a59 : SUCCESS in 21m 24s\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/7ca0486e5e6246a5828d50e8f2d71dcd : SUCCESS in 18m 54s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/cfcb9ce1cefd4fac8acf22cc5810cf45 : SUCCESS in 21m 29s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/fc7162ba8a754022b9a0c9d96eff2144 : SUCCESS in 1h 17m 06s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/aab0b71d2391419f96f46cc667988559 : SUCCESS in 1h 02m 22s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/a4427525532a4daa827a8a7f18cf1e34 : SUCCESS in 27m 00s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/c1d4f5695eb34e5fa1113f14c344513f : FAILURE in 36m 31s (non-voting)\n- tempest-centos8-stream-fips https://zuul.opendev.org/t/openstack/build/2658ccf22fd1426ebc58254b4ba96f2d : FAILURE in 34m 06s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"0da910238bb3ca4ce1d39b9ffdd62238529105d9","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2023-02-18 09:32:43.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/81c4750ad7084ceaa61b719c3f31a22a : FAILURE in 1h 22m 56s","accounts_in_message":[],"_revision_number":1},{"id":"8f51cbded15a1a978a1a33b1b5bd7f3a1d2f970b","author":{"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"},"date":"2023-02-19 05:28:39.000000000","message":"Patch Set 1: Code-Review+1","accounts_in_message":[],"_revision_number":1},{"id":"776919eed835b78803de1fee6c635e5691b551ce","author":{"_account_id":34860,"name":"Amit Uniyal","email":"auniyal@redhat.com","username":"auniyal"},"date":"2023-03-22 12:57:56.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"72c9a01fcddd66dcaa948daa70889ae1a1d8dff1","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-03-22 13:12:20.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/dbc044e4c61d4d2998a1ee5060999d41\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/e30246c9a7e046f39c64e2c735109a57 : SUCCESS in 13m 01s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/4ed438356d6341e4a2d6b2815d8d6b4b : SUCCESS in 10m 38s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"cec8f7907cedaacf5aaa515f89dbe094226de8eb","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-03-22 14:47:34.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/09164787a9e741b6b589e39b0d0efbce\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/65705d7029774dacbb35e6c14b5b22cf : SUCCESS in 1h 32m 54s\n- tempest-integrated-compute-centos-8-stream https://zuul.opendev.org/t/openstack/build/cd1011893f3b4607a007bbb0c2d5d04e : FAILURE in 43m 00s (non-voting)\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/41d7edf9186b452cab7c8ca6656bf310 : SUCCESS in 57m 17s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/4454b1506b9c48769c9e5c56bc32d0c5 : SUCCESS in 18m 19s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/24a2a4303bac4560991e3a9bc6678028 : SUCCESS in 13m 27s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/6f08b2ca0d3f4b0cb0f61e187e4d96bc : SUCCESS in 12m 14s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/4928572c2e2c4746aa673ec9147f8c4b : SUCCESS in 13m 04s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/c03cb2d3530243aeb14d201cfd03cd49 : SUCCESS in 10m 44s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/0f08a8a5f18c42659e1698368ce39266 : SUCCESS in 1h 06m 24s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/59a25f7a22464c8b83b2e100021373b1 : SUCCESS in 55m 58s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/d2d08c99c99b49ac8b73b0544021d5d2 : SUCCESS in 51m 17s\n- nova-live-migration-ceph https://zuul.opendev.org/t/openstack/build/099f897137e64befa034e5f337e448f6 : SUCCESS in 55m 59s (non-voting)\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/9509d9739b1c46ecaae08dfcefc54442 : SUCCESS in 1h 42m 19s\n- nova-next https://zuul.opendev.org/t/openstack/build/4d3e42e3886544ac85be761bd4823666 : SUCCESS in 1h 36m 04s\n- nova-ovs-hybrid-plug https://zuul.opendev.org/t/openstack/build/fcda9ae1077a4cf2a43cea86a8529b25 : SUCCESS in 1h 00m 15s\n- nova-emulation https://zuul.opendev.org/t/openstack/build/a4e71240625e43dfb3d7a880b203e4ff : SUCCESS in 52m 25s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/441fb54b3f7649e7b669c9b0f32ac99d : SUCCESS in 6m 09s (non-voting)\n- nova-tox-functional-centos8-py36 https://zuul.opendev.org/t/openstack/build/88602c9ae4c84d3ab1c01473276406e4 : SUCCESS in 22m 24s\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/d66a4a0d97794805a91535bd22ca7af2 : SUCCESS in 21m 26s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/069fc4e4373c43d580311691400430a3 : SUCCESS in 21m 16s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/02b4cf1fd5a54216bb359e173e083c51 : SUCCESS in 1h 15m 47s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/96199c6fd6d7422cb264a1c21d1d5e1b : SUCCESS in 46m 06s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/97bfcbc1b6254d9bb643b2ca0b289594 : SUCCESS in 26m 47s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/7c065418bedd458eba2c093c7af72a9b : FAILURE in 30m 21s (non-voting)\n- tempest-centos8-stream-fips https://zuul.opendev.org/t/openstack/build/8e8a2a21c3424090a7f57dee03b3730c : FAILURE in 34m 05s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"7df2efab4143a6d161a7130e725387fe10f25602","author":{"_account_id":34860,"name":"Amit Uniyal","email":"auniyal@redhat.com","username":"auniyal"},"date":"2023-03-22 14:48:24.000000000","message":"Patch Set 1: Code-Review+1","accounts_in_message":[],"_revision_number":1},{"id":"96bf6c2cd85a882473d7031d50d88c6ec39699a0","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2023-03-22 17:28:06.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 https://ftp2.osuosl.org/pub/ppc64el/openstack/nova/65/874065/1/check/tempest-dsvm-full-focal-py3/5e24f72/ : FAILURE in 1h 05m 26s","accounts_in_message":[],"_revision_number":1},{"id":"3cfc53d98b0f34140534936b23453281911eedb7","author":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"date":"2023-04-04 16:35:08.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1\n\n(2 comments)","accounts_in_message":[],"_revision_number":1},{"id":"073eb2cfa09367ab693dbc9aaf00be0a9ba07395","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-04-04 16:35:55.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"454beb2039ee1443a3017c6443d1de1597bb2759","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-04-04 19:34:28.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/1cf2392f78824767b8228f9b17ee69ba\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/2cc464bf402a40ff9a211ac7951fc46c : SUCCESS in 1h 28m 44s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/82d741a9f331403eb3e2f2dec7392788 : SUCCESS in 1h 02m 05s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/ec9c0c7081894a60a41e968b3cefea72 : SUCCESS in 13m 12s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/8377b52f7869430e96b37b71e04b5ee5 : SUCCESS in 13m 14s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/da3926a0830b431dba30e8e9f89ea54b : SUCCESS in 12m 24s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/0c14559fb51547b9b8076786d3625a61 : SUCCESS in 9m 45s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/b8085ba4a32540b3ab52e707900f18c9 : SUCCESS in 53m 50s\n- nova-live-migration-ceph https://zuul.opendev.org/t/openstack/build/d4961856d4d2403c943668f97795cae6 : SUCCESS in 36m 38s (non-voting)\n- nova-tox-functional-centos8-py36 https://zuul.opendev.org/t/openstack/build/142475b6ea864600a44959cb33e6e3e4 : SUCCESS in 23m 25s\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/9e9dac7f6c204050ba3fd5f8b73e04d0 : SUCCESS in 20m 22s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/95df2f4f8561497fbbc645e0378d9f06 : SUCCESS in 24m 29s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/9bad569a59934cec81a7a2ea4cb73306 : SUCCESS in 1h 36m 59s\n- nova-next https://zuul.opendev.org/t/openstack/build/ecaf033a46b64f5baf17bc5b72d92da8 : SUCCESS in 1h 45m 31s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/d821c1f03a5a44da9e14f84c0e0325d0 : SUCCESS in 5m 06s\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/e774b7d7f3064414905f9ac7c94f0b78 : SUCCESS in 57m 02s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/5cd9ccfe0db04403bb8d92a4cb5a9710 : SUCCESS in 52m 12s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/6300ba09b1c940919fcff10d3e6ed90f : SUCCESS in 53m 48s\n- tempest-integrated-compute-centos-8-stream https://zuul.opendev.org/t/openstack/build/2d5df2a6902d48c88594ca89c803833e : FAILURE in 43m 08s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"ad64b9c5aa83dcfb3d8eab6c651d837000d10232","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-04-04 19:34:28.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":1},{"id":"ea46c150c25c8d466322b899db21fc5aeafa67ba","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-04-04 19:35:38.000000000","message":"Patch Set 1:\n\nBuild succeeded (promote pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/324bc891ae2f49f89e863755de20f515\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/6e6ccaad01ee4b7d97c8ce9ce8db062e : SUCCESS in 49s","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"ce2cc54bfe236554badb9f6bf53a958417e5525d","revisions":{"ce2cc54bfe236554badb9f6bf53a958417e5525d":{"kind":"REWORK","_number":1,"created":"2023-02-16 08:51:59.000000000","uploader":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"ref":"refs/changes/65/874065/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/65/874065/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/65/874065/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/65/874065/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/65/874065/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/65/874065/1"}}},"commit":{"parents":[{"commit":"eada760a21302a1e353f7b858ba9b55acf244d01","subject":"Merge \"Accept both 1 and Y as AMD SEV KVM kernel param value\" into stable/yoga","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/eada760a21302a1e353f7b858ba9b55acf244d01"}]}],"author":{"name":"Stephen Finucane","email":"sfinucan@redhat.com","date":"2022-04-08 10:38:54.000000000","tz":60},"committer":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2023-02-16 08:50:31.000000000","tz":0},"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\nConflicts:\n    nova/tests/fixtures/nova.py\n\nNOTE(melwitt): The conflict is because change\nIa1da21577d859885838de10110dd473f72af285d (db: Trivial rewrapping of\nwarning filters) is not in Yoga.\n\nChange-Id: I63208c7bd5f9f4c3d5e4a40bd0f6253d0f042a37\nSigned-off-by: Stephen Finucane \u003csfinucan@redhat.com\u003e\n(cherry picked from commit 8142b9dc47b7096ab9d8180f0b5b1e52d513e2dc)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/ce2cc54bfe236554badb9f6bf53a958417e5525d"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/ce2cc54bfe236554badb9f6bf53a958417e5525d"}]},"branch":"refs/heads/stable/yoga"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~DefaultSubmitRule","status":"CLOSED","labels":[{"label":"Verified","status":"MAY","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"MAY","applied_by":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"}},{"label":"Workflow","status":"MAY","applied_by":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"}},{"label":"Review-Priority","status":"MAY"}]}],"submit_requirements":[{"name":"Verified","description":"Verified in gate by CI","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Verified\u003dMAX AND -label:Verified\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Verified\u003dMAX"],"failing_atoms":["label:Verified\u003dMIN"],"atom_explanations":{}}},{"name":"Code-Review","description":"Code reviewed by core reviewer","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Code-Review\u003dMAX AND -label:Code-Review\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Code-Review\u003dMAX"],"failing_atoms":["label:Code-Review\u003dMIN"],"atom_explanations":{}}},{"name":"Review-Priority","description":"Review Priority","status":"NOT_APPLICABLE","is_legacy":false,"applicability_expression_result":{"fulfilled":false,"status":"FAIL"}},{"name":"Workflow","description":"Approved for gate by core reviewer","status":"SATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Workflow\u003dMAX AND -label:Workflow\u003dMIN","fulfilled":true,"status":"PASS","passing_atoms":["label:Workflow\u003dMAX"],"failing_atoms":["label:Workflow\u003dMIN"],"atom_explanations":{}}}]}