[MDEV-10188] MariaDB server can't join Galera cluster after restart Created: 2016-06-07  Updated: 2016-06-29  Resolved: 2016-06-29

Status: Closed
Project: MariaDB Server
Component/s: Galera, Galera SST
Affects Version/s: 10.1.12
Fix Version/s: 10.1.15

Type: Bug Priority: Major
Reporter: Thomas Cheronneau Assignee: Nirbhay Choubey (Inactive)
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Debian Jessie 8.3.
4 physical servers in cluster.
63G Memory / machine
24 CPU / machine


Attachments: Text File maria.log    
Issue Links:
Duplicate
is duplicated by MDEV-9423 cannot add new node to the cluser: Bi... Closed

 Description   

Hi,

We have configured a cluster of 4 mariaDB servers with Galera (with the SST xtrabackup-v2).
We had some issue when joining the cluster with one node.

Our problem is that when we launch the mysql process it tried to sync with the cluster. It clean the /var/lib/mysql folder and sync all data from an other node.
Everything goes well until it tries to launch the process itself (at the end of the joining process).
We have some logs that I provide in attachments (maria.log).

So it seems that it does not found one file and when we try to start again the process it fails and sync from the begining.

Maybe we forgot something (obvious ?) in the configuration but we can't find it.

If you can help us it would be great.

Thanks.
Regards,
Thomas.



 Comments   
Comment by Thomas Cheronneau [ 2016-06-08 ]

Hi,

For the record, I've found this issue which seems related : https://jira.mariadb.org/browse/MDEV-9423.
I've tried to change the configuration as quoted there : https://jira.mariadb.org/browse/MDEV-9423?focusedCommentId=82677&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-82677.
But without success.

Comment by Nirbhay Choubey (Inactive) [ 2016-06-08 ]

Yes, its a duplicate of MDEV-9423.

Comment by Thomas Cheronneau [ 2016-06-10 ]

For the information, it is possible to fix it temporarly by adding the missing log (rsync between donor and receiver).
It has to be done at the end of the SST process before MariaDB starts.
But after that we've seen another issue (https://jira.mariadb.org/browse/MDEV-9423). Which is solved with the timeout in systemd (as explain on jira).
So we managed to add the node to the cluster this way and it is working now.

Generated at Thu Feb 08 07:40:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.