The Ultimate Guide to High Availability with MariaDB

Comments - Introduction to State Snapshot Transfers (SSTs)

3 years, 11 months ago Geoff Montee
Re: Error in Joining Cluster

Hi,

This is an important clue:

2020-05-20 15:54:20 0 [Note] WSREP: /usr/sbin/mysqld: Terminated.
May 20 15:54:20 uodbdb2 systemd: mariadb.service: main process exited, code=killed, status=6/ABRT

It appears that the mysqld process was killed by systemd. To check for sure, execute this:

sudo journalctl -u mariadb

This usually happens because your SST timed out. You most likely have to increase the systemd timeout. e.g.:

sudo tee /etc/systemd/system/mariadb.service.d/timeoutsec.conf <<EOF
[Service]

TimeoutStartSec=0
TimeoutStopSec=0
EOF
sudo systemctl daemon-reload

See here: https://mariadb.com/kb/en/systemd/#configuring-the-systemd-service-timeout

 
3 years, 11 months ago Testing User A Test
Re: Error in Joining Cluster

Thank you for your advice. I didn't update and change any clustering configuration or timeoutsec.conf. I found there are selinux issues and got them fixed. Then node 2 could successfully join the cluster.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.