2017-08-29 01:52:57 14705 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000018 of size 134217728 byte s 2017-08-29 02:20:45 14705 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000019 of size 134217728 byte s 2017-08-29 02:54:23 14705 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000020 of size 134217728 byte s 2017-08-29 03:40:30 14705 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000021 of size 134217728 byte s 2017-08-29 04:22:29 14705 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000022 of size 134217728 byte s 2017-08-29 06:22:10 14705 [Note] WSREP: 0.0 (Node1): State transfer to 1.0 (Node2) complete. 2017-08-29 06:22:10 14705 [Note] WSREP: Member 0.0 (Node1) synced with group. WSREP_SST: [INFO] Preparing the backup at /var/lib/mysql//.sst (2017-08-29 06:22:10) WSREP_SST: [INFO] Evaluating innobackupex --no-version-check --use-memory=20G --apply-log $rebuildcmd ${DATA} &>${DATA}/innobackup.prepare.log (2017-08-29 06:22:10) 2017-08-29 06:23:06 14705 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000023 of size 134217728 byte s ^C [root@webnx6 projects_data]# tail -f /var/log/mysql/error.log 2017-08-29 01:52:57 14705 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000018 of size 134217728 bytes 2017-08-29 02:20:45 14705 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000019 of size 134217728 bytes 2017-08-29 02:54:23 14705 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000020 of size 134217728 bytes 2017-08-29 03:40:30 14705 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000021 of size 134217728 bytes 2017-08-29 04:22:29 14705 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000022 of size 134217728 bytes 2017-08-29 06:22:10 14705 [Note] WSREP: 0.0 (Node1): State transfer to 1.0 (Node2) complete. 2017-08-29 06:22:10 14705 [Note] WSREP: Member 0.0 (Node1) synced with group. WSREP_SST: [INFO] Preparing the backup at /var/lib/mysql//.sst (2017-08-29 06:22:10) WSREP_SST: [INFO] Evaluating innobackupex --no-version-check --use-memory=20G --apply-log $rebuildcmd ${DATA} &>${DATA}/innobackup.prepare.log (2017-08-29 06:22:10) 2017-08-29 06:23:06 14705 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000023 of size 134217728 bytes 2017-08-29 06:52:56 14705 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000024 of size 134217728 bytes rm: cannot remove ‘/var/lib/mysql//innobackup.prepare.log’: No such file or directory rm: cannot remove ‘/var/lib/mysql//innobackup.move.log’: No such file or directory WSREP_SST: [INFO] Moving the backup to /var/lib/mysql/ (2017-08-29 07:22:23) WSREP_SST: [INFO] Evaluating innobackupex --defaults-file=/etc/my.cnf --defaults-group=mysqld --no-version-check --datadir=/var/lib/mysql/ --move-back --force-non-empty-directories ${DATA} &>${DATA}/innobackup.move.log (2017-08-29 07:22:23) WSREP_SST: [INFO] Move successful, removing /var/lib/mysql//.sst (2017-08-29 07:24:50) WSREP_SST: [INFO] Galera co-ords from recovery: af81d29b-8a9a-11e7-92d4-962488332acf:7167823 (2017-08-29 07:24:51) WSREP_SST: [INFO] Total time on joiner: 0 seconds (2017-08-29 07:24:51) WSREP_SST: [INFO] Removing the sst_in_progress file (2017-08-29 07:24:51) 2017-08-29 07:24:51 14705 [Note] WSREP: SST complete, seqno: 7167823 2017-08-29 07:24:51 14705 [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-08-29 07:24:51 14705 [Note] Plugin 'FEDERATED' is disabled. 2017-08-29 07:24:51 7f5492fd38c0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2017-08-29 07:24:51 7f5492fd38c0 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. 2017-08-29 07:24:51 14705 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-08-29 07:24:51 14705 [Note] InnoDB: The InnoDB memory heap is disabled 2017-08-29 07:24:51 14705 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-08-29 07:24:51 14705 [Note] InnoDB: Memory barrier is not used 2017-08-29 07:24:51 14705 [Note] InnoDB: Compressed tables use zlib 1.2.7 2017-08-29 07:24:51 14705 [Note] InnoDB: Using Linux native AIO 2017-08-29 07:24:51 14705 [Note] InnoDB: Using CPU crc32 instructions 2017-08-29 07:24:51 14705 [Warning] InnoDB: innodb_file_io_threads is deprecated. Please use innodb_read_io_threads and innodb_write_io_threads instead 2017-08-29 07:24:51 14705 [Note] InnoDB: Initializing buffer pool, size = 10.0G 2017-08-29 07:24:52 14705 [Note] InnoDB: Completed initialization of buffer pool 2017-08-29 07:24:52 14705 [Note] InnoDB: Highest supported file format is Barracuda. 2017-08-29 08:00:55 14705 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000025 of size 134217728 bytes 2017-08-29 08:22:33 14705 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000026 of size 134217728 bytes 2017-08-29 09:22:21 14705 [Note] WSREP: Created page /var/lib/mysql/gcache.page.000027 of size 134217728 bytes 2017-08-29 10:06:55 14705 [Note] InnoDB: 128 rollback segment(s) are active. 2017-08-29 10:06:55 14705 [Note] InnoDB: Waiting for purge to start 2017-08-29 10:06:55 14705 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 7347200454611 2017-08-29 10:06:55 14705 [ERROR] Aborting 2017-08-29 10:06:55 14705 [Note] WSREP: Signalling cancellation of the SST request. 2017-08-29 10:06:55 14705 [Note] WSREP: SST request was cancelled 2017-08-29 10:06:55 14705 [Note] WSREP: Closing send monitor... 2017-08-29 10:06:55 14705 [Note] WSREP: Closed send monitor. 2017-08-29 10:06:55 14705 [Note] WSREP: gcomm: terminating thread 2017-08-29 10:06:55 14705 [Note] WSREP: gcomm: joining thread 2017-08-29 10:06:55 14705 [Note] WSREP: gcomm: closing backend 2017-08-29 10:06:57 14705 [Note] WSREP: Service disconnected. 2017-08-29 10:06:57 14705 [Note] WSREP: Waiting to close threads...... 2017-08-29 10:06:57 14705 [Note] WSREP: rollbacker thread exiting 2017-08-29 10:06:59 14705 [Note] WSREP: (b4d4055e, 'tcp://0.0.0.0:4567') connection to peer af813e7a with addr tcp://192.168.11.5:4567 timed out, no messages seen in PT3S 2017-08-29 10:06:59 14705 [Note] WSREP: (b4d4055e, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://192.168.11.5:4567 2017-08-29 10:07:00 14705 [Note] WSREP: (b4d4055e, 'tcp://0.0.0.0:4567') reconnecting to af813e7a (tcp://192.168.11.5:4567), attempt 0 2017-08-29 10:07:01 14705 [Note] WSREP: evs::proto(b4d4055e, LEAVING, view_id(REG,af813e7a,14)) suspecting node: af813e7a 2017-08-29 10:07:01 14705 [Note] WSREP: evs::proto(b4d4055e, LEAVING, view_id(REG,af813e7a,14)) suspected node without join message, declaring inactive 2017-08-29 10:07:01 14705 [Note] WSREP: view(view_id(NON_PRIM,af813e7a,14) memb { b4d4055e,0 } joined { } left { } partitioned { af813e7a,0 }) 2017-08-29 10:07:01 14705 [Note] WSREP: view((empty)) 2017-08-29 10:07:01 14705 [Note] WSREP: gcomm: closed 2017-08-29 10:07:01 14705 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2017-08-29 10:07:01 14705 [Note] WSREP: Flow-control interval: [16, 16] 2017-08-29 10:07:01 14705 [Note] WSREP: Received NON-PRIMARY. 2017-08-29 10:07:01 14705 [Note] WSREP: Shifting JOINER -> OPEN (TO: 7252706) 2017-08-29 10:07:01 14705 [Note] WSREP: Received self-leave message. 2017-08-29 10:07:01 14705 [Note] WSREP: Flow-control interval: [0, 0] 2017-08-29 10:07:01 14705 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2017-08-29 10:07:01 14705 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 7252706) 2017-08-29 10:07:01 14705 [Note] WSREP: RECV thread exiting 0: Success 2017-08-29 10:07:01 14705 [Note] WSREP: recv_thread() joined. 2017-08-29 10:07:01 14705 [Note] WSREP: Closing replication queue. 2017-08-29 10:07:01 14705 [Note] WSREP: Closing slave action queue. 2017-08-29 10:07:02 14705 [Note] WSREP: Some threads may fail to exit. 2017-08-29 10:07:02 14705 [Note] Binlog end 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'partition' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'BLACKHOLE' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'ARCHIVE' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_METRICS' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_CMPMEM' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_CMP' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_LOCKS' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'INNODB_TRX' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'XTRADB_ZIP_DICT' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'XTRADB_RSEG' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'XTRADB_READ_VIEW' 2017-08-29 10:07:02 14705 [Note] Shutting down plugin 'InnoDB' 2017-08-29 10:07:02 14705 [Note] InnoDB: FTS optimize thread exiting. 2017-08-29 10:07:02 14705 [Note] InnoDB: Starting shutdown... 2017-08-29 10:07:03 14705 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2017-08-29 10:07:07 14705 [Note] InnoDB: Shutdown completed; log sequence number 7347200454621 2017-08-29 10:07:07 14705 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2017-08-29 10:07:07 14705 [Note] Shutting down plugin 'CSV' 2017-08-29 10:07:07 14705 [Note] Shutting down plugin 'MyISAM' 2017-08-29 10:07:07 14705 [Note] Shutting down plugin 'MRG_MYISAM' 2017-08-29 10:07:07 14705 [Note] Shutting down plugin 'MEMORY' 2017-08-29 10:07:07 14705 [Note] Shutting down plugin 'sha256_password' 2017-08-29 10:07:07 14705 [Note] Shutting down plugin 'mysql_old_password' 2017-08-29 10:07:07 14705 [Note] Shutting down plugin 'mysql_native_password' 2017-08-29 10:07:07 14705 [Note] Shutting down plugin 'wsrep' 2017-08-29 10:07:07 14705 [Note] Shutting down plugin 'binlog' 2017-08-29 10:07:07 14705 [Note] Error in my_thread_global_end(): 1 threads didn't exit