← Back to team overview

maria-discuss team mailing list archive

New Question: MariaDB with Galera on RedHat 7.2 not starting

 

Hello,

A new question has been asked in "Starting and Stopping MariaDB" by veselin_vasilev_g. Please answer it at http://mariadb.com/kb/en/mariadb-with-galera-on-redhat-72-not-starting/ as the person asking the question may not be subscribed to the mailing list.

--------------------------------
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 <info@xxxxxxxxxxxxx> 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

--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-with-galera-on-redhat-72-not-starting/