)]}'
{"id":"openstack%2Fironic~892621","triplet_id":"openstack%2Fironic~master~I62c12d0ec9809f3b756f1b6b796ea5dd11b3e023","project":"openstack/ironic","branch":"master","attention_set":{},"removed_from_attention_set":{"10342":{"account":{"_account_id":10342,"name":"Jay Faulkner","display_name":"JayF","email":"jay@jvf.cc","username":"JayF","status":"youtube.com/@oss-gr / podcast.gr-oss.io"},"last_update":"2023-08-23 20:16:46.000000000","reason":"\u003cGERRIT_ACCOUNT_10342\u003e replied on the change","reason_account":{"_account_id":10342,"name":"Jay Faulkner","display_name":"JayF","email":"jay@jvf.cc","username":"JayF","status":"youtube.com/@oss-gr / podcast.gr-oss.io"}},"11655":{"account":{"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},"last_update":"2024-01-03 23:26:19.000000000","reason":"Change was abandoned"}},"hashtags":[],"change_id":"I62c12d0ec9809f3b756f1b6b796ea5dd11b3e023","subject":"DB: Un-nest some returns from dbapi","status":"ABANDONED","created":"2023-08-23 19:48:57.000000000","updated":"2024-01-03 23:26:19.000000000","total_comment_count":3,"unresolved_comment_count":1,"has_review_started":true,"meta_rev_id":"018e079a94f687d9c7deff0386a356d7529c4acf","_number":892621,"virtual_id_number":892621,"owner":{"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"_account_id":10342,"name":"Jay Faulkner","display_name":"JayF","email":"jay@jvf.cc","username":"JayF","status":"youtube.com/@oss-gr / podcast.gr-oss.io"},{"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"},{"tag":"autogenerated:zuul:check","value":1,"date":"2023-08-24 11:16:26.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"}],"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","value":1,"default_value":0,"optional":true},"Code-Review":{"rejected":{"_account_id":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"},"all":[{"value":2,"date":"2023-08-23 20:16:46.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":10342,"name":"Jay Faulkner","display_name":"JayF","email":"jay@jvf.cc","username":"JayF","status":"youtube.com/@oss-gr / podcast.gr-oss.io"},{"value":2,"date":"2023-08-24 09:05:07.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":-2,"date":"2023-08-24 09:39:11.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"}],"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":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"},"all":[{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":10342,"name":"Jay Faulkner","display_name":"JayF","email":"jay@jvf.cc","username":"JayF","status":"youtube.com/@oss-gr / podcast.gr-oss.io"},{"value":1,"date":"2023-08-24 09:05:07.000000000","permitted_voting_range":{"min":-1,"max":1},"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":-1,"date":"2023-08-24 09:39:11.000000000","permitted_voting_range":{"min":-1,"max":1},"_account_id":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Backport-Candidate":{"all":[{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":10342,"name":"Jay Faulkner","display_name":"JayF","email":"jay@jvf.cc","username":"JayF","status":"youtube.com/@oss-gr / podcast.gr-oss.io"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"}],"values":{"-1":"Do Not Backport"," 0":"Backport Review Needed","+1":"Should Backport"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"CC":[{"_account_id":14629,"name":"HPE Proliant","email":"proliantutils@gmail.com","username":"proliantci"}],"REVIEWER":[{"_account_id":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"},{"_account_id":10342,"name":"Jay Faulkner","display_name":"JayF","email":"jay@jvf.cc","username":"JayF","status":"youtube.com/@oss-gr / podcast.gr-oss.io"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2023-08-23 19:51:31.000000000","updated_by":{"_account_id":10342,"name":"Jay Faulkner","display_name":"JayF","email":"jay@jvf.cc","username":"JayF","status":"youtube.com/@oss-gr / podcast.gr-oss.io"},"reviewer":{"_account_id":10342,"name":"Jay Faulkner","display_name":"JayF","email":"jay@jvf.cc","username":"JayF","status":"youtube.com/@oss-gr / podcast.gr-oss.io"},"state":"REVIEWER"},{"updated":"2023-08-23 20:06:33.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-08-23 20:45:13.000000000","updated_by":{"_account_id":14629,"name":"HPE Proliant","email":"proliantutils@gmail.com","username":"proliantci"},"reviewer":{"_account_id":14629,"name":"HPE Proliant","email":"proliantutils@gmail.com","username":"proliantci"},"state":"CC"},{"updated":"2023-08-23 21:21:34.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-08-24 09:04:57.000000000","updated_by":{"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"},"reviewer":{"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"},"state":"CC"},{"updated":"2023-08-24 09:05:07.000000000","updated_by":{"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"},"reviewer":{"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"},"state":"REVIEWER"},{"updated":"2023-08-24 09:39:11.000000000","updated_by":{"_account_id":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"},"reviewer":{"_account_id":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"},"state":"REVIEWER"}],"messages":[{"id":"d546a4cdb5919e6340ad3f78d98a5f06558b41b8","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},"date":"2023-08-23 19:48:57.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"82f866918428267293c3b81fe11a34bb4e157063","author":{"_account_id":10342,"name":"Jay Faulkner","display_name":"JayF","email":"jay@jvf.cc","username":"JayF","status":"youtube.com/@oss-gr / podcast.gr-oss.io"},"date":"2023-08-23 19:51:31.000000000","message":"Patch Set 1: Code-Review+1\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"657f3bf3bcadd4c4244fd8cef4dce0e1d6750b51","author":{"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},"date":"2023-08-23 19:54:46.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"a742706f62f632b9652866b8c0433963e7853077","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-08-23 20:06:33.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/7b3084d21219404f8c7b41aeb9c8d90f\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/f14001adb92545ddb6be0a5f2248e014 : SUCCESS in 14m 55s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/1e57cd23fc70497dbc408f0338f544b1 : SUCCESS in 6m 07s (non-voting)\n- openstack-tox-py310-arm64 https://zuul.opendev.org/t/openstack/build/be2e186b64924fd8a44c810cea53be61 : SUCCESS in 14m 56s (non-voting)\n- openstack-tox-py311-arm64 https://zuul.opendev.org/t/openstack/build/ee51cb3db492409fa05e2a927c8d21f3 : RETRY_LIMIT in 1m 24s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"0de8e864e7008d4fbb19e180af45373e3bc8689e","author":{"_account_id":10342,"name":"Jay Faulkner","display_name":"JayF","email":"jay@jvf.cc","username":"JayF","status":"youtube.com/@oss-gr / podcast.gr-oss.io"},"date":"2023-08-23 20:16:46.000000000","message":"Patch Set 1: Code-Review+2","accounts_in_message":[],"_revision_number":1},{"id":"b030c5e4985232bbd0c31a6d11433b6f84fdf43b","author":{"_account_id":14629,"name":"HPE Proliant","email":"proliantutils@gmail.com","username":"proliantci"},"date":"2023-08-23 20:45:13.000000000","message":"Patch Set 1:\n\nBuild succeeded.\n\n- HPE-Proliant-ironic-container-standalone-wholedisk-ilo-virtual-media-direct https://hpproliant.github.io/hpeproliant.github.io/logs/21/892621/1/check/HPE-Proliant-ironic-container-standalone-wholedisk-ilo-virtual-media-direct/5dfca7b/5dfca7b.html : SUCCESS in 16m 43s\n- HPE-Proliant-ironic-container-standalone-wholedisk-ilo-ipxe-direct https://hpproliant.github.io/hpeproliant.github.io/logs/21/892621/1/check/HPE-Proliant-ironic-container-standalone-wholedisk-ilo-ipxe-direct/a2a0dcb/a2a0dcb.html : SUCCESS in 18m 36s\n- HPE-Proliant-ironic-container-standalone-wholedisk-ilo-uefi-https-direct https://hpproliant.github.io/hpeproliant.github.io/logs/21/892621/1/check/HPE-Proliant-ironic-container-standalone-wholedisk-ilo-uefi-https-direct/8c26f91/8c26f91.html : SUCCESS in 55m 05s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"0bfdbd6a33e4525eab3d40341de5b2d507d786a5","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-08-23 21:21:34.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/32e5e11ea6064506b8f21dc9db737e30\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/514281540f6148529f1768ac9843addc : SUCCESS in 14m 00s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/30cc3cc0c26d4059a025886a3d7b4b5c : SUCCESS in 5m 03s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/562b7a88d42142d395d298cccb9784b2 : SUCCESS in 9m 16s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/5725f864f29149d8a0ccf0f7ea8e176f : SUCCESS in 9m 05s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/37bdb0cac99843f89c1c57d352349a8a : SUCCESS in 8m 55s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/fda3a9e8660148c1a9569665ce05d102 : RETRY_LIMIT in 1m 36s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/53228a12683a44618a2bfe3b53122980 : SUCCESS in 14m 12s\n- ironic-tox-unit-mysql-migrations https://zuul.opendev.org/t/openstack/build/6701a72ea16042b4ba301f8afe1850e5 : SUCCESS in 5m 17s\n- ironic-tox-unit-with-sqlalchemy-2x https://zuul.opendev.org/t/openstack/build/49bc55e2339d465f97e804e03a94e1f3 : SUCCESS in 9m 17s\n- ironic-tox-unit-with-driver-libs https://zuul.opendev.org/t/openstack/build/fa188af2489147e8a41278eb2927174f : SUCCESS in 8m 52s\n- ironic-cross-sushy https://zuul.opendev.org/t/openstack/build/780615d8446f4186864e2262b6780905 : SUCCESS in 8m 08s (non-voting)\n- ironic-tempest-functional-python3 https://zuul.opendev.org/t/openstack/build/fd996a9dccab40709f4911865ae073ac : SUCCESS in 30m 52s\n- ironic-tempest-functional-rbac-scope-enforced https://zuul.opendev.org/t/openstack/build/b40f8749fc61465b9e59cd79694400f6 : SUCCESS in 33m 06s (non-voting)\n- ironic-grenade https://zuul.opendev.org/t/openstack/build/e4b21e2a0a194cdbb3233af2ae7970f6 : SUCCESS in 1h 19m 51s\n- ironic-grenade-skip-level https://zuul.opendev.org/t/openstack/build/4bf37407c04f419fb3ea9bf843e1de97 : SUCCESS in 1h 07m 20s (non-voting)\n- ironic-standalone https://zuul.opendev.org/t/openstack/build/71a88f37349a4a58980e1efb88139543 : SUCCESS in 42m 01s\n- ironic-standalone-redfish https://zuul.opendev.org/t/openstack/build/90574a72ceae428a9faf896f339bea4e : SUCCESS in 1h 03m 40s\n- ironic-tempest-bios-redfish-pxe https://zuul.opendev.org/t/openstack/build/abf26335aee047bc9b11851dc8b77114 : SUCCESS in 37m 13s\n- ironic-tempest-uefi-redfish-vmedia https://zuul.opendev.org/t/openstack/build/456108b8bff44944a2b808897672564b : SUCCESS in 47m 26s\n- ironic-tempest-wholedisk-bios-snmp-pxe https://zuul.opendev.org/t/openstack/build/39310b711a964ce1bc26433e44303537 : SUCCESS in 45m 30s\n- ironic-tempest-partition-uefi-ipmi-pxe https://zuul.opendev.org/t/openstack/build/75a535a092054c5988f03d034b935032 : SUCCESS in 55m 24s\n- ironic-tempest-ipa-wholedisk-direct-tinyipa-multinode https://zuul.opendev.org/t/openstack/build/aa7849ed69ab47589aeb59882fbb2285 : SUCCESS in 1h 30m 36s (non-voting)\n- ironic-tempest-bios-ipmi-direct-tinyipa https://zuul.opendev.org/t/openstack/build/d02679755ffa470d8e6c36fc5db7c995 : SUCCESS in 1h 08m 54s\n- ironic-tempest-bfv https://zuul.opendev.org/t/openstack/build/ce836d5aa0f342ca86be84f125f2297c : SUCCESS in 43m 28s\n- ironic-tempest-ipa-partition-uefi-pxe-grub2 https://zuul.opendev.org/t/openstack/build/6c1c68df4d1644efb984c33d52506865 : SUCCESS in 43m 56s\n- metalsmith-integration-glance-centos8-legacy https://zuul.opendev.org/t/openstack/build/0deb8e8d19c44c48b0170ab65e38ea5b : FAILURE in 38m 36s\n- metal3-integration https://zuul.opendev.org/t/openstack/build/6253d9cd11d64b2081db1f212bd39138 : SUCCESS in 34m 27s\n- ironic-tox-bandit https://zuul.opendev.org/t/openstack/build/d76551311ddf4265b3d779fb33d97afa : SUCCESS in 4m 56s (non-voting)\n- ironic-inspector-tempest https://zuul.opendev.org/t/openstack/build/37fe91ecccc749bfbff0d69912be28b4 : SUCCESS in 1h 04m 33s (non-voting)\n- ironic-inspector-tempest-managed-non-standalone https://zuul.opendev.org/t/openstack/build/a9673e4b97e341edaca898ac046133a4 : FAILURE in 46m 48s (non-voting)\n- ironic-tempest-ipa-wholedisk-bios-ipmi-direct-dib https://zuul.opendev.org/t/openstack/build/c0ef3742a23447e59750a0c84ad6639d : SUCCESS in 51m 45s (non-voting)\n- ironic-tempest-ipxe-ipv6 https://zuul.opendev.org/t/openstack/build/11d845e34d0e4649877fca84d80f1e4a : SUCCESS in 56m 05s (non-voting)\n- ironic-standalone-anaconda https://zuul.opendev.org/t/openstack/build/02c0d538f6624b37a71af141e22b2357 : SUCCESS in 34m 11s (non-voting)\n- ironic-inspector-tempest-rbac-scope-enforced https://zuul.opendev.org/t/openstack/build/1979d30d86d543349a26f224055a4432 : SUCCESS in 48m 43s (non-voting)\n- bifrost-integration-tinyipa-ubuntu-focal https://zuul.opendev.org/t/openstack/build/eb9b6ebaece6481787022cc290299499 : SUCCESS in 35m 22s (non-voting)\n- bifrost-integration-redfish-vmedia-uefi-centos-9 https://zuul.opendev.org/t/openstack/build/61e9db1717734de591d5a54aa828c575 : SUCCESS in 41m 24s (non-voting)\n- ironic-tempest-pxe_ipmitool-postgres https://zuul.opendev.org/t/openstack/build/71b2529326424ea3a513d4e291cbaa12 : SUCCESS in 43m 16s (non-voting)\n- bifrost-benchmark-ironic https://zuul.opendev.org/t/openstack/build/daad5a75d8ba4106abb53e22b11a7cda : SUCCESS in 38m 21s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"6f2139557db189a1bd07d5f9478f8d480e35eb77","author":{"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"},"date":"2023-08-24 09:04:57.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"d1ad2441efbd93f41b64dab2ff8d68f60a499231","author":{"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"},"date":"2023-08-24 09:05:07.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":1},{"id":"5c546ab6958075caba0b82b2ecc46521a0c662c0","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-08-24 09:16:23.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/27e29a885fb84760990421bbd2e56ed0\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/e2af2bce51e743849d41c25264255729 : SUCCESS in 7m 54s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/30747ec358df4146ba3f966d3cfbf9d1 : SUCCESS in 8m 40s (non-voting)\n- openstack-tox-py310-arm64 https://zuul.opendev.org/t/openstack/build/02c56721b99440fc8c79528b24da20a6 : SUCCESS in 8m 16s (non-voting)\n- openstack-tox-py311-arm64 https://zuul.opendev.org/t/openstack/build/ab78041df18547c191049506aaeb2ae9 : RETRY_LIMIT in 1m 45s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"968ac90da82fe6ef1d9fa1534dab31697d4f548f","author":{"_account_id":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"},"date":"2023-08-24 09:39:11.000000000","message":"Patch Set 1: Code-Review-2 Workflow-1\n\nI\u0027m sorry, it\u0027s going to be a bit harsh, but please stop landing things that don\u0027t make any sense whatsoever from Python perspective.","accounts_in_message":[],"_revision_number":1},{"id":"329c3c2cfe5e6f44fc68ec32f05d1d52b364a8a3","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-08-24 11:16:26.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/c8a987856acb4f1eb730af03766c6764\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/1eb02bdcf165464a85b320d135a74c0f : SUCCESS in 11m 17s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/2b206b764e714cc295e64ae99d1a27ce : SUCCESS in 4m 58s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/2aa5253c368f4a2b87a7a6eae586631b : SUCCESS in 10m 20s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/ebdd21642d2b46da8204ea49a63900fa : SUCCESS in 8m 42s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/3ad58a841c62479ba35f5b75f5aa6e21 : SUCCESS in 8m 32s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/36054dea9f2944e192363fc2fd8bfe11 : RETRY_LIMIT in 2m 24s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/77ac8385cbdd4f408b2240c249e6138f : SUCCESS in 12m 38s\n- ironic-tox-unit-mysql-migrations https://zuul.opendev.org/t/openstack/build/5084052b250e48178deb794762d6e812 : SUCCESS in 6m 28s\n- ironic-tox-unit-with-sqlalchemy-2x https://zuul.opendev.org/t/openstack/build/3ae1a2f9219d47e7b5b8c0e684356b66 : SUCCESS in 8m 20s\n- ironic-tox-unit-with-driver-libs https://zuul.opendev.org/t/openstack/build/8a186b5e34474b23a8c5391d09f74f69 : SUCCESS in 10m 25s\n- ironic-cross-sushy https://zuul.opendev.org/t/openstack/build/4a46e69738ae470ebe603bc0d179c37d : SUCCESS in 9m 31s (non-voting)\n- ironic-tempest-functional-python3 https://zuul.opendev.org/t/openstack/build/8d6e50b6e83449f4819a97ae6f9c2874 : SUCCESS in 29m 30s\n- ironic-tempest-functional-rbac-scope-enforced https://zuul.opendev.org/t/openstack/build/b413e66fc16a4888bf62158c8d9eecc5 : SUCCESS in 23m 37s (non-voting)\n- ironic-grenade https://zuul.opendev.org/t/openstack/build/35cfb0b8630744b59e88097c85430ed7 : SUCCESS in 49m 42s\n- ironic-grenade-skip-level https://zuul.opendev.org/t/openstack/build/0eb94263e5744d3abfe8385e01dd0e4f : SUCCESS in 1h 08m 03s (non-voting)\n- ironic-standalone https://zuul.opendev.org/t/openstack/build/140de75ef649460aaad252b35be8246c : SUCCESS in 1h 07m 08s\n- ironic-standalone-redfish https://zuul.opendev.org/t/openstack/build/5e51f35fb0dc4253839a27c554b6b6f3 : SUCCESS in 1h 04m 34s\n- ironic-tempest-bios-redfish-pxe https://zuul.opendev.org/t/openstack/build/f131aa1e921f486e8680a3a114d13630 : SUCCESS in 46m 13s\n- ironic-tempest-uefi-redfish-vmedia https://zuul.opendev.org/t/openstack/build/efaad59f1e0d4a028ef230a862294f02 : SUCCESS in 58m 09s\n- ironic-tempest-wholedisk-bios-snmp-pxe https://zuul.opendev.org/t/openstack/build/eaa65952c06049e6b2eed97f52b5c673 : SUCCESS in 44m 44s\n- ironic-tempest-partition-uefi-ipmi-pxe https://zuul.opendev.org/t/openstack/build/efa75293e47b4c25895f4aa6c60f4a36 : SUCCESS in 55m 45s\n- ironic-tempest-ipa-wholedisk-direct-tinyipa-multinode https://zuul.opendev.org/t/openstack/build/284816ce9c6e4ea080589e6b92534076 : SUCCESS in 1h 57m 49s (non-voting)\n- ironic-tempest-bios-ipmi-direct-tinyipa https://zuul.opendev.org/t/openstack/build/540e3538e55742e3b1d48d0745feef36 : SUCCESS in 53m 38s\n- ironic-tempest-bfv https://zuul.opendev.org/t/openstack/build/5fce66e090f64a57859305ced2d4d01b : SUCCESS in 41m 43s\n- ironic-tempest-ipa-partition-uefi-pxe-grub2 https://zuul.opendev.org/t/openstack/build/f0b47428f1d44f0eac5fee26e25cc3b8 : SUCCESS in 40m 42s\n- metalsmith-integration-glance-centos8-legacy https://zuul.opendev.org/t/openstack/build/8e44ebdc51a44916bdfe2b54524954c6 : SUCCESS in 1h 25m 22s\n- metal3-integration https://zuul.opendev.org/t/openstack/build/9bbb18c65610464d8c223009b50408bf : SUCCESS in 44m 24s\n- ironic-tox-bandit https://zuul.opendev.org/t/openstack/build/891860c9da5c4bfca8e18cfce7165959 : SUCCESS in 5m 25s (non-voting)\n- ironic-inspector-tempest https://zuul.opendev.org/t/openstack/build/a146ace745274b71a0afc5bda5d225f6 : SUCCESS in 47m 23s (non-voting)\n- ironic-inspector-tempest-managed-non-standalone https://zuul.opendev.org/t/openstack/build/67750c4ea05a40f1b4f3b01cfade28af : FAILURE in 1h 01m 09s (non-voting)\n- ironic-tempest-ipa-wholedisk-bios-ipmi-direct-dib https://zuul.opendev.org/t/openstack/build/f682fa0a0c2b44a4802e78c6e63743ab : SUCCESS in 38m 18s (non-voting)\n- ironic-tempest-ipxe-ipv6 https://zuul.opendev.org/t/openstack/build/99a94be02fc346a9a656fccb0e84902d : SUCCESS in 59m 27s (non-voting)\n- ironic-standalone-anaconda https://zuul.opendev.org/t/openstack/build/37ef4c4ceac54eb69343bf8cf249a19a : SUCCESS in 53m 01s (non-voting)\n- ironic-inspector-tempest-rbac-scope-enforced https://zuul.opendev.org/t/openstack/build/be57ceed17524f8ba5743208e0b9f4e5 : SUCCESS in 43m 35s (non-voting)\n- bifrost-integration-tinyipa-ubuntu-focal https://zuul.opendev.org/t/openstack/build/6c21db035a074e90af19416df927e70e : SUCCESS in 40m 05s (non-voting)\n- bifrost-integration-redfish-vmedia-uefi-centos-9 https://zuul.opendev.org/t/openstack/build/9cd404f39a1c4ee6892ec54ba447888e : SUCCESS in 38m 59s (non-voting)\n- ironic-tempest-pxe_ipmitool-postgres https://zuul.opendev.org/t/openstack/build/4e08c59d35104bd38c5be01bf2971e8c : SUCCESS in 56m 20s (non-voting)\n- bifrost-benchmark-ironic https://zuul.opendev.org/t/openstack/build/f4d81979de104fe4a11e0f102df2cc97 : SUCCESS in 42m 50s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"018e079a94f687d9c7deff0386a356d7529c4acf","tag":"autogenerated:gerrit:abandon","author":{"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},"date":"2024-01-03 23:26:19.000000000","message":"Abandoned","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"0e1a4df3fb4963d83949d5db1c4be64a0d640780","revisions":{"0e1a4df3fb4963d83949d5db1c4be64a0d640780":{"kind":"REWORK","_number":1,"created":"2023-08-23 19:48:57.000000000","uploader":{"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},"ref":"refs/changes/21/892621/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/ironic","ref":"refs/changes/21/892621/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/ironic refs/changes/21/892621/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/ironic refs/changes/21/892621/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/ironic refs/changes/21/892621/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/ironic refs/changes/21/892621/1"}}},"commit":{"parents":[{"commit":"461d85502df4a7dc1dcbe1d1cc52014598398fe4","subject":"Merge \"Retool sqlite retries\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/ironic/commit/461d85502df4a7dc1dcbe1d1cc52014598398fe4"}]}],"author":{"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","date":"2023-08-23 19:25:40.000000000","tz":-420},"committer":{"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","date":"2023-08-23 19:40:52.000000000","tz":-420},"subject":"DB: Un-nest some returns from dbapi","message":"DB: Un-nest some returns from dbapi\n\nWhile looking at Metal3 locking issues, I went back and looked at\nthe preceeding calls because post-pivot of services, the order of\noperation against Ironic\u0027s API is slightly different as the nodes\nare going to be moved into adoption.\n\nThe major difference is pre-pivot, we generally saw power state\nsynchronization occur right before the first \"database is locked\"\nerror, but in post pivot, power state sync completed earlier and\nthen a few different GET queries executed.\n\nThose queries:\n    GET /v1\n    GET /v1/drivers\n    GET /v1/nodes/\u003cuuid\u003e\n    GET /v1/ports?fields\u003dnode_uuid\u0026node_uuid\u003d\u003cuuid\u003e\n\nAnd of course, the update node then proceeded to fail because the\ndatabase was locked due to the UUID which we were just doing GETs\nupon.\n\nDigging through the sequence:\n  * /v1 has no DB Queries.\n  * /v1/drivers *did* end up having *two* separate queries to\n    composite the results. Which led towards some slight\n    structural changes to ensure we\u0027re not closing out the\n    method with anything that could have a tie to the database.\n  * This then looking at the db/sqlalchemy/api.py file, primarly\n    because nodes has recieved quite a bit of scruitney in the\n    handling of queries and responses. In this, I noticed we\n    returned from within a _session_for_read with block, which\n    is quite likely a root cause issue for database locking.\n    Looking through, I found a few more places that were sort\n    of similar in pattern, so cleaned them up as well.\n  * Investigating ports, just to double check, we ended up\n    assigning an node object to a variable only for the ID\n    value of the node, but we didn\u0027t really need to be stored\n    in memory, so I reformated a little bit so we don\u0027t have\n    a variable that needs to be cleaned up later.\n\nChange-Id: I62c12d0ec9809f3b756f1b6b796ea5dd11b3e023\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/ironic/commit/0e1a4df3fb4963d83949d5db1c4be64a0d640780"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/ironic/commit/0e1a4df3fb4963d83949d5db1c4be64a0d640780"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[{"name":"Verified","description":"Verified in gate by CI","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Verified\u003dMAX AND -label:Verified\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Verified\u003dMAX","label:Verified\u003dMIN"],"atom_explanations":{}}},{"name":"Backport-Candidate","description":"Backport candidate status","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":"Code-Review","description":"Code reviewed by core reviewer","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Code-Review\u003dMAX AND -label:Code-Review\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":["label:Code-Review\u003dMAX","label:Code-Review\u003dMIN"],"failing_atoms":[],"atom_explanations":{}}},{"name":"Workflow","description":"Approved for gate by core reviewer","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Workflow\u003dMAX AND -label:Workflow\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":["label:Workflow\u003dMAX","label:Workflow\u003dMIN"],"failing_atoms":[],"atom_explanations":{}}}]}