MariaDB Galera Failed To Open Gcomm Backend Connection

Mariadb Galera Failed to open gcomm backend connection

  • Database mariadb galera cluster tidak bisa di start dengan log error seperti berikut:
2021-10-29  2:11:01 0 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out)
         at /home/buildbot/buildbot/build/gcomm/src/pc.cpp:connect():160
2021-10-29  2:11:01 0 [ERROR] WSREP: /home/buildbot/buildbot/build/gcs/src/gcs_core.cpp:gcs_core_open():219: Failed to open backend connection: -110 (Connection timed out)
2021-10-29  2:11:01 0 [ERROR] WSREP: /home/buildbot/buildbot/build/gcs/src/gcs.cpp:gcs_open():1632: Failed to open channel 'IJN' at 'gcomm://10.3.0.27,192.168.41.59': -110 (Connection timed out)
2021-10-29  2:11:01 0 [ERROR] WSREP: gcs connect failed: Connection timed out
2021-10-29  2:11:01 0 [ERROR] WSREP: wsrep::connect(gcomm://10.3.0.27,192.168.41.59) failed: 7
2021-10-29  2:11:01 0 [ERROR] Aborting
  • Untuk memperbaiki cukup jalankan perintah berikut:
galera_new_cluster
  • Dan pastikan nilai safe_to_bootstrap adalah 1 pada file /var/lib/mysql/grastate.dat
cat /var/lib/mysql/grastate.dat

# GALERA saved state
version: 2.1
uuid:    6a1f102a-13a3-11e7-b710-b2876418a643
seqno:   -1
safe_to_bootstrap: 1

herdiana3389

A system administrator with skills in system administration, virtualization, linux, windows, networking, cloud computing, container, etc.