)]}'
{"id":"openstack%2Fironic~895039","triplet_id":"openstack%2Fironic~stable%2F2023.1~I0b68f054c951655b01f0cd776feb5a8c768471ab","project":"openstack/ironic","branch":"stable/2023.1","attention_set":{},"removed_from_attention_set":{"11655":{"account":{"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},"last_update":"2023-09-15 19:10:33.000000000","reason":"\u003cGERRIT_ACCOUNT_11655\u003e replied on the change","reason_account":{"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"}}},"hashtags":[],"change_id":"I0b68f054c951655b01f0cd776feb5a8c768471ab","subject":"DB: Select upon delete for allocations","status":"MERGED","created":"2023-09-15 13:21:32.000000000","updated":"2023-09-15 20:46:10.000000000","submitted":"2023-09-15 20:45:01.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":2,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"895039","cherry_pick_of_change":889890,"cherry_pick_of_patch_set":2,"meta_rev_id":"2fbbee14061f337c9d8bcbd107c0441d2993608f","_number":895039,"virtual_id_number":895039,"owner":{"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":24245,"name":"Harald Jensås","email":"hjensas@redhat.com","username":"harald.jensas"},{"value":0,"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2023-09-15 20:45:01.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_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":"","default_value":0,"optional":true},"Code-Review":{"approved":{"_account_id":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"},"recommended":{"_account_id":24245,"name":"Harald Jensås","email":"hjensas@redhat.com","username":"harald.jensas"},"all":[{"value":1,"date":"2023-09-15 16:54:40.000000000","permitted_voting_range":{"min":1,"max":2},"_account_id":24245,"name":"Harald Jensås","email":"hjensas@redhat.com","username":"harald.jensas"},{"value":0,"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":2,"date":"2023-09-15 14:55:45.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":"","value":1,"default_value":0,"optional":true},"Workflow":{"approved":{"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},"all":[{"value":0,"_account_id":24245,"name":"Harald Jensås","email":"hjensas@redhat.com","username":"harald.jensas"},{"value":1,"date":"2023-09-15 19:10:33.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_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,"_account_id":24245,"name":"Harald Jensås","email":"hjensas@redhat.com","username":"harald.jensas"},{"value":0,"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_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":{"REVIEWER":[{"_account_id":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"},{"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":24245,"name":"Harald Jensås","email":"hjensas@redhat.com","username":"harald.jensas"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2023-09-15 14:21:38.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-09-15 14:55:45.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"},{"updated":"2023-09-15 15:02:18.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-09-15 16:54:40.000000000","updated_by":{"_account_id":24245,"name":"Harald Jensås","email":"hjensas@redhat.com","username":"harald.jensas"},"reviewer":{"_account_id":24245,"name":"Harald Jensås","email":"hjensas@redhat.com","username":"harald.jensas"},"state":"REVIEWER"}],"messages":[{"id":"86bde08783a877f2414f803eece65f969f7963d6","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-09-15 13:21:32.000000000","message":"Patch Set 1: Cherry Picked from branch master.","accounts_in_message":[],"_revision_number":1},{"id":"0c9fed60aa96023e9c13abdbafac5c9a29f42ced","author":{"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},"date":"2023-09-15 13:21:58.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"066ad2d5cddbef20dc83bd24f74fe3bc687beeac","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-15 14:21:38.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/f43fb70380f14c17b8afdab17e6e7e71\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/bc4895647455426099901be02ee6228e : SUCCESS in 14m 32s (non-voting)\n- openstack-tox-py310-arm64 https://zuul.opendev.org/t/openstack/build/46483353708e47e6843819823f9ba95b : SUCCESS in 23m 36s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"fbdfec7c1219c4136a8368f7e1fdc602a3b4a9fc","author":{"_account_id":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"},"date":"2023-09-15 14:55:45.000000000","message":"Patch Set 1: Code-Review+2","accounts_in_message":[],"_revision_number":1},{"id":"7a7152aa59cd672221a67ef480641ab9e49366ec","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-15 15:02:18.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/c5fc10db8c5847e6bae7590dea2795e5\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/8b601fc1e1a64e0b9f48227aa11120fe : SUCCESS in 9m 11s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/720637ed26c44d4e8b4f13aac675751f : SUCCESS in 4m 46s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/b327bdcaac134f3783d49c1f7f887ccf : SUCCESS in 9m 20s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/559b0735d5584309a897efb5b4cdf639 : SUCCESS in 6m 57s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/22f343eba7cf49c6907d1c0680e5548f : SUCCESS in 14m 06s\n- ironic-tox-unit-with-driver-libs https://zuul.opendev.org/t/openstack/build/2ba918fa64eb4f2e9e40436da5bb9575 : SUCCESS in 11m 46s\n- ironic-cross-sushy https://zuul.opendev.org/t/openstack/build/eb72e68de0614ccead487d3e7b51e6d9 : SUCCESS in 9m 44s (non-voting)\n- ironic-tempest-functional-python3 https://zuul.opendev.org/t/openstack/build/ab657eebc2254e5d8961dfb6be010b5f : SUCCESS in 35m 31s\n- ironic-tempest-functional-rbac-scope-enforced https://zuul.opendev.org/t/openstack/build/ab2ff61c93914c84a4f99355b6c350e4 : SUCCESS in 34m 31s (non-voting)\n- ironic-grenade https://zuul.opendev.org/t/openstack/build/82fb48f471d04039921d1a9f9a347863 : SUCCESS in 1h 07m 06s\n- ironic-standalone https://zuul.opendev.org/t/openstack/build/eebae70664fe4ed2bfe62ac1caa7f172 : SUCCESS in 1h 00m 19s\n- ironic-standalone-redfish https://zuul.opendev.org/t/openstack/build/eba41031746f44318ea53a30b3e0bf81 : SUCCESS in 1h 04m 11s\n- ironic-tempest-bios-redfish-pxe https://zuul.opendev.org/t/openstack/build/9ca4608cb2b041f186ed429cb8e39f2f : SUCCESS in 43m 08s\n- ironic-tempest-uefi-redfish-vmedia https://zuul.opendev.org/t/openstack/build/cac731e42f9d4f93a0a01363758b8f90 : SUCCESS in 1h 01m 34s\n- ironic-tempest-wholedisk-bios-snmp-pxe https://zuul.opendev.org/t/openstack/build/8d686dbe4e474b4ab43fd66a2988c518 : SUCCESS in 50m 59s\n- ironic-tempest-partition-uefi-ipmi-pxe https://zuul.opendev.org/t/openstack/build/ddd7f6e92a3643ad84c83b11a8379f67 : FAILURE in 1h 05m 20s\n- ironic-tempest-ipa-wholedisk-direct-tinyipa-multinode https://zuul.opendev.org/t/openstack/build/e647ac731a93468fb44960b61190acc2 : SUCCESS in 1h 36m 54s (non-voting)\n- ironic-tempest-bios-ipmi-direct-tinyipa https://zuul.opendev.org/t/openstack/build/9fbcd673625e44aabb1183038a04fb8e : SUCCESS in 1h 13m 00s\n- ironic-tempest-bfv https://zuul.opendev.org/t/openstack/build/56b96e72189b4616ac24c6a0611de254 : SUCCESS in 45m 48s\n- ironic-tempest-ipa-partition-uefi-pxe-grub2 https://zuul.opendev.org/t/openstack/build/425142dec4344a54b8c3ab3dcb09558e : SUCCESS in 53m 52s\n- metalsmith-integration-glance-centos8-legacy https://zuul.opendev.org/t/openstack/build/f34e9b9c35e54b6f91b86d3351ebeb04 : SUCCESS in 1h 28m 24s\n- ironic-tox-bandit https://zuul.opendev.org/t/openstack/build/4e811b8998af4836a1118ac98803e203 : FAILURE in 5m 29s (non-voting)\n- ironic-inspector-tempest https://zuul.opendev.org/t/openstack/build/cf7f68c3785842fb9b6bf727ddcc7302 : SUCCESS in 1h 00m 46s (non-voting)\n- ironic-inspector-tempest-managed-non-standalone https://zuul.opendev.org/t/openstack/build/660ee6fd28bd4693b7218951a3264b1e : FAILURE in 59m 44s (non-voting)\n- ironic-tempest-ipa-wholedisk-bios-ipmi-direct-dib https://zuul.opendev.org/t/openstack/build/f682c7e805014de08557f3dc27ccd32b : SUCCESS in 51m 54s (non-voting)\n- ironic-tempest-ipxe-ipv6 https://zuul.opendev.org/t/openstack/build/9a1b7c9b804c4e9e97a11eb259a84997 : SUCCESS in 1h 07m 16s (non-voting)\n- ironic-standalone-anaconda https://zuul.opendev.org/t/openstack/build/04162febfc14433aa02f91526fe34b57 : SUCCESS in 49m 33s (non-voting)\n- ironic-inspector-tempest-rbac-scope-enforced https://zuul.opendev.org/t/openstack/build/5afbd5f174884c94942a96df9278e2de : SUCCESS in 48m 23s (non-voting)\n- bifrost-integration-tinyipa-ubuntu-focal https://zuul.opendev.org/t/openstack/build/ec5dba2fb1e74278a4fe081bfdc9712a : SUCCESS in 35m 19s (non-voting)\n- bifrost-integration-redfish-vmedia-uefi-centos-9 https://zuul.opendev.org/t/openstack/build/facf72f687874f3cac316bf578f4e8ab : SUCCESS in 35m 41s (non-voting)\n- ironic-tempest-pxe_ipmitool-postgres https://zuul.opendev.org/t/openstack/build/2c5d07aa4b944289bd8de16c71823bef : FAILURE in 37m 54s (non-voting)\n- bifrost-benchmark-ironic https://zuul.opendev.org/t/openstack/build/ce18b348f4b047269377e9c665b1f4b8 : FAILURE in 40m 02s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"063536f385b149ffab784ef56646c46acdef996f","author":{"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},"date":"2023-09-15 15:44:56.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"7fb920e759b483cec40a4e21f0b0b53b27e79a50","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-15 16:22:37.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/2dd1845042b948e5bfbe045cd7775e44\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/8d80651ab7684f2bb8d779cca6ecbfee : SUCCESS in 22m 17s (non-voting)\n- openstack-tox-py310-arm64 https://zuul.opendev.org/t/openstack/build/e979f6773c4049a1ac79dc022657a1e8 : FAILURE in 25m 45s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"30f788cf300843235cd0a830b2be17f49e31feb3","author":{"_account_id":24245,"name":"Harald Jensås","email":"hjensas@redhat.com","username":"harald.jensas"},"date":"2023-09-15 16:54:40.000000000","message":"Patch Set 1: Code-Review+1","accounts_in_message":[],"_revision_number":1},{"id":"a0fa00de989fd403232b08127dda67111aec2f7c","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-15 18:11:54.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/1ff7e543fef74a1f901c93640c89bdd5\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/222938399da6455ba13a90b9d8e43779 : SUCCESS in 10m 57s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/29a9d0911a5945ef9dd44f7416b62973 : SUCCESS in 6m 26s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/3a253dbf1c6342438d740e6b85e61606 : SUCCESS in 9m 46s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/85d0ad336a8a4486bf5a12329c1199ff : SUCCESS in 6m 40s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/f7fab84d534d4ac39e6ad0fb38fd40b0 : SUCCESS in 11m 38s\n- ironic-tox-unit-with-driver-libs https://zuul.opendev.org/t/openstack/build/0c57b91acce74723aeba8b7003cb7817 : SUCCESS in 11m 33s\n- ironic-cross-sushy https://zuul.opendev.org/t/openstack/build/d9c0fa1f10cb4708b1d87485691104c7 : SUCCESS in 9m 34s (non-voting)\n- ironic-tempest-functional-python3 https://zuul.opendev.org/t/openstack/build/4a1d2ffb9b93466b8014c005fd980191 : SUCCESS in 34m 50s\n- ironic-tempest-functional-rbac-scope-enforced https://zuul.opendev.org/t/openstack/build/1eab31138e8c451c8b6f9abc66ba70c6 : SUCCESS in 19m 45s (non-voting)\n- ironic-grenade https://zuul.opendev.org/t/openstack/build/87bf07cf57a540e19121f0163b25ee5b : SUCCESS in 1h 09m 50s\n- ironic-standalone https://zuul.opendev.org/t/openstack/build/909b48c3b5224b8090ce16e9d6633511 : SUCCESS in 1h 04m 41s\n- ironic-standalone-redfish https://zuul.opendev.org/t/openstack/build/55763a9d8c37439d888e28c6962071a8 : SUCCESS in 54m 36s\n- ironic-tempest-bios-redfish-pxe https://zuul.opendev.org/t/openstack/build/15413f6681a445f8b15e1989ed36e3ed : SUCCESS in 49m 27s\n- ironic-tempest-uefi-redfish-vmedia https://zuul.opendev.org/t/openstack/build/3c3fd05c34cd4f1badae725069556f10 : SUCCESS in 1h 00m 03s\n- ironic-tempest-wholedisk-bios-snmp-pxe https://zuul.opendev.org/t/openstack/build/810ae77e6d2f49488e60882ec33fc559 : SUCCESS in 38m 01s\n- ironic-tempest-partition-uefi-ipmi-pxe https://zuul.opendev.org/t/openstack/build/4acd8338e4264229a11913ce95afe9ad : SUCCESS in 59m 58s\n- ironic-tempest-ipa-wholedisk-direct-tinyipa-multinode https://zuul.opendev.org/t/openstack/build/50ff86f0b9684441a0bd80f4df33cbe7 : SUCCESS in 2h 19m 07s (non-voting)\n- ironic-tempest-bios-ipmi-direct-tinyipa https://zuul.opendev.org/t/openstack/build/27ea1b96fd0044a3882376e4e9f45b73 : SUCCESS in 50m 34s\n- ironic-tempest-bfv https://zuul.opendev.org/t/openstack/build/d1419861b50c426693a994d491c84161 : SUCCESS in 47m 19s\n- ironic-tempest-ipa-partition-uefi-pxe-grub2 https://zuul.opendev.org/t/openstack/build/7285d173df684c7f83a047b57c06282d : SUCCESS in 43m 57s\n- metalsmith-integration-glance-centos8-legacy https://zuul.opendev.org/t/openstack/build/c9dbf3f7a53f4067a1870a1b6591697d : SUCCESS in 1h 27m 44s\n- ironic-tox-bandit https://zuul.opendev.org/t/openstack/build/ab59769108fa465584d89cd25f325d56 : FAILURE in 5m 11s (non-voting)\n- ironic-inspector-tempest https://zuul.opendev.org/t/openstack/build/7294c95ace5544fabb515fc5402fe07e : SUCCESS in 1h 01m 58s (non-voting)\n- ironic-inspector-tempest-managed-non-standalone https://zuul.opendev.org/t/openstack/build/11878058551e473888f4369502b10d48 : FAILURE in 1h 01m 46s (non-voting)\n- ironic-tempest-ipa-wholedisk-bios-ipmi-direct-dib https://zuul.opendev.org/t/openstack/build/26db3f9f8fa3422c86b407785b38d0e6 : SUCCESS in 37m 36s (non-voting)\n- ironic-tempest-ipxe-ipv6 https://zuul.opendev.org/t/openstack/build/443d9a979df8434fa7f2a0eb1bbf59c3 : SUCCESS in 53m 57s (non-voting)\n- ironic-standalone-anaconda https://zuul.opendev.org/t/openstack/build/65063bdd295d416db2601e694c3fa572 : SUCCESS in 43m 13s (non-voting)\n- ironic-inspector-tempest-rbac-scope-enforced https://zuul.opendev.org/t/openstack/build/1a7cb60781034292b66f152ba0f27b61 : SUCCESS in 1h 02m 35s (non-voting)\n- bifrost-integration-tinyipa-ubuntu-focal https://zuul.opendev.org/t/openstack/build/8625d88ca1054e7082735484b57dee49 : SUCCESS in 29m 24s (non-voting)\n- bifrost-integration-redfish-vmedia-uefi-centos-9 https://zuul.opendev.org/t/openstack/build/69fc79c6575d413fa9a963b5f00add66 : SUCCESS in 34m 05s (non-voting)\n- ironic-tempest-pxe_ipmitool-postgres https://zuul.opendev.org/t/openstack/build/8d05270d81a94a488d110e3efbff7735 : FAILURE in 22m 07s (non-voting)\n- bifrost-benchmark-ironic https://zuul.opendev.org/t/openstack/build/b5a78bf58a6d47dd92b52a9d654f7c2b : FAILURE in 38m 16s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"52b11e3bcdd7bdcc45e7d179a9747e3d4d4e8eb3","author":{"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},"date":"2023-09-15 19:10:33.000000000","message":"Patch Set 1: Workflow+1","accounts_in_message":[],"_revision_number":1},{"id":"b550a3dfd60eaaa14fe73242d405b7c4b7dcae3a","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-15 19:11:10.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"7be8120ee1eebaeebf8b844ffda6ad2c2055ba39","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-15 20:45:01.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/cae724df73c64a779a40ea17a444ed4b\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/0eb6346c3efb4bea9007f8bd19615ca8 : SUCCESS in 5m 27s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/481b81723bc04bf5adbf3a14ae9c85a1 : SUCCESS in 9m 53s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/56186bcc153a49f59bc641716b6326d7 : SUCCESS in 7m 18s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/5c2b569afd104b938918c3e17e06083f : SUCCESS in 12m 50s\n- ironic-tox-unit-with-driver-libs https://zuul.opendev.org/t/openstack/build/7d25ca8ee50c40c5a17164b92089e482 : SUCCESS in 11m 01s\n- ironic-tempest-functional-python3 https://zuul.opendev.org/t/openstack/build/9f68b30f76eb4e9596aa3dbcd3f8ff2c : SUCCESS in 33m 03s\n- ironic-grenade https://zuul.opendev.org/t/openstack/build/c1c75e1a07db4f7587d629116fe5b872 : SUCCESS in 1h 09m 45s\n- ironic-standalone https://zuul.opendev.org/t/openstack/build/2e66fe682b3a46f88c91239c5c43c53e : SUCCESS in 1h 03m 13s\n- ironic-standalone-redfish https://zuul.opendev.org/t/openstack/build/a8860f24dba946d08a6ab3bc430ae6cd : SUCCESS in 49m 07s\n- ironic-tempest-bios-redfish-pxe https://zuul.opendev.org/t/openstack/build/5243464bfca04051baa82679a2e454b6 : SUCCESS in 36m 19s\n- ironic-tempest-uefi-redfish-vmedia https://zuul.opendev.org/t/openstack/build/076feaeeceb84aa3b414249636d8a98c : SUCCESS in 49m 19s\n- ironic-tempest-wholedisk-bios-snmp-pxe https://zuul.opendev.org/t/openstack/build/3cfae0a4164b495e8e6e6bc2a013ead2 : SUCCESS in 37m 49s\n- ironic-tempest-partition-uefi-ipmi-pxe https://zuul.opendev.org/t/openstack/build/e18e3df3d7f64f869fadec033b977f90 : SUCCESS in 55m 07s\n- ironic-tempest-bios-ipmi-direct-tinyipa https://zuul.opendev.org/t/openstack/build/396c777ae23848678b2014d42f720133 : SUCCESS in 58m 14s\n- ironic-tempest-bfv https://zuul.opendev.org/t/openstack/build/f93bc30ab33442a996b8af508f668c3d : SUCCESS in 41m 44s\n- ironic-tempest-ipa-partition-uefi-pxe-grub2 https://zuul.opendev.org/t/openstack/build/72328dd4695942a2bb206e17ba3d462a : SUCCESS in 44m 55s\n- metalsmith-integration-glance-centos8-legacy https://zuul.opendev.org/t/openstack/build/7c635d8274644c47ac51b28f3a0f36a7 : SUCCESS in 1h 29m 00s","accounts_in_message":[],"_revision_number":1},{"id":"914af81b8f9293a6bce1036c6a636237c33c0f9a","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-15 20:45:01.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":1},{"id":"2fbbee14061f337c9d8bcbd107c0441d2993608f","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-09-15 20:46:10.000000000","message":"Patch Set 1:\n\nBuild succeeded (promote pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/d1e24c8f1dab40ea9d14e33f1f7320f8\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/e65aa7c526ec4cadb37219d867b22738 : SUCCESS in 52s","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"58251eb3730e4d49322db3e5c7ddc169fc9539b0","revisions":{"58251eb3730e4d49322db3e5c7ddc169fc9539b0":{"kind":"REWORK","_number":1,"created":"2023-09-15 13:21:32.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/39/895039/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/ironic","ref":"refs/changes/39/895039/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/ironic refs/changes/39/895039/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/ironic refs/changes/39/895039/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/ironic refs/changes/39/895039/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/ironic refs/changes/39/895039/1"}}},"commit":{"parents":[{"commit":"f0778eaa2d783101ae9a9cf8c03e13bfd2a8c141","subject":"CI: Fix PXE Ananconda cleanup test","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/ironic/commit/f0778eaa2d783101ae9a9cf8c03e13bfd2a8c141"}]}],"author":{"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","date":"2023-07-27 17:01:31.000000000","tz":-420},"committer":{"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","date":"2023-09-15 13:21:32.000000000","tz":0},"subject":"DB: Select upon delete for allocations","message":"DB: Select upon delete for allocations\n\nWhen an allocation has been created, it is still being created\nin the background. The client may request deletion of the\nallocation *prior* to the creation of the allocation is entirely\ncompleted. That is fine, but the challenge is we may encounter a\nlocked row if we\u0027re asked to delete while in process.\n\nSo, we\u0027ll query with with_for_update[0] which should be held until\nthe lock is released, which is only released when the original\nlocking transaction closes out[1][2].\n\n[0]: https://docs.sqlalchemy.org/en/14/core/selectable.html#sqlalchemy.sql.expression.GenerativeSelect.with_for_update\n[1]: https://dev.mysql.com/doc/refman/5.7/en/select.html\n[2]: https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-reads.html\n\nChange-Id: I0b68f054c951655b01f0cd776feb5a8c768471ab\nCloses-Bug: #2028866\n(cherry picked from commit 6ac0bdab1de8219fed419a838663aa82973e93e9)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/ironic/commit/58251eb3730e4d49322db3e5c7ddc169fc9539b0"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/ironic/commit/58251eb3730e4d49322db3e5c7ddc169fc9539b0"}]},"branch":"refs/heads/stable/2023.1"}},"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":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"}},{"label":"Workflow","status":"MAY","applied_by":{"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"}},{"label":"Backport-Candidate","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":"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":"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":"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":{}}}]}