140421 14:34:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-21 14:34:22 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-21 14:34:22 7976 [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. 2014-04-21 14:34:22 7976 [Note] Plugin 'FEDERATED' is disabled. 2014-04-21 14:34:22 7976 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-04-21 14:34:22 7976 [Note] InnoDB: The InnoDB memory heap is disabled 2014-04-21 14:34:22 7976 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-04-21 14:34:22 7976 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-04-21 14:34:22 7976 [Note] InnoDB: Using Linux native AIO 2014-04-21 14:34:22 7976 [Note] InnoDB: Using CPU crc32 instructions 2014-04-21 14:34:22 7976 [Note] InnoDB: Initializing buffer pool, size = 28.0G 2014-04-21 14:34:23 7976 [Note] InnoDB: Completed initialization of buffer pool 2014-04-21 14:34:24 7976 [Note] InnoDB: Highest supported file format is Barracuda. 2014-04-21 14:34:24 7976 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*4096 pages, LSN=1625997 2014-04-21 14:34:24 7976 [Warning] InnoDB: Starting to delete and rewrite log files. 2014-04-21 14:34:24 7976 [Note] InnoDB: Setting log file ./ib_logfile101 size to 64 MB 2014-04-21 14:34:24 7976 [Note] InnoDB: Setting log file ./ib_logfile1 size to 64 MB 2014-04-21 14:34:24 7976 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2014-04-21 14:34:24 7976 [Warning] InnoDB: New log files created, LSN=1625997 2014-04-21 14:34:24 7976 [Note] InnoDB: 128 rollback segment(s) are active. 2014-04-21 14:34:24 7976 [Note] InnoDB: Waiting for purge to start 2014-04-21 14:34:25 7976 [Note] InnoDB: 5.6.17 started; log sequence number 1625997 2014-04-21 14:34:25 7976 [Note] Server hostname (bind-address): '*'; port: 3306 2014-04-21 14:34:25 7976 [Note] IPv6 is available. 2014-04-21 14:34:25 7976 [Note] - '::' resolves to '::'; 2014-04-21 14:34:25 7976 [Note] Server socket created on IP: '::'. 2014-04-21 14:34:25 7976 [Warning] 'proxies_priv' entry '@ root@slavesrv1' ignored in --skip-name-resolve mode. 2014-04-21 14:34:25 7976 [Note] Event Scheduler: Loaded 0 events 2014-04-21 14:34:25 7976 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2014-04-22 12:39:04 7976 [Note] /usr/sbin/mysqld: Normal shutdown 2014-04-22 12:39:04 7976 [Note] Giving 0 client threads a chance to die gracefully 2014-04-22 12:39:04 7976 [Note] Event Scheduler: Purging the queue. 0 events 2014-04-22 12:39:04 7976 [Note] Shutting down slave threads 2014-04-22 12:39:04 7976 [Note] Forcefully disconnecting 0 remaining clients 2014-04-22 12:39:04 7976 [Note] Binlog end 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'partition' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'BLACKHOLE' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'ARCHIVE' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_METRICS' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_CMP' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'INNODB_TRX' 2014-04-22 12:39:04 7976 [Note] Shutting down plugin 'InnoDB' 2014-04-22 12:39:04 7976 [Note] InnoDB: FTS optimize thread exiting. 2014-04-22 12:39:04 7976 [Note] InnoDB: Starting shutdown... 2014-04-22 12:39:07 7976 [Note] InnoDB: Shutdown completed; log sequence number 3211960059 2014-04-22 12:39:07 7976 [Note] Shutting down plugin 'MyISAM' 2014-04-22 12:39:07 7976 [Note] Shutting down plugin 'MRG_MYISAM' 2014-04-22 12:39:07 7976 [Note] Shutting down plugin 'CSV' 2014-04-22 12:39:07 7976 [Note] Shutting down plugin 'MEMORY' 2014-04-22 12:39:07 7976 [Note] Shutting down plugin 'sha256_password' 2014-04-22 12:39:07 7976 [Note] Shutting down plugin 'mysql_old_password' 2014-04-22 12:39:07 7976 [Note] Shutting down plugin 'mysql_native_password' 2014-04-22 12:39:07 7976 [Note] Shutting down plugin 'binlog' 2014-04-22 12:39:07 7976 [Note] /usr/sbin/mysqld: Shutdown complete 140422 12:39:07 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140422 12:39:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-22 12:39:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-22 12:39:08 11103 [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. 2014-04-22 12:39:08 11103 [Note] Plugin 'FEDERATED' is disabled. 2014-04-22 12:39:08 11103 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-04-22 12:39:08 11103 [Note] InnoDB: The InnoDB memory heap is disabled 2014-04-22 12:39:08 11103 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-04-22 12:39:08 11103 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-04-22 12:39:08 11103 [Note] InnoDB: Using Linux native AIO 2014-04-22 12:39:08 11103 [Note] InnoDB: Using CPU crc32 instructions 2014-04-22 12:39:08 11103 [Note] InnoDB: Initializing buffer pool, size = 28.0G 2014-04-22 12:39:10 11103 [Note] InnoDB: Completed initialization of buffer pool 2014-04-22 12:39:10 11103 [Note] InnoDB: Highest supported file format is Barracuda. 2014-04-22 12:39:10 11103 [Note] InnoDB: 128 rollback segment(s) are active. 2014-04-22 12:39:10 11103 [Note] InnoDB: Waiting for purge to start 2014-04-22 12:39:10 11103 [Note] InnoDB: 5.6.17 started; log sequence number 3211960059 2014-04-22 12:39:11 11103 [Note] Server hostname (bind-address): '*'; port: 3306 2014-04-22 12:39:11 11103 [Note] IPv6 is available. 2014-04-22 12:39:11 11103 [Note] - '::' resolves to '::'; 2014-04-22 12:39:11 11103 [Note] Server socket created on IP: '::'. 2014-04-22 12:39:11 11103 [Warning] 'proxies_priv' entry '@ root@xxxx' ignored in --skip-name-resolve mode. 2014-04-22 12:39:11 11103 [Note] Event Scheduler: Loaded 0 events 2014-04-22 12:39:11 11103 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2014-04-22 12:52:42 11103 [Warning] Did not write failed 'grant all on vesti_db.* to 'vesti_user'@'xxxx'' into binary log while granting/revoking privileges in databases. 2014-04-22 12:54:15 11103 [Warning] Did not write failed 'grant all on vesti_db.* to 'vesti_user'@'xxxx'' into binary log while granting/revoking privileges in databases. 2014-04-22 12:57:08 11103 [Warning] 'proxies_priv' entry '@ root@xxxx' ignored in --skip-name-resolve mode. 2014-04-22 13:33:16 11103 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='xxxx', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. 2014-04-22 13:33:29 11103 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2014-04-22 13:33:29 11103 [Note] Slave I/O thread: connected to master 'repl@xxxx:3306',replication started in log 'FIRST' at position 4 2014-04-22 13:33:29 11103 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/lib/mysql/data/mysql-relay-bin.000001' position: 4 2014-04-22 13:45:55 11103 [Warning] 'proxies_priv' entry '@ root@xxxx' ignored in --skip-name-resolve mode. 2014-04-22 13:49:34 11103 [Warning] 'proxies_priv' entry '@ root@xxxx' ignored in --skip-name-resolve mode. 2014-04-22 13:49:34 11103 [Warning] 'proxies_priv' entry '@ root@xxxx' ignored in --skip-name-resolve mode. 2014-04-22 13:58:32 11103 [Warning] 'proxies_priv' entry '@ root@xxxx' ignored in --skip-name-resolve mode. 2014-04-23 12:28:24 11103 [Note] Slave: received end packet from server, apparent master shutdown: 2014-04-23 12:28:24 11103 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000019' at position 1018261722 2014-04-23 12:28:24 11103 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2014-04-23 12:28:24 11103 [ERROR] Slave I/O: error reconnecting to master 'repl@xxxx:3306' - retry-time: 60 retries: 1, Error_code: 2003 2014-04-23 12:29:24 11103 [Note] Slave: connected to master 'repl@xxxx:3306',replication resumed in log 'mysql-bin.000019' at position 1018261722 2014-04-23 12:29:37 11103 [Note] /usr/sbin/mysqld: Normal shutdown 2014-04-23 12:29:37 11103 [Note] Giving 2 client threads a chance to die gracefully 2014-04-23 12:29:37 11103 [Note] Event Scheduler: Purging the queue. 0 events 2014-04-23 12:29:37 11103 [Note] Shutting down slave threads 2014-04-23 12:29:37 11103 [Note] Error reading relay log event: slave SQL thread was killed 2014-04-23 12:29:37 11103 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2014-04-23 12:29:37 11103 [Note] Slave I/O thread killed while reading event 2014-04-23 12:29:37 11103 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000020', position 16182656 2014-04-23 12:29:37 11103 [Note] Forcefully disconnecting 0 remaining clients 2014-04-23 12:29:37 11103 [Note] Binlog end 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'partition' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'BLACKHOLE' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'ARCHIVE' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_METRICS' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_CMP' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'INNODB_TRX' 2014-04-23 12:29:37 11103 [Note] Shutting down plugin 'InnoDB' 2014-04-23 12:29:37 11103 [Note] InnoDB: FTS optimize thread exiting. 2014-04-23 12:29:37 11103 [Note] InnoDB: Starting shutdown... 2014-04-23 12:29:40 11103 [Note] InnoDB: Shutdown completed; log sequence number 17341844738 2014-04-23 12:29:40 11103 [Note] Shutting down plugin 'MyISAM' 2014-04-23 12:29:40 11103 [Note] Shutting down plugin 'MRG_MYISAM' 2014-04-23 12:29:40 11103 [Note] Shutting down plugin 'CSV' 2014-04-23 12:29:40 11103 [Note] Shutting down plugin 'MEMORY' 2014-04-23 12:29:40 11103 [Note] Shutting down plugin 'sha256_password' 2014-04-23 12:29:40 11103 [Note] Shutting down plugin 'mysql_old_password' 2014-04-23 12:29:40 11103 [Note] Shutting down plugin 'mysql_native_password' 2014-04-23 12:29:40 11103 [Note] Shutting down plugin 'binlog' 2014-04-23 12:29:40 11103 [Note] /usr/sbin/mysqld: Shutdown complete 140423 12:29:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140423 12:29:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-23 12:29:43 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-23 12:29:43 14720 [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. 2014-04-23 12:29:43 14720 [Note] Plugin 'FEDERATED' is disabled. 2014-04-23 12:29:43 14720 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-04-23 12:29:43 14720 [Note] InnoDB: The InnoDB memory heap is disabled 2014-04-23 12:29:43 14720 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-04-23 12:29:43 14720 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-04-23 12:29:43 14720 [Note] InnoDB: Using Linux native AIO 2014-04-23 12:29:43 14720 [Note] InnoDB: Using CPU crc32 instructions 2014-04-23 12:29:43 14720 [Note] InnoDB: Initializing buffer pool, size = 28.0G 2014-04-23 12:29:45 14720 [Note] InnoDB: Completed initialization of buffer pool 2014-04-23 12:29:45 14720 [Note] InnoDB: Highest supported file format is Barracuda. 2014-04-23 12:29:46 14720 [Note] InnoDB: 128 rollback segment(s) are active. 2014-04-23 12:29:46 14720 [Note] InnoDB: Waiting for purge to start 2014-04-23 12:29:46 14720 [Note] InnoDB: 5.6.17 started; log sequence number 17341844738 2014-04-23 12:29:47 14720 [Note] Server hostname (bind-address): '*'; port: 3306 2014-04-23 12:29:47 14720 [Note] IPv6 is available. 2014-04-23 12:29:47 14720 [Note] - '::' resolves to '::'; 2014-04-23 12:29:47 14720 [Note] Server socket created on IP: '::'. 2014-04-23 12:29:47 14720 [Warning] 'proxies_priv' entry '@ root@xxxx' ignored in --skip-name-resolve mode. 2014-04-23 12:29:47 14720 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2014-04-23 12:29:47 14720 [Note] Slave I/O thread: connected to master 'repl@xxxx:3306',replication started in log 'mysql-bin.000020' at position 16182656 2014-04-23 12:29:47 14720 [Note] Event Scheduler: Loaded 0 events 2014-04-23 12:29:47 14720 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2014-04-23 12:29:47 14720 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000020' at position 16182656, relay log '/var/lib/mysql/data/mysql-relay-bin.000055' position: 16182866 2014-04-23 14:12:16 14720 [Note] /usr/sbin/mysqld: Normal shutdown 2014-04-23 14:12:16 14720 [Note] Giving 6 client threads a chance to die gracefully 2014-04-23 14:12:16 14720 [Note] Event Scheduler: Purging the queue. 0 events 2014-04-23 14:12:16 14720 [Note] Shutting down slave threads 2014-04-23 14:12:16 14720 [Note] Error reading relay log event: slave SQL thread was killed 2014-04-23 14:12:16 14720 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2014-04-23 14:12:16 14720 [Note] Slave I/O thread killed while reading event 2014-04-23 14:12:16 14720 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000021', position 496350654 2014-04-23 14:12:18 14720 [Note] Forcefully disconnecting 3 remaining clients 2014-04-23 14:12:18 14720 [Warning] /usr/sbin/mysqld: Forcing close of thread 1980 user: 'shahriyar_r' 2014-04-23 14:12:18 14720 [Warning] /usr/sbin/mysqld: Forcing close of thread 1983 user: 'shahriyar_r' 2014-04-23 14:12:18 14720 [Warning] /usr/sbin/mysqld: Forcing close of thread 2314 user: 'shahriyar_r' 2014-04-23 14:12:18 14720 [Note] Binlog end 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'partition' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'BLACKHOLE' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'ARCHIVE' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_METRICS' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_CMP' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'INNODB_TRX' 2014-04-23 14:12:18 14720 [Note] Shutting down plugin 'InnoDB' 2014-04-23 14:12:18 14720 [Note] InnoDB: FTS optimize thread exiting. 2014-04-23 14:12:18 14720 [Note] InnoDB: Starting shutdown... 2014-04-23 14:12:22 14720 [Note] InnoDB: Shutdown completed; log sequence number 18718254094 2014-04-23 14:12:22 14720 [Note] Shutting down plugin 'MyISAM' 2014-04-23 14:12:22 14720 [Note] Shutting down plugin 'MRG_MYISAM' 2014-04-23 14:12:22 14720 [Note] Shutting down plugin 'CSV' 2014-04-23 14:12:22 14720 [Note] Shutting down plugin 'MEMORY' 2014-04-23 14:12:22 14720 [Note] Shutting down plugin 'sha256_password' 2014-04-23 14:12:22 14720 [Note] Shutting down plugin 'mysql_old_password' 2014-04-23 14:12:22 14720 [Note] Shutting down plugin 'mysql_native_password' 2014-04-23 14:12:22 14720 [Note] Shutting down plugin 'binlog' 2014-04-23 14:12:22 14720 [Note] /usr/sbin/mysqld: Shutdown complete 140423 14:12:22 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140423 14:12:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-23 14:12:25 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-23 14:12:25 15923 [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. 2014-04-23 14:12:25 15923 [Note] Plugin 'FEDERATED' is disabled. 2014-04-23 14:12:25 15923 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-04-23 14:12:25 15923 [Note] InnoDB: The InnoDB memory heap is disabled 2014-04-23 14:12:25 15923 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-04-23 14:12:25 15923 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-04-23 14:12:25 15923 [Note] InnoDB: Using Linux native AIO 2014-04-23 14:12:25 15923 [Note] InnoDB: Using CPU crc32 instructions 2014-04-23 14:12:25 15923 [Note] InnoDB: Initializing buffer pool, size = 28.0G 2014-04-23 14:12:26 15923 [Note] InnoDB: Completed initialization of buffer pool 2014-04-23 14:12:27 15923 [Note] InnoDB: Highest supported file format is Barracuda. 2014-04-23 14:12:27 15923 [Note] InnoDB: 128 rollback segment(s) are active. 2014-04-23 14:12:27 15923 [Note] InnoDB: Waiting for purge to start 2014-04-23 14:12:27 15923 [Note] InnoDB: 5.6.17 started; log sequence number 18718254094 2014-04-23 14:12:28 15923 [Note] Server hostname (bind-address): '*'; port: 3306 2014-04-23 14:12:28 15923 [Note] IPv6 is available. 2014-04-23 14:12:28 15923 [Note] - '::' resolves to '::'; 2014-04-23 14:12:28 15923 [Note] Server socket created on IP: '::'. 2014-04-23 14:12:28 15923 [Warning] 'proxies_priv' entry '@ root@xxxx' ignored in --skip-name-resolve mode. 2014-04-23 14:12:30 15923 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2014-04-23 14:12:30 15923 [Note] Slave I/O thread: connected to master 'repl@xxxx:3306',replication started in log 'mysql-bin.000021' at position 496350654 2014-04-23 14:12:30 15923 [Note] Event Scheduler: Loaded 0 events 2014-04-23 14:12:30 15923 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2014-04-23 14:12:30 15923 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000021' at position 496350654, relay log '/var/lib/mysql/data/mysql-relay-bin.000059' position: 496350864 2014-04-23 14:36:15 15923 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.000021' at position 564721983 2014-04-23 14:36:15 15923 [Note] /usr/sbin/mysqld: Normal shutdown 2014-04-23 14:36:15 15923 [Note] Giving 6 client threads a chance to die gracefully 2014-04-23 14:36:15 15923 [Note] Event Scheduler: Purging the queue. 0 events 2014-04-23 14:36:15 15923 [Note] Shutting down slave threads 2014-04-23 14:36:15 15923 [Note] Slave I/O thread killed while reading event 2014-04-23 14:36:15 15923 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000021', position 884083624 2014-04-23 14:36:17 15923 [Note] Forcefully disconnecting 2 remaining clients 2014-04-23 14:36:17 15923 [Warning] /usr/sbin/mysqld: Forcing close of thread 605 user: 'shahriyar_r' 2014-04-23 14:36:17 15923 [Warning] /usr/sbin/mysqld: Forcing close of thread 606 user: 'shahriyar_r' 2014-04-23 14:36:17 15923 [Note] Binlog end 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'partition' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'BLACKHOLE' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'ARCHIVE' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_METRICS' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_CMP' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'INNODB_TRX' 2014-04-23 14:36:17 15923 [Note] Shutting down plugin 'InnoDB' 2014-04-23 14:36:17 15923 [Note] InnoDB: FTS optimize thread exiting. 2014-04-23 14:36:17 15923 [Note] InnoDB: Starting shutdown... 2014-04-23 14:36:19 15923 [Note] InnoDB: Shutdown completed; log sequence number 18779838534 2014-04-23 14:36:19 15923 [Note] Shutting down plugin 'MyISAM' 2014-04-23 14:36:19 15923 [Note] Shutting down plugin 'MRG_MYISAM' 2014-04-23 14:36:19 15923 [Note] Shutting down plugin 'CSV' 2014-04-23 14:36:19 15923 [Note] Shutting down plugin 'MEMORY' 2014-04-23 14:36:19 15923 [Note] Shutting down plugin 'sha256_password' 2014-04-23 14:36:19 15923 [Note] Shutting down plugin 'mysql_old_password' 2014-04-23 14:36:19 15923 [Note] Shutting down plugin 'mysql_native_password' 2014-04-23 14:36:19 15923 [Note] Shutting down plugin 'binlog' 2014-04-23 14:36:19 15923 [Note] /usr/sbin/mysqld: Shutdown complete 140423 14:36:19 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140423 14:36:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-23 14:36:22 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-23 14:36:22 16970 [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. 2014-04-23 14:36:22 16970 [Note] Plugin 'FEDERATED' is disabled. 2014-04-23 14:36:22 16970 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-04-23 14:36:22 16970 [Note] InnoDB: The InnoDB memory heap is disabled 2014-04-23 14:36:22 16970 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-04-23 14:36:22 16970 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-04-23 14:36:22 16970 [Note] InnoDB: Using Linux native AIO 2014-04-23 14:36:22 16970 [Note] InnoDB: Using CPU crc32 instructions 2014-04-23 14:36:22 16970 [Note] InnoDB: Initializing buffer pool, size = 28.0G 2014-04-23 14:36:24 16970 [Note] InnoDB: Completed initialization of buffer pool 2014-04-23 14:36:24 16970 [Note] InnoDB: Highest supported file format is Barracuda. 2014-04-23 14:36:24 16970 [Note] InnoDB: 128 rollback segment(s) are active. 2014-04-23 14:36:24 16970 [Note] InnoDB: Waiting for purge to start 2014-04-23 14:36:24 16970 [Note] InnoDB: 5.6.17 started; log sequence number 18779838534 2014-04-23 14:36:25 16970 [Note] Server hostname (bind-address): '*'; port: 3306 2014-04-23 14:36:25 16970 [Note] IPv6 is available. 2014-04-23 14:36:25 16970 [Note] - '::' resolves to '::'; 2014-04-23 14:36:25 16970 [Note] Server socket created on IP: '::'. 2014-04-23 14:36:25 16970 [Warning] 'proxies_priv' entry '@ root@xxxx' ignored in --skip-name-resolve mode. 2014-04-23 14:36:26 16970 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2014-04-23 14:36:26 16970 [Note] Slave I/O thread: connected to master 'repl@xxxx:3306',replication started in log 'mysql-bin.000021' at position 884083624 2014-04-23 14:36:26 16970 [Note] Event Scheduler: Loaded 0 events 2014-04-23 14:36:26 16970 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2014-04-23 14:36:26 16970 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000021' at position 564721983, relay log '/var/lib/mysql/data/mysql-relay-bin.000061' position: 68371777 2014-04-24 11:05:03 16970 [Note] /usr/sbin/mysqld: Normal shutdown 2014-04-24 11:05:03 16970 [Note] Giving 7 client threads a chance to die gracefully 2014-04-24 11:05:03 16970 [Note] Event Scheduler: Purging the queue. 0 events 2014-04-24 11:05:03 16970 [Note] Shutting down slave threads 2014-04-24 11:05:03 16970 [Note] Error reading relay log event: slave SQL thread was killed 2014-04-24 11:05:03 16970 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) 2014-04-24 11:05:03 16970 [Note] Slave I/O thread killed while reading event 2014-04-24 11:05:03 16970 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000032', position 601356330 2014-04-24 11:05:05 16970 [Note] Forcefully disconnecting 4 remaining clients 2014-04-24 11:05:05 16970 [Warning] /usr/sbin/mysqld: Forcing close of thread 451872 user: 'shahriyar_r' 2014-04-24 11:05:05 16970 [Warning] /usr/sbin/mysqld: Forcing close of thread 452183 user: 'shahriyar_r' 2014-04-24 11:05:05 16970 [Warning] /usr/sbin/mysqld: Forcing close of thread 452181 user: 'shahriyar_r' 2014-04-24 11:05:05 16970 [Warning] /usr/sbin/mysqld: Forcing close of thread 451874 user: 'shahriyar_r' 2014-04-24 11:05:05 16970 [Note] Binlog end 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'partition' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'BLACKHOLE' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'ARCHIVE' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_METRICS' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_CMP' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'INNODB_TRX' 2014-04-24 11:05:05 16970 [Note] Shutting down plugin 'InnoDB' 2014-04-24 11:05:05 16970 [Note] InnoDB: FTS optimize thread exiting. 2014-04-24 11:05:05 16970 [Note] InnoDB: Starting shutdown... 2014-04-24 11:05:11 16970 [Note] InnoDB: Shutdown completed; log sequence number 26594581567 2014-04-24 11:05:11 16970 [Note] Shutting down plugin 'MyISAM' 2014-04-24 11:05:11 16970 [Note] Shutting down plugin 'MRG_MYISAM' 2014-04-24 11:05:11 16970 [Note] Shutting down plugin 'CSV' 2014-04-24 11:05:11 16970 [Note] Shutting down plugin 'MEMORY' 2014-04-24 11:05:11 16970 [Note] Shutting down plugin 'sha256_password' 2014-04-24 11:05:11 16970 [Note] Shutting down plugin 'mysql_old_password' 2014-04-24 11:05:11 16970 [Note] Shutting down plugin 'mysql_native_password' 2014-04-24 11:05:11 16970 [Note] Shutting down plugin 'binlog' 2014-04-24 11:05:11 16970 [Note] /usr/sbin/mysqld: Shutdown complete 140424 11:05:11 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140424 11:05:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-24 11:05:13 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-24 11:05:13 19994 [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. 2014-04-24 11:05:13 19994 [Note] Plugin 'FEDERATED' is disabled. 2014-04-24 11:05:13 19994 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-04-24 11:05:13 19994 [Note] InnoDB: The InnoDB memory heap is disabled 2014-04-24 11:05:13 19994 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-04-24 11:05:13 19994 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-04-24 11:05:13 19994 [Note] InnoDB: Using Linux native AIO 2014-04-24 11:05:13 19994 [Note] InnoDB: Using CPU crc32 instructions 2014-04-24 11:05:13 19994 [Note] InnoDB: Initializing buffer pool, size = 28.0G 2014-04-24 11:05:15 19994 [Note] InnoDB: Completed initialization of buffer pool 2014-04-24 11:05:15 19994 [Note] InnoDB: Highest supported file format is Barracuda. 2014-04-24 11:05:16 19994 [Note] InnoDB: 128 rollback segment(s) are active. 2014-04-24 11:05:16 19994 [Note] InnoDB: Waiting for purge to start 2014-04-24 11:05:16 19994 [Note] InnoDB: 5.6.17 started; log sequence number 26594581567 2014-04-24 11:05:16 19994 [Note] Server hostname (bind-address): '*'; port: 3306 2014-04-24 11:05:16 19994 [Note] IPv6 is available. 2014-04-24 11:05:16 19994 [Note] - '::' resolves to '::'; 2014-04-24 11:05:16 19994 [Note] Server socket created on IP: '::'. 2014-04-24 11:05:16 19994 [Warning] 'proxies_priv' entry '@ root@xxxx' ignored in --skip-name-resolve mode. 2014-04-24 11:05:17 19994 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2014-04-24 11:05:17 19994 [Note] Slave I/O thread: connected to master 'repl@xxxx:3306',replication started in log 'mysql-bin.000032' at position 601356330 2014-04-24 11:05:17 19994 [Note] Event Scheduler: Loaded 0 events 2014-04-24 11:05:17 19994 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2014-04-24 11:05:17 19994 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000032' at position 601356330, relay log '/var/lib/mysql/data/mysql-relay-bin.000095' position: 601356540 2014-04-24 14:39:17 19994 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_4e1a_1.MYI'; try to repair it 2014-04-24 14:39:17 19994 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:40:02 19994 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_4e1a_0.MYI'; try to repair it 2014-04-24 14:40:02 19994 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:40:37 19994 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_4e1a_0.MYI'; try to repair it 2014-04-24 14:40:37 19994 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:40:37 19994 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_4e1a_1.MYI'; try to repair it 2014-04-24 14:40:37 19994 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql140424 14:42:40 mysqld_safe Number of processes running now: 0 140424 14:42:40 mysqld_safe mysqld restarted 2014-04-24 14:42:41 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-24 14:42:41 20672 [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. 2014-04-24 14:42:41 20672 [Note] Plugin 'FEDERATED' is disabled. 2014-04-24 14:42:41 20672 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-04-24 14:42:41 20672 [Note] InnoDB: The InnoDB memory heap is disabled 2014-04-24 14:42:41 20672 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-04-24 14:42:41 20672 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-04-24 14:42:41 20672 [Note] InnoDB: Using Linux native AIO 2014-04-24 14:42:41 20672 [Note] InnoDB: Using CPU crc32 instructions 2014-04-24 14:42:41 20672 [Note] InnoDB: Initializing buffer pool, size = 28.0G 2014-04-24 14:42:43 20672 [Note] InnoDB: Completed initialization of buffer pool 2014-04-24 14:42:43 20672 [Note] InnoDB: Highest supported file format is Barracuda. 2014-04-24 14:42:43 20672 [Note] InnoDB: Log scan progressed past the checkpoint lsn 29009893269 2014-04-24 14:42:43 20672 [Note] InnoDB: Database was not shutdown normally! 2014-04-24 14:42:43 20672 [Note] InnoDB: Starting crash recovery. 2014-04-24 14:42:43 20672 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-04-24 14:42:43 20672 [Note] InnoDB: Restoring possible half-written data pages 2014-04-24 14:42:43 20672 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 29010540952 InnoDB: Transaction 45255576 was in the XA prepared state. InnoDB: 1 transaction(s) which must be rolled back or cleaned up InnoDB: in total 0 row operations to undo InnoDB: Trx id counter is 45255936 2014-04-24 14:42:44 20672 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 7669199, file name mysql-bin.000044 2014-04-24 14:42:45 20672 [Note] InnoDB: 128 rollback segment(s) are active. InnoDB: Starting in background the rollback of uncommitted transactions 2014-04-24 14:42:45 7f9b4845c700 InnoDB: Rollback of non-prepared transactions completed 2014-04-24 14:42:45 20672 [Note] InnoDB: Waiting for purge to start 2014-04-24 14:42:45 20672 [Note] InnoDB: 5.6.17 started; log sequence number 29010540952 2014-04-24 14:42:45 20672 [Note] Recovering after a crash using /var/lib/mysql/data/mysql-bin 2014-04-24 14:42:45 20672 [ERROR] Error in Log_event::read_log_event(): 'read error', data_len: 8214, event_type: 31 2014-04-24 14:42:45 20672 [Note] Starting crash recovery... 2014-04-24 14:42:45 7fa347abd720 InnoDB: Starting recovery for XA transactions... 2014-04-24 14:42:45 7fa347abd720 InnoDB: Transaction 45255576 in prepared state after recovery 2014-04-24 14:42:45 7fa347abd720 InnoDB: Transaction contains changes to 4287 rows 2014-04-24 14:42:45 7fa347abd720 InnoDB: 1 transactions in prepared state after recovery 2014-04-24 14:42:45 20672 [Note] Found 1 prepared transaction(s) in InnoDB 2014-04-24 14:42:45 20672 [Note] Crash recovery finished. 2014-04-24 14:42:45 20672 [Note] Crashed binlog file /var/lib/mysql/data/mysql-bin.000044 size is 7725056, but recovered up to 7669199. Binlog trimmed to 7669199 bytes. 2014-04-24 14:42:45 20672 [Note] Server hostname (bind-address): '*'; port: 3306 2014-04-24 14:42:45 20672 [Note] IPv6 is available. 2014-04-24 14:42:45 20672 [Note] - '::' resolves to '::'; 2014-04-24 14:42:45 20672 [Note] Server socket created on IP: '::'. 2014-04-24 14:42:45 20672 [Warning] 'proxies_priv' entry '@ root@xxxx' ignored in --skip-name-resolve mode. 2014-04-24 14:42:47 20672 [ERROR] Error in Log_event::read_log_event(): 'read error', data_len: 2070, event_type: 29 2014-04-24 14:42:47 20672 [Warning] Error reading GTIDs from binary log: -1 2014-04-24 14:42:47 20672 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2014-04-24 14:42:47 20672 [Note] Slave I/O thread: connected to master 'repl@xxxx:3306',replication started in log 'mysql-bin.000035' at position 608489949 2014-04-24 14:42:47 20672 [Note] Event Scheduler: Loaded 0 events 2014-04-24 14:42:47 20672 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2014-04-24 14:42:47 20672 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000035' at position 615130896, relay log '/var/lib/mysql/data/mysql-relay-bin.000105' position: 615131106 2014-04-24 14:42:47 20672 [Warning] Disk is full writing '/var/lib/mysql/data/mysql-bin.000045' (Errcode: 28 - No space left on device). Waiting for someone to free space... 2014-04-24 14:42:47 20672 [Warning] Retry in 60 secs. Message reprinted in 600 secs 2014-04-24 14:42:47 20672 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50c0_2.MYI'; try to repair it 2014-04-24 14:42:47 20672 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:42:47 20672 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50c0_3.MYI'; try to repair it 2014-04-24 14:42:47 20672 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:42:47 20672 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50c0_2.MYI'; try to repair it 2014-04-24 14:42:47 20672 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:42:47 20672 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50c0_3.MYI'; try to repair it 2014-04-24 14:42:47 20672 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:42:47 20672 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50c0_0.MYI'; try to repair it 2014-04-24 14:42:47 20672 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:42:48 20672 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50c0_1.MYI'; try to repair it 2014-04-24 14:42:48 20672 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:42:48 20672 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50c0_0.MYI'; try to repair it 2014-04-24 14:42:48 20672 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:42:49 20672 [Warning] Disk is full writing '/var/lib/mysql/data/mysql-relay-bin.000107' (Errcode: 28 - No space left on device). Waiting for someone to free space... 2014-04-24 14:42:49 20672 [Warning] Retry in 60 secs. Message reprinted in 600 secs 09:42:50 UTC - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely w140424 14:42:50 mysqld_safe Number of processes running now: 0 140424 14:42:50 mysqld_safe mysqld restarted 2014-04-24 14:42:51 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-24 14:42:51 20720 [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. 2014-04-24 14:42:51 20720 [Note] Plugin 'FEDERATED' is disabled. 2014-04-24 14:42:51 20720 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-04-24 14:42:51 20720 [Note] InnoDB: The InnoDB memory heap is disabled 2014-04-24 14:42:51 20720 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-04-24 14:42:51 20720 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-04-24 14:42:51 20720 [Note] InnoDB: Using Linux native AIO 2014-04-24 14:42:51 20720 [Note] InnoDB: Using CPU crc32 instructions 2014-04-24 14:42:51 20720 [Note] InnoDB: Initializing buffer pool, size = 28.0G 2014-04-24 14:42:53 20720 [Note] InnoDB: Completed initialization of buffer pool 2014-04-24 14:42:53 20720 [Note] InnoDB: Highest supported file format is Barracuda. 2014-04-24 14:42:53 20720 [Note] InnoDB: Log scan progressed past the checkpoint lsn 29009893269 2014-04-24 14:42:53 20720 [Note] InnoDB: Database was not shutdown normally! 2014-04-24 14:42:53 20720 [Note] InnoDB: Starting crash recovery. 2014-04-24 14:42:53 20720 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-04-24 14:42:53 20720 [Note] InnoDB: Restoring possible half-written data pages 2014-04-24 14:42:53 20720 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 29011531048 InnoDB: Transaction 45255957 was in the XA prepared state. InnoDB: 1 transaction(s) which must be rolled back or cleaned up InnoDB: in total 0 row operations to undo InnoDB: Trx id counter is 45256704 2014-04-24 14:42:54 20720 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 7669199, file name mysql-bin.000044 2014-04-24 14:42:55 20720 [Note] InnoDB: 128 rollback segment(s) are active. InnoDB: Starting in background the rollback of uncommitted transactions 2014-04-24 14:42:55 7ff230395700 InnoDB: Rollback of non-prepared transactions completed 2014-04-24 14:42:55 20720 [Note] InnoDB: Waiting for purge to start 2014-04-24 14:42:55 20720 [Note] InnoDB: 5.6.17 started; log sequence number 29011531048 2014-04-24 14:42:55 20720 [Note] Recovering after a crash using /var/lib/mysql/data/mysql-bin 2014-04-24 14:42:55 20720 [ERROR] Error in Log_event::read_log_event(): 'read error', data_len: 8214, event_type: 31 2014-04-24 14:42:55 20720 [Note] Starting crash recovery... 2014-04-24 14:42:55 7ffa2f7ef720 InnoDB: Starting recovery for XA transactions... 2014-04-24 14:42:55 7ffa2f7ef720 InnoDB: Transaction 45255957 in prepared state after recovery 2014-04-24 14:42:55 7ffa2f7ef720 InnoDB: Transaction contains changes to 4287 rows 2014-04-24 14:42:55 7ffa2f7ef720 InnoDB: 1 transactions in prepared state after recovery 2014-04-24 14:42:55 20720 [Note] Found 1 prepared transaction(s) in InnoDB 2014-04-24 14:42:55 20720 [Note] Crash recovery finished. 2014-04-24 14:42:55 20720 [Note] Crashed binlog file /var/lib/mysql/data/mysql-bin.000045 size is 4096, but recovered up to 231. Binlog trimmed to 231 bytes. 2014-04-24 14:42:55 20720 [Note] Server hostname (bind-address): '*'; port: 3306 2014-04-24 14:42:55 20720 [Note] IPv6 is available. 2014-04-24 14:42:55 20720 [Note] - '::' resolves to '::'; 2014-04-24 14:42:55 20720 [Note] Server socket created on IP: '::'. 2014-04-24 14:42:55 20720 [Warning] 'proxies_priv' entry '@ root@xxxx' ignored in --skip-name-resolve mode. 2014-04-24 14:42:55 20720 [ERROR] Error in Log_event::read_log_event(): 'read error', data_len: 8662, event_type: 31 2014-04-24 14:42:55 20720 [Warning] Error reading GTIDs from binary log: -1 2014-04-24 14:42:55 20720 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2014-04-24 14:42:55 20720 [Note] Slave I/O thread: connected to master 'repl@xxxx:3306',replication started in log 'mysql-bin.000035' at position 615544790 2014-04-24 14:42:56 20720 [Note] Event Scheduler: Loaded 0 events 2014-04-24 14:42:56 20720 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2014-04-24 14:42:56 20720 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000035' at position 615130896, relay log '/var/lib/mysql/data/mysql-relay-bin.000105' position: 615131106 2014-04-24 14:42:56 20720 [ERROR] Slave SQL: Could not execute Update_rows event on table apa_az.online_new; Error writing file '/tmp/MLN4w3gu' (Errcode: 28 - No space left on device), Error_code: 3; Error writing file '/var/lib/mysql/data/mysql-bin' (errno: 28 - No space left on device), Error_code: 1026; handler error HA_ERR_RBR_LOGGING_FAILED; the event's master log mysql-bin.000035, end_log_pos 615533655, Error_code: 3 2014-04-24 14:42:56 20720 [Warning] Slave: Error writing file '/tmp/MLN4w3gu' (Errcode: 28 - No space left on device) Error_code: 3 2014-04-24 14:42:56 20720 [Warning] Slave: Error writing file '/var/lib/mysql/data/mysql-bin' (errno: 28 - No space left on device) Error_code: 1026 2014-04-24 14:42:56 20720 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000035' position 615130896 2014-04-24 14:42:57 20720 [Warning] Disk is full writing '/var/lib/mysql/data/mysql-relay-bin.000109' (Errcode: 28 - No space left on device). Waiting for someone to free space... 2014-04-24 14:42:57 20720 [Warning] Retry in 60 secs. Message reprinted in 600 secs 2014-04-24 14:42:57 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_1.MYI'; try to repair it 2014-04-24 14:42:57 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:42:57 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:42:57 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:42:58 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:42:58 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:42:58 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:42:58 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:42:58 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:42:58 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:42:58 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:42:58 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:42:58 20720 [ERROR] /usr/sbin/mysqld: Incorrect key2014-04-24 14:43:04 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:04 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:04 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:04 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:04 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:04 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:04 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:05 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:05 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:05 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:05 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:05 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:05 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:05 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:05 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:05 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:05 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:05 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:05 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:05 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:05 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:06 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:06 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:06 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:06 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:06 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:06 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:06 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:06 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:06 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:06 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:06 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:06 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:06 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:06 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:06 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:06 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:07 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:07 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:07 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:07 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:07 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:07 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:07 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:07 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:07 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:07 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:07 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_0.MYI'; try to repair it 2014-04-24 14:43:07 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:08 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_1.MYI'; try to repair it 2014-04-24 14:43:08 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:08 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_1.MYI'; try to repair it 2014-04-24 14:43:08 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:08 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_1.MYI'; try to repair it 2014-04-24 14:43:08 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:08 20720 [ERROR] /usr/sbin/mysqld: In2014-04-24 14:43:26 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_3.MYI'; try to repair it 2014-04-24 14:43:26 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:26 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_2.MYI'; try to repair it 2014-04-24 14:43:26 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:26 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_2.MYI'; try to repair it 2014-04-24 14:43:26 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:26 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_2.MYI'; try to repair it 2014-04-24 14:43:26 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:27 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_2.MYI'; try to repair it 2014-04-24 14:43:27 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:27 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_2.MYI'; try to repair it 2014-04-24 14:43:27 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:27 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_2.MYI'; try to repair it 2014-04-24 14:43:27 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:27 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_2.MYI'; try to repair it 2014-04-24 14:43:27 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:27 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_2.MYI'; try to repair it 2014-04-24 14:43:27 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:27 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_2.MYI'; try to repair it 2014-04-24 14:43:27 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:27 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_3.MYI'; try to repair it 2014-04-24 14:43:27 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:29 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_1.MYI'; try to repair it 2014-04-24 14:43:29 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:29 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_1.MYI'; try to repair it 2014-04-24 14:43:29 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6.17/storage/myisam/mi_write.c:226 2014-04-24 14:43:29 20720 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_50f0_1.MYI'; try to repair it 2014-04-24 14:43:29 20720 [ERROR] Got an error from unknown thread, /pb2/build/sb_0-11763321-1394824719.47/rpm/BUILD/mysql-5.6.17/mysql-5.6140424 14:44:04 mysqld_safe Number of processes running now: 0 140424 14:44:05 mysqld_safe mysqld restarted 2014-04-24 14:44:06 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-24 14:44:06 20770 [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. 2014-04-24 14:44:06 20770 [Note] Plugin 'FEDERATED' is disabled. 2014-04-24 14:44:06 20770 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-04-24 14:44:06 20770 [Note] InnoDB: The InnoDB memory heap is disabled 2014-04-24 14:44:06 20770 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-04-24 14:44:06 20770 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-04-24 14:44:06 20770 [Note] InnoDB: Using Linux native AIO 2014-04-24 14:44:06 20770 [Note] InnoDB: Using CPU crc32 instructions 2014-04-24 14:44:06 20770 [Note] InnoDB: Initializing buffer pool, size = 28.0G 2014-04-24 14:44:08 20770 [Note] InnoDB: Completed initialization of buffer pool 2014-04-24 14:44:08 20770 [Note] InnoDB: Highest supported file format is Barracuda. 2014-04-24 14:44:08 20770 [Note] InnoDB: Log scan progressed past the checkpoint lsn 29011531058 2014-04-24 14:44:08 20770 [Note] InnoDB: Database was not shutdown normally! 2014-04-24 14:44:08 20770 [Note] InnoDB: Starting crash recovery. 2014-04-24 14:44:08 20770 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-04-24 14:44:08 20770 [Note] InnoDB: Restoring possible half-written data pages 2014-04-24 14:44:08 20770 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 29012883107 2014-04-24 14:44:09 20770 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 7669199, file name mysql-bin.000044 2014-04-24 14:44:10 20770 [Note] InnoDB: 128 rollback segment(s) are active. 2014-04-24 14:44:10 20770 [Note] InnoDB: Waiting for purge to start 2014-04-24 14:44:10 20770 [Note] InnoDB: 5.6.17 started; log sequence number 29012883107 2014-04-24 14:44:10 20770 [Note] Recovering after a crash using /var/lib/mysql/data/mysql-bin 2014-04-24 14:44:10 20770 [Note] Starting crash recovery... 2014-04-24 14:44:10 20770 [Note] Crash recovery finished. 09:44:10 UTC - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=0 max_threads=10000 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3985223 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8d6475] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x663084] /lib64/libpthread.so.0[0x3058c0f710] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 140424 14:44:11 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140424 15:06:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-24 15:06:42 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). /usr/sbin/mysqld: File '/home/data.index' not found (Errcode: 13 - Permission denied) 2014-04-24 15:06:42 21822 [ERROR] Aborting 2014-04-24 15:06:42 21822 [Note] Binlog end 2014-04-24 15:06:42 21822 [Note] /usr/sbin/mysqld: Shutdown complete 140424 15:06:42 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140424 15:16:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-24 15:16:30 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). /usr/sbin/mysqld: File '/home/data/mysql-bin.index' not found (Errcode: 13 - Permission denied) 2014-04-24 15:16:30 22867 [ERROR] Aborting 2014-04-24 15:16:30 22867 [Note] Binlog end 2014-04-24 15:16:30 22867 [Note] /usr/sbin/mysqld: Shutdown complete 140424 15:16:31 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140424 15:17:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-24 15:17:38 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). /usr/sbin/mysqld: File '/home/data/mysql-bin.index' not found (Errcode: 13 - Permission denied) 2014-04-24 15:17:38 23922 [ERROR] Aborting 2014-04-24 15:17:38 23922 [Note] Binlog end 2014-04-24 15:17:38 23922 [Note] /usr/sbin/mysqld: Shutdown complete 140424 15:17:38 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140424 15:21:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-24 15:21:11 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). /usr/sbin/mysqld: File '/home/data/mysql-bin.index' not found (Errcode: 13 - Permission denied) 2014-04-24 15:21:11 24877 [ERROR] Aborting 2014-04-24 15:21:11 24877 [Note] Binlog end 2014-04-24 15:21:11 24877 [Note] /usr/sbin/mysqld: Shutdown complete 140424 15:21:11 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140424 15:26:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-24 15:26:41 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). /usr/sbin/mysqld: File '/home/data/mysql-bin.index' not found (Errcode: 13 - Permission denied) 2014-04-24 15:26:41 25889 [ERROR] Aborting 2014-04-24 15:26:41 25889 [Note] Binlog end 2014-04-24 15:26:41 25889 [Note] /usr/sbin/mysqld: Shutdown complete 140424 15:26:41 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140424 15:29:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-24 15:29:47 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). /usr/sbin/mysqld: File '/home/data/mysql-bin.index' not found (Errcode: 13 - Permission denied) 2014-04-24 15:29:47 26824 [ERROR] Aborting 2014-04-24 15:29:47 26824 [Note] Binlog end 2014-04-24 15:29:47 26824 [Note] /usr/sbin/mysqld: Shutdown complete 140424 15:29:47 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140424 15:37:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-24 15:37:51 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). /usr/sbin/mysqld: File '/home/data/mysql-bin.index' not found (Errcode: 13 - Permission denied) 2014-04-24 15:37:51 27793 [ERROR] Aborting 2014-04-24 15:37:51 27793 [Note] Binlog end 2014-04-24 15:37:51 27793 [Note] /usr/sbin/mysqld: Shutdown complete 140424 15:37:51 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140424 15:44:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-24 15:44:19 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-24 15:44:19 28739 [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. 2014-04-24 15:44:19 28739 [Note] Plugin 'FEDERATED' is disabled. 2014-04-24 15:44:19 28739 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-04-24 15:44:19 28739 [Note] InnoDB: The InnoDB memory heap is disabled 2014-04-24 15:44:19 28739 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-04-24 15:44:19 28739 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-04-24 15:44:19 28739 [Note] InnoDB: Using Linux native AIO 2014-04-24 15:44:19 28739 [Note] InnoDB: Using CPU crc32 instructions 2014-04-24 15:44:19 28739 [Note] InnoDB: Initializing buffer pool, size = 28.0G 2014-04-24 15:44:24 28739 [Note] InnoDB: Completed initialization of buffer pool 2014-04-24 15:44:25 28739 [Note] InnoDB: Highest supported file format is Barracuda. 2014-04-24 15:44:25 28739 [Note] InnoDB: Log scan progressed past the checkpoint lsn 29011531058 2014-04-24 15:44:25 28739 [Note] InnoDB: Database was not shutdown normally! 2014-04-24 15:44:25 28739 [Note] InnoDB: Starting crash recovery. 2014-04-24 15:44:25 28739 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-04-24 15:44:25 28739 [Note] InnoDB: Restoring possible half-written data pages 2014-04-24 15:44:25 28739 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 29012883117 2014-04-24 15:44:26 28739 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 7669199, file name mysql-bin.000044 2014-04-24 15:44:29 28739 [Note] InnoDB: 128 rollback segment(s) are active. 2014-04-24 15:44:29 28739 [Note] InnoDB: Waiting for purge to start 2014-04-24 15:44:29 28739 [Note] InnoDB: 5.6.17 started; log sequence number 29012883117 10:44:29 UTC - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=0 max_threads=10000 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3985223 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8d6475] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x663084] /lib64/libpthread.so.0[0x3058c0f710] /usr/sbin/mysqld(_ZN9MYSQL_LOG17generate_new_nameEPcPKc+0x89)[0x64ded9] /usr/sbin/mysqld(_ZN9MYSQL_LOG26init_and_set_log_file_nameEPKcS1_13enum_log_type10cache_type+0x5f)[0x64df9f] /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG11open_binlogEPKcS1_10cache_typembbbP28Format_description_log_event+0x7e)[0x88ab4e] /usr/sbin/mysqld[0x59aa18] /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x455)[0x59f6c5] /lib64/libc.so.6(__libc_start_main+0xfd)[0x305881ed1d] /usr/sbin/mysqld[0x591949] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 140424 15:44:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140424 15:48:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-24 15:48:40 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-24 15:48:40 29773 [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. 2014-04-24 15:48:40 29773 [Note] Plugin 'FEDERATED' is disabled. 2014-04-24 15:48:40 29773 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-04-24 15:48:40 29773 [Note] InnoDB: The InnoDB memory heap is disabled 2014-04-24 15:48:40 29773 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-04-24 15:48:40 29773 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-04-24 15:48:40 29773 [Note] InnoDB: Using Linux native AIO 2014-04-24 15:48:40 29773 [Note] InnoDB: Using CPU crc32 instructions 2014-04-24 15:48:40 29773 [Note] InnoDB: Initializing buffer pool, size = 28.0G 2014-04-24 15:48:42 29773 [Note] InnoDB: Completed initialization of buffer pool 2014-04-24 15:48:42 29773 [Note] InnoDB: Highest supported file format is Barracuda. 2014-04-24 15:48:42 29773 [Note] InnoDB: Log scan progressed past the checkpoint lsn 29011531058 2014-04-24 15:48:42 29773 [Note] InnoDB: Database was not shutdown normally! 2014-04-24 15:48:42 29773 [Note] InnoDB: Starting crash recovery. 2014-04-24 15:48:42 29773 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-04-24 15:48:42 29773 [Note] InnoDB: Restoring possible half-written data pages 2014-04-24 15:48:42 29773 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 29012883127 2014-04-24 15:48:43 29773 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 7669199, file name mysql-bin.000044 2014-04-24 15:48:44 29773 [Note] InnoDB: 128 rollback segment(s) are active. 2014-04-24 15:48:44 29773 [Note] InnoDB: Waiting for purge to start 2014-04-24 15:48:44 29773 [Note] InnoDB: 5.6.17 started; log sequence number 29012883127 /usr/sbin/mysqld: File '/var/lib/mysql/data/mysql-bin.000046' not found (Errcode: 2 - No such file or directory) 2014-04-24 15:48:44 29773 [ERROR] Failed to open log (file '/var/lib/mysql/data/mysql-bin.000046', errno 2) 2014-04-24 15:48:44 29773 [ERROR] Could not open log file 2014-04-24 15:48:44 29773 [ERROR] Can't init tc log 2014-04-24 15:48:44 29773 [ERROR] Aborting 2014-04-24 15:48:44 29773 [Note] Binlog end 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'partition' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'BLACKHOLE' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'ARCHIVE' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_METRICS' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_CMP' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'INNODB_TRX' 2014-04-24 15:48:44 29773 [Note] Shutting down plugin 'InnoDB' 2014-04-24 15:48:44 29773 [Note] InnoDB: FTS optimize thread exiting. 2014-04-24 15:48:44 29773 [Note] InnoDB: Starting shutdown... 2014-04-24 15:48:47 29773 [Note] InnoDB: Shutdown completed; log sequence number 29012892906 2014-04-24 15:48:47 29773 [Note] Shutting down plugin 'MyISAM' 2014-04-24 15:48:47 29773 [Note] Shutting down plugin 'MRG_MYISAM' 2014-04-24 15:48:47 29773 [Note] Shutting down plugin 'CSV' 2014-04-24 15:48:47 29773 [Note] Shutting down plugin 'MEMORY' 2014-04-24 15:48:47 29773 [Note] Shutting down plugin 'sha256_password' 2014-04-24 15:48:47 29773 [Note] Shutting down plugin 'mysql_old_password' 2014-04-24 15:48:47 29773 [Note] Shutting down plugin 'mysql_native_password' 2014-04-24 15:48:47 29773 [Note] Shutting down plugin 'binlog' 2014-04-24 15:48:47 29773 [Note] /usr/sbin/mysqld: Shutdown complete 140424 15:48:47 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140424 15:52:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-24 15:52:51 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-24 15:52:51 30780 [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. 2014-04-24 15:52:51 30780 [Note] Plugin 'FEDERATED' is disabled. 2014-04-24 15:52:51 30780 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-04-24 15:52:51 30780 [Note] InnoDB: The InnoDB memory heap is disabled 2014-04-24 15:52:51 30780 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-04-24 15:52:51 30780 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-04-24 15:52:51 30780 [Note] InnoDB: Using Linux native AIO 2014-04-24 15:52:51 30780 [Note] InnoDB: Using CPU crc32 instructions 2014-04-24 15:52:51 30780 [Note] InnoDB: Initializing buffer pool, size = 28.0G 2014-04-24 15:52:53 30780 [Note] InnoDB: Completed initialization of buffer pool 2014-04-24 15:52:53 30780 [Note] InnoDB: Highest supported file format is Barracuda. 2014-04-24 15:52:54 30780 [Note] InnoDB: 128 rollback segment(s) are active. 2014-04-24 15:52:54 30780 [Note] InnoDB: Waiting for purge to start 2014-04-24 15:52:54 30780 [Note] InnoDB: 5.6.17 started; log sequence number 29012892906 /usr/sbin/mysqld: File '/home/data/mysql-bin.000046' not found (Errcode: 13 - Permission denied) 2014-04-24 15:52:54 30780 [ERROR] Failed to open log (file '/home/data/mysql-bin.000046', errno 13) 2014-04-24 15:52:54 30780 [ERROR] Could not open log file 2014-04-24 15:52:54 30780 [ERROR] Can't init tc log 2014-04-24 15:52:54 30780 [ERROR] Aborting 2014-04-24 15:52:54 30780 [Note] Binlog end 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'partition' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'BLACKHOLE' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'ARCHIVE' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_METRICS' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_CMP' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'INNODB_TRX' 2014-04-24 15:52:54 30780 [Note] Shutting down plugin 'InnoDB' 2014-04-24 15:52:54 30780 [Note] InnoDB: FTS optimize thread exiting. 2014-04-24 15:52:54 30780 [Note] InnoDB: Starting shutdown... 2014-04-24 15:52:57 30780 [Note] InnoDB: Shutdown completed; log sequence number 29012893134 2014-04-24 15:52:57 30780 [Note] Shutting down plugin 'MyISAM' 2014-04-24 15:52:57 30780 [Note] Shutting down plugin 'MRG_MYISAM' 2014-04-24 15:52:57 30780 [Note] Shutting down plugin 'CSV' 2014-04-24 15:52:57 30780 [Note] Shutting down plugin 'MEMORY' 2014-04-24 15:52:57 30780 [Note] Shutting down plugin 'sha256_password' 2014-04-24 15:52:57 30780 [Note] Shutting down plugin 'mysql_old_password' 2014-04-24 15:52:57 30780 [Note] Shutting down plugin 'mysql_native_password' 2014-04-24 15:52:57 30780 [Note] Shutting down plugin 'binlog' 2014-04-24 15:52:57 30780 [Note] /usr/sbin/mysqld: Shutdown complete 140424 15:52:57 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140424 15:53:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-24 15:53:35 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-24 15:53:35 31787 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-04-24 15:53:35 31787 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-04-24 15:53:35 31787 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-04-24 15:53:35 31787 [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. 2014-04-24 15:53:35 31787 [Note] Plugin 'FEDERATED' is disabled. 2014-04-24 15:53:35 31787 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-04-24 15:53:35 31787 [Note] InnoDB: The InnoDB memory heap is disabled 2014-04-24 15:53:35 31787 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-04-24 15:53:35 31787 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-04-24 15:53:35 31787 [Note] InnoDB: Using Linux native AIO 2014-04-24 15:53:35 31787 [Note] InnoDB: Using CPU crc32 instructions 2014-04-24 15:53:35 31787 [Note] InnoDB: Initializing buffer pool, size = 28.0G 2014-04-24 15:53:37 31787 [Note] InnoDB: Completed initialization of buffer pool 2014-04-24 15:53:37 31787 [Note] InnoDB: Highest supported file format is Barracuda. 2014-04-24 15:53:38 31787 [Note] InnoDB: 128 rollback segment(s) are active. 2014-04-24 15:53:38 31787 [Note] InnoDB: Waiting for purge to start 2014-04-24 15:53:38 31787 [Note] InnoDB: 5.6.17 started; log sequence number 29012893134 /usr/sbin/mysqld: File '/home/data/mysql-bin.000046' not found (Errcode: 13 - Permission denied) 2014-04-24 15:53:38 31787 [ERROR] Failed to open log (file '/home/data/mysql-bin.000046', errno 13) 2014-04-24 15:53:38 31787 [ERROR] Could not open log file 2014-04-24 15:53:38 31787 [ERROR] Can't init tc log 2014-04-24 15:53:38 31787 [ERROR] Aborting 2014-04-24 15:53:38 31787 [Note] Binlog end 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'partition' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'BLACKHOLE' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'ARCHIVE' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_METRICS' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_CMP' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'INNODB_TRX' 2014-04-24 15:53:38 31787 [Note] Shutting down plugin 'InnoDB' 2014-04-24 15:53:38 31787 [Note] InnoDB: FTS optimize thread exiting. 2014-04-24 15:53:38 31787 [Note] InnoDB: Starting shutdown... 2014-04-24 15:53:41 31787 [Note] InnoDB: Shutdown completed; log sequence number 29012893144 2014-04-24 15:53:41 31787 [Note] Shutting down plugin 'MyISAM' 2014-04-24 15:53:41 31787 [Note] Shutting down plugin 'MRG_MYISAM' 2014-04-24 15:53:41 31787 [Note] Shutting down plugin 'CSV' 2014-04-24 15:53:41 31787 [Note] Shutting down plugin 'MEMORY' 2014-04-24 15:53:41 31787 [Note] Shutting down plugin 'sha256_password' 2014-04-24 15:53:41 31787 [Note] Shutting down plugin 'mysql_old_password' 2014-04-24 15:53:41 31787 [Note] Shutting down plugin 'mysql_native_password' 2014-04-24 15:53:41 31787 [Note] Shutting down plugin 'binlog' 2014-04-24 15:53:41 31787 [Note] /usr/sbin/mysqld: Shutdown complete 140424 15:53:41 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140424 17:04:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-24 17:04:12 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-24 17:04:12 32933 [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. 2014-04-24 17:04:12 32933 [Note] Plugin 'FEDERATED' is disabled. 2014-04-24 17:04:12 32933 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-04-24 17:04:12 32933 [Note] InnoDB: The InnoDB memory heap is disabled 2014-04-24 17:04:12 32933 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-04-24 17:04:12 32933 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-04-24 17:04:12 32933 [Note] InnoDB: Using Linux native AIO 2014-04-24 17:04:12 32933 [Note] InnoDB: Using CPU crc32 instructions 2014-04-24 17:04:12 32933 [Note] InnoDB: Initializing buffer pool, size = 28.0G 2014-04-24 17:04:14 32933 [Note] InnoDB: Completed initialization of buffer pool 2014-04-24 17:04:14 32933 [Note] InnoDB: Highest supported file format is Barracuda. 2014-04-24 17:04:15 32933 [Note] InnoDB: 128 rollback segment(s) are active. 2014-04-24 17:04:15 32933 [Note] InnoDB: Waiting for purge to start 2014-04-24 17:04:15 32933 [Note] InnoDB: 5.6.17 started; log sequence number 29012893144 /usr/sbin/mysqld: File '/home/data/mysql-bin.000046' not found (Errcode: 13 - Permission denied) 2014-04-24 17:04:15 32933 [ERROR] Failed to open log (file '/home/data/mysql-bin.000046', errno 13) 2014-04-24 17:04:15 32933 [ERROR] Could not open log file 2014-04-24 17:04:15 32933 [ERROR] Can't init tc log 2014-04-24 17:04:15 32933 [ERROR] Aborting 2014-04-24 17:04:15 32933 [Note] Binlog end 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'partition' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'BLACKHOLE' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'ARCHIVE' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_METRICS' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_CMP' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'INNODB_TRX' 2014-04-24 17:04:15 32933 [Note] Shutting down plugin 'InnoDB' 2014-04-24 17:04:15 32933 [Note] InnoDB: FTS optimize thread exiting. 2014-04-24 17:04:15 32933 [Note] InnoDB: Starting shutdown... 2014-04-24 17:04:18 32933 [Note] InnoDB: Shutdown completed; log sequence number 29012893154 2014-04-24 17:04:18 32933 [Note] Shutting down plugin 'MyISAM' 2014-04-24 17:04:18 32933 [Note] Shutting down plugin 'MRG_MYISAM' 2014-04-24 17:04:18 32933 [Note] Shutting down plugin 'CSV' 2014-04-24 17:04:18 32933 [Note] Shutting down plugin 'MEMORY' 2014-04-24 17:04:18 32933 [Note] Shutting down plugin 'sha256_password' 2014-04-24 17:04:18 32933 [Note] Shutting down plugin 'mysql_old_password' 2014-04-24 17:04:18 32933 [Note] Shutting down plugin 'mysql_native_password' 2014-04-24 17:04:18 32933 [Note] Shutting down plugin 'binlog' 2014-04-24 17:04:18 32933 [Note] /usr/sbin/mysqld: Shutdown complete 140424 17:04:18 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 140424 17:37:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-04-24 17:37:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-04-24 17:37:08 34000 [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. 2014-04-24 17:37:08 34000 [Note] Plugin 'FEDERATED' is disabled. 2014-04-24 17:37:08 34000 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-04-24 17:37:08 34000 [Note] InnoDB: The InnoDB memory heap is disabled 2014-04-24 17:37:08 34000 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-04-24 17:37:08 34000 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-04-24 17:37:08 34000 [Note] InnoDB: Using Linux native AIO 2014-04-24 17:37:08 34000 [Note] InnoDB: Using CPU crc32 instructions 2014-04-24 17:37:08 34000 [Note] InnoDB: Initializing buffer pool, size = 28.0G 2014-04-24 17:37:09 34000 [Note] InnoDB: Completed initialization of buffer pool 2014-04-24 17:37:10 34000 [Note] InnoDB: Highest supported file format is Barracuda. 2014-04-24 17:37:11 34000 [Note] InnoDB: 128 rollback segment(s) are active. 2014-04-24 17:37:11 34000 [Note] InnoDB: Waiting for purge to start 2014-04-24 17:37:11 34000 [Note] InnoDB: 5.6.17 started; log sequence number 29012893154 /usr/sbin/mysqld: File '/home/data/mysql-bin.000046' not found (Errcode: 13 - Permission denied) 2014-04-24 17:37:11 34000 [ERROR] Failed to open log (file '/home/data/mysql-bin.000046', errno 13) 2014-04-24 17:37:11 34000 [ERROR] Could not open log file 2014-04-24 17:37:11 34000 [ERROR] Can't init tc log 2014-04-24 17:37:11 34000 [ERROR] Aborting 2014-04-24 17:37:11 34000 [Note] Binlog end 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'partition' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'BLACKHOLE' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'ARCHIVE' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_METRICS' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_CMP' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'INNODB_TRX' 2014-04-24 17:37:11 34000 [Note] Shutting down plugin 'InnoDB' 2014-04-24 17:37:11 34000 [Note] InnoDB: FTS optimize thread exiting. 2014-04-24 17:37:11 34000 [Note] InnoDB: Starting shutdown... 2014-04-24 17:37:14 34000 [Note] InnoDB: Shutdown completed; log sequence number 29012893164 2014-04-24 17:37:14 34000 [Note] Shutting down plugin 'MyISAM' 2014-04-24 17:37:14 34000 [Note] Shutting down plugin 'MRG_MYISAM' 2014-04-24 17:37:14 34000 [Note] Shutting down plugin 'CSV' 2014-04-24 17:37:14 34000 [Note] Shutting down plugin 'MEMORY' 2014-04-24 17:37:14 34000 [Note] Shutting down plugin 'sha256_password' 2014-04-24 17:37:14 34000 [Note] Shutting down plugin 'mysql_old_password' 2014-04-24 17:37:14 34000 [Note] Shutting down plugin 'mysql_native_password' 2014-04-24 17:37:14 34000 [Note] Shutting down plugin 'binlog' 2014-04-24 17:37:14 34000 [Note] /usr/sbin/mysqld: Shutdown complete 140424 17:37:14 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended