)]}'
{"id":"openstack%2Fnova~874069","triplet_id":"openstack%2Fnova~stable%2Fwallaby~I63208c7bd5f9f4c3d5e4a40bd0f6253d0f042a37","project":"openstack/nova","branch":"stable/wallaby","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-12-19 17:40:14.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:32:32.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 09:30:19.000000000","updated":"2023-12-19 17:41:38.000000000","submitted":"2023-12-19 17:40:14.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":6,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"874069","meta_rev_id":"092b404d0cee79962d9e86c90f081f67958565e6","_number":874069,"virtual_id_number":874069,"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":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},{"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"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2023-12-19 17:40:14.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"},"recommended":{"_account_id":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},"all":[{"value":1,"date":"2023-10-29 16:44:08.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},{"value":2,"date":"2023-09-07 13:25:19.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:32:32.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":1,"date":"2023-02-19 05:40:09.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":"","value":1,"default_value":0,"optional":true},"Workflow":{"approved":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"all":[{"value":0,"_account_id":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},{"value":1,"date":"2023-09-07 13:25:19.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":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":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},{"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":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":{"REVIEWER":[{"_account_id":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},{"_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"]}],"CC":[{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2023-02-16 09:30:19.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 10:16:11.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 11:09:31.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-17 07:16:15.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-17 07:16:58.000000000","updated_by":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"reviewer":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"state":"CC"},{"updated":"2023-02-19 05:40:09.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-09-07 13:25:19.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"},{"updated":"2023-10-29 16:44:08.000000000","updated_by":{"_account_id":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},"reviewer":{"_account_id":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},"state":"REVIEWER"},{"updated":"2023-12-19 13:42:11.000000000","updated_by":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"reviewer":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"state":"CC"}],"messages":[{"id":"1384bb1a0b44e377bfbb925de82a049a47df799b","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2023-02-16 09:30:19.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"328d840c1784cf0596c2a3d3f2a9be7fe522563a","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-02-16 10:16:11.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/a1a615c21fe84f62a78e315c1b4d49e7\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/148a1c4677ac49e69f95dfcf9d5fec40 : SUCCESS in 43m 47s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/949dacdff4f041efbf4bf49ff03eba6c : SUCCESS in 43m 12s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"75a3c1d71b4942068ea3d8e5685319a5633fd9d6","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2023-02-16 10:32:32.000000000","message":"Patch Set 1: Code-Review+2","accounts_in_message":[],"_revision_number":1},{"id":"9f1f4de9be4d6be19aa7e17d32c35a13a7800406","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2023-02-16 10:32:48.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"b52f7c5af2264036ed026acdd17900f1db158a3e","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2023-02-16 10:34:52.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"28bb5ba4f801ce012f75f7d5738fe4842798b4bd","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-02-16 11:09:31.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/7ae7cbbb5a594238a9b84219c86f19f8\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/e73f31d3133c43758cf44ad95e9527bd : SUCCESS in 1h 17m 09s\n- tempest-integrated-compute-centos-8-stream https://zuul.opendev.org/t/openstack/build/9a19b824d88947189d1b1c6d48b5d173 : FAILURE in 1h 36m 21s (non-voting)\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/411404de8b73433aba2ea6dc65ef6bb2 : SUCCESS in 16m 05s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/caa9920f42184d2caf62147d72342824 : SUCCESS in 8m 29s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/b97d5eaf0e05402781a38b9669f11f92 : SUCCESS in 11m 43s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/79b023c6b3a64485be7a8026744c0c28 : SUCCESS in 11m 01s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/c9facdab82784998a17b61eb68401354 : SUCCESS in 13m 54s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/76eab274e43440c3b870d5f6d11f4b6b : SUCCESS in 8m 10s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/af2a27dc558c412ba6fea1db08350cc2 : SUCCESS in 57m 38s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/5ba03690ee9b4bbba1b599060227e4d2 : FAILURE in 1h 31m 46s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/982d402588634d26b92964a9874cf0dd : SUCCESS in 44m 46s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/e6f4a1a20a9c4d70aa832fdca5e13b40 : SUCCESS in 1h 06m 44s\n- nova-next https://zuul.opendev.org/t/openstack/build/7065565d56494e238b0137da0be9b64d : SUCCESS in 1h 23m 55s\n- nova-ovs-hybrid-plug https://zuul.opendev.org/t/openstack/build/ea6d7d634f5a44e0aeed11c898c66bf5 : SUCCESS in 51m 52s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/061bbb12ae7e45bfbecaef011149f20f : FAILURE in 5m 08s (non-voting)\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/6d1a4f547c554d268b5fb37defdc777d : SUCCESS in 18m 24s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/c7334524bc9a47dab78abeb996c98707 : SUCCESS in 20m 33s (non-voting)\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/2fa6e84456cd48a3aa057b531b78cea4 : SUCCESS in 1h 11m 22s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/1fe8e1cfdd144acbb76e4596f5443d37 : SUCCESS in 54m 10s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/1f40f38c90e84375aca6eea674f28b70 : SUCCESS in 34m 39s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/1fe88970d3344a70979d6987073111c1 : FAILURE in 33m 07s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"97bbadb41bf958a0af92541a60281b97db35e9bd","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2023-02-17 07:16:15.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 tempest-dsvm-full-focal-py3 : NODE_FAILURE in 0s","accounts_in_message":[],"_revision_number":1},{"id":"2841e4fd970792a30b28a8285393ebc64db7dfc1","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"date":"2023-02-17 07:16:58.000000000","message":"Patch Set 1:\n\nBuild Failed \n\n* openstack-sriov-nova-wallaby-macvtap http://13.74.249.42/refs/changes/69/874069/1/openstack-sriov-nova-wallaby-macvtap : FAILURE\n\n* openstack-sriov-nova-wallaby-direct http://13.74.249.42/refs/changes/69/874069/1/openstack-sriov-nova-wallaby-direct : FAILURE","accounts_in_message":[],"_revision_number":1},{"id":"3899bb2b28f8c6719bf03b56c80a81a5071cc414","author":{"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"},"date":"2023-02-19 05:40:09.000000000","message":"Patch Set 1: Code-Review+1","accounts_in_message":[],"_revision_number":1},{"id":"95521633789f05cb9e0263b423bc79f2d46445b3","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2023-04-04 19:54:46.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"084aac394d19509b42491d45a9baf16871a34783","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"date":"2023-04-04 19:55:25.000000000","message":"Patch Set 1:\n\nBuild Failed \n\n* openstack-sriov-nova-wallaby-direct http://13.74.249.42/refs/changes/69/874069/1/openstack-sriov-nova-wallaby-direct : FAILURE\n\n* openstack-sriov-nova-wallaby-macvtap http://13.74.249.42/refs/changes/69/874069/1/openstack-sriov-nova-wallaby-macvtap : FAILURE","accounts_in_message":[],"_revision_number":1},{"id":"709a1ade8b2a9802fed55e935ad320b89f6022d3","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-04-04 20:33:05.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/319fe537d7cb4ea7a728e0531072bf4c\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/3cdbe1f058f24ae791a5323f9cbba15b : SUCCESS in 36m 00s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/842b5812df124ebabe154a79a052ff82 : SUCCESS in 16m 18s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"ba8ea9bc955670b78db405d131bf970951e3b166","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-04-04 21:45:11.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/06b2091b220445e08fd26a918cc754da\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/72468a207cde42fda057f05f6783259a : SUCCESS in 1h 31m 41s\n- tempest-integrated-compute-centos-8-stream https://zuul.opendev.org/t/openstack/build/8af2cb107007414c9dc72c0e399fb99e : FAILURE in 1h 44m 32s (non-voting)\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/dae161ef99c4463e9ea3e616fe8888f3 : SUCCESS in 14m 27s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/81f516b00fac44bea3fb12df10724a9c : SUCCESS in 6m 48s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/f37a16ca453c45bcb2077d83334642d5 : SUCCESS in 12m 18s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/d20779f96f9d487bac973747cd989e08 : SUCCESS in 12m 59s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/985c47c2baa34be2a41ef535c07b28ff : SUCCESS in 13m 05s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/5ea9d25561da4f7bbc0bf75374fb42ba : SUCCESS in 9m 15s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/6512b742e1cc4f51acb37d84bd2561dc : FAILURE in 1h 05m 46s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/3164dd06b2e24b8fbc3c768f8fb3839d : SUCCESS in 1h 22m 58s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/ef1eedb188f34678810f75bbf62447ce : SUCCESS in 42m 54s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/4519251f858e4e9e976621df089ef6d9 : SUCCESS in 1h 02m 27s\n- nova-next https://zuul.opendev.org/t/openstack/build/abac1679494847dd9d34f508b2b9020e : SUCCESS in 1h 26m 53s\n- nova-ovs-hybrid-plug https://zuul.opendev.org/t/openstack/build/e424780241dd42b7be48699ead5b9775 : SUCCESS in 40m 56s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/a386f1ca1a694070a9a86a9080202f96 : FAILURE in 5m 28s (non-voting)\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/1fdbb2759fcc478892e2398d1ed0f371 : SUCCESS in 17m 21s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/711161e5a30f48ea834928a8a19a854f : SUCCESS in 19m 17s (non-voting)\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/3fa87a4fcab4449a9744de543f7cde58 : SUCCESS in 53m 21s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/4667394de56f4650b2c7487a0ef2d8a6 : SUCCESS in 1h 01m 21s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/786918f280ee442ca816d5a01cd86dc3 : SUCCESS in 37m 43s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/d09001ab00bf43e4b8f457ba6d49bfc4 : FAILURE in 30m 17s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"d45e1658584ec687ac904bb8ed38362503ab5642","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2023-04-05 00:49:34.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/69/874069/1/check/tempest-dsvm-full-focal-py3/25778ce/ : FAILURE in 1h 15m 12s","accounts_in_message":[],"_revision_number":1},{"id":"ca8a47cd7e1bc98cba2b7784e593b543f4b1da7f","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":9732,"name":"Mellanox CI","email":"mlnx-openstack-ci@dev.mellanox.co.il","username":"mellanox","tags":["SERVICE_USER"]},"date":"2023-04-05 00:50:11.000000000","message":"Patch Set 1:\n\nBuild Failed \n\n* openstack-sriov-nova-wallaby-direct http://13.74.249.42/refs/changes/69/874069/1/openstack-sriov-nova-wallaby-direct : FAILURE\n\n* openstack-sriov-nova-wallaby-macvtap http://13.74.249.42/refs/changes/69/874069/1/openstack-sriov-nova-wallaby-macvtap : FAILURE","accounts_in_message":[],"_revision_number":1},{"id":"eb523c6507a835375913c6ddad024d14c7a92bd8","author":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"date":"2023-09-07 13:25:19.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"1bbcb563e6e314bb69df6a1a665b6a63a37c6ced","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-07 13:27:42.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"e061cf2306235342c298a8630618cc66183bd5f4","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-07 16:28:18.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\nhttps://zuul.opendev.org/t/openstack/buildset/aa1e92282456463f81186c226d20c811\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/a7ba212a28e84de5ac928e68e2d04e04 : SUCCESS in 1h 20m 05s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/f9f8a038bb62493694e3063d45c802e3 : SUCCESS in 8m 41s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/187fd46c19a442c08805b116fc6e246f : SUCCESS in 15m 19s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/9c4248d329c74fdf9f232f779e9b16e3 : SUCCESS in 14m 06s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/d2cefbaa49bd4a0898e1de943581bfcf : SUCCESS in 10m 31s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/a454ea5099984375bf3c88dac765d16f : SUCCESS in 50m 17s\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/f84ab441a99642e5b473113adab31806 : SUCCESS in 19m 21s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/46837b67698648b0b97342ebd3b77417 : SUCCESS in 1h 15m 24s\n- nova-next https://zuul.opendev.org/t/openstack/build/40c1a4facf7342a9a3a8eea45e84b91d : SUCCESS in 1h 40m 56s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/dd0157e5ab144f3e9e2f5a66acb930ca : SUCCESS in 5m 39s\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/52103639a1eb423fbdf65cd8922a0d1b : FAILURE in 50m 11s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/b6d05f0956544cb78906a38f581b9638 : SUCCESS in 1h 00m 54s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/a2cfd135e36143c09450b0cc1ad83e7c : SUCCESS in 1h 03m 50s","accounts_in_message":[],"_revision_number":1},{"id":"1292266583b03e10164f26aaf04f8c6e74d70241","author":{"_account_id":7634,"name":"Takashi Natsume","email":"takanattie@gmail.com","username":"natsumet"},"date":"2023-10-29 16:44:08.000000000","message":"Patch Set 1: Code-Review+1\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"3d53803e6a0a8f507b673e7ce5b6b462647ac80b","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-10-29 17:22:36.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/3c2038a4e6834937833ed2096f2264b8\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/4c6854a6ddb642b39e03b3d50be106d1 : SUCCESS in 35m 00s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/69471360054f4965a4ec91c286c94bcd : SUCCESS in 15m 38s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"b58b5337ca75ca0aea6802969166de623c2dfb64","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-10-29 18:46: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\nhttps://zuul.opendev.org/t/openstack/buildset/69cd5f8a51a64dffa08a9c137ac4bb60\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/6fefa435acd74d77a66854d0783bf2ec : SUCCESS in 1h 17m 40s\n- tempest-integrated-compute-centos-8-stream https://zuul.opendev.org/t/openstack/build/57b6413ff4c54ea79460c03ffaf53bca : FAILURE in 1h 28m 16s (non-voting)\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/8cd9330da9e14295ac1d3daffbcd7548 : SUCCESS in 19m 45s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/e06fd5054f93449eb1d73a05ef5e599b : SUCCESS in 7m 01s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/0db7350ef6a64295a69bdb205c34a90f : SUCCESS in 16m 52s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/d6fb9c460a794bdaa25a4fa639b763b1 : SUCCESS in 13m 58s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/49bb00f79b7345f0ac8584ec3c9a38b2 : SUCCESS in 12m 54s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/a79662c50d894bd6a5c4898b8f4d83cc : SUCCESS in 9m 29s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/66dccd3f5c774b509f73b147967137b6 : SUCCESS in 51m 20s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/cc4bbdb23478466a85e2be0faf75af39 : SUCCESS in 1h 09m 33s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/9169c222390746608c0b3f5a8c1a66ca : SUCCESS in 46m 22s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/62c6cc751b18490b919efafaedc99ab1 : SUCCESS in 1h 07m 47s\n- nova-next https://zuul.opendev.org/t/openstack/build/8be24a5d54024a1a8c7ea0a32ab22f31 : FAILURE in 1h 24m 43s\n- nova-ovs-hybrid-plug https://zuul.opendev.org/t/openstack/build/9324cfcdd3b04975bb4f727b46ba061f : SUCCESS in 48m 51s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/292198124fa6470c842409079e6127b7 : SUCCESS in 8m 44s (non-voting)\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/065cb0f4c2b44b3d9fdc1969a856c7b0 : SUCCESS in 17m 39s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/bcabf18260ff40f6976dbe7defb0d5ee : SUCCESS in 21m 36s (non-voting)\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/9f4ec3b0007a43d68312a7abb061c02f : SUCCESS in 53m 32s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/b470e9d1579045c39447537f6b9dee73 : SUCCESS in 47m 33s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/7efb90c3807743d3b8ac40c27c6b1a91 : SUCCESS in 28m 47s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/e2b468a8c97f4d65968a94c26d9a2a7f : FAILURE in 26m 22s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"273e4e3720828acb9298090e0419f99d334078ac","author":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"date":"2023-12-19 13:42:11.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"9d7081087d86e42922351b94ffd9545f7d6ca442","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-12-19 13:56:49.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/90e67f10c7d04182aefcf9649214f17e\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/af058219bb2d4fecb9cc27f665b5575b : SUCCESS in 10m 10s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/705080da4bdf448caa61e67f9592f2ed : SUCCESS in 13m 35s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"e89f729fb33e3b2de10ff1096ef4ed007b6c3250","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-12-19 15:10:00.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/6c26ff3fde1b4e1ab0ec733d2d526d84\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/5d455094903440afad262ee1c144b5b5 : SUCCESS in 1h 11m 59s\n- tempest-integrated-compute-centos-8-stream https://zuul.opendev.org/t/openstack/build/9ad00de1a5544b2eb477eccd47a91b13 : FAILURE in 1h 26m 52s (non-voting)\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/3c3ed575300e48dbbfa40eb644b182e3 : SUCCESS in 16m 57s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/2097e6768db148b9baea143bb819d6f9 : SUCCESS in 6m 50s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/46a54cb1332a438484a67f78d494be72 : SUCCESS in 12m 21s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/c84a53cb27484055a24b06de5f52efa5 : SUCCESS in 11m 04s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/88c78cb6c6774c97a45304d2d7c9121e : SUCCESS in 11m 45s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/5ad5dcf651ff4d589497abeb0c671305 : SUCCESS in 8m 38s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/ab4dd7fcc8bd4cb380b88ff5f4d12f7d : SUCCESS in 47m 38s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/bfba458e41b74ef8ba3b82e88356d67b : SUCCESS in 1h 05m 49s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/4b15993b823f4ac2a0a7129792c510ef : SUCCESS in 53m 29s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/b35b16bff2d740e393969f6036de84e0 : SUCCESS in 1h 10m 54s\n- nova-next https://zuul.opendev.org/t/openstack/build/2372ea946e194f40a2afc61a43e8da7e : SUCCESS in 1h 10m 24s\n- nova-ovs-hybrid-plug https://zuul.opendev.org/t/openstack/build/f1ac4d4628964e168a7c191bd67fc232 : SUCCESS in 1h 03m 12s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/223f0ed004e446cbb5440a6bb3d1c77e : SUCCESS in 5m 50s (non-voting)\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/b90f03aa95cf4bf68fd4bcdbb6839870 : SUCCESS in 19m 42s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/788784ddbf754f438751f80c022fe819 : SUCCESS in 21m 49s (non-voting)\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/82b61d40a0c548eead231363031e2272 : SUCCESS in 1h 09m 23s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/949b5e07e9574534848e511cf7beece6 : SUCCESS in 1h 04m 18s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/e21aac4c5ad84b65a9c17559d2b62971 : SUCCESS in 39m 11s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/9b10c147508b401fbf9449dac83db2ec : FAILURE in 50m 34s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"3d3601580bf8fc156268e953dd63f191f95733de","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-12-19 15:10:57.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"0b022eee36d81b35c13a2e24e6ce274e660e6b6c","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-12-19 17:40:14.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/291996ce0b4749d598b2ebd644db56da\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/092e2ada3e69463b8e89bcd9f5807180 : SUCCESS in 1h 26m 27s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/b03a4e4a23f145a29589519de4b37af1 : SUCCESS in 7m 19s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/bf7492a39444481e9b83a5b79e676b3f : SUCCESS in 13m 15s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/32563d230814484cbdfae116bc3de2ba : SUCCESS in 13m 26s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/d8c7f57858c44c83ae091f3bc3132391 : SUCCESS in 8m 07s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/17d1e36ea7ae48189b5f880da14fe40f : SUCCESS in 1h 01m 47s\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/f0116710176f4954a19082f661544bff : SUCCESS in 19m 42s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/131866405b864056a29399296bb4bef7 : SUCCESS in 1h 17m 59s\n- nova-next https://zuul.opendev.org/t/openstack/build/209e4db17b2e44b1b631f7f20079fb77 : SUCCESS in 1h 32m 03s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/e8b0bf7c7b874d51aad2b0fb1ef368aa : SUCCESS in 5m 45s\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/ac99197875b34e51868887e098282dd3 : SUCCESS in 1h 23m 25s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/fc818e3b876744a3a108632b78c3a2c0 : SUCCESS in 1h 22m 19s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/18f938932a1248a997013a6af0365634 : SUCCESS in 1h 05m 48s","accounts_in_message":[],"_revision_number":1},{"id":"746611109c365a98e7784497930f5e0af9b168ff","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-12-19 17:40:14.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":1},{"id":"092b404d0cee79962d9e86c90f081f67958565e6","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-12-19 17:41:38.000000000","message":"Patch Set 1:\n\nBuild succeeded (promote pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/0f1c152ddc5f4b15b39c8a194a14dd0c\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/b43bf0da13c7418d8ef7d8c495fecc99 : SUCCESS in 1m 02s","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"5d0325a78b2a5f7a9109290fb23d46a841042da6","revisions":{"5d0325a78b2a5f7a9109290fb23d46a841042da6":{"kind":"REWORK","_number":1,"created":"2023-02-16 09:30:19.000000000","uploader":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"ref":"refs/changes/69/874069/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/69/874069/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/69/874069/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/69/874069/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/69/874069/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/69/874069/1"}}},"commit":{"parents":[{"commit":"797c5fa9debf86049b86084a86a5b939e11592d4","subject":"Merge \"[stable-only][cve] Check VMDK create-type against an allowed list\" into stable/wallaby","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/797c5fa9debf86049b86084a86a5b939e11592d4"}]}],"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 09:23:57.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/objects/cell_mapping.py\n    nova/tests/fixtures/nova.py\n\nNOTE(melwitt): The conflicts are because\n\n  * Change Ia5304c552ce552ae3c5223a2bfb3a9cd543ec57c (db: Post\n    reshuffle cleanup) is not in Wallaby\n\n  * The WarningsFixture is in nova/tests/fixtures.py in Wallaby and\n    change I07be8e16381592fc177eeecd4f0d7f2db93eb09d (tests: Enable\n    SADeprecationWarning warnings) is also not in Wallaby\n\nChange-Id: I63208c7bd5f9f4c3d5e4a40bd0f6253d0f042a37\nSigned-off-by: Stephen Finucane \u003csfinucan@redhat.com\u003e\n(cherry picked from commit 8142b9dc47b7096ab9d8180f0b5b1e52d513e2dc)\n(cherry picked from commit ce2cc54bfe236554badb9f6bf53a958417e5525d)\n(cherry picked from commit 5b1d487d7fc49580a606b68e1271cae5f2f2df87)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/5d0325a78b2a5f7a9109290fb23d46a841042da6"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/5d0325a78b2a5f7a9109290fb23d46a841042da6"}]},"branch":"refs/heads/stable/wallaby"}},"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":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"}},{"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"},"submittability_expression_result":{"expression":"is:true","fulfilled":true,"status":"NOT_EVALUATED","passing_atoms":[],"failing_atoms":[],"atom_explanations":{}}},{"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":{}}}]}