secode node and third node can't join in Galera cluster

24 views
Skip to first unread message

lee a

unread,
Jun 11, 2022, 3:05:18 PM6/11/22
to codership
Hello everyone
I am new to Galera, I have been Setup a 3-nodes Galera cluster.
But when I am going to start
the first node started up normally  with command:  galera_new_cluster
But the second node and the third node started  failed with command:
#systemctl start mariadb.
Job for mariadb.service failed because a fatal signal was delivered to the control process. See "systemctl status mariadb.service" and "journalctl -xe" for details.

three nodes OS and mariadb version are the same:

OS: CentOS Linux release 7.6.1810 (Core)
Mariadb and Galera version:
MariaDB-client.x86_64                 10.6.8-1.el7.centos            
MariaDB-common.x86_64                 10.6.8-1.el7.centos            
MariaDB-compat.x86_64                 10.6.8-1.el7.centos            
MariaDB-server.x86_64                 10.6.8-1.el7.centos            
galera-4.x86_64                       26.4.11-1.el7.centos

three nodes  config and logs are  showed in attachment,
Thank you for your help.


config file
logfile

Private Citizen

unread,
Jun 11, 2022, 3:35:11 PM6/11/22
to codership
In your logs for node3 you can see;

    [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_rsync --role 'joiner' --address '10.7.201.213' ...
    [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'joiner' --address '10.7.201.213' ...
    [ERROR] WSREP: Failed to prepare for 'rsync' SST. Unrecoverable.
    [ERROR] WSREP: SST request callback failed. This is unrecoverable, restart required.

Start trouble shooting there.
Why can't it establish connection with 10.7.201.213?
Are all firewall ports open? (4567,4568,4444)


Reply all
Reply to author
Forward
0 new messages