May 7 16:31:29 galera2 systemd: Starting MariaDB 10.3.6 database server... May 7 16:31:31 galera2 sh: WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1 May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] /usr/sbin/mysqld (mysqld 10.3.6-MariaDB) starting as process 1287 ... May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: Read nil XID from storage engines, skipping position init May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: wsrep_load(): Galera 25.3.23(r3789) by Codership Oy loaded successfully. May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: CRC-32C: using hardware acceleration. May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1 May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 192.168.122.202; 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_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 = PT3S; pc.checksum = false; p May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: GCache history reset: 97291d02-5216-11e8-a348-3b355a8cc067:0 -> 00000000-0000-0000-0000-000000000000:-1 May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: wsrep_sst_grab() May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: Start replication May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: protonet asio version 0 May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: Using CRC-32C for message checksums. May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: backend: asio May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: restore pc from disk failed May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: GMCast version 0 May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: (a0edf5fe, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: (a0edf5fe, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: EVS version 0 May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: gcomm: connecting to group 'training', peer '192.168.122.201:,192.168.122.202:,192.168.122.203:' May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: (a0edf5fe, 'tcp://0.0.0.0:4567') connection established to a0edf5fe tcp://192.168.122.202:4567 May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Warning] WSREP: (a0edf5fe, 'tcp://0.0.0.0:4567') address 'tcp://192.168.122.202:4567' points to own listening address, blacklisting May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: (a0edf5fe, 'tcp://0.0.0.0:4567') connection established to 7e3fe92c tcp://192.168.122.201:4567 May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: (a0edf5fe, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: declaring 7e3fe92c at tcp://192.168.122.201:4567 stable May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: Node 7e3fe92c state prim May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: view(view_id(PRIM,7e3fe92c,2) memb { May 7 16:31:32 galera2 mysqld: 7e3fe92c,0 May 7 16:31:32 galera2 mysqld: a0edf5fe,0 May 7 16:31:32 galera2 mysqld: } joined { May 7 16:31:32 galera2 mysqld: } left { May 7 16:31:32 galera2 mysqld: } partitioned { May 7 16:31:32 galera2 mysqld: }) May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: save pc into disk May 7 16:31:32 galera2 mysqld: 2018-05-07 16:31:32 0 [Note] WSREP: discarding pending addr without UUID: tcp://192.168.122.203:4567 May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: gcomm: connected May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: Opened channel 'training' May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: Waiting for SST to complete. May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2 May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: STATE EXCHANGE: sent state msg: a13b2c83-5235-11e8-94bf-f207aec1b71c May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: STATE EXCHANGE: got state msg: a13b2c83-5235-11e8-94bf-f207aec1b71c from 0 (galera1) May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: STATE EXCHANGE: got state msg: a13b2c83-5235-11e8-94bf-f207aec1b71c from 1 (galera2) May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: Quorum results: May 7 16:31:33 galera2 mysqld: version = 4, May 7 16:31:33 galera2 mysqld: component = PRIMARY, May 7 16:31:33 galera2 mysqld: conf_id = 1, May 7 16:31:33 galera2 mysqld: members = 1/2 (joined/total), May 7 16:31:33 galera2 mysqld: act_id = 6, May 7 16:31:33 galera2 mysqld: last_appl. = -1, May 7 16:31:33 galera2 mysqld: protocols = 0/8/3 (gcs/repl/appl), May 7 16:31:33 galera2 mysqld: group UUID = 97291d02-5216-11e8-a348-3b355a8cc067 May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: Flow-control interval: [23, 23] May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: Trying to continue unpaused monitor May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 6) May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 1 [Note] WSREP: State transfer required: May 7 16:31:33 galera2 mysqld: Group state: 97291d02-5216-11e8-a348-3b355a8cc067:6 May 7 16:31:33 galera2 mysqld: Local state: 00000000-0000-0000-0000-000000000000:-1 May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 1 [Note] WSREP: New cluster view: global state: 97291d02-5216-11e8-a348-3b355a8cc067:6, view# 2: Primary, number of nodes: 2, my index: 1, protocol version 3 May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 1 [Warning] WSREP: Gap in state sequence. Need state transfer. May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '192.168.122.202' --datadir '/var/lib/mysql/' --parent '1287' '' ' May 7 16:31:33 galera2 rsyncd[1336]: rsyncd version 3.0.9 starting, listening on port 4444 May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 1 [Note] WSREP: Prepared SST request: rsync|192.168.122.202:4444/rsync_sst May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 1 [Note] WSREP: REPL Protocols: 8 (3, 2) May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 1 [Note] WSREP: Assign initial position for certification: 6, protocol version: 3 May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: Service thread queue flushed. May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 1 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (97291d02-5216-11e8-a348-3b355a8cc067): 1 (Operation not permitted) May 7 16:31:33 galera2 mysqld: at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will be unavailable. May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: Member 1.0 (galera2) requested state transfer from '*any*'. Selected 0.0 (galera1)(SYNCED) as donor. May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 6) May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 1 [Note] WSREP: Requesting state transfer: success, donor: 0 May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 1 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 97291d02-5216-11e8-a348-3b355a8cc067:6 May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Warning] WSREP: 0.0 (galera1): State transfer to 1.0 (galera2) failed: -255 (Unknown error 255) May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [ERROR] WSREP: gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():737: Will never receive state. Need to abort. May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: gcomm: terminating thread May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: gcomm: joining thread May 7 16:31:33 galera2 mysqld: 2018-05-07 16:31:33 0 [Note] WSREP: gcomm: closing backend May 7 16:31:35 galera2 mysqld: 2018-05-07 16:31:35 0 [Note] WSREP: (a0edf5fe, 'tcp://0.0.0.0:4567') connection to peer a0edf5fe with addr tcp://192.168.122.202:4567 timed out, no messages seen in PT3S May 7 16:31:35 galera2 mysqld: 2018-05-07 16:31:35 0 [Note] WSREP: (a0edf5fe, 'tcp://0.0.0.0:4567') turning message relay requesting off May 7 16:31:36 galera2 mysqld: 2018-05-07 16:31:36 0 [Note] WSREP: (a0edf5fe, 'tcp://0.0.0.0:4567') connection to peer 7e3fe92c with addr tcp://192.168.122.201:4567 timed out, no messages seen in PT3S May 7 16:31:36 galera2 mysqld: 2018-05-07 16:31:36 0 [Note] WSREP: (a0edf5fe, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://192.168.122.201:4567 May 7 16:31:38 galera2 mysqld: 2018-05-07 16:31:38 0 [Note] WSREP: (a0edf5fe, 'tcp://0.0.0.0:4567') reconnecting to 7e3fe92c (tcp://192.168.122.201:4567), attempt 0 May 7 16:31:38 galera2 mysqld: 2018-05-07 16:31:38 0 [Note] WSREP: evs::proto(a0edf5fe, LEAVING, view_id(REG,7e3fe92c,2)) suspecting node: 7e3fe92c May 7 16:31:38 galera2 mysqld: 2018-05-07 16:31:38 0 [Note] WSREP: evs::proto(a0edf5fe, LEAVING, view_id(REG,7e3fe92c,2)) suspected node without join message, declaring inactive May 7 16:31:38 galera2 mysqld: 2018-05-07 16:31:38 0 [Note] WSREP: view(view_id(NON_PRIM,7e3fe92c,2) memb { May 7 16:31:38 galera2 mysqld: a0edf5fe,0 May 7 16:31:38 galera2 mysqld: } joined { May 7 16:31:38 galera2 mysqld: } left { May 7 16:31:38 galera2 mysqld: } partitioned { May 7 16:31:38 galera2 mysqld: 7e3fe92c,0 May 7 16:31:38 galera2 mysqld: }) May 7 16:31:38 galera2 mysqld: 2018-05-07 16:31:38 0 [Note] WSREP: view((empty)) May 7 16:31:38 galera2 mysqld: 2018-05-07 16:31:38 0 [Note] WSREP: gcomm: closed May 7 16:31:38 galera2 mysqld: 2018-05-07 16:31:38 0 [Note] WSREP: /usr/sbin/mysqld: Terminated. May 7 16:31:38 galera2 systemd: mariadb.service: main process exited, code=killed, status=6/ABRT May 7 16:31:38 galera2 mysqld: Beendet May 7 16:31:38 galera2 mysqld: WSREP_SST: [INFO] Joiner cleanup. rsync PID: 1336 (20180507 16:31:38.968) May 7 16:31:39 galera2 rsyncd[1336]: sent 0 bytes received 0 bytes total size 0 May 7 16:31:39 galera2 mysqld: WSREP_SST: [INFO] Joiner cleanup done. (20180507 16:31:39.478) May 7 16:31:39 galera2 systemd: Failed to start MariaDB 10.3.6 database server. May 7 16:31:39 galera2 systemd: Unit mariadb.service entered failed state. May 7 16:31:39 galera2 systemd: mariadb.service failed.