Mariadb service fails to restart with Galera - Source

Revision: 140340
User: paul adams
Date: 2024-06-18 14:01

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:
# 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.

Mariadb service fails to restart with Galera - Source

Products

Services

Pricing

Resources

About Us

Download MariaDB