maria-discuss team mailing list archive

Thread
Date
转发：failed to connect mariadb at addition node in MariaDB galera cluster

To: "maria-discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>, "yan-jack.chen" <yan-jack.chen@xxxxxxxxx>,
From: "西门吹牛" <zh1029@xxxxxxxx>
Date: Fri, 02 Sep 2016 11:08:39 +0800
Reply-to: zh1029@xxxxxxxx
Hi,
  I deployed two MariaDB galera version in two nodes to build cluster. But I can’t connect MariaDB in second node as seems the port is not created by MariaDB because looks like it is stuck somehow.
  Version: mysqld 10.1.17-MariaDB-debug VS galera-3-25.3.17
 
I started MariaDB in first node. Seems fine. Port 3307 was created and I can login Mariadb by mysql.


 


[root@MMN-0(RCP-69) /root/test]

# /home/_rcpadmin/bin/mariadb/bin/mysqld --defaults-extra-file=./mmn.my.cnf --wsrep-new-cluster --debug

2016-09-01 16:41:37 140716544316288 [Note] /home/_rcpadmin/bin/mariadb/bin/mysqld (mysqld 10.1.17-MariaDB-debug) starting as process 15248 ...

2016-09-01 16:41:38 140716544316288 [Note] WSREP: Setting wsrep_ready to 0

2016-09-01 16:41:38 140716544316288 [Note] WSREP: Read nil XID from storage engines, skipping position init

2016-09-01 16:41:38 140716544316288 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/libgalera_smm.so'

2016-09-01 16:41:38 140716544316288 [Note] WSREP: wsrep_load(): Galera 3.17(r0) by Codership Oy <info@xxxxxxxxxxxxx> loaded successfully.

2016-09-01 16:41:38 140716544316288 [Note] WSREP: CRC-32C: using hardware acceleration.

2016-09-01 16:41:38 140716544316288 [Note] WSREP: Found saved state: 900987cc-7003-11e6-b25f-de0a52317f1d:0

2016-09-01 16:41:38 140716544316288 [Note] WSREP: Passing config to GCS: base_dir = /mariadb/; base_host = MMN-0; base_port = 4567; cert.log_conflicts = no; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period
= PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout
= PT24H; gcache.dir = /mariadb/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /mariadb//galera.cache; gcache.page_size = 300M; gcache.size = 300M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave
= no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum
= false; pc.ignore_sb = false; pc

2016-09-01 16:41:38 140716029634304 [Note] WSREP: Service thread queue flushed.

2016-09-01 16:41:38 140716544316288 [Note] WSREP: Assign initial position for certification: 0, protocol version: -1

2016-09-01 16:41:38 140716544316288 [Note] WSREP: wsrep_sst_grab()

2016-09-01 16:41:38 140716544316288 [Note] WSREP: Start replication

2016-09-01 16:41:38 140716544316288 [Note] WSREP: 'wsrep-new-cluster' option used, bootstrapping the cluster

2016-09-01 16:41:38 140716544316288 [Note] WSREP: Setting initial position to 900987cc-7003-11e6-b25f-de0a52317f1d:0

2016-09-01 16:41:38 140716544316288 [Note] WSREP: protonet asio version 0

2016-09-01 16:41:38 140716544316288 [Note] WSREP: Using CRC-32C for message checksums.

2016-09-01 16:41:38 140716544316288 [Note] WSREP: backend: asio

2016-09-01 16:41:38 140716544316288 [Note] WSREP: gcomm thread scheduling priority set to other:0 

2016-09-01 16:41:38 140716544316288 [Warning] WSREP: access file(/mariadb//gvwstate.dat) failed(No such file or directory)

2016-09-01 16:41:38 140716544316288 [Note] WSREP: restore pc from disk failed

2016-09-01 16:41:38 140716544316288 [Note] WSREP: GMCast version 0

2016-09-01 16:41:38 140716544316288 [Note] WSREP: (e5a32d3c, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567

2016-09-01 16:41:38 140716544316288 [Note] WSREP: (e5a32d3c, 'tcp://0.0.0.0:4567') multicast: , ttl: 1

2016-09-01 16:41:38 140716544316288 [Note] WSREP: EVS version 0

2016-09-01 16:41:38 140716544316288 [Note] WSREP: gcomm: bootstrapping new group 'example_cluster'

2016-09-01 16:41:38 140716544316288 [Note] WSREP: start_prim is enabled, turn off pc_recovery

2016-09-01 16:41:38 140716544316288 [Note] WSREP: Node e5a32d3c state prim

2016-09-01 16:41:38 140716544316288 [Note] WSREP: view(view_id(PRIM,e5a32d3c,1) memb {

        e5a32d3c,0

} joined {

} left {

} partitioned {

})

2016-09-01 16:41:38 140716544316288 [Note] WSREP: save pc into disk

2016-09-01 16:41:38 140716544316288 [Note] WSREP: discarding pending addr without UUID: tcp://169.254.0.4:4567

2016-09-01 16:41:38 140716544316288 [Note] WSREP: discarding pending addr proto entry 0x5652b0352ef0

2016-09-01 16:41:38 140716544316288 [Note] WSREP: discarding pending addr without UUID: tcp://169.254.0.5:4567

2016-09-01 16:41:38 140716544316288 [Note] WSREP: discarding pending addr proto entry 0x5652b035b720

2016-09-01 16:41:38 140716544316288 [Note] WSREP: discarding pending addr without UUID: tcp://169.254.0.6:4567

2016-09-01 16:41:38 140716544316288 [Note] WSREP: discarding pending addr proto entry 0x5652b0363ea0

2016-09-01 16:41:38 140716544316288 [Note] WSREP: gcomm: connected

2016-09-01 16:41:38 140716544316288 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636

2016-09-01 16:41:38 140716544316288 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)

2016-09-01 16:41:38 140716544316288 [Note] WSREP: Opened channel 'example_cluster'

2016-09-01 16:41:38 140715987670784 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1

2016-09-01 16:41:38 140716544316288 [Note] WSREP: Waiting for SST to complete.

2016-09-01 16:41:38 140715987670784 [Note] WSREP: STATE_EXCHANGE: sent state UUID: e5a3bc45-701f-11e6-ba1c-471590fea490

2016-09-01 16:41:38 140715987670784 [Note] WSREP: STATE EXCHANGE: sent state msg: e5a3bc45-701f-11e6-ba1c-471590fea490

2016-09-01 16:41:38 140715987670784 [Note] WSREP: STATE EXCHANGE: got state msg: e5a3bc45-701f-11e6-ba1c-471590fea490 from 0 (MMN-0)

2016-09-01 16:41:38 140715987670784 [Note] WSREP: Quorum results:

        version    = 4,

        component  = PRIMARY,

        conf_id    = 0,

        members    = 1/1 (joined/total),

        act_id     = 0,

        last_appl. = -1,

        protocols  = 0/7/3 (gcs/repl/appl),

        group UUID = 900987cc-7003-11e6-b25f-de0a52317f1d

2016-09-01 16:41:38 140715987670784 [Note] WSREP: Flow-control interval: [16, 16]

2016-09-01 16:41:38 140715987670784 [Note] WSREP: Restored state OPEN -> JOINED (0)

2016-09-01 16:41:38 140715987670784 [Note] WSREP: Member 0.0 (MMN-0) synced with group.

2016-09-01 16:41:38 140716542806784 [Note] WSREP: New cluster view: global state: 900987cc-7003-11e6-b25f-de0a52317f1d:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3

2016-09-01 16:41:38 140715987670784 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)

2016-09-01 16:41:38 140716544316288 [Note] WSREP: SST complete, seqno: 0

2016-09-01 16:41:38 140716544316288 [Note] InnoDB: Using mutexes to ref count buffer pool pages

2016-09-01 16:41:38 140716544316288 [Note] InnoDB:  InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!

2016-09-01 16:41:38 140716544316288 [Note] InnoDB:  InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!

2016-09-01 16:41:38 140716544316288 [Note] InnoDB: The InnoDB memory heap is disabled

2016-09-01 16:41:38 140716-��ם~���jب
Follow ups

Re: 转发：failed to connect mariadb at addition node in MariaDB galera cluster
From: Nirbhay Choubey, 2016-09-02