)]}'
{"id":"openstack%2Fopenstack-helm-infra~693362","triplet_id":"openstack%2Fopenstack-helm-infra~master~I2104aef8f75b55031fa1aa6ac2552fbb4f019453","project":"openstack/openstack-helm-infra","branch":"master","topic":"mariadb_upgrade_up","hashtags":[],"change_id":"I2104aef8f75b55031fa1aa6ac2552fbb4f019453","subject":"Add upgrade mariadb functionality","status":"ABANDONED","created":"2019-11-07 14:35:18.000000000","updated":"2020-08-26 19:27:16.000000000","total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"1e21d24262640dcc70cbbac02a2010cc3f619cc1","_number":693362,"virtual_id_number":693362,"owner":{"_account_id":18795,"name":"mkarpin","email":"mkarpin@mirantis.com","username":"nkarpin"},"actions":{},"labels":{"Verified":{"disliked":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"tag":"autogenerated:zuul:check","value":-1,"date":"2019-11-11 09:23:00.000000000","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":"","value":-1,"default_value":0,"optional":true},"Code-Review":{"all":[{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_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":{"all":[{"_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}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2019-11-11 09:23:00.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":"1fd4f8aaf2178784e56874598bc4f20a5173e43c","author":{"_account_id":18795,"name":"mkarpin","email":"mkarpin@mirantis.com","username":"nkarpin"},"date":"2019-11-07 14:35:18.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"fed8963955d78908cbe677601452af3dba9e84bc","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-11-07 15:32:34.000000000","message":"Patch Set 1: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttp://docs.openstack.org/infra/manual/developers.html#automated-testing\n\n\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/52e521753f47464d9e63f9648965e643 : SUCCESS in 2m 46s\n- openstack-helm-lint https://zuul.opendev.org/t/openstack/build/c1d49b85cf434127ab05a7e0ed6c5ba2 : SUCCESS in 1m 57s\n- openstack-helm-infra-aio-logging https://zuul.opendev.org/t/openstack/build/6b626a326c004edba932445ee1a54c80 : SUCCESS in 38m 52s\n- openstack-helm-infra-aio-monitoring https://zuul.opendev.org/t/openstack/build/2eca3606c2e741118dfaa76c2a377a04 : FAILURE in 34m 56s\n- openstack-helm-infra-aio-network-policy https://zuul.opendev.org/t/openstack/build/9705e5cac4c846e898f7a425b7eaf240 : FAILURE in 31m 45s (non-voting)\n- openstack-helm-infra-openstack-support https://zuul.opendev.org/t/openstack/build/b0eb78661f4b4851a2ed8407e40cc0f6 : FAILURE in 56m 46s\n- openstack-helm-infra-kubernetes-keystone-auth https://zuul.opendev.org/t/openstack/build/3df64ec58411401ba34fc16b3bcea384 : FAILURE in 47m 39s\n- openstack-helm-infra-airship-divingbell https://zuul.opendev.org/t/openstack/build/20de69a1e74d423194b9ebd3d14f80ad : SUCCESS in 12m 16s (non-voting)\n- openstack-helm-infra-aio-podsecuritypolicy https://zuul.opendev.org/t/openstack/build/73bbcd3666ce4b1a8b5b677a624a7c14 : FAILURE in 13m 18s (non-voting)\n- openstack-helm-infra-apparmor https://zuul.opendev.org/t/openstack/build/3fd05285e5104a04a90d1c72f586dfce : SUCCESS in 31m 06s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"8c31fd1b34f42972632f24723cdbc1549b8421da","author":{"_account_id":18795,"name":"mkarpin","email":"mkarpin@mirantis.com","username":"nkarpin"},"date":"2019-11-11 07:40:06.000000000","message":"Patch Set 2: Published edit on patch set 1.","accounts_in_message":[],"_revision_number":2},{"id":"474c24a35298bbfaa0d3058567182a441764e796","author":{"_account_id":18795,"name":"mkarpin","email":"mkarpin@mirantis.com","username":"nkarpin"},"date":"2019-11-11 07:40:12.000000000","message":"Patch Set 3: Patch Set 2 was rebased","accounts_in_message":[],"_revision_number":3},{"id":"efc493029ee89c208a11db07a8ce1f581ae1389e","author":{"_account_id":18795,"name":"mkarpin","email":"mkarpin@mirantis.com","username":"nkarpin"},"date":"2019-11-11 08:10:50.000000000","message":"Patch Set 4: Published edit on patch set 3.","accounts_in_message":[],"_revision_number":4},{"id":"195ea905194e617321f94f3c6eb815e6980f35ae","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2019-11-11 09:23:00.000000000","message":"Patch Set 4: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttp://docs.openstack.org/infra/manual/developers.html#automated-testing\n\n\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/4bba102f97ac408e82ad0dbdc8b4261c : SUCCESS in 3m 52s\n- openstack-helm-lint https://zuul.opendev.org/t/openstack/build/82abb00887e34975b97143d3c815d4ed : SUCCESS in 2m 28s\n- openstack-helm-infra-aio-logging https://zuul.opendev.org/t/openstack/build/1397bd1b6edd40aab40c9d8529b0a78a : SUCCESS in 1h 11m 47s\n- openstack-helm-infra-aio-monitoring https://zuul.opendev.org/t/openstack/build/ccfcd2bf7a854310bca22ed140530886 : SUCCESS in 49m 24s\n- openstack-helm-infra-aio-network-policy https://zuul.opendev.org/t/openstack/build/5c4824716687410baddeefb79e58a8a6 : FAILURE in 56m 10s (non-voting)\n- openstack-helm-infra-openstack-support https://zuul.opendev.org/t/openstack/build/4c7e96b4821c493483174183709ad879 : SUCCESS in 55m 48s\n- openstack-helm-infra-kubernetes-keystone-auth https://zuul.opendev.org/t/openstack/build/9ea0a5fac0be42e5bb0da29a995f0e77 : FAILURE in 47m 52s\n- openstack-helm-infra-airship-divingbell https://zuul.opendev.org/t/openstack/build/b4892d7f92a940f3a0209557df91ce06 : SUCCESS in 11m 11s (non-voting)\n- openstack-helm-infra-aio-podsecuritypolicy https://zuul.opendev.org/t/openstack/build/4cb2f12ba07c427ea5ee8829c18d08c4 : FAILURE in 17m 19s (non-voting)\n- openstack-helm-infra-apparmor https://zuul.opendev.org/t/openstack/build/da34ae1701684d44ba4ab6538715e7b0 : SUCCESS in 34m 46s (non-voting)","accounts_in_message":[],"_revision_number":4},{"id":"f13e593fc28466dd040d23339ee8502c0f1c2e40","author":{"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},"date":"2020-08-26 19:27:16.000000000","message":"Abandoned\n\nAbandoning since there hasn\u0027t been any recent activity, if anyone wants to continue this work, please feel free to restore this.","accounts_in_message":[],"_revision_number":4}],"current_revision_number":4,"current_revision":"5ef2b2ca200c640823ae49d26db70836cec5feb5","revisions":{"056c59c4c6e994a6c28db3878b51840f8fa615a8":{"kind":"REWORK","_number":1,"created":"2019-11-07 14:35:18.000000000","uploader":{"_account_id":18795,"name":"mkarpin","email":"mkarpin@mirantis.com","username":"nkarpin"},"ref":"refs/changes/62/693362/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/openstack-helm-infra","ref":"refs/changes/62/693362/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/62/693362/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/62/693362/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/62/693362/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/openstack-helm-infra refs/changes/62/693362/1"}}},"commit":{"parents":[{"commit":"9d808c96fa5974841d089496aef06850f561a851","subject":"Adding missing readOnlyRootFilesystem flag for container security context","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/9d808c96fa5974841d089496aef06850f561a851"}]}],"author":{"name":"Mykyta Karpin","email":"mkarpin@mirantis.com","date":"2019-11-05 13:42:49.000000000","tz":120},"committer":{"name":"Mykyta Karpin","email":"mkarpin@mirantis.com","date":"2019-11-07 14:33:19.000000000","tz":120},"subject":"Add upgrade mariadb functionality","message":"Add upgrade mariadb functionality\n\nThis change allows to perform mariadb upgrade in run_mysqld method in\ncase mysql system tables are already present is in data directory.\nIf mysql is already upgraded no attempts to run upgrade will be preformed.\nTogether with statefulset rolling upgrade strategy, this allows\nto perform rolling upgrade of mysql according to [1]\n\nThe workflow of upgrade:\n- launch mysqld with wsrep disable\n- wait till it is up\n- perform mysql_upgrade command\n- shutdown mysqld\n- launch mysqld with wsrep enabled\n\n[1] https://mariadb.com/kb/en/library/upgrading-from-mariadb-102-to-mariadb-103-with-galera-cluster/\n\nalso script is switched to subprocess32 because of subprocess.popen hanging during mysql status check.\n\nChange-Id: I2104aef8f75b55031fa1aa6ac2552fbb4f019453\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/056c59c4c6e994a6c28db3878b51840f8fa615a8"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/056c59c4c6e994a6c28db3878b51840f8fa615a8"}]},"branch":"refs/heads/master"},"6005054a97343edf2da4bd96b1050ed240a80db2":{"kind":"REWORK","_number":2,"created":"2019-11-11 07:40:06.000000000","uploader":{"_account_id":18795,"name":"mkarpin","email":"mkarpin@mirantis.com","username":"nkarpin"},"ref":"refs/changes/62/693362/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/openstack-helm-infra","ref":"refs/changes/62/693362/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/62/693362/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/62/693362/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/62/693362/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/openstack-helm-infra refs/changes/62/693362/2"}}},"commit":{"parents":[{"commit":"9d808c96fa5974841d089496aef06850f561a851","subject":"Adding missing readOnlyRootFilesystem flag for container security context","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/9d808c96fa5974841d089496aef06850f561a851"}]}],"author":{"name":"Mykyta Karpin","email":"mkarpin@mirantis.com","date":"2019-11-05 13:42:49.000000000","tz":120},"committer":{"name":"Mykyta Karpin","email":"mkarpin@mirantis.com","date":"2019-11-11 07:40:02.000000000","tz":0},"subject":"Add upgrade mariadb functionality","message":"Add upgrade mariadb functionality\n\nThis change allows to perform mariadb upgrade in run_mysqld method in\ncase mysql system tables are already present is in data directory.\nIf mysql is already upgraded no attempts to run upgrade will be preformed.\nTogether with statefulset rolling upgrade strategy, this allows\nto perform rolling upgrade of mysql according to [1]\n\nThe workflow of upgrade:\n- launch mysqld with wsrep disable\n- wait till it is up\n- perform mysql_upgrade command\n- shutdown mysqld\n- launch mysqld with wsrep enabled\n\n[1] https://mariadb.com/kb/en/library/upgrading-from-mariadb-102-to-mariadb-103-with-galera-cluster/\n\nalso script is switched to subprocess32 because of subprocess.popen hanging during mysql status check.\n\nChange-Id: I2104aef8f75b55031fa1aa6ac2552fbb4f019453\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/6005054a97343edf2da4bd96b1050ed240a80db2"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/6005054a97343edf2da4bd96b1050ed240a80db2"}]},"branch":"refs/heads/master"},"bb14df861a07fe43f350492de47da4b5d9b7b142":{"kind":"TRIVIAL_REBASE","_number":3,"created":"2019-11-11 07:40:12.000000000","uploader":{"_account_id":18795,"name":"mkarpin","email":"mkarpin@mirantis.com","username":"nkarpin"},"ref":"refs/changes/62/693362/3","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/openstack-helm-infra","ref":"refs/changes/62/693362/3","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/62/693362/3 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/62/693362/3 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/62/693362/3 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/openstack-helm-infra refs/changes/62/693362/3"}}},"commit":{"parents":[{"commit":"02af18d5dc35913e66870db2ef359b6167b9c289","subject":"Merge \"Fix search of max sequence number\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/02af18d5dc35913e66870db2ef359b6167b9c289"}]}],"author":{"name":"Mykyta Karpin","email":"mkarpin@mirantis.com","date":"2019-11-05 13:42:49.000000000","tz":120},"committer":{"name":"Mykyta Karpin","email":"mkarpin@mirantis.com","date":"2019-11-11 07:40:12.000000000","tz":0},"subject":"Add upgrade mariadb functionality","message":"Add upgrade mariadb functionality\n\nThis change allows to perform mariadb upgrade in run_mysqld method in\ncase mysql system tables are already present is in data directory.\nIf mysql is already upgraded no attempts to run upgrade will be preformed.\nTogether with statefulset rolling upgrade strategy, this allows\nto perform rolling upgrade of mysql according to [1]\n\nThe workflow of upgrade:\n- launch mysqld with wsrep disable\n- wait till it is up\n- perform mysql_upgrade command\n- shutdown mysqld\n- launch mysqld with wsrep enabled\n\n[1] https://mariadb.com/kb/en/library/upgrading-from-mariadb-102-to-mariadb-103-with-galera-cluster/\n\nalso script is switched to subprocess32 because of subprocess.popen hanging during mysql status check.\n\nChange-Id: I2104aef8f75b55031fa1aa6ac2552fbb4f019453\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/bb14df861a07fe43f350492de47da4b5d9b7b142"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/bb14df861a07fe43f350492de47da4b5d9b7b142"}]},"branch":"refs/heads/master"},"5ef2b2ca200c640823ae49d26db70836cec5feb5":{"kind":"REWORK","_number":4,"created":"2019-11-11 08:10:50.000000000","uploader":{"_account_id":18795,"name":"mkarpin","email":"mkarpin@mirantis.com","username":"nkarpin"},"ref":"refs/changes/62/693362/4","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/openstack-helm-infra","ref":"refs/changes/62/693362/4","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/62/693362/4 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/62/693362/4 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/openstack-helm-infra refs/changes/62/693362/4 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/openstack-helm-infra refs/changes/62/693362/4"}}},"commit":{"parents":[{"commit":"02af18d5dc35913e66870db2ef359b6167b9c289","subject":"Merge \"Fix search of max sequence number\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/02af18d5dc35913e66870db2ef359b6167b9c289"}]}],"author":{"name":"Mykyta Karpin","email":"mkarpin@mirantis.com","date":"2019-11-05 13:42:49.000000000","tz":120},"committer":{"name":"Mykyta Karpin","email":"mkarpin@mirantis.com","date":"2019-11-11 08:10:48.000000000","tz":0},"subject":"Add upgrade mariadb functionality","message":"Add upgrade mariadb functionality\n\nThis change allows to perform mariadb upgrade in run_mysqld method in\ncase mysql system tables are already present is in data directory.\nIf mysql is already upgraded no attempts to run upgrade will be preformed.\nTogether with statefulset rolling upgrade strategy, this allows\nto perform rolling upgrade of mysql according to [1]\n\nThe workflow of upgrade:\n- launch mysqld with wsrep disable\n- wait till it is up\n- perform mysql_upgrade command\n- shutdown mysqld\n- launch mysqld with wsrep enabled\n\n[1] https://mariadb.com/kb/en/library/upgrading-from-mariadb-102-to-mariadb-103-with-galera-cluster/\n\nalso script is switched to subprocess32 because of subprocess.popen hanging during mysql status check.\n\nChange-Id: I2104aef8f75b55031fa1aa6ac2552fbb4f019453\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/5ef2b2ca200c640823ae49d26db70836cec5feb5"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm-infra/commit/5ef2b2ca200c640823ae49d26db70836cec5feb5"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}