2017-06-27 14:17:10 4354 [Note] WSREP: Setting wsrep_ready to 0 2017-06-27 14:17:10 4354 [Note] WSREP: Read nil XID from storage engines, skipping position init 2017-06-27 14:17:10 4354 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/libgalera_smm.so' 2017-06-27 14:17:10 4354 [Note] WSREP: wsrep_load(): Galera 3.20(r7e383f7) by Codership Oy loaded successfully. 2017-06-27 14:17:10 4354 [Note] WSREP: CRC-32C: using hardware acceleration. 2017-06-27 14:17:10 4354 [Note] WSREP: Found saved state: 7b486f6e-5a83-11e7-a79a-eac6996ff682:53, safe_to_bootsrap: 0 2017-06-27 14:17:10 4354 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = X.X.X.2; 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 = /var/lib/mysql/; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; 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 = 2017-06-27 14:17:10 4354 [Note] WSREP: GCache history reset: old(7b486f6e-5a83-11e7-a79a-eac6996ff682:0) -> new(7b486f6e-5a83-11e7-a79a-eac6996ff682:53) 2017-06-27 14:17:10 4354 [Note] WSREP: Assign initial position for certification: 53, protocol version: -1 2017-06-27 14:17:10 4354 [Note] WSREP: wsrep_sst_grab() 2017-06-27 14:17:10 4354 [Note] WSREP: Start replication 2017-06-27 14:17:10 4354 [Note] WSREP: Setting initial position to 7b486f6e-5a83-11e7-a79a-eac6996ff682:53 2017-06-27 14:17:10 4354 [Note] WSREP: protonet asio version 0 2017-06-27 14:17:10 4354 [Note] WSREP: Using CRC-32C for message checksums. 2017-06-27 14:17:10 4354 [Note] WSREP: backend: asio 2017-06-27 14:17:10 4354 [Note] WSREP: gcomm thread scheduling priority set to other:0 2017-06-27 14:17:10 4354 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) 2017-06-27 14:17:10 4354 [Note] WSREP: restore pc from disk failed 2017-06-27 14:17:10 4354 [Note] WSREP: GMCast version 0 2017-06-27 14:17:10 4354 [Note] WSREP: (8b929fa5, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2017-06-27 14:17:10 4354 [Note] WSREP: (8b929fa5, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2017-06-27 14:17:10 4354 [Note] WSREP: EVS version 0 2017-06-27 14:17:10 4354 [Note] WSREP: gcomm: connecting to group 'pxc-cluster', peer 'X.X.X.1:,X.X.X.2:,X.X.X.3:' 2017-06-27 14:17:10 4354 [Note] WSREP: (8b929fa5, 'tcp://0.0.0.0:4567') connection established to 8b929fa5 tcp://X.X.X.2:4567 2017-06-27 14:17:10 4354 [Warning] WSREP: (8b929fa5, 'tcp://0.0.0.0:4567') address 'tcp://X.X.X.2:4567' points to own listening address, blacklisting 2017-06-27 14:17:10 4354 [Note] WSREP: (8b929fa5, 'tcp://0.0.0.0:4567') connection established to 90f9e878 tcp://X.X.X.3:4567 2017-06-27 14:17:10 4354 [Note] WSREP: (8b929fa5, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 2017-06-27 14:17:10 4354 [Note] WSREP: (8b929fa5, 'tcp://0.0.0.0:4567') connection established to 8b4fea66 tcp://X.X.X.1:4567 2017-06-27 14:17:10 4354 [Note] WSREP: declaring 8b4fea66 at tcp://X.X.X.1:4567 stable 2017-06-27 14:17:10 4354 [Note] WSREP: declaring 90f9e878 at tcp://X.X.X.3:4567 stable 2017-06-27 14:17:10 4354 [Note] WSREP: Node 8b4fea66 state prim 2017-06-27 14:17:10 4354 [Note] WSREP: view(view_id(PRIM,8b4fea66,27) memb { 8b4fea66,0 8b929fa5,0 90f9e878,0 } joined { } left { } partitioned { }) 2017-06-27 14:17:10 4354 [Note] WSREP: save pc into disk 2017-06-27 14:17:11 4354 [Note] WSREP: gcomm: connected 2017-06-27 14:17:11 4354 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2017-06-27 14:17:11 4354 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2017-06-27 14:17:11 4354 [Note] WSREP: Opened channel 'pxc-cluster' 2017-06-27 14:17:11 4354 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3 2017-06-27 14:17:11 4354 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2017-06-27 14:17:11 4354 [Note] WSREP: STATE EXCHANGE: sent state msg: 8b9f3ff2-5b32-11e7-8a1f-3365dbad90f6 2017-06-27 14:17:11 4354 [Note] WSREP: STATE EXCHANGE: got state msg: 8b9f3ff2-5b32-11e7-8a1f-3365dbad90f6 from 2 (pxc3) 2017-06-27 14:17:11 4354 [Note] WSREP: STATE EXCHANGE: got state msg: 8b9f3ff2-5b32-11e7-8a1f-3365dbad90f6 from 0 (pxc1) 2017-06-27 14:17:11 4354 [Note] WSREP: Waiting for SST to complete. 2017-06-27 14:17:11 4354 [Note] WSREP: STATE EXCHANGE: got state msg: 8b9f3ff2-5b32-11e7-8a1f-3365dbad90f6 from 1 (pxc2) 2017-06-27 14:17:11 4354 [Note] WSREP: Quorum results: version = 4, component = PRIMARY, conf_id = 25, members = 3/3 (joined/total), act_id = 53, last_appl. = -1, protocols = 0/7/3 (gcs/repl/appl), group UUID = 7b486f6e-5a83-11e7-a79a-eac6996ff682 2017-06-27 14:17:11 4354 [Note] WSREP: Flow-control interval: [28, 28] 2017-06-27 14:17:11 4354 [Note] WSREP: Restored state OPEN -> JOINED (53) 2017-06-27 14:17:11 4354 [Note] WSREP: Member 1.0 (pxc2) synced with group. 2017-06-27 14:17:11 4354 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 53) 2017-06-27 14:17:11 4354 [Note] WSREP: Member 0.0 (pxc1) synced with group. 2017-06-27 14:17:11 4354 [Note] WSREP: New cluster view: global state: 7b486f6e-5a83-11e7-a79a-eac6996ff682:53, view# 26: Primary, number of nodes: 3, my index: 1, protocol version 3 2017-06-27 14:17:11 4354 [Note] WSREP: SST complete, seqno: 53 2017-06-27 14:17:11 4354 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2017-06-27 14:17:11 4354 [Note] Plugin 'FEDERATED' is disabled. 2017-06-27 14:17:11 4354 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB. 2017-06-27 14:17:11 4354 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-06-27 14:17:11 4354 [Note] InnoDB: The InnoDB memory heap is disabled 2017-06-27 14:17:11 4354 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-06-27 14:17:11 4354 [Note] InnoDB: Memory barrier is not used 2017-06-27 14:17:11 4354 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-06-27 14:17:11 4354 [Note] InnoDB: Using Linux native AIO 2017-06-27 14:17:11 4354 [Note] InnoDB: Using CPU crc32 instructions 2017-06-27 14:17:11 4354 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2017-06-27 14:17:11 4354 [Note] InnoDB: Completed initialization of buffer pool 2017-06-27 14:17:11 4354 [Note] InnoDB: Highest supported file format is Barracuda. 2017-06-27 14:17:11 4354 [Note] InnoDB: 128 rollback segment(s) are active. 2017-06-27 14:17:11 4354 [Note] InnoDB: Waiting for purge to start 2017-06-27 14:17:11 4354 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1772095 2017-06-27 14:17:11 4354 [Note] WSREP: Initial TC log open: dummy 2017-06-27 14:17:11 4354 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work. 2017-06-27 14:17:11 4354 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work. 2017-06-27 14:17:11 4354 [Note] Server hostname (bind-address): 'X.X.X.2'; port: 3306 2017-06-27 14:17:11 4354 [Note] - 'X.X.X.2' resolves to 'X.X.X.2'; 2017-06-27 14:17:11 4354 [Note] Server socket created on IP: 'X.X.X.2'. 2017-06-27 14:17:11 4354 [Note] Event Scheduler: Loaded 0 events 2017-06-27 14:17:11 4354 [Note] WSREP: Set WSREPXid for InnoDB: 7b486f6e-5a83-11e7-a79a-eac6996ff682:53 2017-06-27 14:17:11 4354 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.36-82.0-56' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Percona XtraDB Cluster (GPL), Release rel82.0, Revision de7a681, WSREP version 26.20, wsrep_26.20 2017-06-27 14:17:11 4354 [Note] WSREP: Initialized wsrep sidno 1 2017-06-27 14:17:11 4354 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2017-06-27 14:17:11 4354 [Note] WSREP: REPL Protocols: 7 (3, 2) 2017-06-27 14:17:11 4354 [Note] WSREP: Assign initial position for certification: 53, protocol version: 3 2017-06-27 14:17:11 4354 [Note] WSREP: Service thread queue flushed. 2017-06-27 14:17:11 4354 [Note] WSREP: Synchronized with group, ready for connections 2017-06-27 14:17:11 4354 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2017-06-27 14:17:11 4354 [Note] WSREP: Nobody is waiting for SST. 2017-06-27 14:17:13 4354 [Note] WSREP: (8b929fa5, 'tcp://0.0.0.0:4567') connection to peer 8b929fa5 with addr tcp://X.X.X.2:4567 timed out, no messages seen in PT3S 2017-06-27 14:17:13 4354 [Note] WSREP: (8b929fa5, 'tcp://0.0.0.0:4567') turning message relay requesting off 2017-06-27 14:17:24 4354 [Note] WSREP: Set WSREPXid for InnoDB: 7b486f6e-5a83-11e7-a79a-eac6996ff682:54 2017-06-27 14:17:35 4354 [Note] WSREP: Set WSREPXid for InnoDB: 7b486f6e-5a83-11e7-a79a-eac6996ff682:55 2017-06-27 14:17:45 4354 [Note] WSREP: cleanup transaction for LOCAL_STATE: SELECT * FROM example