)]}'
{"id":"openstack%2Fopenstack-helm~522729","triplet_id":"openstack%2Fopenstack-helm~master~I020b1161925cedc7837d4fbb3d4e02fcaf3f4f7d","project":"openstack/openstack-helm","branch":"master","topic":"bp/mariadb_auto_recovery","hashtags":[],"change_id":"I020b1161925cedc7837d4fbb3d4e02fcaf3f4f7d","subject":"auto recovery when all mariadb crashed","status":"ABANDONED","created":"2017-11-24 07:22:36.000000000","updated":"2020-07-15 19:34:52.000000000","total_comment_count":1,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"02b6d0e08ecbdd6650f45ee80dff7bf39292aaf0","_number":522729,"virtual_id_number":522729,"owner":{"_account_id":16513,"name":"Seungkyu Ahn","email":"seungkyua@gmail.com","username":"seungkyu"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"_account_id":20466,"name":"Tin Lam","email":"tin@lam.wtf","username":"tinlam"},{"_account_id":17591,"name":"Steve Wilkerson","email":"wilkers.steve@gmail.com","username":"srwilkers"},{"_account_id":23928,"name":"Pete Birley","email":"petebirley@gmail.com","username":"portdirect"},{"date":"2017-12-05 06:56:27.000000000","_account_id":26201,"name":"AT\u0026T Openstack-Helm CI","email":"stacey.fletcher@att.com","username":"ATT-OSH-CI"},{"value":1,"date":"2017-12-05 07:49:41.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":20466,"name":"Tin Lam","email":"tin@lam.wtf","username":"tinlam"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":17591,"name":"Steve Wilkerson","email":"wilkers.steve@gmail.com","username":"srwilkers"},{"value":0,"permitted_voting_range":{"min":-2,"max":2},"_account_id":23928,"name":"Pete Birley","email":"petebirley@gmail.com","username":"portdirect"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":26201,"name":"AT\u0026T Openstack-Helm CI","email":"stacey.fletcher@att.com","username":"ATT-OSH-CI"},{"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":20466,"name":"Tin Lam","email":"tin@lam.wtf","username":"tinlam"},{"_account_id":17591,"name":"Steve Wilkerson","email":"wilkers.steve@gmail.com","username":"srwilkers"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":23928,"name":"Pete Birley","email":"petebirley@gmail.com","username":"portdirect"},{"_account_id":26201,"name":"AT\u0026T Openstack-Helm CI","email":"stacey.fletcher@att.com","username":"ATT-OSH-CI"},{"_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":17591,"name":"Steve Wilkerson","email":"wilkers.steve@gmail.com","username":"srwilkers"},{"_account_id":20466,"name":"Tin Lam","email":"tin@lam.wtf","username":"tinlam"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":23928,"name":"Pete Birley","email":"petebirley@gmail.com","username":"portdirect"},{"_account_id":26201,"name":"AT\u0026T Openstack-Helm CI","email":"stacey.fletcher@att.com","username":"ATT-OSH-CI"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2017-11-24 09:15:13.000000000","updated_by":{"_account_id":23928,"name":"Pete Birley","email":"petebirley@gmail.com","username":"portdirect"},"reviewer":{"_account_id":23928,"name":"Pete Birley","email":"petebirley@gmail.com","username":"portdirect"},"state":"REVIEWER"},{"updated":"2017-11-24 09:17:35.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":"2017-11-24 09:20:27.000000000","updated_by":{"_account_id":17591,"name":"Steve Wilkerson","email":"wilkers.steve@gmail.com","username":"srwilkers"},"reviewer":{"_account_id":17591,"name":"Steve Wilkerson","email":"wilkers.steve@gmail.com","username":"srwilkers"},"state":"REVIEWER"},{"updated":"2017-12-05 06:56:27.000000000","updated_by":{"_account_id":26201,"name":"AT\u0026T Openstack-Helm CI","email":"stacey.fletcher@att.com","username":"ATT-OSH-CI"},"reviewer":{"_account_id":26201,"name":"AT\u0026T Openstack-Helm CI","email":"stacey.fletcher@att.com","username":"ATT-OSH-CI"},"state":"REVIEWER"},{"updated":"2017-12-05 07:49:41.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":"fee0737f005234d27fd7301e9953960ea1b862ae","author":{"_account_id":16513,"name":"Seungkyu Ahn","email":"seungkyua@gmail.com","username":"seungkyu"},"date":"2017-11-24 07:22:36.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"1ffd92923b79ecf090cfca0d6a235b88a7170aef","author":{"_account_id":26201,"name":"AT\u0026T Openstack-Helm CI","email":"stacey.fletcher@att.com","username":"ATT-OSH-CI"},"date":"2017-11-24 07:25:15.000000000","message":"Patch Set 1:\n\nBuild Started http://10.24.20.18:30081/job/charts/job/openstack/job/openstack-helm/job/basic/2250/","accounts_in_message":[],"_revision_number":1},{"id":"b3303b7e9185fa4fa9d22e885df4d9feaf2b34c7","author":{"_account_id":26201,"name":"AT\u0026T Openstack-Helm CI","email":"stacey.fletcher@att.com","username":"ATT-OSH-CI"},"date":"2017-11-24 07:44:33.000000000","message":"Patch Set 1:\n\nBuild Failed \n\nhttp://12.37.173.196:32775/repository/att-comdev-jenkins-logs/openstack-helm/org.openstack.helm/2250/org.openstack.helm-2250.x-gtar : FAILURE","accounts_in_message":[],"_revision_number":1},{"id":"6d86573ff83ca407259a3d0b94cc12914532d362","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2017-11-24 09:08:26.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- build-openstack-sphinx-docs http://logs.openstack.org/29/522729/1/check/build-openstack-sphinx-docs/5b9e331/html/ : SUCCESS in 4m 26s\n- legacy-openstack-helm-nocluster-linter-ovs-rbd http://logs.openstack.org/29/522729/1/check/legacy-openstack-helm-nocluster-linter-ovs-rbd/6c7a683/ : SUCCESS in 3m 24s\n- legacy-openstack-helm-aio-basic-ovs-rbd http://logs.openstack.org/29/522729/1/check/legacy-openstack-helm-aio-basic-ovs-rbd/57c862b/ : TIMED_OUT in 1h 44m 35s (non-voting)\n- legacy-openstack-helm-aio-basic-ovs-swift http://logs.openstack.org/29/522729/1/check/legacy-openstack-helm-aio-basic-ovs-swift/8392a33/ : SUCCESS in 57m 16s (non-voting)\n- legacy-openstack-helm-aio-basic-ovs-radosgw http://logs.openstack.org/29/522729/1/check/legacy-openstack-helm-aio-basic-ovs-radosgw/8dcf387/ : FAILURE in 50m 05s (non-voting)\n- legacy-openstack-helm-aio-basic-ovs-pvc http://logs.openstack.org/29/522729/1/check/legacy-openstack-helm-aio-basic-ovs-pvc/043f8e0/ : SUCCESS in 36m 32s (non-voting)\n- legacy-openstack-helm-aio-basic-linuxbridge-rbd http://logs.openstack.org/29/522729/1/check/legacy-openstack-helm-aio-basic-linuxbridge-rbd/edfde2e/ : SUCCESS in 40m 38s (non-voting)\n- legacy-openstack-helm-aio-basic-ovs-rbd-centos-7 http://logs.openstack.org/29/522729/1/check/legacy-openstack-helm-aio-basic-ovs-rbd-centos-7/935850a/ : FAILURE in 2m 51s (non-voting)\n- legacy-openstack-helm-aio-basic-ovs-rbd-fedora-26 http://logs.openstack.org/29/522729/1/check/legacy-openstack-helm-aio-basic-ovs-rbd-fedora-26/7473d8b/ : SUCCESS in 50m 33s (non-voting)\n- openstack-helm-linter http://logs.openstack.org/29/522729/1/check/openstack-helm-linter/03863be/ : SUCCESS in 1m 41s\n- openstack-helm-legacy-ubuntu-vm-ovs-radosgw http://logs.openstack.org/29/522729/1/check/openstack-helm-legacy-ubuntu-vm-ovs-radosgw/6425126/ : SUCCESS in 1h 12m 40s (non-voting)\n- openstack-helm-legacy-ubuntu-vm-lb-radosgw http://logs.openstack.org/29/522729/1/check/openstack-helm-legacy-ubuntu-vm-lb-radosgw/cae477b/ : SUCCESS in 1h 11m 29s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"bb22c878d4c43320979e3f84c0134d860fb452e0","author":{"_account_id":14119,"name":"Sam Yaple","email":"sam+git@yaple.net","username":"SamYaple"},"date":"2017-11-26 20:47:45.000000000","message":"Patch Set 1: Code-Review-1\n\n(1 comment)\n\nThe proper way to do this is with lots of healthchecking across the cluster *before* any action is taken.\n\nI have some scripts that work with etcd to automatically recover a mariadb+galera cluster under any condition. Thats a non-trival change to OSH though, and thats why i haven\u0027t started that work.\n\nThis patch, however, should not be merged as is.","accounts_in_message":[],"_revision_number":1},{"id":"2ab6a6f84631c4d3e3a71a599a5f7f491f3f6f99","author":{"_account_id":16513,"name":"Seungkyu Ahn","email":"seungkyua@gmail.com","username":"seungkyu"},"date":"2017-12-05 06:08:07.000000000","message":"Uploaded patch set 2.","accounts_in_message":[],"_revision_number":2},{"id":"fbeb76413d71a5aa46d0ca62c4af31d23d93fafc","author":{"_account_id":26201,"name":"AT\u0026T Openstack-Helm CI","email":"stacey.fletcher@att.com","username":"ATT-OSH-CI"},"date":"2017-12-05 06:08:14.000000000","message":"Patch Set 2:\n\nBuild Started http://10.24.20.18:30081/job/charts/job/openstack/job/openstack-helm/job/basic/2415/","accounts_in_message":[],"_revision_number":2},{"id":"90f65978dc0173c33fb76ba5ae8c53d412a000be","author":{"_account_id":26201,"name":"AT\u0026T Openstack-Helm CI","email":"stacey.fletcher@att.com","username":"ATT-OSH-CI"},"date":"2017-12-05 06:56:27.000000000","message":"Patch Set 2:\n\nBuild Failed \n\nhttp://12.37.173.196:32775/repository/att-comdev-jenkins-logs/openstack-helm/org.openstack.helm/2415/org.openstack.helm-2415.x-gtar : FAILURE","accounts_in_message":[],"_revision_number":2},{"id":"95f5333e56af4bd5b2d78898a72b582ac1dc5d91","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2017-12-05 07:49:41.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\n\n- build-openstack-sphinx-docs http://logs.openstack.org/29/522729/2/check/build-openstack-sphinx-docs/ccda5ab/html/ : SUCCESS in 3m 27s\n- openstack-helm-linter http://logs.openstack.org/29/522729/2/check/openstack-helm-linter/08a65bc/ : SUCCESS in 1m 27s\n- openstack-helm-legacy-ubuntu-vm-ovs-radosgw http://logs.openstack.org/29/522729/2/check/openstack-helm-legacy-ubuntu-vm-ovs-radosgw/08b754b/ : SUCCESS in 1h 38m 05s (non-voting)\n- openstack-helm-legacy-ubuntu-vm-lb-radosgw http://logs.openstack.org/29/522729/2/check/openstack-helm-legacy-ubuntu-vm-lb-radosgw/a59af0a/ : SUCCESS in 1h 13m 18s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"dab0aef1e75c68efe42b1c00b9bbc6924e175077","author":{"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},"date":"2020-07-15 19:34:52.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":2}],"current_revision_number":2,"current_revision":"66967e5fc8392fd57fb56ac00cb4421ba9452b12","revisions":{"abfef34388bddc3648cb8cc7f8be6ba42c5d076a":{"kind":"REWORK","_number":1,"created":"2017-11-24 07:22:36.000000000","uploader":{"_account_id":16513,"name":"Seungkyu Ahn","email":"seungkyua@gmail.com","username":"seungkyu"},"ref":"refs/changes/29/522729/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/openstack-helm","ref":"refs/changes/29/522729/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/openstack-helm refs/changes/29/522729/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/openstack-helm refs/changes/29/522729/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/openstack-helm refs/changes/29/522729/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/openstack-helm refs/changes/29/522729/1"}}},"commit":{"parents":[{"commit":"5ae0bff97c99e6854bc5eae04e907b50da28d2e2","subject":"Zuul v3 cross repo dependency and gate entrypoint","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm/commit/5ae0bff97c99e6854bc5eae04e907b50da28d2e2"}]}],"author":{"name":"Seungkyu Ahn","email":"seungkyua@gmail.com","date":"2017-11-24 05:53:55.000000000","tz":540},"committer":{"name":"Seungkyu Ahn","email":"seungkyua@gmail.com","date":"2017-11-24 05:53:55.000000000","tz":540},"subject":"auto recovery when all mariadb crashed","message":"auto recovery when all mariadb crashed\n\nWhen all mariadb galera cluster is down, it will not be recovered automatically.\nBecause mariadb data exits.\n\nThis PS modify start.sh script to set safe_to_bootsrap as 1.\nIt\u0027ll make mariadb restart automatically without any problem.\n\nChange-Id: I020b1161925cedc7837d4fbb3d4e02fcaf3f4f7d\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm/commit/abfef34388bddc3648cb8cc7f8be6ba42c5d076a"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm/commit/abfef34388bddc3648cb8cc7f8be6ba42c5d076a"}]},"branch":"refs/heads/master"},"66967e5fc8392fd57fb56ac00cb4421ba9452b12":{"kind":"REWORK","_number":2,"created":"2017-12-05 06:08:07.000000000","uploader":{"_account_id":16513,"name":"Seungkyu Ahn","email":"seungkyua@gmail.com","username":"seungkyu"},"ref":"refs/changes/29/522729/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/openstack-helm","ref":"refs/changes/29/522729/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/openstack-helm refs/changes/29/522729/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/openstack-helm refs/changes/29/522729/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/openstack-helm refs/changes/29/522729/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/openstack-helm refs/changes/29/522729/2"}}},"commit":{"parents":[{"commit":"cae76dc9ab94f48259a8514075efb76f088a2722","subject":"Merge \"Images: Neutron service specific explicit image names\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm/commit/cae76dc9ab94f48259a8514075efb76f088a2722"}]}],"author":{"name":"Seungkyu Ahn","email":"seungkyua@gmail.com","date":"2017-11-24 05:53:55.000000000","tz":540},"committer":{"name":"Seungkyu Ahn","email":"seungkyua@gmail.com","date":"2017-12-05 06:01:04.000000000","tz":540},"subject":"auto recovery when all mariadb crashed","message":"auto recovery when all mariadb crashed\n\nWhen all mariadb galera cluster is down, it will not be recovered automatically.\nBecause mariadb data exists.\n\nFirst, Logging recovery position with recovery option.\nSecond, Mariadb starts with read_only mode and save it\u0027s own position value.\nThirtd, Using liveness find out mariadb which has max position,\nand restart that mariadb with new-cluster option and set safe_to_bootsrap as 1.\n\nIt\u0027ll make mariadb restart automatically without any problem.\n\nChange-Id: I020b1161925cedc7837d4fbb3d4e02fcaf3f4f7d\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm/commit/66967e5fc8392fd57fb56ac00cb4421ba9452b12"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/openstack-helm/commit/66967e5fc8392fd57fb56ac00cb4421ba9452b12"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}