[root@devlsql04 ~]# vi /var/log/mysqld.err? ]? cat /var/log/mysqld.err 2018-12-17T01:39:49.324180Z 5 [Note] WSREP: Setting wsrep_ready to true 2018-12-17T01:39:49.324187Z 5 [Warning] WSREP: Gap in state sequence. Need state transfer.? 2018-12-17T01:39:49.324193Z 5 [Note] WSREP: Setting wsrep_ready to false? 2018-12-17T01:39:49.324976Z 5 [Note] WSREP: You have configured 'xtrabackup-v2' state snapshot transfer method which cannot be performed on a running server. Wsrep provider won't be able to fall back to it if other means of state transfer are unavailable. In that case you will need to restart the server.? 2018-12-17T01:39:49.325030Z 5 [Note] WSREP: Auto Increment Offset/Increment re-align with cluster membership change (Offset: 1 -> 1) (Increment: 1 -> 2)? 2018-12-17T01:39:49.325045Z 5 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.? 2018-12-17T01:39:49.325071Z 5 [ERROR] WSREP: Local state UUID 6b530d8f-fc21-11e8-8dbf-921ed01a88d2 is different from group state UUID b9455b6d-fa00-11e8-8a11-f751cb54f21b, and SST request is null: restart required.? 2018-12-17T01:39:49.325083Z 5 [Note] WSREP: Closing send monitor...? 2018-12-17T01:39:49.325091Z 5 [Note] WSREP: Closed send monitor.? 2018-12-17T01:39:49.325104Z 5 [Note] WSREP: gcomm: terminating thread? 2018-12-17T01:39:49.325131Z 5 [Note] WSREP: gcomm: joining thread? 2018-12-17T01:39:49.325213Z 5 [Note] WSREP: gcomm: closing backend? 2018-12-17T01:39:51.818725Z 5 [Note] WSREP: (a39f01b3, 'tcp://0.0.0.0:4567') turning message relay requesting off? 2018-12-17T01:39:52.818736Z 5 [Note] WSREP: (a39f01b3, 'tcp://0.0.0.0:4567') connection to peer b64da5e0 with addr tcp://172.18.23.12:4567 timed out, no messages seen in PT3S (gmcast.peer_timeout)? 2018-12-17T01:39:52.818893Z 5 [Note] WSREP: (a39f01b3, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://172.18.23.12:4567? 2018-12-17T01:39:54.318737Z 5 [Note] WSREP: (a39f01b3, 'tcp://0.0.0.0:4567') reconnecting to b64da5e0 (tcp://172.18.23.12:4567), attempt 0? 2018-12-17T01:39:54.825398Z 5 [Note] WSREP: declaring node with index 1 suspected, timeout PT5S (evs.suspect_timeout)? 2018-12-17T01:39:54.825448Z 5 [Note] WSREP: evs::proto(a39f01b3, LEAVING, view_id(REG,a39f01b3,2)) suspecting node: b64da5e0? 2018-12-17T01:39:54.825456Z 5 [Note] WSREP: evs::proto(a39f01b3, LEAVING, view_id(REG,a39f01b3,2)) suspected node without join message, declaring inactive? 2018-12-17T01:39:54.825500Z 5 [Note] WSREP: Current view of cluster as seen by this node? view (view_id(NON_PRIM,a39f01b3,2)? memb {? ? ? ? ? a39f01b3,0? ? ? ? ? }? joined {? ? ? ? ? }? left {? ? ? ? ? }? partitioned {? ? ? ? ? b64da5e0,0? ? ? ? ? }? )? 2018-12-17T01:39:54.825553Z 5 [Note] WSREP: Current view of cluster as seen by this node? view ((empty))? 2018-12-17T01:39:54.825761Z 5 [Note] WSREP: gcomm: closed? 2018-12-17T01:39:54.825874Z 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1? 2018-12-17T01:39:54.825920Z 0 [Note] WSREP: Flow-control interval: [100, 100]? 2018-12-17T01:39:54.825930Z 0 [Note] WSREP: Trying to continue unpaused monitor? 2018-12-17T01:39:54.825937Z 0 [Note] WSREP: Received NON-PRIMARY.? 2018-12-17T01:39:54.825945Z 0 [Note] WSREP: Shifting PRIMARY -> OPEN (TO: 58)? 2018-12-17T01:39:54.825960Z 0 [Note] WSREP: Received self-leave message.? 2018-12-17T01:39:54.825992Z 0 [Note] WSREP: Flow-control interval: [0, 0]? 2018-12-17T01:39:54.826003Z 0 [Note] WSREP: Trying to continue unpaused monitor? 2018-12-17T01:39:54.826012Z 0 [Note] WSREP: Received SELF-LEAVE. Closing connection.? 2018-12-17T01:39:54.826020Z 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 58)? 2018-12-17T01:39:54.826053Z 0 [Note] WSREP: RECV thread exiting 0: Success? 2018-12-17T01:39:54.826104Z 5 [Note] WSREP: recv_thread() joined.? 2018-12-17T01:39:54.826110Z 5 [Note] WSREP: Closing replication queue.? 2018-12-17T01:39:54.826113Z 5 [Note] WSREP: Closing slave action queue.? 2018-12-17T01:39:54.826135Z 5 [Note] WSREP: /usr/sbin/mysqld: Terminated.? 2018-12-17T01:40:10.187179Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-23-57-log) starting as process 4364 ... 2018-12-17T01:40:10.207431Z 0 [Note] WSREP: Setting wsrep_ready to false? 2018-12-17T01:40:10.207461Z 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization.? 2018-12-17T01:40:10.207469Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera3/libgalera_smm.so'? 2018-12-17T01:40:10.219034Z 0 [Note] WSREP: wsrep_load(): Galera 3.31(rf216443) by Codership Oy loaded successfully.? 2018-12-17T01:40:10.219352Z 0 [Note] WSREP: CRC-32C: using "slicing-by-8" algorithm.? 2018-12-17T01:40:10.220881Z 0 [Note] WSREP: Found saved state: 6b530d8f-fc21-11e8-8dbf-921ed01a88d2:2, safe_to_bootstrap: 0? 2018-12-17T01:40:10.226166Z 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 172.18.23.13; 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 = 10; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 4; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.freeze_purge_at_seqno = -1; 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; gcs.fc_limit = 100; 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.npvo = false; pc.recovery = 1; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 1; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 9; socket.checksum = 2; socket.recv_buf_size = 212992;? 2018-12-17T01:40:10.256044Z 0 [Note] WSREP: GCache history reset: 6b530d8f-fc21-11e8-8dbf-921ed01a88d2:0 -> 6b530d8f-fc21-11e8-8dbf-921ed01a88d2:2? 2018-12-17T01:40:10.257873Z 0 [Note] WSREP: Assign initial position for certification: 2, protocol version: -1? 2018-12-17T01:40:10.263170Z 0 [Note] InnoDB: PUNCH HOLE support available? 2018-12-17T01:40:10.263206Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins? 2018-12-17T01:40:10.263216Z 0 [Note] InnoDB: Uses event mutexes? 2018-12-17T01:40:10.263225Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier? 2018-12-17T01:40:10.263233Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3? 2018-12-17T01:40:10.263240Z 0 [Note] InnoDB: Using Linux native AIO? 2018-12-17T01:40:10.263681Z 0 [Note] InnoDB: Number of pools: 1? 2018-12-17T01:40:10.263882Z 0 [Note] InnoDB: Not using CPU crc32 instructions? 2018-12-17T01:40:10.269551Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M? 2018-12-17T01:40:10.277880Z 0 [Note] InnoDB: Completed initialization of buffer pool? 2018-12-17T01:40:10.281682Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().? 2018-12-17T01:40:10.301692Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite? 2018-12-17T01:40:10.319083Z 0 [Note] InnoDB: Highest supported file format is Barracuda.? 2018-12-17T01:40:10.321892Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2596936? 2018-12-17T01:40:10.321922Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2596945? 2018-12-17T01:40:10.321939Z 0 [Note] InnoDB: Database was not shutdown normally!? 2018-12-17T01:40:10.321949Z 0 [Note] InnoDB: Starting crash recovery.? 2018-12-17T01:40:10.343352Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 3932160 bytes? 2018-12-17T01:40:10.407484Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"? 2018-12-17T01:40:10.407543Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables? 2018-12-17T01:40:10.408014Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...? 2018-12-17T01:40:10.435793Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.? 2018-12-17T01:40:10.439355Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.? 2018-12-17T01:40:10.439387Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.? 2018-12-17T01:40:10.440444Z 0 [Note] InnoDB: Waiting for purge to start? 2018-12-17T01:40:10.490755Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.23-23 started; log sequence number 2596945? 2018-12-17T01:40:10.491265Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool? 2018-12-17T01:40:10.491373Z 0 [Note] Plugin 'FEDERATED' is disabled.? 2018-12-17T01:40:10.498094Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181217 ?9:40:10? 2018-12-17T01:40:10.507273Z 0 [Note] Recovering after a crash using mysql-bin? 2018-12-17T01:40:10.507314Z 0 [Note] WSREP: Before binlog recovery (wsrep position 6b530d8f-fc21-11e8-8dbf-921ed01a88d2:2)? 2018-12-17T01:40:10.507355Z 0 [Note] Starting crash recovery...? 2018-12-17T01:40:10.507402Z 0 [Note] Crash recovery finished.? 2018-12-17T01:40:10.507421Z 0 [Note] WSREP: After binlog recovery (wsrep position 6b530d8f-fc21-11e8-8dbf-921ed01a88d2:2)? 2018-12-17T01:40:10.532990Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.? 2018-12-17T01:40:10.533051Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.? 2018-12-17T01:40:10.555392Z 0 [Warning] CA certificate ca.pem is self signed.? 2018-12-17T01:40:10.555518Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-12-17T01:40:10.560694Z 0 [Note] Server hostname (bind-address): '*'; port: 3306? 2018-12-17T01:40:10.560768Z 0 [Note] IPv6 is available.? 2018-12-17T01:40:10.560781Z 0 [Note] ? - '::' resolves to '::';? 2018-12-17T01:40:10.560813Z 0 [Note] Server socket created on IP: '::'.? 2018-12-17T01:40:11.480370Z 0 [Note] Event Scheduler: Loaded 0 events? 2018-12-17T01:40:11.480805Z 0 [Note] /usr/sbin/mysqld: ready for connections.? Version: '5.7.23-23-57-log' ?socket: '/var/lib/mysql/mysql.sock' ?port: 3306 ?Percona XtraDB Cluster (GPL), Release rel23, Revision f5578f0, WSREP version 31.31, wsrep_31.31?