mysqld[9399]: 2015-10-20 9:44:19 140433629358016 [Note] /usr/sbin/mysqld (mysqld 10.1.8-MariaDB-1~jessie-log) starting as process 9399 ... mysqld[9399]: 2015-10-20 9:44:19 140433629358016 [Note] Using unique option prefix 'myisam_recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] InnoDB: Using mutexes to ref count buffer pool pages mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] InnoDB: The InnoDB memory heap is disabled mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] InnoDB: Memory barrier is not used mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] InnoDB: Compressed tables use zlib 1.2.8 mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] InnoDB: Using Linux native AIO mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] InnoDB: Using CPU crc32 instructions mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] InnoDB: Initializing buffer pool, size = 256.0M mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] InnoDB: Completed initialization of buffer pool mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] InnoDB: Highest supported file format is Barracuda. mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] InnoDB: 128 rollback segment(s) are active. mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] InnoDB: Waiting for purge to start mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1616859 mysqld[9399]: 2015-10-20 9:44:20 140432843441920 [Note] InnoDB: Dumping buffer pool(s) not yet started mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] Plugin 'FEEDBACK' is disabled. mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] Server socket created on IP: '127.0.0.1'. mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] Event Scheduler: Loaded 0 events mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] Reading of all Master_info entries succeded mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] Added new Master_info '' to hash table mysqld[9399]: 2015-10-20 9:44:20 140433629358016 [Note] /usr/sbin/mysqld: ready for connections. mysqld[9399]: Version: '10.1.8-MariaDB-1~jessie-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution mysqld[9429]: Checking for corrupt, not cleanly closed and upgrade needing tables. mysqld[9399]: 2015-10-20 9:45:31 140433628530432 [Note] /usr/sbin/mysqld: Normal shutdown mysqld[9399]: 2015-10-20 9:45:31 140433628530432 [Note] Event Scheduler: Purging the queue. 0 events mysqld[9399]: 2015-10-20 9:45:31 140432826656512 [Note] InnoDB: FTS optimize thread exiting. mysqld[9399]: 2015-10-20 9:45:31 140433628530432 [Note] InnoDB: Starting shutdown... mysqld[9399]: 2015-10-20 9:45:33 140433628530432 [Note] InnoDB: Shutdown completed; log sequence number 1616869 mysqld[9399]: 2015-10-20 9:45:33 140433628530432 [Note] /usr/sbin/mysqld: Shutdown complete mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] /usr/sbin/mysqld (mysqld 10.1.8-MariaDB-1~jessie-log) starting as process 9460 ... mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: Read nil XID from storage engines, skipping position init mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so' mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: wsrep_load(): Galera 3.9(rXXXX) by Codership Oy loaded successfully. mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Warning] WSREP: Failed to guess base node address. Set it explicitly via wsrep_node_address. mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: CRC-32C: using hardware acceleration. mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Warning] WSREP: Could not open saved state file for reading: /var/lib/mysql//grastate.dat mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1 mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: Passing config to GCS: 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.size = 128M; 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 = 3; 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. mysqld[9460]: 2015-10-20 9:45:33 139731668465408 [Note] WSREP: Service thread queue flushed. mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: wsrep_sst_grab() mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: Start replication mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: protonet asio version 0 mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: Using CRC-32C for message checksums. mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: backend: asio mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory) mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: restore pc from disk failed mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: GMCast version 0 mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: (fb57231b, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: (fb57231b, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: EVS version 0 mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: gcomm: connecting to group 'CLUSTERNAME', peer '192.168.100.10:' mysqld[9460]: 2015-10-20 9:45:33 139731982227392 [Note] WSREP: (fb57231b, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://192.168.100.214:4567 tcp://192.168.100.23:4567 tcp://192.168.100.24:4567 tcp://192.168.100.25:4567 mysqld[9460]: 2015-10-20 9:45:34 139731982227392 [Note] WSREP: declaring 1db9130f at tcp://192.168.100.25:4567 stable mysqld[9460]: 2015-10-20 9:45:34 139731982227392 [Note] WSREP: declaring 8eb89748 at tcp://192.168.100.24:4567 stable mysqld[9460]: 2015-10-20 9:45:34 139731982227392 [Note] WSREP: declaring 904765e1 at tcp://192.168.100.23:4567 stable mysqld[9460]: 2015-10-20 9:45:34 139731982227392 [Note] WSREP: declaring f91c6227 at tcp://192.168.100.10:4567 stable mysqld[9460]: 2015-10-20 9:45:34 139731982227392 [Note] WSREP: declaring f93c89bd at tcp://192.168.100.214:4567 stable mysqld[9460]: 2015-10-20 9:45:34 139731982227392 [Note] WSREP: Node 1db9130f state prim mysqld[9460]: 2015-10-20 9:45:34 139731982227392 [Note] WSREP: view(view_id(PRIM,1db9130f,764) memb { mysqld[9460]: 1db9130f,3 mysqld[9460]: 8eb89748,3 mysqld[9460]: 904765e1,3 mysqld[9460]: f91c6227,3 mysqld[9460]: f93c89bd,3 mysqld[9460]: fb57231b,3 mysqld[9460]: } joined { mysqld[9460]: } left { mysqld[9460]: } partitioned { mysqld[9460]: }) mysqld[9460]: 2015-10-20 9:45:34 139731982227392 [Note] WSREP: save pc into disk mysqld[9460]: 2015-10-20 9:45:34 139731982227392 [Note] WSREP: gcomm: connected mysqld[9460]: 2015-10-20 9:45:34 139731982227392 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 mysqld[9460]: 2015-10-20 9:45:34 139731982227392 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) mysqld[9460]: 2015-10-20 9:45:34 139731982227392 [Note] WSREP: Opened channel 'CLUSTERNAME' mysqld[9460]: 2015-10-20 9:45:34 139731982227392 [Note] WSREP: Waiting for SST to complete. mysqld[9460]: 2015-10-20 9:45:34 139731597784832 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 5, memb_num = 6 mysqld[9460]: 2015-10-20 9:45:34 139731597784832 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. mysqld[9460]: 2015-10-20 9:45:34 139731597784832 [Note] WSREP: STATE EXCHANGE: sent state msg: eed78e7b-7749-11e5-83a3-2e545c48cd61 mysqld[9460]: 2015-10-20 9:45:34 139731597784832 [Note] WSREP: STATE EXCHANGE: got state msg: eed78e7b-7749-11e5-83a3-2e545c48cd61 from 0 (maria-3) mysqld[9460]: 2015-10-20 9:45:34 139731597784832 [Note] WSREP: STATE EXCHANGE: got state msg: eed78e7b-7749-11e5-83a3-2e545c48cd61 from 1 (maria-2) mysqld[9460]: 2015-10-20 9:45:34 139731597784832 [Note] WSREP: STATE EXCHANGE: got state msg: eed78e7b-7749-11e5-83a3-2e545c48cd61 from 2 (core) mysqld[9460]: 2015-10-20 9:45:34 139731597784832 [Note] WSREP: STATE EXCHANGE: got state msg: eed78e7b-7749-11e5-83a3-2e545c48cd61 from 4 (debian-maria10-0) mysqld[9460]: 2015-10-20 9:45:34 139731597784832 [Note] WSREP: STATE EXCHANGE: got state msg: eed78e7b-7749-11e5-83a3-2e545c48cd61 from 3 (admin) mysqld[9460]: 2015-10-20 9:45:34 139731597784832 [Note] WSREP: STATE EXCHANGE: got state msg: eed78e7b-7749-11e5-83a3-2e545c48cd61 from 5 () mysqld[9460]: 2015-10-20 9:45:34 139731597784832 [Note] WSREP: Quorum results: mysqld[9460]: version = 3, mysqld[9460]: component = PRIMARY, mysqld[9460]: conf_id = 763, mysqld[9460]: members = 4/6 (joined/total), mysqld[9460]: act_id = 229458, mysqld[9460]: last_appl. = -1, mysqld[9460]: protocols = 0/7/3 (gcs/repl/appl), mysqld[9460]: group UUID = fb718299-4edb-11e5-ba62-834a441c1ed2 mysqld[9460]: 2015-10-20 9:45:34 139731597784832 [Note] WSREP: Flow-control interval: [39, 39] mysqld[9460]: 2015-10-20 9:45:34 139731597784832 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 229458) mysqld[9460]: 2015-10-20 9:45:34 139731981920000 [Note] WSREP: State transfer required: mysqld[9460]: Group state: fb718299-4edb-11e5-ba62-834a441c1ed2:229458 mysqld[9460]: Local state: 00000000-0000-0000-0000-000000000000:-1 mysqld[9460]: 2015-10-20 9:45:34 139731981920000 [Note] WSREP: New cluster view: global state: fb718299-4edb-11e5-ba62-834a441c1ed2:229458, view# 764: Primary, number of nodes: 6, my index: 5, protocol version 3 mysqld[9460]: 2015-10-20 9:45:34 139731981920000 [Warning] WSREP: Gap in state sequence. Need state transfer. mysqld[9460]: 2015-10-20 9:45:34 139731981920000 [ERROR] WSREP: Failed to guess address to accept state transfer. wsrep_sst_receive_address must be set manually. mysqld[9460]: 2015-10-20 9:45:34 139731981920000 [ERROR] Aborting mysqld[9460]: Error in my_thread_global_end(): 1 threads didn't exit systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE systemd[1]: Failed to start MariaDB database server. systemd[1]: Unit mariadb.service entered failed state.