The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Mariadb service fails to restart with Galera

Hi,

I configured Maraidb with Galera on Alma Linux, I have a 3 node cluster. Everything works ok, but when I restart mariadb the service fails.

I tried to start small with just one node as part of the cluster to troubleshoot, but have the same problem. When I move: /etc/my.cnf.d/galera.cnf to /tmp and then restart maraidb it works fine.

Here is an eg of the error:

  1. systemctl restart mariadb Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.

[root@mariadb01 mariadb]# tail -f mariadb.log 2024-06-18 14:26:59 0 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.50232S), skipping check 2024-06-18 14:27:28 0 [Note] WSREP: PC protocol downgrade 1 -> 0 2024-06-18 14:27:28 0 [Note] WSREP: view((empty)) 2024-06-18 14:27:28 0 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out) at /builddir/build/BUILD/galera-26.4.14/gcomm/src/pc.cpp:connect():160 2024-06-18 14:27:28 0 [ERROR] WSREP: /builddir/build/BUILD/galera-26.4.14/gcs/src/gcs_core.cpp:gcs_core_open():221: Failed to open backend connection: -110 (Connection timed out) 2024-06-18 14:27:29 0 [ERROR] WSREP: /builddir/build/BUILD/galera-26.4.14/gcs/src/gcs.cpp:gcs_open():1669: Failed to open channel 'clustera' at 'gcomm:172.16.33.171': -110 (Connection timed out) 2024-06-18 14:27:29 0 [ERROR] WSREP: gcs connect failed: Connection timed out 2024-06-18 14:27:29 0 [ERROR] WSREP: wsrep::connect(gcomm:172.16.33.171) failed: 7 2024-06-18 14:27:29 0 [ERROR] Aborting

Tried re-inialising, and then it works and shows only one clustre rmember (because I only added one to start with whilst troubleshooting): galera_new_cluster

But the moment I restart mariadb it fails again.

Any ideas? Thanks in advance

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.