)]}'
{"id":"openstack%2Fopenstack-helm-infra~705867","triplet_id":"openstack%2Fopenstack-helm-infra~master~I805c605ed2b424640ad6a0a379b1c0b9c0004e94","project":"openstack/openstack-helm-infra","branch":"master","hashtags":[],"change_id":"I805c605ed2b424640ad6a0a379b1c0b9c0004e94","subject":"Fix MariaDB Single Database Restore","status":"MERGED","created":"2020-02-04 23:47:39.000000000","updated":"2020-02-11 22:25:28.000000000","submitted":"2020-02-11 22:22:06.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":9,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"705867-1581459726413-2176cf01","meta_rev_id":"928e843ed7d21fd6e0579602bc52553e900096fe","_number":705867,"virtual_id_number":705867,"owner":{"_account_id":22636,"name":"Cliff Parsons","email":"cliffhparsons@aol.com","username":"cliffparsons"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":20466,"name":"Tin Lam","email":"tin@lam.wtf","username":"tinlam"},{"value":0,"_account_id":8898,"name":"Chris Wedgwood","email":"cw@f00f.org","username":"anticw"},{"value":0,"_account_id":18250,"name":"Roy Tang","email":"roy.s.tang@att.com","username":"rt7380"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2020-02-11 22:22:06.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":24780,"name":"Sangeet Gupta","email":"sg774j@att.com","username":"sgupta"},{"value":0,"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},{"value":0,"date":"2020-02-06 16:18:17.000000000","_account_id":22636,"name":"Cliff Parsons","email":"cliffhparsons@aol.com","username":"cliffparsons"},{"value":0,"_account_id":14029,"name":"Alexander Vlasov","email":"vlasov.alexandr89@gmail.com","username":"avlasov"},{"value":0,"_account_id":11934,"name":"Scott Grasley","email":"sg0818@att.com","username":"grasley"}],"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":8898,"name":"Chris Wedgwood","email":"cw@f00f.org","username":"anticw"},"all":[{"value":0,"_account_id":20466,"name":"Tin Lam","email":"tin@lam.wtf","username":"tinlam"},{"value":2,"date":"2020-02-11 21:19:09.000000000","_account_id":8898,"name":"Chris Wedgwood","email":"cw@f00f.org","username":"anticw"},{"value":1,"date":"2020-02-06 16:57:54.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":18250,"name":"Roy Tang","email":"roy.s.tang@att.com","username":"rt7380"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":24780,"name":"Sangeet Gupta","email":"sg774j@att.com","username":"sgupta"},{"value":2,"date":"2020-02-11 20:09:11.000000000","_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},{"value":0,"_account_id":22636,"name":"Cliff Parsons","email":"cliffhparsons@aol.com","username":"cliffparsons"},{"value":0,"_account_id":14029,"name":"Alexander Vlasov","email":"vlasov.alexandr89@gmail.com","username":"avlasov"},{"value":1,"date":"2020-02-06 17:10:05.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":11934,"name":"Scott Grasley","email":"sg0818@att.com","username":"grasley"}],"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":8898,"name":"Chris Wedgwood","email":"cw@f00f.org","username":"anticw"},"all":[{"value":0,"_account_id":20466,"name":"Tin Lam","email":"tin@lam.wtf","username":"tinlam"},{"value":1,"date":"2020-02-11 21:19:09.000000000","_account_id":8898,"name":"Chris Wedgwood","email":"cw@f00f.org","username":"anticw"},{"value":0,"_account_id":18250,"name":"Roy Tang","email":"roy.s.tang@att.com","username":"rt7380"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":24780,"name":"Sangeet Gupta","email":"sg774j@att.com","username":"sgupta"},{"value":0,"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},{"value":0,"_account_id":22636,"name":"Cliff Parsons","email":"cliffhparsons@aol.com","username":"cliffparsons"},{"value":0,"_account_id":14029,"name":"Alexander Vlasov","email":"vlasov.alexandr89@gmail.com","username":"avlasov"},{"value":0,"_account_id":11934,"name":"Scott Grasley","email":"sg0818@att.com","username":"grasley"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":8898,"name":"Chris Wedgwood","email":"cw@f00f.org","username":"anticw"},{"_account_id":11934,"name":"Scott Grasley","email":"sg0818@att.com","username":"grasley"},{"_account_id":14029,"name":"Alexander Vlasov","email":"vlasov.alexandr89@gmail.com","username":"avlasov"},{"_account_id":18250,"name":"Roy Tang","email":"roy.s.tang@att.com","username":"rt7380"},{"_account_id":20466,"name":"Tin Lam","email":"tin@lam.wtf","username":"tinlam"},{"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":22636,"name":"Cliff Parsons","email":"cliffhparsons@aol.com","username":"cliffparsons"},{"_account_id":24780,"name":"Sangeet Gupta","email":"sg774j@att.com","username":"sgupta"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2020-02-05 14:30:56.000000000","updated_by":{"_account_id":14029,"name":"Alexander Vlasov","email":"vlasov.alexandr89@gmail.com","username":"avlasov"},"reviewer":{"_account_id":14029,"name":"Alexander Vlasov","email":"vlasov.alexandr89@gmail.com","username":"avlasov"},"state":"REVIEWER"},{"updated":"2020-02-05 16:03:20.000000000","updated_by":{"_account_id":24780,"name":"Sangeet Gupta","email":"sg774j@att.com","username":"sgupta"},"reviewer":{"_account_id":24780,"name":"Sangeet Gupta","email":"sg774j@att.com","username":"sgupta"},"state":"REVIEWER"},{"updated":"2020-02-05 16:57:42.000000000","updated_by":{"_account_id":20466,"name":"Tin Lam","email":"tin@lam.wtf","username":"tinlam"},"reviewer":{"_account_id":20466,"name":"Tin Lam","email":"tin@lam.wtf","username":"tinlam"},"state":"REVIEWER"},{"updated":"2020-02-06 16:57:54.000000000","updated_by":{"_account_id":18250,"name":"Roy Tang","email":"roy.s.tang@att.com","username":"rt7380"},"reviewer":{"_account_id":18250,"name":"Roy Tang","email":"roy.s.tang@att.com","username":"rt7380"},"state":"REVIEWER"},{"updated":"2020-02-06 17:10:05.000000000","updated_by":{"_account_id":11934,"name":"Scott Grasley","email":"sg0818@att.com","username":"grasley"},"reviewer":{"_account_id":11934,"name":"Scott Grasley","email":"sg0818@att.com","username":"grasley"},"state":"REVIEWER"},{"updated":"2020-02-11 20:09:11.000000000","updated_by":{"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},"reviewer":{"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},"state":"REVIEWER"},{"updated":"2020-02-11 21:19:09.000000000","updated_by":{"_account_id":8898,"name":"Chris Wedgwood","email":"cw@f00f.org","username":"anticw"},"reviewer":{"_account_id":8898,"name":"Chris Wedgwood","email":"cw@f00f.org","username":"anticw"},"state":"REVIEWER"},{"updated":"2020-02-11 22:22:06.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":"f4c592711fa0e2f9b0d82037c812d7d0cff98567","author":{"_account_id":22636,"name":"Cliff Parsons","email":"cliffhparsons@aol.com","username":"cliffparsons"},"date":"2020-02-04 23:47:39.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"59e541b562910a7b07e7b28d2c370ddea0ee886b","author":{"_account_id":22636,"name":"Cliff Parsons","email":"cliffhparsons@aol.com","username":"cliffparsons"},"date":"2020-02-04 23:50:32.000000000","message":"Uploaded patch set 2: Commit message was updated.","accounts_in_message":[],"_revision_number":2},{"id":"d7486d3c884891613afe3c365b43ad854165f3b4","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-02-05 00:46:16.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\n\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/b274a22855b2423eab3bececd979931c : SUCCESS in 3m 10s\n- openstack-helm-lint https://zuul.opendev.org/t/openstack/build/f59c6712b98143feb59d800a6c7b5c67 : SUCCESS in 2m 13s\n- openstack-helm-infra-bandit https://zuul.opendev.org/t/openstack/build/3a210fecfcd743e5a8f55a3e8d934f30 : FAILURE in 7m 31s (non-voting)\n- openstack-helm-infra-aio-logging https://zuul.opendev.org/t/openstack/build/5bf673caf6dc4516b3fc930049e324b1 : SUCCESS in 54m 39s\n- openstack-helm-infra-aio-monitoring https://zuul.opendev.org/t/openstack/build/4bf5b15b4a6047629c813d0728238dd5 : SUCCESS in 37m 24s\n- openstack-helm-infra-federated-monitoring https://zuul.opendev.org/t/openstack/build/f5336838ff2445ea95eb2b900cfc5138 : FAILURE in 35m 43s (non-voting)\n- openstack-helm-infra-kafka https://zuul.opendev.org/t/openstack/build/2a1a394622604ab4a4a2e6f816a40e4c : SUCCESS in 38m 37s (non-voting)\n- openstack-helm-infra-aio-network-policy https://zuul.opendev.org/t/openstack/build/0ab23c9abeb84fd4b8fd53253ba308cd : FAILURE in 40m 12s (non-voting)\n- openstack-helm-infra-openstack-support https://zuul.opendev.org/t/openstack/build/1378331bab4c4746847bd22c61d6963a : SUCCESS in 48m 29s\n- openstack-helm-infra-airship-divingbell https://zuul.opendev.org/t/openstack/build/324d848244644889aec138ff8d148b0c : SUCCESS in 13m 15s (non-voting)\n- openstack-helm-infra-aio-podsecuritypolicy https://zuul.opendev.org/t/openstack/build/bd74e393c5d74526a2caec2fb39242a1 : FAILURE in 14m 29s (non-voting)\n- openstack-helm-infra-apparmor https://zuul.opendev.org/t/openstack/build/69df876a4a194318996af77c910d0847 : FAILURE in 43m 53s (non-voting)\n- openstack-helm-infra-local-storage https://zuul.opendev.org/t/openstack/build/da881ca8ba554f6e94274663cd9e6605 : SUCCESS in 23m 24s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"8a7f13741664e8293748e0a4e961425232f6118f","author":{"_account_id":14029,"name":"Alexander Vlasov","email":"vlasov.alexandr89@gmail.com","username":"avlasov"},"date":"2020-02-05 14:30:56.000000000","message":"Patch Set 2: Code-Review+1","accounts_in_message":[],"_revision_number":2},{"id":"ec5358a7a6b365db1a89f1ec0c50c78b5c07e1ff","author":{"_account_id":11934,"name":"Scott Grasley","email":"sg0818@att.com","username":"grasley"},"date":"2020-02-05 15:02:01.000000000","message":"Patch Set 2: Code-Review+1","accounts_in_message":[],"_revision_number":2},{"id":"3eb707df1a75b122ee89b2e33db3b8f2e87d51ea","author":{"_account_id":24780,"name":"Sangeet Gupta","email":"sg774j@att.com","username":"sgupta"},"date":"2020-02-05 16:03:20.000000000","message":"Patch Set 2: Code-Review+1","accounts_in_message":[],"_revision_number":2},{"id":"a5742d05d6868b2b004e040dbee65a2aad58cf26","author":{"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},"date":"2020-02-05 16:50:08.000000000","message":"Patch Set 2: Code-Review+1","accounts_in_message":[],"_revision_number":2},{"id":"4f5a2346224bc2e427a24a842dfb33b85b6f763a","author":{"_account_id":20466,"name":"Tin Lam","email":"tin@lam.wtf","username":"tinlam"},"date":"2020-02-05 16:57:42.000000000","message":"Patch Set 2: Code-Review-1\n\n(3 comments)","accounts_in_message":[],"_revision_number":2},{"id":"54108e5d732759c9e591bffc82560821925cdbb5","author":{"_account_id":18250,"name":"Roy Tang","email":"roy.s.tang@att.com","username":"rt7380"},"date":"2020-02-05 17:43:19.000000000","message":"Patch Set 2: Code-Review-1\n\n(2 comments)","accounts_in_message":[],"_revision_number":2},{"id":"67f53a752990f1b3df78fb94ad6730ca2e0a0b10","author":{"_account_id":22636,"name":"Cliff Parsons","email":"cliffhparsons@aol.com","username":"cliffparsons"},"date":"2020-02-06 16:17:56.000000000","message":"Uploaded patch set 3.","accounts_in_message":[],"_revision_number":3},{"id":"8a25c14ba608141693d5480512200e7b831e1a4e","author":{"_account_id":22636,"name":"Cliff Parsons","email":"cliffhparsons@aol.com","username":"cliffparsons"},"date":"2020-02-06 16:18:17.000000000","message":"Patch Set 3:\n\n(4 comments)","accounts_in_message":[],"_revision_number":3},{"id":"a7dee9f743076820fd886b8176007f0c2c8058af","author":{"_account_id":18250,"name":"Roy Tang","email":"roy.s.tang@att.com","username":"rt7380"},"date":"2020-02-06 16:57:54.000000000","message":"Patch Set 3: Code-Review+1","accounts_in_message":[],"_revision_number":3},{"id":"a2af00a918914165bd93c4a45f33822431a617fa","author":{"_account_id":11934,"name":"Scott Grasley","email":"sg0818@att.com","username":"grasley"},"date":"2020-02-06 17:10:05.000000000","message":"Patch Set 3: Code-Review+1","accounts_in_message":[],"_revision_number":3},{"id":"5403795e395384982d9f308b3654119883110749","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-02-06 17:15:10.000000000","message":"Patch Set 3: Verified+1\n\nBuild succeeded (check pipeline).\n\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/6bf654bc95e944d18ada0d38a47b9c28 : SUCCESS in 5m 38s\n- openstack-helm-lint https://zuul.opendev.org/t/openstack/build/51b7ae54ba294666b484b97dd8d3ecef : SUCCESS in 5m 09s\n- openstack-helm-infra-bandit https://zuul.opendev.org/t/openstack/build/7bf00b1932e3421fa7fedb24a7cdd369 : FAILURE in 8m 52s (non-voting)\n- openstack-helm-infra-aio-logging https://zuul.opendev.org/t/openstack/build/741630f37bf94f308bb7304bfe58ca3e : SUCCESS in 52m 08s\n- openstack-helm-infra-aio-monitoring https://zuul.opendev.org/t/openstack/build/de6cc217cca641f8b7838b422529e474 : SUCCESS in 49m 59s\n- openstack-helm-infra-federated-monitoring https://zuul.opendev.org/t/openstack/build/432899410cc84467bf6561da22ee66f3 : FAILURE in 36m 54s (non-voting)\n- openstack-helm-infra-kafka https://zuul.opendev.org/t/openstack/build/827f8e13f58c4ab4acde1b8f5de629ba : SUCCESS in 40m 21s (non-voting)\n- openstack-helm-infra-aio-network-policy https://zuul.opendev.org/t/openstack/build/a30bd887ba3844bab69b2a26a57d2db8 : SUCCESS in 36m 44s (non-voting)\n- openstack-helm-infra-openstack-support https://zuul.opendev.org/t/openstack/build/6a8fca05fd5641d3ad897a6428ab2f26 : SUCCESS in 54m 39s\n- openstack-helm-infra-airship-divingbell https://zuul.opendev.org/t/openstack/build/ac5f1670eb3c42aba5c7b6853db3bad4 : SUCCESS in 14m 29s (non-voting)\n- openstack-helm-infra-aio-podsecuritypolicy https://zuul.opendev.org/t/openstack/build/74a7f8e566c8480ab4e8c8d24d26b140 : FAILURE in 16m 13s (non-voting)\n- openstack-helm-infra-apparmor https://zuul.opendev.org/t/openstack/build/d697293b887c47168518bc547dfd8dd6 : SUCCESS in 34m 29s (non-voting)\n- openstack-helm-infra-local-storage https://zuul.opendev.org/t/openstack/build/25ac250ad0454038837e7589b439427e : SUCCESS in 22m 51s (non-voting)","accounts_in_message":[],"_revision_number":3},{"id":"475da5244d55c67217df5a0468431f7b9f0148a5","author":{"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},"date":"2020-02-11 20:09:11.000000000","message":"Patch Set 3: Code-Review+2","accounts_in_message":[],"_revision_number":3},{"id":"8df1d9299edbe205c67db667acda68eadc217c7d","author":{"_account_id":8898,"name":"Chris Wedgwood","email":"cw@f00f.org","username":"anticw"},"date":"2020-02-11 21:19:09.000000000","message":"Patch Set 3: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":3},{"id":"af012746509e3502bfba45f42c4820585fbdd832","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-02-11 21:19:23.000000000","message":"Patch Set 3: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":3},{"id":"1978e5bd06022977761733a72101ec07a05b769a","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-02-11 22:22:06.000000000","message":"Patch Set 3: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/a90ee13d064443d59895676b75d59eed : SUCCESS in 6m 01s\n- openstack-helm-lint https://zuul.opendev.org/t/openstack/build/e7b4862c2cd44a88a218aa7eb1f04250 : SUCCESS in 3m 29s\n- openstack-helm-infra-aio-logging https://zuul.opendev.org/t/openstack/build/06602bae38cf47cbb33b98fa4401a978 : SUCCESS in 49m 50s\n- openstack-helm-infra-aio-monitoring https://zuul.opendev.org/t/openstack/build/b2c45a0fadc544abaa7cc85ae5d96cdf : SUCCESS in 41m 12s\n- openstack-helm-infra-openstack-support https://zuul.opendev.org/t/openstack/build/e3094599580140d786091461fd432bce : SUCCESS in 59m 19s","accounts_in_message":[],"_revision_number":3},{"id":"17d46ffcabbdfe0b62dd71141198385c911e5c49","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-02-11 22:22:06.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":3},{"id":"928e843ed7d21fd6e0579602bc52553e900096fe","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-02-11 22:25:28.000000000","message":"Patch Set 3:\n\nBuild succeeded (promote pipeline).\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/53a1bfe06edf4c1fba1dbb6ff5fcb8b6 : SUCCESS in 1m 20s","accounts_in_message":[],"_revision_number":3}],"current_revision_number":3,"current_revision":"ef9d8392f27b801b79b2b913cd338ddd0a612e59","revisions":{"dbff81b95a53051d009aa0d10fd3dd45acde68cd":{"kind":"REWORK","_number":1,"created":"2020-02-04 23:47:39.000000000","uploader":{"_account_id":22636,"name":"Cliff Parsons","email":"cliffhparsons@aol.com","username":"cliffparsons"},"ref":"refs/changes/67/705867/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/openstack-helm-infra","ref":"refs/changes/67/705867/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/67/705867/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/67/705867/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/67/705867/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/openstack-helm-infra refs/changes/67/705867/1"}}},"commit":{"parents":[{"commit":"92dfac645a564f46fe6c74a3c706a3598a758b8a","subject":"[Ceph Nautilus] Fix _checkPGs.py.tpl for Nautilus compatibility","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/92dfac645a564f46fe6c74a3c706a3598a758b8a"}]}],"author":{"name":"Parsons, Cliff (cp769u)","email":"cp769u@att.com","date":"2020-02-04 23:38:16.000000000","tz":0},"committer":{"name":"Parsons, Cliff (cp769u)","email":"cp769u@att.com","date":"2020-02-04 23:38:16.000000000","tz":0},"subject":"Fix MariaDB Single Database Restore","message":"Fix MariaDB Single Database Restore\n\nThis patchset fixes a serious database restoration problem where the\nuser is trying to restore a single database, but in the process of\nrestoring the database, the script inadvertently also removes all\ntables from the other databases.\n\nThe root cause was that the mysql \"--one-database\" restore option\nachieves the single database restoration, but somehow corrupts the\nother databases. The new approach taken in this patchset is to\ncreate a temporary database user which only has permission to\nrestore the chosen database, and that will leave the other databases\nunharmed. This approach, which can be applied for restoring\nindividual databases and even database tables, was recommended in (1).\nAfter the database is restored, the temporary user is deleted.\n\n(1) https://mariadb.com/kb/en/restoring-data-from-dump-files/\n\nChange-Id: I805c605ed2b424640ad6a0a379b1c0b9c0004e94\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/dbff81b95a53051d009aa0d10fd3dd45acde68cd"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/dbff81b95a53051d009aa0d10fd3dd45acde68cd"}]},"branch":"refs/heads/master"},"c2f361af5f455344fef1e516f4aa0f88071a67d7":{"kind":"NO_CODE_CHANGE","_number":2,"created":"2020-02-04 23:50:32.000000000","uploader":{"_account_id":22636,"name":"Cliff Parsons","email":"cliffhparsons@aol.com","username":"cliffparsons"},"ref":"refs/changes/67/705867/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/openstack-helm-infra","ref":"refs/changes/67/705867/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/67/705867/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/67/705867/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/67/705867/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/openstack-helm-infra refs/changes/67/705867/2"}}},"commit":{"parents":[{"commit":"92dfac645a564f46fe6c74a3c706a3598a758b8a","subject":"[Ceph Nautilus] Fix _checkPGs.py.tpl for Nautilus compatibility","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/92dfac645a564f46fe6c74a3c706a3598a758b8a"}]}],"author":{"name":"Parsons, Cliff (cp769u)","email":"cp769u@att.com","date":"2020-02-04 23:38:16.000000000","tz":0},"committer":{"name":"Parsons, Cliff (cp769u)","email":"cp769u@att.com","date":"2020-02-04 23:49:43.000000000","tz":0},"subject":"Fix MariaDB Single Database Restore","message":"Fix MariaDB Single Database Restore\n\nThis patchset fixes a serious database restoration problem where the\nuser is trying to restore a single database, but in the process of\nrestoring the database, the script inadvertently also removes all\ntables from the other databases.\n\nThe root cause was that the mysql \"--one-database\" restore option\nachieves the single database restoration, but somehow corrupts the\nother databases. The new approach taken in this patchset is to\ncreate a temporary database user which only has permission to\nrestore the chosen database, and that will leave the other databases\nunharmed. This approach, which can be applied for restoring\nindividual databases and even database tables, was recommended in (1).\nAfter the database is restored, the temporary user is deleted.\n\n(1) https://mariadb.com/kb/en/restoring-data-from-dump-files/\n\nAlso improved some of the error handling as well.\n\nChange-Id: I805c605ed2b424640ad6a0a379b1c0b9c0004e94\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/c2f361af5f455344fef1e516f4aa0f88071a67d7"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/c2f361af5f455344fef1e516f4aa0f88071a67d7"}]},"branch":"refs/heads/master"},"ef9d8392f27b801b79b2b913cd338ddd0a612e59":{"kind":"REWORK","_number":3,"created":"2020-02-06 16:17:56.000000000","uploader":{"_account_id":22636,"name":"Cliff Parsons","email":"cliffhparsons@aol.com","username":"cliffparsons"},"ref":"refs/changes/67/705867/3","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/openstack-helm-infra","ref":"refs/changes/67/705867/3","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/67/705867/3 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/67/705867/3 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/67/705867/3 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/openstack-helm-infra refs/changes/67/705867/3"}}},"commit":{"parents":[{"commit":"92dfac645a564f46fe6c74a3c706a3598a758b8a","subject":"[Ceph Nautilus] Fix _checkPGs.py.tpl for Nautilus compatibility","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/92dfac645a564f46fe6c74a3c706a3598a758b8a"}]}],"author":{"name":"Parsons, Cliff (cp769u)","email":"cp769u@att.com","date":"2020-02-04 23:38:16.000000000","tz":0},"committer":{"name":"Parsons, Cliff (cp769u)","email":"cp769u@att.com","date":"2020-02-06 16:17:28.000000000","tz":0},"subject":"Fix MariaDB Single Database Restore","message":"Fix MariaDB Single Database Restore\n\nThis patchset fixes a serious database restoration problem where the\nuser is trying to restore a single database, but in the process of\nrestoring the database, the script inadvertently also removes all\ntables from the other databases.\n\nThe root cause was that the mysql \"--one-database\" restore option\nachieves the single database restoration, but somehow corrupts the\nother databases. The new approach taken in this patchset is to\ncreate a temporary database user which only has permission to\nrestore the chosen database, and that will leave the other databases\nunharmed. This approach, which can be applied for restoring\nindividual databases and even database tables, was recommended in (1).\nAfter the database is restored, the temporary user is deleted.\n\n(1) https://mariadb.com/kb/en/restoring-data-from-dump-files/\n\nAlso improved some of the error handling as well.\n\nChange-Id: I805c605ed2b424640ad6a0a379b1c0b9c0004e94\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/ef9d8392f27b801b79b2b913cd338ddd0a612e59"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/ef9d8392f27b801b79b2b913cd338ddd0a612e59"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}