MariaDB with Galera on RedHat 7.2 not starting
Hi, can someone please help as I couldn't find relevant information online. When trying to initialize the first node of the cluster, I get this:
Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: wsrep_load(): Galera 25.3.15(r3578) by Codership Oy <[email protected]> loaded Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: CRC-32C: using hardware acceleration. Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 172.20.1.56; bas Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510378977024 [Note] WSREP: Service thread queue flushed. Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: wsrep_sst_grab() Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Start replication Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: protonet asio version 0 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Using CRC-32C for message checksums. Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: backend: asio Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: restore pc from disk failed Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: GMCast version 0 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: (b5e7b88e, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: (b5e7b88e, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: EVS version 0 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: gcomm: connecting to group 'galera_cluster', peer '172.20.1.56:,172.20.1.57:,17 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Warning] WSREP: (b5e7b88e, 'tcp://0.0.0.0:4567') address 'tcp://172.20.1.56:4567' points to Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:43 140510611449984 [Warning] WSREP: no nodes coming from prim view, prim not possible Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:43 140510611449984 [Note] WSREP: view(view_id(NON_PRIM,b5e7b88e,1) memb { Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: b5e7b88e,0 Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: } joined { Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: } left { Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: } partitioned { Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: }) Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:43 140510611449984 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.50184S), skipping check Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [Note] WSREP: view((empty)) Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 11 Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: at gcomm/src/pc.cpp:connect():162 Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: - Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1379: Failed to open channel 'galera_cluster' at 'g Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] WSREP: gcs connect failed: Connection timed out Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] WSREP: wsrep::connect(gcomm://172.20.1.56,172.20.1.57,172.20.1.58) failed: 7 Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] Aborting Jun 12 11:15:14 mariadb-N1.intelligene.local systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE Jun 12 11:15:14 mariadb-N1.intelligene.local systemd[1]: Failed to start MariaDB database server. -- Subject: Unit mariadb.service has failed
Answer Answered by Claudio Nanni in this comment.
It looks like you are starting the first node of the cluster, the first node should not look for any other node of the cluster but it should perform what is called 'bootstrap', this can be achieved in a couple of ways(one is the way Nirbhay mentioned), for more complete reference on this please refer to: https://mariadb.com/blog/mariadb-galera-cluster-quirk-bootstrapping
Comments
Comments loading...
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.