)]}'
{"id":"openstack%2Ftrove~759337","triplet_id":"openstack%2Ftrove~master~Ibdec63324b1b39ba9b8a38dbe529da17bbb06767","project":"openstack/trove","branch":"master","topic":"mysql-8","hashtags":[],"change_id":"Ibdec63324b1b39ba9b8a38dbe529da17bbb06767","subject":"Support mysql 8.0","status":"MERGED","created":"2020-10-23 01:14:31.000000000","updated":"2020-10-26 09:54:22.000000000","submitted":"2020-10-26 09:53:09.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"759337-1603705989783-a1fd6842","meta_rev_id":"3e848e81dce0e123ebec2d8eda47d8bf0077fcad","_number":759337,"virtual_id_number":759337,"owner":{"_account_id":6732,"name":"Lingxian Kong","email":"anlin.kong@gmail.com","username":"kong"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":3031,"name":"Sam Morrison","email":"sorrison@gmail.com","username":"sorrison"},{"value":0,"_account_id":6732,"name":"Lingxian Kong","email":"anlin.kong@gmail.com","username":"kong"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2020-10-26 09:53:09.000000000","post_submit":true,"permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"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":6732,"name":"Lingxian Kong","email":"anlin.kong@gmail.com","username":"kong"},"all":[{"value":0,"_account_id":3031,"name":"Sam Morrison","email":"sorrison@gmail.com","username":"sorrison"},{"value":2,"date":"2020-10-26 07:52:44.000000000","_account_id":6732,"name":"Lingxian Kong","email":"anlin.kong@gmail.com","username":"kong"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"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":6732,"name":"Lingxian Kong","email":"anlin.kong@gmail.com","username":"kong"},"all":[{"value":0,"_account_id":3031,"name":"Sam Morrison","email":"sorrison@gmail.com","username":"sorrison"},{"value":1,"date":"2020-10-26 07:52:44.000000000","_account_id":6732,"name":"Lingxian Kong","email":"anlin.kong@gmail.com","username":"kong"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Backport-Candidate":{"all":[{"value":0,"_account_id":3031,"name":"Sam Morrison","email":"sorrison@gmail.com","username":"sorrison"},{"value":0,"_account_id":6732,"name":"Lingxian Kong","email":"anlin.kong@gmail.com","username":"kong"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-1":"Not A Backport Candidate"," 0":"Backport Review Needed","+1":"Proposed Backport"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":3031,"name":"Sam Morrison","email":"sorrison@gmail.com","username":"sorrison"},{"_account_id":6732,"name":"Lingxian Kong","email":"anlin.kong@gmail.com","username":"kong"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2020-10-23 01:19:10.000000000","updated_by":{"_account_id":3031,"name":"Sam Morrison","email":"sorrison@gmail.com","username":"sorrison"},"reviewer":{"_account_id":3031,"name":"Sam Morrison","email":"sorrison@gmail.com","username":"sorrison"},"state":"REVIEWER"},{"updated":"2020-10-26 09:53:09.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"}],"messages":[{"id":"e476b3f1e70dc344c84f98ddec75458bf66c41d7","author":{"_account_id":6732,"name":"Lingxian Kong","email":"anlin.kong@gmail.com","username":"kong"},"date":"2020-10-23 01:14:31.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"24dde8008c82e2ee7aa24770da24f4b6584c608b","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-10-23 03:37:24.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/da98d0dc02f8455595d272d184798b89 : SUCCESS in 4m 31s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/325f9e4d7b22420d822411de9fd2a828 : FAILURE in 7m 47s (non-voting)\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/de44c7b7e6634e7ea10917af2f060b1d : SUCCESS in 7m 16s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/a75b993565a24df8bcc22bc2c7762eac : SUCCESS in 6m 49s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/082b4be8923b4c49bf6c1879e4d09f24 : SUCCESS in 6m 54s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/4a776311e43243b88609c5443b057d03 : SUCCESS in 7m 18s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/0611f876d0b54896a0f886c431ed1978 : SUCCESS in 6m 42s\n- trove-tox-bandit-baseline https://zuul.opendev.org/t/openstack/build/416ec7652eec4277b15a5f523619aeb9 : SUCCESS in 6m 53s (non-voting)\n- trove-tempest https://zuul.opendev.org/t/openstack/build/f7895e3746084a99b3f09d3bf2fc1ad6 : TIMED_OUT in 2h 14m 11s (non-voting)\n- trove-tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/71559f1625564bde8f47c50fd7477406 : SUCCESS in 1h 11m 45s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"5340efd1ea40ba50dbffd8599328fc1fe4f8b778","author":{"_account_id":6732,"name":"Lingxian Kong","email":"anlin.kong@gmail.com","username":"kong"},"date":"2020-10-23 11:10:54.000000000","message":"Uploaded patch set 2.","accounts_in_message":[],"_revision_number":2},{"id":"6e47d49c894eb2e21a881216d9aa88b35c8deec0","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-10-23 11:32:52.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/42907b834fb042c198667b7af95e2550 : SUCCESS in 8m 42s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/d4ffdf11d95c450584fd1a5a263026d3 : FAILURE in 8m 52s (non-voting)\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/b81f8487cdfc48fb8ada9ce134a1b3c5 : SUCCESS in 8m 25s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/f7aed1c6e9b7468f82353c44b71095cd : SUCCESS in 7m 10s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/07621942af2e4809bb067a4bf5180741 : SUCCESS in 8m 02s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/f290945c21894d2cbb7ed5b8ef46e681 : SUCCESS in 7m 50s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/9c08fa9819e34334b63813bd66cd5ea8 : SUCCESS in 6m 55s\n- trove-tox-bandit-baseline https://zuul.opendev.org/t/openstack/build/ee9ea565119b4df9a6e1522fac0af1c9 : SUCCESS in 8m 02s (non-voting)\n- trove-tempest https://zuul.opendev.org/t/openstack/build/15176a9e8aac4094a64b7962709bb592 : FAILURE in 7m 05s (non-voting)\n- trove-tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/8b56d7b00b8b41d3abcb50bdb448bb32 : FAILURE in 5m 54s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"16444bd7372ae176108fd4a623fe24377d68be85","author":{"_account_id":6732,"name":"Lingxian Kong","email":"anlin.kong@gmail.com","username":"kong"},"date":"2020-10-26 07:52:44.000000000","message":"Patch Set 2: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":2},{"id":"2e1c5384383add039f064e490d120e6b209e7eb7","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-10-26 07:52:55.000000000","message":"Patch Set 2: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":2},{"id":"ad25c0b5c381c5eaf0da6cc94981145b6b525fe4","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-10-26 09:53:09.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":2},{"id":"af2230e7d8dc38c80c186a6fcc3c86a5bb51dd06","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-10-26 09:53:09.000000000","message":"Patch Set 2: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/febb0c43a4924feaa11b3c31873b863a : SUCCESS in 3m 16s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/a8c50b126b2443acb9bee402a2c80470 : SUCCESS in 6m 03s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/1798fb36db0f40859312d6187b11c4dd : SUCCESS in 4m 55s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/37a284c8b556482e8bf7acd8f21c6953 : SUCCESS in 5m 38s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/e4b2a2526b8d4a6baf0ef81d525cdece : SUCCESS in 7m 56s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/e0a876a8d5134a6d8c87b5bdbe873921 : SUCCESS in 5m 34s\n- trove-tempest https://zuul.opendev.org/t/openstack/build/034d26627b58454aa29bce992f51ff75 : FAILURE in 1h 58m 46s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"c1f3839beee58f45a68a344cde8d8e9f998e0e87","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-10-26 09:54:22.000000000","message":"Patch Set 2:\n\nBuild succeeded (promote pipeline).\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/8e8c9d710b8f4286ae140ceaf58305f3 : SUCCESS in 50s","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"d1af33f17b0994ac1d0ca5acca91f2f29bc82ce9","revisions":{"25ffbeba3f8709340284720f8e7ccfe5e5632e55":{"kind":"REWORK","_number":1,"created":"2020-10-23 01:14:31.000000000","uploader":{"_account_id":6732,"name":"Lingxian Kong","email":"anlin.kong@gmail.com","username":"kong"},"ref":"refs/changes/37/759337/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/trove","ref":"refs/changes/37/759337/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/trove refs/changes/37/759337/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/trove refs/changes/37/759337/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/trove refs/changes/37/759337/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/trove refs/changes/37/759337/1"}}},"commit":{"parents":[{"commit":"4df3dceeeee8d92f1c876effa4375f88e3249bca","subject":"Merge \"Update quota API description\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/trove/commit/4df3dceeeee8d92f1c876effa4375f88e3249bca"}]}],"author":{"name":"Lingxian Kong","email":"anlin.kong@gmail.com","date":"2020-10-13 10:51:46.000000000","tz":780},"committer":{"name":"Lingxian Kong","email":"anlin.kong@gmail.com","date":"2020-10-23 01:13:35.000000000","tz":780},"subject":"Support mysql 8.0","message":"Support mysql 8.0\n\n* MySQL 5.7 and MySQL 8.0 need different percona-xtrabackup package version.\n  Added Percona XtraBackup 8 support for MySQL 8.x backup and restore.\n* Construct different backup container image names for MySQL 5.7 and MySQL 8.0\n  based on the default option value.\n* Two docker images are uploaded for backup/restore:\n  openstacktrove/db-backup-mysql5.7:1.0.0 and\n  openstacktrove/db-backup-mysql8.0:1.0.0. Trove guest agent can automatically\n  choose the approriate one based on the datastore version.\n* Added option \"secure-file-priv\u003dNULL\" in MySQL config template to fix\n  https://github.com/docker-library/mysql/issues/541.\n* Stop using IDENTIFIED BY in GRANT clause (also REVOKE). Starting with MySQL 8\n  creating a user implicitly using the GRANT command is not supported.\n\nStory: #2008275\nTask: #41143\n\nChange-Id: Ibdec63324b1b39ba9b8a38dbe529da17bbb06767\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/trove/commit/25ffbeba3f8709340284720f8e7ccfe5e5632e55"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/trove/commit/25ffbeba3f8709340284720f8e7ccfe5e5632e55"}]},"branch":"refs/heads/master"},"d1af33f17b0994ac1d0ca5acca91f2f29bc82ce9":{"kind":"REWORK","_number":2,"created":"2020-10-23 11:10:54.000000000","uploader":{"_account_id":6732,"name":"Lingxian Kong","email":"anlin.kong@gmail.com","username":"kong"},"ref":"refs/changes/37/759337/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/trove","ref":"refs/changes/37/759337/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/trove refs/changes/37/759337/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/trove refs/changes/37/759337/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/trove refs/changes/37/759337/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/trove refs/changes/37/759337/2"}}},"commit":{"parents":[{"commit":"4df3dceeeee8d92f1c876effa4375f88e3249bca","subject":"Merge \"Update quota API description\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/trove/commit/4df3dceeeee8d92f1c876effa4375f88e3249bca"}]}],"author":{"name":"Lingxian Kong","email":"anlin.kong@gmail.com","date":"2020-10-13 10:51:46.000000000","tz":780},"committer":{"name":"Lingxian Kong","email":"anlin.kong@gmail.com","date":"2020-10-23 10:50:39.000000000","tz":780},"subject":"Support mysql 8.0","message":"Support mysql 8.0\n\n* MySQL 5.7 and MySQL 8.0 need different percona-xtrabackup package version.\n  Added Percona XtraBackup 8 support for MySQL 8.x backup and restore.\n* Construct different backup container image names for MySQL 5.7 and MySQL 8.0\n  based on the default option value.\n* Two docker images are uploaded for backup/restore:\n  openstacktrove/db-backup-mysql5.7:1.0.0 and\n  openstacktrove/db-backup-mysql8.0:1.0.0. Trove guest agent can automatically\n  choose the approriate one based on the datastore version.\n* Added option \"secure-file-priv\u003dNULL\" in MySQL config template to fix\n  https://github.com/docker-library/mysql/issues/541.\n* Stop using IDENTIFIED BY in GRANT clause (also REVOKE). Starting with MySQL 8\n  creating a user implicitly using the GRANT command is not supported.\n\nStory: #2008275\nTask: #41143\n\nChange-Id: Ibdec63324b1b39ba9b8a38dbe529da17bbb06767\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/trove/commit/d1af33f17b0994ac1d0ca5acca91f2f29bc82ce9"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/trove/commit/d1af33f17b0994ac1d0ca5acca91f2f29bc82ce9"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}