140617 12:04:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140617 12:04:03 mysqld_safe Skipping wsrep-recover for empty datadir: /var/lib/mysql 140617 12:04:03 mysqld_safe Assigning 00000000-0000-0000-0000-000000000000:-1 to wsrep_start_position 2014-06-17 12:04:04 0 [Note] WSREP: wsrep_start_position var submitted: '00000000-0000-0000-0000-000000000000:-1' 2014-06-17 12:04:04 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-06-17 12:04:04 17673 [Note] WSREP: Read nil XID from storage engines, skipping position init 2014-06-17 12:04:04 17673 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/libgalera_smm.so' 2014-06-17 12:04:04 17673 [Note] WSREP: wsrep_load(): Galera 3.5(r178) by Codership Oy loaded successfully. 2014-06-17 12:04:04 17673 [Note] WSREP: CRC-32C: using "slicing-by-8" algorithm. 2014-06-17 12:04:05 17673 [Warning] WSREP: Could not open saved state file for reading: /var/lib/mysql//grastate.dat 2014-06-17 12:04:05 17673 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1 2014-06-17 12:04:05 17673 [Note] WSREP: Passing config to GCS: base_host = 192.168.3.3; base_port = 4567; cert.log_conflicts = no; debug = no; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT 1S; evs.max_install_timeouts = 1; 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; gcach e.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 = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false ; pc.npvo = false; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = P30S; pc.weight = 1; protonet 2014-06-17 12:04:05 17673 [Note] WSREP: Service thread queue flushed. 2014-06-17 12:04:05 17673 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 2014-06-17 12:04:05 17673 [Note] WSREP: wsrep_sst_grab() 2014-06-17 12:04:05 17673 [Note] WSREP: Start replication 2014-06-17 12:04:05 17673 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 2014-06-17 12:04:05 17673 [Note] WSREP: protonet asio version 0 2014-06-17 12:04:05 17673 [Note] WSREP: Using CRC-32C (optimized) for message checksums. 2014-06-17 12:04:05 17673 [Note] WSREP: backend: asio 2014-06-17 12:04:05 17673 [Note] WSREP: GMCast version 0 2014-06-17 12:04:05 17673 [Note] WSREP: (b701a6c7-f606-11e3-8f0f-6bd26dec2af7, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2014-06-17 12:04:05 17673 [Note] WSREP: (b701a6c7-f606-11e3-8f0f-6bd26dec2af7, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2014-06-17 12:04:05 17673 [Note] WSREP: EVS version 0 2014-06-17 12:04:05 17673 [Note] WSREP: PC version 0 2014-06-17 12:04:05 17673 [Note] WSREP: gcomm: connecting to group 'L1', peer '192.168.3.2:,192.168.3.3:,192.168.3.4:' 2014-06-17 12:04:05 17673 [Warning] WSREP: (b701a6c7-f606-11e3-8f0f-6bd26dec2af7, 'tcp://0.0.0.0:4567') address 'tcp://192.168.3.3:4567' points to own listening address, blacklisting 2014-06-17 12:04:05 17673 [Note] WSREP: (b701a6c7-f606-11e3-8f0f-6bd26dec2af7, 'tcp://0.0.0.0:4567') address 'tcp://192.168.3.3:4567' pointing to uuid b701a6c7-f606-11e3-8f0f-6bd26dec2af7 is blacklisted, skipping 2014-06-17 12:04:05 17673 [Note] WSREP: declaring 88d25beb-f605-11e3-be57-23c32973460b stable 2014-06-17 12:04:05 17673 [Note] WSREP: Node 88d25beb-f605-11e3-be57-23c32973460b state prim 2014-06-17 12:04:05 17673 [Note] WSREP: view(view_id(PRIM,88d25beb-f605-11e3-be57-23c32973460b,2) memb { 88d25beb-f605-11e3-be57-23c32973460b,0 b701a6c7-f606-11e3-8f0f-6bd26dec2af7,0 } joined { } left { } partitioned { }) 2014-06-17 12:04:05 17673 [Note] WSREP: discarding pending addr without UUID: tcp://192.168.3.4:4567 2014-06-17 12:04:06 17673 [Note] WSREP: gcomm: connected 2014-06-17 12:04:06 17673 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2014-06-17 12:04:06 17673 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2014-06-17 12:04:06 17673 [Note] WSREP: Opened channel 'L1' 2014-06-17 12:04:06 17673 [Note] WSREP: Waiting for SST to complete. 2014-06-17 12:04:06 17673 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2 2014-06-17 12:04:06 17673 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2014-06-17 12:04:06 17673 [Note] WSREP: STATE EXCHANGE: sent state msg: b75efc0e-f606-11e3-95bd-42f7ed465ed9 2014-06-17 12:04:06 17673 [Note] WSREP: STATE EXCHANGE: got state msg: b75efc0e-f606-11e3-95bd-42f7ed465ed9 from 0 (percona1) 2014-06-17 12:04:06 17673 [Note] WSREP: STATE EXCHANGE: got state msg: b75efc0e-f606-11e3-95bd-42f7ed465ed9 from 1 (percona2) 2014-06-17 12:04:06 17673 [Note] WSREP: Quorum results: version = 3, component = PRIMARY, conf_id = 1, members = 1/2 (joined/total), act_id = 2, last_appl. = -1, protocols = 0/5/2 (gcs/repl/appl), group UUID = b29d5e17-f231-11e3-8811-c60297db8369 2014-06-17 12:04:06 17673 [Note] WSREP: Flow-control interval: [23, 23] 2014-06-17 12:04:06 17673 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 2) 2014-06-17 12:04:06 17673 [Note] WSREP: State transfer required: Group state: b29d5e17-f231-11e3-8811-c60297db8369:2 Local state: 00000000-0000-0000-0000-000000000000:-1 2014-06-17 12:04:06 17673 [Note] WSREP: New cluster view: global state: b29d5e17-f231-11e3-8811-c60297db8369:2, view# 2: Primary, number of nodes: 2, my index: 1, protocol version 2 2014-06-17 12:04:06 17673 [Warning] WSREP: Gap in state sequence. Need state transfer. 2014-06-17 12:04:08 17673 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '192.168.3.3' --auth 'root:' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '17673' --binlog 'percona2-bin' ' cat: /var/lib/mysql//rsync_sst.pid: No such file or directory 2014-06-17 12:04:08 17673 [Note] WSREP: Prepared SST request: rsync|192.168.3.3:4444/rsync_sst 2014-06-17 12:04:08 17673 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2014-06-17 12:04:08 17673 [Note] WSREP: REPL Protocols: 5 (3, 1) 2014-06-17 12:04:08 17673 [Note] WSREP: Service thread queue flushed. 2014-06-17 12:04:08 17673 [Note] WSREP: Assign initial position for certification: 2, protocol version: 3 2014-06-17 12:04:08 17673 [Note] WSREP: Service thread queue flushed. 2014-06-17 12:04:08 17673 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (b29d5e17-f231-11e3-8811-c60297db8369): 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():447. IST will be unavailable. 2014-06-17 12:04:08 17673 [Note] WSREP: Member 1.0 (percona2) requested state transfer from '*any*'. Selected 0.0 (percona1)(SYNCED) as donor. 2014-06-17 12:04:08 17673 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 2) 2014-06-17 12:04:08 17673 [Note] WSREP: Requesting state transfer: success, donor: 0 2014-06-17 12:04:17 17673 [Note] WSREP: 0.0 (percona1): State transfer to 1.0 (percona2) complete. 2014-06-17 12:04:17 17673 [Note] WSREP: Member 0.0 (percona1) synced with group. WSREP_SST: [INFO] Extracting binlog files: (20140617 12:04:17.436) percona1-bin.000008 ls: cannot access percona2-bin.*: No such file or directory WSREP_SST: [INFO] Joiner cleanup. (20140617 12:04:17.460) WSREP_SST: [INFO] Joiner cleanup done. (20140617 12:04:17.968) 2014-06-17 12:04:17 17673 [Note] WSREP: SST complete, seqno: 2 2014-06-17 12:04:17 17673 [Note] Plugin 'FEDERATED' is disabled. 2014-06-17 12:04:18 7fe71f1c97e0 InnoDB: Warning: Using innodb_locks_unsafe_for_binlog is DEPRECATED. This option may be removed in future releases. Please use READ COMMITTED transaction isolation level instead, see http://dev.mysql.com/doc/refman/5.6/en/set-transaction.html. 2014-06-17 12:04:18 17673 [Note] InnoDB: The InnoDB memory heap is disabled 2014-06-17 12:04:18 17673 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-06-17 12:04:18 17673 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-06-17 12:04:18 17673 [Note] InnoDB: Using Linux native AIO 2014-06-17 12:04:18 17673 [Note] InnoDB: Not using CPU crc32 instructions 2014-06-17 12:04:18 17673 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-06-17 12:04:18 17673 [Note] InnoDB: Completed initialization of buffer pool 2014-06-17 12:04:18 17673 [Note] InnoDB: The first specified data file /srv/mysql/ibdata1 did not exist: a new database to be created! 2014-06-17 12:04:18 17673 [Note] InnoDB: Setting file /srv/mysql/ibdata1 size to 12 MB 2014-06-17 12:04:18 17673 [Note] InnoDB: Database physically writes the file full: wait... 2014-06-17 12:04:18 17673 [Note] InnoDB: Setting log file ./ib_logfile101 size to 64 MB 2014-06-17 12:04:18 17673 [ERROR] InnoDB: Cannot create ./ib_logfile1 2014-06-17 12:04:18 17673 [ERROR] Plugin 'InnoDB' init function returned error. 2014-06-17 12:04:18 17673 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2014-06-17 12:04:18 17673 [ERROR] Unknown/unsupported storage engine: InnoDB 2014-06-17 12:04:18 17673 [ERROR] Aborting 2014-06-17 12:04:20 17673 [Note] WSREP: Closing send monitor... 2014-06-17 12:04:20 17673 [Note] WSREP: Closed send monitor. 2014-06-17 12:04:20 17673 [Note] WSREP: gcomm: terminating thread 2014-06-17 12:04:20 17673 [Note] WSREP: gcomm: joining thread 2014-06-17 12:04:20 17673 [Note] WSREP: gcomm: closing backend 2014-06-17 12:04:21 17673 [Note] WSREP: view(view_id(NON_PRIM,88d25beb-f605-11e3-be57-23c32973460b,2) memb { b701a6c7-f606-11e3-8f0f-6bd26dec2af7,0 } joined { } left { } partitioned { 88d25beb-f605-11e3-be57-23c32973460b,0 }) 2014-06-17 12:04:21 17673 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2014-06-17 12:04:21 17673 [Note] WSREP: view((empty)) 2014-06-17 12:04:21 17673 [Note] WSREP: gcomm: closed 2014-06-17 12:04:21 17673 [Note] WSREP: Flow-control interval: [16, 16] 2014-06-17 12:04:21 17673 [Note] WSREP: Received NON-PRIMARY. 2014-06-17 12:04:21 17673 [Note] WSREP: Shifting JOINER -> OPEN (TO: 2) 2014-06-17 12:04:21 17673 [Note] WSREP: Received self-leave message. 2014-06-17 12:04:21 17673 [Note] WSREP: Flow-control interval: [0, 0] 2014-06-17 12:04:21 17673 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2014-06-17 12:04:21 17673 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 2) 2014-06-17 12:04:21 17673 [Note] WSREP: RECV thread exiting 0: Success 2014-06-17 12:04:21 17673 [Note] WSREP: recv_thread() joined. 2014-06-17 12:04:21 17673 [Note] WSREP: Closing replication queue. 2014-06-17 12:04:21 17673 [Note] WSREP: Closing slave action queue. 2014-06-17 12:04:21 17673 [Note] WSREP: Service disconnected. 2014-06-17 12:04:21 17673 [Note] WSREP: rollbacker thread exiting 2014-06-17 12:04:22 17673 [Note] WSREP: Some threads may fail to exit. 2014-06-17 12:04:22 17673 [Note] Binlog end 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'partition' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'BLACKHOLE' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'ARCHIVE' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_METRICS' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_CMP' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'INNODB_TRX' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'XTRADB_RSEG' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'XTRADB_READ_VIEW' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'CSV' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'MEMORY' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'MRG_MYISAM' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'MyISAM' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'sha256_password' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'mysql_old_password' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'mysql_native_password' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'wsrep' 2014-06-17 12:04:22 17673 [Note] Shutting down plugin 'binlog' 2014-06-17 12:04:22 17673 [Note] /usr/sbin/mysqld: Shutdown complete Error in my_thread_global_end(): 1 threads didn't exit 140617 12:04:27 mysqld_safe mysqld from pid file /var/lib/mysql/percona2.pid ended