)]}'
{"/COMMIT_MSG":[{"author":{"_account_id":14525,"name":"Vasyl Saienko","email":"vsaienko@mirantis.com","username":"vsaienko"},"change_message_id":"c8ff1bd253fe644339619fd67d22e34887281a81","unresolved":true,"context_lines":[{"line_number":6,"context_line":""},{"line_number":7,"context_line":"Add ready service to record the running nodes in the cluster"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"If the primary mariadb node is terminated, and the primary"},{"line_number":10,"context_line":"service has no endpoints, and the node will start a new"},{"line_number":11,"context_line":"cluster with \u0027--wsrep-new-cluster\u0027. We use the ready"},{"line_number":12,"context_line":"service to record the running nodes in the cluster."},{"line_number":13,"context_line":""},{"line_number":14,"context_line":"Change-Id: I2950fcf382911fd005e482aa8c2448679e36c319"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":3,"id":"1389b14c_10a422e0","line":11,"range":{"start_line":9,"start_character":0,"end_line":11,"end_character":51},"updated":"2024-11-25 18:55:44.000000000","message":"Can you please describe how to reproduce this probelm in more detail. I do not think that mentioned here will happen as when not endpoints preset we will start leader election https://github.com/openstack/openstack-helm-infra/blob/master/mariadb/templates/bin/_start.py.tpl#L989","commit_id":"32af7881ba999e669de8c9b1b6221125017b6b28"},{"author":{"_account_id":31827,"name":"Jorhson Deng","email":"jorhson_deng@163.com","username":"dengzhaosen"},"change_message_id":"ca05d44c32c889db6eb7a91a8c0101029ab79769","unresolved":true,"context_lines":[{"line_number":6,"context_line":""},{"line_number":7,"context_line":"Add ready service to record the running nodes in the cluster"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"If the primary mariadb node is terminated, and the primary"},{"line_number":10,"context_line":"service has no endpoints, and the node will start a new"},{"line_number":11,"context_line":"cluster with \u0027--wsrep-new-cluster\u0027. We use the ready"},{"line_number":12,"context_line":"service to record the running nodes in the cluster."},{"line_number":13,"context_line":""},{"line_number":14,"context_line":"Change-Id: I2950fcf382911fd005e482aa8c2448679e36c319"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":3,"id":"602d72d7_073caf91","line":11,"range":{"start_line":9,"start_character":0,"end_line":11,"end_character":51},"in_reply_to":"1389b14c_10a422e0","updated":"2024-11-26 02:29:46.000000000","message":"There are some way to reproduce the problem. There is only one endpoint IP in the mariadb service， and that is the primary pod.\n1. you can just kill the process of the mysql in the primary pod. The pod will restart the process, and there will has no endpoints in mariadb service. The process cannot get any points and will start with the parameter \"--wsrep-new-cluster\".\n2. just terminate the pod with the ip in mariadb service, and the k8s will restart a new mariadb pod.\n\nIf you recheck the mariadb with the command \"show status like \"%wsrep%\";\", you will find the cluster_size is 2 in the other pod, and the  cluster_size is 1 in the new pod.","commit_id":"32af7881ba999e669de8c9b1b6221125017b6b28"},{"author":{"_account_id":31827,"name":"Jorhson Deng","email":"jorhson_deng@163.com","username":"dengzhaosen"},"change_message_id":"85f07d1e5ae772e3bea9f16dde5117c559288eb7","unresolved":true,"context_lines":[{"line_number":6,"context_line":""},{"line_number":7,"context_line":"Add ready service to record the running nodes in the cluster"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"If the primary mariadb node is terminated, and the primary"},{"line_number":10,"context_line":"service has no endpoints, and the node will start a new"},{"line_number":11,"context_line":"cluster with \u0027--wsrep-new-cluster\u0027. We use the ready"},{"line_number":12,"context_line":"service to record the running nodes in the cluster."},{"line_number":13,"context_line":""},{"line_number":14,"context_line":"Change-Id: I2950fcf382911fd005e482aa8c2448679e36c319"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":3,"id":"7a2e9a11_2b5f03a6","line":11,"range":{"start_line":9,"start_character":0,"end_line":11,"end_character":51},"in_reply_to":"1c014363_34197e06","updated":"2024-11-27 01:12:49.000000000","message":"sorry, this is a patch for I1d8a8db0ce8102e5e23f7efdeedd139726ffff28， and a revert is already added by Id53a6503b177f0c46e89a7def2c0773a68b8d8e8. So this patch will be abonded.\n\nI was wonder that the mariadb service with one endpoint has a significant advantage over three endpoints or not.\n\nDeadlocks are frequently encountered during testing with three endpoint， and we are    \ntesting based I1d8a8db0ce8102e5e23f7efdeedd139726ffff28 with only one endpoints.","commit_id":"32af7881ba999e669de8c9b1b6221125017b6b28"},{"author":{"_account_id":14525,"name":"Vasyl Saienko","email":"vsaienko@mirantis.com","username":"vsaienko"},"change_message_id":"e3e9e9d76b1f241c389cc25a25694e5de17174e7","unresolved":true,"context_lines":[{"line_number":6,"context_line":""},{"line_number":7,"context_line":"Add ready service to record the running nodes in the cluster"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"If the primary mariadb node is terminated, and the primary"},{"line_number":10,"context_line":"service has no endpoints, and the node will start a new"},{"line_number":11,"context_line":"cluster with \u0027--wsrep-new-cluster\u0027. We use the ready"},{"line_number":12,"context_line":"service to record the running nodes in the cluster."},{"line_number":13,"context_line":""},{"line_number":14,"context_line":"Change-Id: I2950fcf382911fd005e482aa8c2448679e36c319"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":3,"id":"1c014363_34197e06","line":11,"range":{"start_line":9,"start_character":0,"end_line":11,"end_character":51},"in_reply_to":"3277b7e2_e0a0c1f5","updated":"2024-11-26 13:32:57.000000000","message":"@jorhson_deng@163.com can you please provide helm chart values that you are using for mariadb deployment?","commit_id":"32af7881ba999e669de8c9b1b6221125017b6b28"},{"author":{"_account_id":31827,"name":"Jorhson Deng","email":"jorhson_deng@163.com","username":"dengzhaosen"},"change_message_id":"03f7eff61ff923635b6fe3e180c4f1b7ce842885","unresolved":true,"context_lines":[{"line_number":6,"context_line":""},{"line_number":7,"context_line":"Add ready service to record the running nodes in the cluster"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"If the primary mariadb node is terminated, and the primary"},{"line_number":10,"context_line":"service has no endpoints, and the node will start a new"},{"line_number":11,"context_line":"cluster with \u0027--wsrep-new-cluster\u0027. We use the ready"},{"line_number":12,"context_line":"service to record the running nodes in the cluster."},{"line_number":13,"context_line":""},{"line_number":14,"context_line":"Change-Id: I2950fcf382911fd005e482aa8c2448679e36c319"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":3,"id":"b86989e5_107c35c2","line":11,"range":{"start_line":9,"start_character":0,"end_line":11,"end_character":51},"in_reply_to":"40e3c5a3_b8d0ca66","updated":"2024-11-27 08:18:34.000000000","message":"If so I think it will be better that the mariadb service has only one endpoints. The mariadb service play as the role of loadbalancer to choose the mysql node in the current chart. \nWill it be more efficient and stable for the mariadb with three endpoints?","commit_id":"32af7881ba999e669de8c9b1b6221125017b6b28"},{"author":{"_account_id":14525,"name":"Vasyl Saienko","email":"vsaienko@mirantis.com","username":"vsaienko"},"change_message_id":"a3d563870d47a54f4dee1e8b366f2b2fe30cf149","unresolved":true,"context_lines":[{"line_number":6,"context_line":""},{"line_number":7,"context_line":"Add ready service to record the running nodes in the cluster"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"If the primary mariadb node is terminated, and the primary"},{"line_number":10,"context_line":"service has no endpoints, and the node will start a new"},{"line_number":11,"context_line":"cluster with \u0027--wsrep-new-cluster\u0027. We use the ready"},{"line_number":12,"context_line":"service to record the running nodes in the cluster."},{"line_number":13,"context_line":""},{"line_number":14,"context_line":"Change-Id: I2950fcf382911fd005e482aa8c2448679e36c319"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":3,"id":"3277b7e2_e0a0c1f5","line":11,"range":{"start_line":9,"start_character":0,"end_line":11,"end_character":51},"in_reply_to":"602d72d7_073caf91","updated":"2024-11-26 10:43:06.000000000","message":"so how it is possible that no endpoints are present in the service after we killed primary pod as on step2 remaining pods are still running and ready.","commit_id":"32af7881ba999e669de8c9b1b6221125017b6b28"},{"author":{"_account_id":14525,"name":"Vasyl Saienko","email":"vsaienko@mirantis.com","username":"vsaienko"},"change_message_id":"538c73b3cb6d251c37b9a959cffc38d1b3d18912","unresolved":true,"context_lines":[{"line_number":6,"context_line":""},{"line_number":7,"context_line":"Add ready service to record the running nodes in the cluster"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"If the primary mariadb node is terminated, and the primary"},{"line_number":10,"context_line":"service has no endpoints, and the node will start a new"},{"line_number":11,"context_line":"cluster with \u0027--wsrep-new-cluster\u0027. We use the ready"},{"line_number":12,"context_line":"service to record the running nodes in the cluster."},{"line_number":13,"context_line":""},{"line_number":14,"context_line":"Change-Id: I2950fcf382911fd005e482aa8c2448679e36c319"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":3,"id":"40e3c5a3_b8d0ca66","line":11,"range":{"start_line":9,"start_character":0,"end_line":11,"end_character":51},"in_reply_to":"7a2e9a11_2b5f03a6","updated":"2024-11-27 08:02:32.000000000","message":"This chart deployed mariadb in multimaster mode. OpenStack does not work with multimaster mysql, all connections should be done via single node as multimaster deployment is eventually consistent.\nUsually in production deployments in openstack loadbalancer is deployed on top of mysql and it always points to single node.","commit_id":"32af7881ba999e669de8c9b1b6221125017b6b28"}],"/PATCHSET_LEVEL":[{"author":{"_account_id":31827,"name":"Jorhson Deng","email":"jorhson_deng@163.com","username":"dengzhaosen"},"change_message_id":"095604506c6139c42f25dd56d97a70458c4f95f3","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":3,"id":"25a3d455_8204c985","updated":"2024-11-19 10:29:23.000000000","message":"recheck","commit_id":"32af7881ba999e669de8c9b1b6221125017b6b28"}]}