)]}'
{"id":"openstack%2Fbifrost~851907","triplet_id":"openstack%2Fbifrost~master~Iabcb8296489b0915bdb6a2a8a0de4dfe87853482","project":"openstack/bifrost","branch":"master","attention_set":{},"removed_from_attention_set":{"14826":{"account":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"last_update":"2022-08-03 12:49:18.000000000","reason":"Change was submitted"}},"hashtags":[],"change_id":"Iabcb8296489b0915bdb6a2a8a0de4dfe87853482","subject":"Repair MariaDB tables after upgrade","status":"MERGED","created":"2022-08-02 16:17:19.000000000","updated":"2022-08-03 12:50:39.000000000","submitted":"2022-08-03 12:49:18.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":1,"unresolved_comment_count":1,"has_review_started":true,"submission_id":"851907","meta_rev_id":"7078572e414ed377d653e62552bac7fe90374887","_number":851907,"virtual_id_number":851907,"owner":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"},{"value":0,"_account_id":23084,"name":"Bartosz Bezak","email":"bartosz@stackhpc.com","username":"b.bezak"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2022-08-03 12:49:17.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":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"},"all":[{"value":2,"date":"2022-08-03 07:27:33.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"},{"value":1,"date":"2022-08-02 19:39:48.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":23084,"name":"Bartosz Bezak","email":"bartosz@stackhpc.com","username":"b.bezak"},{"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":{"-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":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"},"all":[{"value":0,"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"},{"value":0,"_account_id":23084,"name":"Bartosz Bezak","email":"bartosz@stackhpc.com","username":"b.bezak"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":1,"date":"2022-08-03 11:29:45.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}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":23084,"name":"Bartosz Bezak","email":"bartosz@stackhpc.com","username":"b.bezak"},{"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2022-08-02 17:22:02.000000000","updated_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"reviewer":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2022-08-02 19:39:48.000000000","updated_by":{"_account_id":23084,"name":"Bartosz Bezak","email":"bartosz@stackhpc.com","username":"b.bezak"},"reviewer":{"_account_id":23084,"name":"Bartosz Bezak","email":"bartosz@stackhpc.com","username":"b.bezak"},"state":"REVIEWER"},{"updated":"2022-08-03 07:27:33.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":"2022-08-03 11:29: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"}],"messages":[{"id":"181efbaa764722079bc38626115ef0a30fe12c92","tag":"autogenerated:gerrit:newWipPatchSet","author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"date":"2022-08-02 16:17:19.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"fe236f0f525f58e6e5784bfb124019c755c063a0","tag":"autogenerated:gerrit:setReadyForReview","author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"date":"2022-08-02 17:05:30.000000000","message":"Set Ready For Review","accounts_in_message":[],"_revision_number":1},{"id":"f569e181869c4932467b8a41e2116b8248353498","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-08-02 17:22:02.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/fc05e5a0539048fd81b45275cc80124f\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/e0d2fb1f3a4044a4be7dd8bc3943fcce : SUCCESS in 3m 30s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/aec744fa3a794de09b32af25b2a30878 : SUCCESS in 4m 27s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/d63439372550403b87c53389fd08dd99 : SUCCESS in 4m 30s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/cd507fcdf935400d88337927bc9393df : SUCCESS in 4m 31s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/4a3ee45538d9418b9e1a252edb4f52ca : SUCCESS in 5m 51s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/2dd600dbecfb492caa580e0a9ca51ad9 : SUCCESS in 4m 50s\n- bifrost-tox-linters https://zuul.opendev.org/t/openstack/build/28b0139cc6ec49b5a535430fade5596c : SUCCESS in 6m 27s\n- bifrost-integration-tinyipa-centos-9 https://zuul.opendev.org/t/openstack/build/0056d6be52e147229456d2e185ccaae9 : SUCCESS in 37m 41s\n- bifrost-integration-tinyipa-ubuntu-focal https://zuul.opendev.org/t/openstack/build/4c34031efb954f47a746629fae376f0d : SUCCESS in 33m 39s\n- bifrost-integration-tinyipa-keystone-ubuntu-focal https://zuul.opendev.org/t/openstack/build/9e20c03f2cae4bb3884f18caa2623fc5 : SUCCESS in 34m 40s\n- bifrost-integration-tinyipa-keystone-centos-9 https://zuul.opendev.org/t/openstack/build/1b22247f790945988faa696208aad1b3 : SUCCESS in 38m 52s\n- bifrost-integration-tinyipa-debian-bullseye https://zuul.opendev.org/t/openstack/build/4e6a7c45bba84584954ff5fb2482f4ee : SUCCESS in 36m 01s\n- bifrost-integration-redfish-vmedia-uefi-ubuntu-focal https://zuul.opendev.org/t/openstack/build/26d00253bbd14ab185834ce4e98180e8 : SUCCESS in 32m 51s\n- bifrost-integration-redfish-vmedia-uefi-centos-9 https://zuul.opendev.org/t/openstack/build/6c21206986f8409b8cfe02293f39158f : SUCCESS in 35m 33s\n- bifrost-upgrade-ubuntu-focal https://zuul.opendev.org/t/openstack/build/67ce4a2eede049eb9a9b719549164190 : SUCCESS in 57m 32s\n- bifrost-upgrade-keystone-centos9 https://zuul.opendev.org/t/openstack/build/66eb27beb4f04d0daa55463f110712c6 : SUCCESS in 1h 02m 09s\n- bifrost-integration-tinyipa-fedora-latest https://zuul.opendev.org/t/openstack/build/ccd4a7b11b4e405687ed8d4fc1f32f77 : SUCCESS in 41m 51s (non-voting)\n- bifrost-integration-redfish-uefi-fedora-latest https://zuul.opendev.org/t/openstack/build/0d1c77c3c3d24402895e6555062c27f4 : SUCCESS in 41m 07s (non-voting)\n- bifrost-integration-dhcp-ubuntu-focal https://zuul.opendev.org/t/openstack/build/dac04c5058264364b279c8319d589d54 : SUCCESS in 40m 18s (non-voting)\n- bifrost-integration-dhcp-centos-9 https://zuul.opendev.org/t/openstack/build/4a75fd84f0dd4929a45398c53208bfb1 : SUCCESS in 48m 17s (non-voting)\n- bifrost-integration-dibipa-debian-ubuntu-focal https://zuul.opendev.org/t/openstack/build/d88eaeb20da44b519169e47de38f09ee : SUCCESS in 32m 47s (non-voting)\n- bifrost-integration-dibipa-debian-centos-9 https://zuul.opendev.org/t/openstack/build/0c2470350b134770863bef14ac531385 : FAILURE in 12m 51s (non-voting)\n- bifrost-cli-ubuntu-focal https://zuul.opendev.org/t/openstack/build/c91ba66985b543e8960e4d216a94c9d5 : SUCCESS in 35m 21s (non-voting)\n- bifrost-collections-src https://zuul.opendev.org/t/openstack/build/9be8e87d847f458aaf017c575268985c : SUCCESS in 34m 50s (non-voting)\n- bifrost-keystone-collections-src https://zuul.opendev.org/t/openstack/build/e0d3a88c41d24a45bfee788e6b9205e3 : SUCCESS in 33m 56s (non-voting)\n- kolla-ansible-ubuntu-source-bifrost https://zuul.opendev.org/t/openstack/build/946e6ce8036344e9ad109c15bfa9c16a : SUCCESS in 35m 47s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"bfbe5a27de33976e14ee7e2fef0afefad4531f14","author":{"_account_id":23084,"name":"Bartosz Bezak","email":"bartosz@stackhpc.com","username":"b.bezak"},"date":"2022-08-02 19:39:48.000000000","message":"Patch Set 1: Code-Review+1","accounts_in_message":[],"_revision_number":1},{"id":"358ed380ba89a0f16b1d931db659daef5e05346f","author":{"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"},"date":"2022-08-03 07:27:33.000000000","message":"Patch Set 1: Code-Review+2","accounts_in_message":[],"_revision_number":1},{"id":"17caf07523ba0aed80254a1827d924603fea7e70","author":{"_account_id":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"},"date":"2022-08-03 11:29:45.000000000","message":"Patch Set 1: Workflow+1\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"706ca98c04ea58efb2ffdb26ca3a02fd75027e96","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-08-03 11:30:26.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"bd9ba43ee08390aeb6728d3c5c45a2b8db729662","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-08-03 12:49:17.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/d3ee5aa7183d4480a2a12154eea1345f\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/c7cbc19bd9bf4c9592a28de66ca18808 : SUCCESS in 3m 24s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/ed90b3ee9c034212a03b62455ef01ee6 : SUCCESS in 4m 26s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/9006fe6b4c304ad7a04cad04c9400d1a : SUCCESS in 4m 04s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/b1f59d2320e54263a007e7a5ca9839f3 : SUCCESS in 5m 20s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/467ccfb6ca834171b4fa8938f3eb7ca9 : SUCCESS in 4m 19s\n- bifrost-tox-linters https://zuul.opendev.org/t/openstack/build/3b5106844db444a1885527349d621f4e : SUCCESS in 7m 10s\n- bifrost-integration-tinyipa-centos-9 https://zuul.opendev.org/t/openstack/build/91fa919781a042539d0939117d219a68 : SUCCESS in 46m 02s\n- bifrost-integration-tinyipa-ubuntu-focal https://zuul.opendev.org/t/openstack/build/ac240cfbae94454d85b5ac24fdc2490d : SUCCESS in 38m 55s\n- bifrost-integration-tinyipa-keystone-ubuntu-focal https://zuul.opendev.org/t/openstack/build/9baa1963e99c4a91a61636fe8e44c102 : SUCCESS in 39m 29s\n- bifrost-integration-tinyipa-keystone-centos-9 https://zuul.opendev.org/t/openstack/build/469cf5bd71d944949ec46ccbd13e1346 : SUCCESS in 42m 35s\n- bifrost-integration-tinyipa-debian-bullseye https://zuul.opendev.org/t/openstack/build/4fad0e9558944a78855b219eaf56ce23 : SUCCESS in 38m 57s\n- bifrost-integration-redfish-vmedia-uefi-ubuntu-focal https://zuul.opendev.org/t/openstack/build/3258945a06c244abaa13bb8ab8ce096d : SUCCESS in 38m 29s\n- bifrost-integration-redfish-vmedia-uefi-centos-9 https://zuul.opendev.org/t/openstack/build/2ab390cb3ef142148881fbb2d4e6f023 : SUCCESS in 40m 31s\n- bifrost-upgrade-ubuntu-focal https://zuul.opendev.org/t/openstack/build/c2780d01d5434f69b819d0711a7142e1 : SUCCESS in 1h 09m 11s\n- bifrost-upgrade-keystone-centos9 https://zuul.opendev.org/t/openstack/build/1f7240b7ac5348b7b7d4ce24655f23b8 : SUCCESS in 1h 15m 09s","accounts_in_message":[],"_revision_number":1},{"id":"02f470387473e5f663c3b622bf21aff22ae25bcc","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-08-03 12:49:18.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":1},{"id":"7078572e414ed377d653e62552bac7fe90374887","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-08-03 12:50:39.000000000","message":"Patch Set 1:\n\nBuild succeeded (promote pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/7d54c1bc29c84a06812789dd1e7d49ec\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/68f6de1e741c44c18176928ff7a524c6 : SUCCESS in 1m 02s\n- promote-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/3f25bf22f8d34d078f01d2c81fe2b735 : SUCCESS in 57s","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"da3b67819ed8a219c4b0ca30b5a0b4a00f0027f3","revisions":{"da3b67819ed8a219c4b0ca30b5a0b4a00f0027f3":{"kind":"REWORK","_number":1,"created":"2022-08-02 16:17:19.000000000","uploader":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"ref":"refs/changes/07/851907/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/bifrost","ref":"refs/changes/07/851907/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/bifrost refs/changes/07/851907/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/bifrost refs/changes/07/851907/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/bifrost refs/changes/07/851907/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/bifrost refs/changes/07/851907/1"}}},"commit":{"parents":[{"commit":"7c9ef4e68e586b1af591af8ac8d914bbdb66765b","subject":"Merge \"Exclude ansible collection \u003e1.8.0,\u003c2.0.0\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/bifrost/commit/7c9ef4e68e586b1af591af8ac8d914bbdb66765b"}]}],"author":{"name":"Mark Goddard","email":"mark@stackhpc.com","date":"2022-08-02 16:09:57.000000000","tz":60},"committer":{"name":"Mark Goddard","email":"mark@stackhpc.com","date":"2022-08-02 16:17:05.000000000","tz":60},"subject":"Repair MariaDB tables after upgrade","message":"Repair MariaDB tables after upgrade\n\nSometimes MariaDB changes the format of database tables between\nreleases. A mysql_upgrade tool is provided that will attempt to repair\nthe tables to make them compatible with the new version of MariaDB.\n\nUpgrading from Ubuntu Focal 20.04 to Ubuntu Jammy 22.04 will trigger\nsuch an issue:\n\n  TASK [bifrost-ironic-install : MySQL - Creating user for Ironic]\n  The user specified as a definer (\u0027mariadb.sys\u0027@\u0027localhost\u0027) does not exist\n\nThis change runs mysql_upgrade after installing MariaDB.\n\nStory: 2010208\nTask: 45935\n\nChange-Id: Iabcb8296489b0915bdb6a2a8a0de4dfe87853482\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/bifrost/commit/da3b67819ed8a219c4b0ca30b5a0b4a00f0027f3"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/bifrost/commit/da3b67819ed8a219c4b0ca30b5a0b4a00f0027f3"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~DefaultSubmitRule","status":"CLOSED","labels":[{"label":"Verified","status":"OK","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"OK","applied_by":{"_account_id":23851,"name":"Riccardo Pittau","email":"elfosardo@gmail.com","username":"elfosardo"}},{"label":"Workflow","status":"OK","applied_by":{"_account_id":10239,"name":"Dmitry Tantsur","email":"dtantsur@protonmail.com","username":"dtantsur"}}]}],"submit_requirements":[]}