130810 16:41:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2013-08-10 16:41:14 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-08-10 16:41:14 8912 [Note] Plugin 'FEDERATED' is disabled. 2013-08-10 16:41:14 8912 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-10 16:41:14 8912 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-10 16:41:14 8912 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-10 16:41:14 8912 [Note] InnoDB: Using Linux native AIO 2013-08-10 16:41:14 8912 [Note] InnoDB: Using CPU crc32 instructions 2013-08-10 16:41:14 8912 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2013-08-10 16:41:14 8912 [Note] InnoDB: Completed initialization of buffer pool 2013-08-10 16:41:14 8912 [Note] InnoDB: Highest supported file format is Barracuda. 2013-08-10 16:41:14 8912 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-10 16:41:14 8912 [Note] InnoDB: Waiting for purge to start 2013-08-10 16:41:14 8912 [Note] InnoDB: 5.6.12 started; log sequence number 1625987 2013-08-10 16:41:14 8912 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 33434fd2-01fd-11e3-8fd4-2089846422ad. 2013-08-10 16:41:14 8912 [Note] Server hostname (bind-address): '*'; port: 3306 2013-08-10 16:41:14 8912 [Note] IPv6 is available. 2013-08-10 16:41:14 8912 [Note] - '::' resolves to '::'; 2013-08-10 16:41:14 8912 [Note] Server socket created on IP: '::'. 2013-08-10 16:41:15 8912 [Note] Event Scheduler: Loaded 0 events 2013-08-10 16:41:15 8912 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.12' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-08-10 16:43:14 8912 [Note] /usr/sbin/mysqld: Normal shutdown 2013-08-10 16:43:14 8912 [Note] Giving 1 client threads a chance to die gracefully 2013-08-10 16:43:14 8912 [Note] Event Scheduler: Purging the queue. 0 events 2013-08-10 16:43:14 8912 [Note] Shutting down slave threads 2013-08-10 16:43:16 8912 [Note] Forcefully disconnecting 1 remaining clients 2013-08-10 16:43:16 8912 [Warning] /usr/sbin/mysqld: Forcing close of thread 12 user: 'root' 2013-08-10 16:43:16 8912 [Note] Binlog end 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'partition' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'ARCHIVE' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'BLACKHOLE' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_METRICS' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_CMP' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'INNODB_TRX' 2013-08-10 16:43:16 8912 [Note] Shutting down plugin 'InnoDB' 2013-08-10 16:43:16 8912 [Note] InnoDB: FTS optimize thread exiting. 2013-08-10 16:43:16 8912 [Note] InnoDB: Starting shutdown... 2013-08-10 16:43:18 8912 [Note] InnoDB: Shutdown completed; log sequence number 1625997 2013-08-10 16:43:18 8912 [Note] Shutting down plugin 'MRG_MYISAM' 2013-08-10 16:43:18 8912 [Note] Shutting down plugin 'CSV' 2013-08-10 16:43:18 8912 [Note] Shutting down plugin 'MEMORY' 2013-08-10 16:43:18 8912 [Note] Shutting down plugin 'MyISAM' 2013-08-10 16:43:18 8912 [Note] Shutting down plugin 'sha256_password' 2013-08-10 16:43:18 8912 [Note] Shutting down plugin 'mysql_old_password' 2013-08-10 16:43:18 8912 [Note] Shutting down plugin 'mysql_native_password' 2013-08-10 16:43:18 8912 [Note] Shutting down plugin 'binlog' 2013-08-10 16:43:18 8912 [Note] /usr/sbin/mysqld: Shutdown complete 130810 16:43:18 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended 130810 16:43:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2013-08-10 16:43:23 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-08-10 16:43:23 9874 [Note] Plugin 'FEDERATED' is disabled. 2013-08-10 16:43:23 9874 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-10 16:43:23 9874 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-10 16:43:23 9874 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-10 16:43:23 9874 [Note] InnoDB: Using Linux native AIO 2013-08-10 16:43:23 9874 [Note] InnoDB: Using CPU crc32 instructions 2013-08-10 16:43:23 9874 [Note] InnoDB: Initializing buffer pool, size = 256.0M 2013-08-10 16:43:23 9874 [Note] InnoDB: Completed initialization of buffer pool 2013-08-10 16:43:23 9874 [Note] InnoDB: Highest supported file format is Barracuda. 2013-08-10 16:43:23 9874 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*4096 pages, LSN=1625997 2013-08-10 16:43:23 9874 [Warning] InnoDB: Starting to delete and rewrite log files. 2013-08-10 16:43:23 9874 [Note] InnoDB: Setting log file ./ib_logfile101 size to 64 MB 2013-08-10 16:43:24 9874 [Note] InnoDB: Setting log file ./ib_logfile1 size to 64 MB 2013-08-10 16:43:24 9874 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2013-08-10 16:43:24 9874 [Warning] InnoDB: New log files created, LSN=1625997 2013-08-10 16:43:24 9874 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-10 16:43:24 9874 [Note] InnoDB: Waiting for purge to start 2013-08-10 16:43:24 9874 [Note] InnoDB: 5.6.12 started; log sequence number 1625997 2013-08-10 16:43:25 9874 [Note] Server hostname (bind-address): '*'; port: 3306 2013-08-10 16:43:25 9874 [Note] IPv6 is available. 2013-08-10 16:43:25 9874 [Note] - '::' resolves to '::'; 2013-08-10 16:43:25 9874 [Note] Server socket created on IP: '::'. 2013-08-10 16:43:25 9874 [Warning] 'proxies_priv' entry '@ root@localhost.localdomain' ignored in --skip-name-resolve mode. 2013-08-10 16:43:25 9874 [Note] Event Scheduler: Loaded 0 events 2013-08-10 16:43:25 9874 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.12-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-08-10 16:45:46 9874 [Note] /usr/sbin/mysqld: Normal shutdown 2013-08-10 16:45:46 9874 [Note] Giving 1 client threads a chance to die gracefully 2013-08-10 16:45:46 9874 [Note] Event Scheduler: Purging the queue. 0 events 2013-08-10 16:45:46 9874 [Note] Shutting down slave threads 2013-08-10 16:45:48 9874 [Note] Forcefully disconnecting 1 remaining clients 2013-08-10 16:45:48 9874 [Warning] /usr/sbin/mysqld: Forcing close of thread 1 user: 'root' 2013-08-10 16:45:48 9874 [Note] Binlog end 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'partition' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'ARCHIVE' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'BLACKHOLE' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_METRICS' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_CMP' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'INNODB_TRX' 2013-08-10 16:45:48 9874 [Note] Shutting down plugin 'InnoDB' 2013-08-10 16:45:48 9874 [Note] InnoDB: FTS optimize thread exiting. 2013-08-10 16:45:48 9874 [Note] InnoDB: Starting shutdown... 2013-08-10 16:45:49 9874 [Note] InnoDB: Shutdown completed; log sequence number 1670935 2013-08-10 16:45:49 9874 [Note] Shutting down plugin 'MRG_MYISAM' 2013-08-10 16:45:49 9874 [Note] Shutting down plugin 'CSV' 2013-08-10 16:45:49 9874 [Note] Shutting down plugin 'MEMORY' 2013-08-10 16:45:49 9874 [Note] Shutting down plugin 'MyISAM' 2013-08-10 16:45:49 9874 [Note] Shutting down plugin 'sha256_password' 2013-08-10 16:45:49 9874 [Note] Shutting down plugin 'mysql_old_password' 2013-08-10 16:45:49 9874 [Note] Shutting down plugin 'mysql_native_password' 2013-08-10 16:45:49 9874 [Note] Shutting down plugin 'binlog' 2013-08-10 16:45:49 9874 [Note] /usr/sbin/mysqld: Shutdown complete 130810 16:45:49 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended 130810 16:45:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2013-08-10 16:45:50 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-08-10 16:45:50 10761 [Note] Plugin 'FEDERATED' is disabled. 2013-08-10 16:45:50 10761 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-10 16:45:50 10761 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-10 16:45:50 10761 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-10 16:45:50 10761 [Note] InnoDB: Using Linux native AIO 2013-08-10 16:45:50 10761 [Note] InnoDB: Using CPU crc32 instructions 2013-08-10 16:45:50 10761 [Note] InnoDB: Initializing buffer pool, size = 256.0M 2013-08-10 16:45:50 10761 [Note] InnoDB: Completed initialization of buffer pool 2013-08-10 16:45:50 10761 [Note] InnoDB: Highest supported file format is Barracuda. 2013-08-10 16:45:50 7fee8fc04720 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: If you are installing InnoDB, remember that you must create InnoDB: directories yourself, InnoDB does not create them. 2013-08-10 16:45:50 10761 [ERROR] InnoDB: Could not find a valid tablespace file for 'test/test_it'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 2013-08-10 16:45:50 10761 [ERROR] InnoDB: Tablespace open failed for '"test"."test_it"', ignored. 2013-08-10 16:45:50 10761 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-10 16:45:50 10761 [Note] InnoDB: Waiting for purge to start 2013-08-10 16:45:50 10761 [Note] InnoDB: 5.6.12 started; log sequence number 1670935 2013-08-10 16:45:51 10761 [Note] Server hostname (bind-address): '*'; port: 3306 2013-08-10 16:45:51 10761 [Note] IPv6 is available. 2013-08-10 16:45:51 10761 [Note] - '::' resolves to '::'; 2013-08-10 16:45:51 10761 [Note] Server socket created on IP: '::'. 2013-08-10 16:45:51 10761 [Warning] 'proxies_priv' entry '@ root@localhost.localdomain' ignored in --skip-name-resolve mode. 2013-08-10 16:45:51 10761 [Note] Event Scheduler: Loaded 0 events 2013-08-10 16:45:51 10761 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.12-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-08-10 16:47:24 10761 [ERROR] InnoDB: Failed to find tablespace for table '"test"."test_it"' in the cache. Attempting to load the tablespace with space id 6. 2013-08-10 16:47:24 7fee8c37c700 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. 2013-08-10 16:47:24 10761 [ERROR] InnoDB: Could not find a valid tablespace file for 'test/test_it'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 2013-08-10 16:47:24 7fee8c37c700 InnoDB: cannot calculate statistics for table "test"."test_it" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2013-08-10 16:47:24 7fee8c37c700 InnoDB: cannot calculate statistics for table "test"."test_it" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2013-08-10 16:47:26 7fee8c37c700 InnoDB: cannot calculate statistics for table "test"."test_it" because the .ibd file is missing. For help, please refer to http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html 2013-08-10 16:54:21 10761 [Note] /usr/sbin/mysqld: Normal shutdown 2013-08-10 16:54:21 10761 [Note] Giving 1 client threads a chance to die gracefully 2013-08-10 16:54:21 10761 [Note] Event Scheduler: Purging the queue. 0 events 2013-08-10 16:54:21 10761 [Note] Shutting down slave threads 2013-08-10 16:54:23 10761 [Note] Forcefully disconnecting 1 remaining clients 2013-08-10 16:54:23 10761 [Warning] /usr/sbin/mysqld: Forcing close of thread 1 user: 'root' 2013-08-10 16:54:23 10761 [Note] Binlog end 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'partition' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'ARCHIVE' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'BLACKHOLE' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_METRICS' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_CMP' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'INNODB_TRX' 2013-08-10 16:54:23 10761 [Note] Shutting down plugin 'InnoDB' 2013-08-10 16:54:23 10761 [Note] InnoDB: FTS optimize thread exiting. 2013-08-10 16:54:23 10761 [Note] InnoDB: Starting shutdown... 2013-08-10 16:54:25 10761 [Note] InnoDB: Shutdown completed; log sequence number 1670945 2013-08-10 16:54:25 10761 [Note] Shutting down plugin 'MRG_MYISAM' 2013-08-10 16:54:25 10761 [Note] Shutting down plugin 'CSV' 2013-08-10 16:54:25 10761 [Note] Shutting down plugin 'MEMORY' 2013-08-10 16:54:25 10761 [Note] Shutting down plugin 'MyISAM' 2013-08-10 16:54:25 10761 [Note] Shutting down plugin 'sha256_password' 2013-08-10 16:54:25 10761 [Note] Shutting down plugin 'mysql_old_password' 2013-08-10 16:54:25 10761 [Note] Shutting down plugin 'mysql_native_password' 2013-08-10 16:54:25 10761 [Note] Shutting down plugin 'binlog' 2013-08-10 16:54:25 10761 [Note] /usr/sbin/mysqld: Shutdown complete 130810 16:54:25 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended 130810 16:54:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2013-08-10 16:54:50 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-08-10 16:54:50 11731 [Note] Plugin 'FEDERATED' is disabled. 2013-08-10 16:54:50 11731 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-10 16:54:50 11731 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-10 16:54:50 11731 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-10 16:54:50 11731 [Note] InnoDB: Using Linux native AIO 2013-08-10 16:54:50 11731 [Note] InnoDB: Using CPU crc32 instructions 2013-08-10 16:54:50 11731 [Note] InnoDB: Initializing buffer pool, size = 256.0M 2013-08-10 16:54:50 11731 [Note] InnoDB: Completed initialization of buffer pool 2013-08-10 16:54:50 11731 [Note] InnoDB: Highest supported file format is Barracuda. 2013-08-10 16:54:50 7f6e481d7720 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. 2013-08-10 16:54:50 11731 [ERROR] InnoDB: Could not find a valid tablespace file for 'test/test_it'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 2013-08-10 16:54:50 11731 [ERROR] InnoDB: Tablespace open failed for '"test"."test_it"', ignored. 2013-08-10 16:54:50 11731 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-10 16:54:50 11731 [Note] InnoDB: Waiting for purge to start 2013-08-10 16:54:50 11731 [Note] InnoDB: 5.6.12 started; log sequence number 1670945 2013-08-10 16:54:50 11731 [Note] Server hostname (bind-address): '*'; port: 3306 2013-08-10 16:54:50 11731 [Note] IPv6 is available. 2013-08-10 16:54:50 11731 [Note] - '::' resolves to '::'; 2013-08-10 16:54:50 11731 [Note] Server socket created on IP: '::'. 2013-08-10 16:54:50 11731 [Warning] 'proxies_priv' entry '@ root@localhost.localdomain' ignored in --skip-name-resolve mode. 2013-08-10 16:54:50 11731 [Note] Event Scheduler: Loaded 0 events 2013-08-10 16:54:50 11731 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.12-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-08-10 16:55:21 11731 [Note] /usr/sbin/mysqld: Normal shutdown 2013-08-10 16:55:21 11731 [Note] Giving 0 client threads a chance to die gracefully 2013-08-10 16:55:21 11731 [Note] Event Scheduler: Purging the queue. 0 events 2013-08-10 16:55:21 11731 [Note] Shutting down slave threads 2013-08-10 16:55:21 11731 [Note] Forcefully disconnecting 0 remaining clients 2013-08-10 16:55:21 11731 [Note] Binlog end 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'partition' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'ARCHIVE' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'BLACKHOLE' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_METRICS' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_CMP' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'INNODB_TRX' 2013-08-10 16:55:21 11731 [Note] Shutting down plugin 'InnoDB' 2013-08-10 16:55:21 11731 [Note] InnoDB: FTS optimize thread exiting. 2013-08-10 16:55:21 11731 [Note] InnoDB: Starting shutdown... 2013-08-10 16:55:22 11731 [Note] InnoDB: Shutdown completed; log sequence number 1670955 2013-08-10 16:55:22 11731 [Note] Shutting down plugin 'MRG_MYISAM' 2013-08-10 16:55:22 11731 [Note] Shutting down plugin 'CSV' 2013-08-10 16:55:22 11731 [Note] Shutting down plugin 'MEMORY' 2013-08-10 16:55:22 11731 [Note] Shutting down plugin 'MyISAM' 2013-08-10 16:55:22 11731 [Note] Shutting down plugin 'sha256_password' 2013-08-10 16:55:22 11731 [Note] Shutting down plugin 'mysql_old_password' 2013-08-10 16:55:22 11731 [Note] Shutting down plugin 'mysql_native_password' 2013-08-10 16:55:22 11731 [Note] Shutting down plugin 'binlog' 2013-08-10 16:55:22 11731 [Note] /usr/sbin/mysqld: Shutdown complete 130810 16:55:22 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended 130810 16:55:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2013-08-10 16:55:25 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-08-10 16:55:25 12597 [Note] Plugin 'FEDERATED' is disabled. 2013-08-10 16:55:25 12597 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-10 16:55:25 12597 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-10 16:55:25 12597 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-10 16:55:25 12597 [Note] InnoDB: Using Linux native AIO 2013-08-10 16:55:25 12597 [Note] InnoDB: Using CPU crc32 instructions 2013-08-10 16:55:25 12597 [Note] InnoDB: Initializing buffer pool, size = 256.0M 2013-08-10 16:55:25 12597 [Note] InnoDB: Completed initialization of buffer pool 2013-08-10 16:55:25 12597 [Note] InnoDB: Highest supported file format is Barracuda. 2013-08-10 16:55:26 12597 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-10 16:55:26 12597 [Note] InnoDB: Waiting for purge to start 2013-08-10 16:55:26 12597 [Note] InnoDB: 5.6.12 started; log sequence number 1670955 2013-08-10 16:55:26 12597 [Note] Server hostname (bind-address): '*'; port: 3306 2013-08-10 16:55:26 12597 [Note] IPv6 is available. 2013-08-10 16:55:26 12597 [Note] - '::' resolves to '::'; 2013-08-10 16:55:26 12597 [Note] Server socket created on IP: '::'. 2013-08-10 16:55:26 12597 [Warning] 'proxies_priv' entry '@ root@localhost.localdomain' ignored in --skip-name-resolve mode. 2013-08-10 16:55:26 12597 [Note] Event Scheduler: Loaded 0 events 2013-08-10 16:55:26 12597 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.12-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-08-10 16:56:24 12597 [Note] /usr/sbin/mysqld: Normal shutdown 2013-08-10 16:56:24 12597 [Note] Giving 0 client threads a chance to die gracefully 2013-08-10 16:56:24 12597 [Note] Event Scheduler: Purging the queue. 0 events 2013-08-10 16:56:24 12597 [Note] Shutting down slave threads 2013-08-10 16:56:24 12597 [Note] Forcefully disconnecting 0 remaining clients 2013-08-10 16:56:24 12597 [Note] Binlog end 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'partition' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'ARCHIVE' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'BLACKHOLE' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_METRICS' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_CMP' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'INNODB_TRX' 2013-08-10 16:56:24 12597 [Note] Shutting down plugin 'InnoDB' 2013-08-10 16:56:24 12597 [Note] InnoDB: FTS optimize thread exiting. 2013-08-10 16:56:24 12597 [Note] InnoDB: Starting shutdown... 2013-08-10 16:56:26 12597 [Note] InnoDB: Shutdown completed; log sequence number 1670965 2013-08-10 16:56:26 12597 [Note] Shutting down plugin 'MRG_MYISAM' 2013-08-10 16:56:26 12597 [Note] Shutting down plugin 'CSV' 2013-08-10 16:56:26 12597 [Note] Shutting down plugin 'MEMORY' 2013-08-10 16:56:26 12597 [Note] Shutting down plugin 'MyISAM' 2013-08-10 16:56:26 12597 [Note] Shutting down plugin 'sha256_password' 2013-08-10 16:56:26 12597 [Note] Shutting down plugin 'mysql_old_password' 2013-08-10 16:56:26 12597 [Note] Shutting down plugin 'mysql_native_password' 2013-08-10 16:56:26 12597 [Note] Shutting down plugin 'binlog' 2013-08-10 16:56:26 12597 [Note] /usr/sbin/mysqld: Shutdown complete 130810 16:56:26 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended 130810 16:56:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2013-08-10 16:56:26 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-08-10 16:56:26 13469 [Note] Plugin 'FEDERATED' is disabled. 2013-08-10 16:56:26 13469 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-10 16:56:26 13469 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-10 16:56:26 13469 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-10 16:56:26 13469 [Note] InnoDB: Using Linux native AIO 2013-08-10 16:56:26 13469 [Note] InnoDB: Using CPU crc32 instructions 2013-08-10 16:56:26 13469 [Note] InnoDB: Initializing buffer pool, size = 256.0M 2013-08-10 16:56:26 13469 [Note] InnoDB: Completed initialization of buffer pool 2013-08-10 16:56:26 13469 [Note] InnoDB: Highest supported file format is Barracuda. 2013-08-10 16:56:27 13469 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-10 16:56:27 13469 [Note] InnoDB: Waiting for purge to start 2013-08-10 16:56:27 13469 [Note] InnoDB: 5.6.12 started; log sequence number 1670965 2013-08-10 16:56:27 13469 [Note] Server hostname (bind-address): '*'; port: 3306 2013-08-10 16:56:27 13469 [Note] IPv6 is available. 2013-08-10 16:56:27 13469 [Note] - '::' resolves to '::'; 2013-08-10 16:56:27 13469 [Note] Server socket created on IP: '::'. 2013-08-10 16:56:27 13469 [Warning] 'proxies_priv' entry '@ root@localhost.localdomain' ignored in --skip-name-resolve mode. 2013-08-10 16:56:27 13469 [Note] Event Scheduler: Loaded 0 events 2013-08-10 16:56:27 13469 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.12-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 20:56:52 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=1 max_threads=10000 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3983660 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x20a81c0 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 = 7f9688402e48 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8c70d5] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x65cbe4] /lib64/libpthread.so.0[0x3d2440f500] /usr/sbin/mysqld[0x983822] /usr/sbin/mysqld[0x8e5a58] /usr/sbin/mysqld[0x8dd649] /usr/sbin/mysqld(_ZN7handler14ha_index_firstEPh+0x9c)[0x59ff7c] /usr/sbin/mysqld(_Z15join_read_firstP13st_join_table+0x81)[0x6b5b01] /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x15d)[0x6b67ad] /usr/sbin/mysqld(_ZN4JOIN4execEv+0x2aa)[0x6b701a] /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x250)[0x6f7770] /usr/sbin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x187)[0x6f7fe7] /usr/sbin/mysqld[0x6d448d] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0xb46)[0x6d63e6] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x32f)[0x6da5ff] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xe0c)[0x6db4fc] /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0xcf)[0x6a90ff] /usr/sbin/mysqld(handle_one_connection+0x47)[0x6a9227] /lib64/libpthread.so.0[0x3d24407851] /lib64/libc.so.6(clone+0x6d)[0x3d23ce890d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f9658004be0): is an invalid pointer Connection ID (thread ID): 1 Status: NOT_KILLED 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. 130810 16:56:52 mysqld_safe Number of processes running now: 0 130810 16:56:52 mysqld_safe mysqld restarted 2013-08-10 16:56:52 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-08-10 16:56:52 13514 [Note] Plugin 'FEDERATED' is disabled. 2013-08-10 16:56:52 13514 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-10 16:56:52 13514 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-10 16:56:52 13514 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-10 16:56:52 13514 [Note] InnoDB: Using Linux native AIO 2013-08-10 16:56:52 13514 [Note] InnoDB: Using CPU crc32 instructions 2013-08-10 16:56:52 13514 [Note] InnoDB: Initializing buffer pool, size = 256.0M 2013-08-10 16:56:52 13514 [Note] InnoDB: Completed initialization of buffer pool 2013-08-10 16:56:52 13514 [Note] InnoDB: Highest supported file format is Barracuda. 2013-08-10 16:56:52 13514 [Note] InnoDB: The log sequence numbers 1670965 and 1670965 in ibdata files do not match the log sequence number 1670975 in the ib_logfiles! 2013-08-10 16:56:52 13514 [Note] InnoDB: Database was not shutdown normally! 2013-08-10 16:56:52 13514 [Note] InnoDB: Starting crash recovery. 2013-08-10 16:56:52 13514 [Note] InnoDB: Reading tablespace information from the .ibd files... 2013-08-10 16:56:52 13514 [Note] InnoDB: Restoring possible half-written data pages 2013-08-10 16:56:52 13514 [Note] InnoDB: from the doublewrite buffer... InnoDB: Last MySQL binlog file position 0 1272, file name mysql-bin.000001 2013-08-10 16:56:52 13514 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-10 16:56:52 13514 [Note] InnoDB: Waiting for purge to start 2013-08-10 16:56:53 13514 [Note] InnoDB: 5.6.12 started; log sequence number 1670975 2013-08-10 16:56:53 13514 [Note] Recovering after a crash using /var/lib/mysql/data/mysql-bin 2013-08-10 16:56:53 13514 [Note] Starting crash recovery... 2013-08-10 16:56:53 13514 [Note] Crash recovery finished. 2013-08-10 16:56:53 13514 [Note] Server hostname (bind-address): '*'; port: 3306 2013-08-10 16:56:53 13514 [Note] IPv6 is available. 2013-08-10 16:56:53 13514 [Note] - '::' resolves to '::'; 2013-08-10 16:56:53 13514 [Note] Server socket created on IP: '::'. 2013-08-10 16:56:53 13514 [Warning] 'proxies_priv' entry '@ root@localhost.localdomain' ignored in --skip-name-resolve mode. 2013-08-10 16:56:53 13514 [Note] Event Scheduler: Loaded 0 events 2013-08-10 16:56:53 13514 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.12-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 20:56:53 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=1 max_threads=10000 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3983660 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2c28df0 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 = 7fd8f0128e48 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8c70d5] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x65cbe4] /lib64/libpthread.so.0[0x3d2440f500] /usr/sbin/mysqld[0x983822] /usr/sbin/mysqld[0x8e5a58] /usr/sbin/mysqld[0x8dd649] /usr/sbin/mysqld(_ZN7handler14ha_index_firstEPh+0x9c)[0x59ff7c] /usr/sbin/mysqld(_Z15join_read_firstP13st_join_table+0x81)[0x6b5b01] /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x15d)[0x6b67ad] /usr/sbin/mysqld(_ZN4JOIN4execEv+0x2aa)[0x6b701a] /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x250)[0x6f7770] /usr/sbin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x187)[0x6f7fe7] /usr/sbin/mysqld[0x6d448d] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0xb46)[0x6d63e6] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x32f)[0x6da5ff] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xe0c)[0x6db4fc] /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0xcf)[0x6a90ff] /usr/sbin/mysqld(handle_one_connection+0x47)[0x6a9227] /lib64/libpthread.so.0[0x3d24407851] /lib64/libc.so.6(clone+0x6d)[0x3d23ce890d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fd8c4004be0): is an invalid pointer Connection ID (thread ID): 1 Status: NOT_KILLED 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. 130810 16:56:53 mysqld_safe Number of processes running now: 0 130810 16:56:53 mysqld_safe mysqld restarted 2013-08-10 16:56:53 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-08-10 16:56:53 13552 [Note] Plugin 'FEDERATED' is disabled. 2013-08-10 16:56:53 13552 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-10 16:56:53 13552 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-10 16:56:53 13552 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-10 16:56:53 13552 [Note] InnoDB: Using Linux native AIO 2013-08-10 16:56:53 13552 [Note] InnoDB: Using CPU crc32 instructions 2013-08-10 16:56:53 13552 [Note] InnoDB: Initializing buffer pool, size = 256.0M 2013-08-10 16:56:53 13552 [Note] InnoDB: Completed initialization of buffer pool 2013-08-10 16:56:53 13552 [Note] InnoDB: Highest supported file format is Barracuda. 2013-08-10 16:56:53 13552 [Note] InnoDB: The log sequence numbers 1670965 and 1670965 in ibdata files do not match the log sequence number 1670975 in the ib_logfiles! 2013-08-10 16:56:53 13552 [Note] InnoDB: Database was not shutdown normally! 2013-08-10 16:56:53 13552 [Note] InnoDB: Starting crash recovery. 2013-08-10 16:56:53 13552 [Note] InnoDB: Reading tablespace information from the .ibd files... 2013-08-10 16:56:53 13552 [Note] InnoDB: Restoring possible half-written data pages 2013-08-10 16:56:53 13552 [Note] InnoDB: from the doublewrite buffer... InnoDB: Last MySQL binlog file position 0 1272, file name mysql-bin.000001 2013-08-10 16:56:53 13552 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-10 16:56:53 13552 [Note] InnoDB: Waiting for purge to start 2013-08-10 16:56:54 13552 [Note] InnoDB: 5.6.12 started; log sequence number 1670975 2013-08-10 16:56:54 13552 [Note] Recovering after a crash using /var/lib/mysql/data/mysql-bin 2013-08-10 16:56:54 13552 [Note] Starting crash recovery... 2013-08-10 16:56:54 13552 [Note] Crash recovery finished. 2013-08-10 16:56:54 13552 [Note] Server hostname (bind-address): '*'; port: 3306 2013-08-10 16:56:54 13552 [Note] IPv6 is available. 2013-08-10 16:56:54 13552 [Note] - '::' resolves to '::'; 2013-08-10 16:56:54 13552 [Note] Server socket created on IP: '::'. 2013-08-10 16:56:54 13552 [Warning] 'proxies_priv' entry '@ root@localhost.localdomain' ignored in --skip-name-resolve mode. 2013-08-10 16:56:54 13552 [Note] Event Scheduler: Loaded 0 events 2013-08-10 16:56:54 13552 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.12-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 20:56:54 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=1 max_threads=10000 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3983660 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x3a47150 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 = 7eff5c436e48 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8c70d5] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x65cbe4] /lib64/libpthread.so.0[0x3d2440f500] /usr/sbin/mysqld[0x983822] /usr/sbin/mysqld[0x8e5a58] /usr/sbin/mysqld[0x8dd649] /usr/sbin/mysqld(_ZN7handler14ha_index_firstEPh+0x9c)[0x59ff7c] /usr/sbin/mysqld(_Z15join_read_firstP13st_join_table+0x81)[0x6b5b01] /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x15d)[0x6b67ad] /usr/sbin/mysqld(_ZN4JOIN4execEv+0x2aa)[0x6b701a] /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x250)[0x6f7770] /usr/sbin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x187)[0x6f7fe7] /usr/sbin/mysqld[0x6d448d] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0xb46)[0x6d63e6] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x32f)[0x6da5ff] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xe0c)[0x6db4fc] /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0xcf)[0x6a90ff] /usr/sbin/mysqld(handle_one_connection+0x47)[0x6a9227] /lib64/libpthread.so.0[0x3d24407851] /lib64/libc.so.6(clone+0x6d)[0x3d23ce890d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7eff34004be0): is an invalid pointer Connection ID (thread ID): 1 Status: NOT_KILLED 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. 130810 16:56:54 mysqld_safe Number of processes running now: 0 130810 16:56:54 mysqld_safe mysqld restarted 2013-08-10 16:56:54 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-08-10 16:56:54 13590 [Note] Plugin 'FEDERATED' is disabled. 2013-08-10 16:56:54 13590 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-10 16:56:54 13590 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-10 16:56:54 13590 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-10 16:56:54 13590 [Note] InnoDB: Using Linux native AIO 2013-08-10 16:56:54 13590 [Note] InnoDB: Using CPU crc32 instructions 2013-08-10 16:56:54 13590 [Note] InnoDB: Initializing buffer pool, size = 256.0M 2013-08-10 16:56:54 13590 [Note] InnoDB: Completed initialization of buffer pool 2013-08-10 16:56:54 13590 [Note] InnoDB: Highest supported file format is Barracuda. 2013-08-10 16:56:54 13590 [Note] InnoDB: The log sequence numbers 1670965 and 1670965 in ibdata files do not match the log sequence number 1670975 in the ib_logfiles! 2013-08-10 16:56:54 13590 [Note] InnoDB: Database was not shutdown normally! 2013-08-10 16:56:54 13590 [Note] InnoDB: Starting crash recovery. 2013-08-10 16:56:54 13590 [Note] InnoDB: Reading tablespace information from the .ibd files... 2013-08-10 16:56:54 13590 [Note] InnoDB: Restoring possible half-written data pages 2013-08-10 16:56:54 13590 [Note] InnoDB: from the doublewrite buffer... InnoDB: Last MySQL binlog file position 0 1272, file name mysql-bin.000001 2013-08-10 16:56:55 13590 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-10 16:56:55 13590 [Note] InnoDB: Waiting for purge to start 2013-08-10 16:56:55 13590 [Note] InnoDB: 5.6.12 started; log sequence number 1670975 2013-08-10 16:56:55 13590 [Note] Recovering after a crash using /var/lib/mysql/data/mysql-bin 2013-08-10 16:56:55 13590 [Note] Starting crash recovery... 2013-08-10 16:56:55 13590 [Note] Crash recovery finished. 2013-08-10 16:56:55 13590 [Note] Server hostname (bind-address): '*'; port: 3306 2013-08-10 16:56:55 13590 [Note] IPv6 is available. 2013-08-10 16:56:55 13590 [Note] - '::' resolves to '::'; 2013-08-10 16:56:55 13590 [Note] Server socket created on IP: '::'. 2013-08-10 16:56:55 13590 [Warning] 'proxies_priv' entry '@ root@localhost.localdomain' ignored in --skip-name-resolve mode. 2013-08-10 16:56:55 13590 [Note] Event Scheduler: Loaded 0 events 2013-08-10 16:56:55 13590 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.12-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 20:56:56 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=1 max_threads=10000 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3983660 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x251ae00 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 = 7fde6043fe48 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8c70d5] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x65cbe4] /lib64/libpthread.so.0[0x3d2440f500] /usr/sbin/mysqld[0x983822] /usr/sbin/mysqld[0x8e5a58] /usr/sbin/mysqld[0x8dd649] /usr/sbin/mysqld(_ZN7handler14ha_index_firstEPh+0x9c)[0x59ff7c] /usr/sbin/mysqld(_Z15join_read_firstP13st_join_table+0x81)[0x6b5b01] /usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x15d)[0x6b67ad] /usr/sbin/mysqld(_ZN4JOIN4execEv+0x2aa)[0x6b701a] /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x250)[0x6f7770] /usr/sbin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x187)[0x6f7fe7] /usr/sbin/mysqld[0x6d448d] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0xb46)[0x6d63e6] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x32f)[0x6da5ff] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xe0c)[0x6db4fc] /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0xcf)[0x6a90ff] /usr/sbin/mysqld(handle_one_connection+0x47)[0x6a9227] /lib64/libpthread.so.0[0x3d24407851] /lib64/libc.so.6(clone+0x6d)[0x3d23ce890d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fde34004be0): is an invalid pointer Connection ID (thread ID): 1 Status: NOT_KILLED 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. 130810 16:56:56 mysqld_safe Number of processes running now: 0 130810 16:56:56 mysqld_safe mysqld restarted 2013-08-10 16:56:56 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-08-10 16:56:56 13628 [Note] Plugin 'FEDERATED' is disabled. 2013-08-10 16:56:56 13628 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-10 16:56:56 13628 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-10 16:56:56 13628 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-10 16:56:56 13628 [Note] InnoDB: Using Linux native AIO 2013-08-10 16:56:56 13628 [Note] InnoDB: Using CPU crc32 instructions 2013-08-10 16:56:56 13628 [Note] InnoDB: Initializing buffer pool, size = 256.0M 2013-08-10 16:56:56 13628 [Note] InnoDB: Completed initialization of buffer pool 2013-08-10 16:56:56 13628 [Note] InnoDB: Highest supported file format is Barracuda. 2013-08-10 16:56:56 13628 [Note] InnoDB: The log sequence numbers 1670965 and 1670965 in ibdata files do not match the log sequence number 1670975 in the ib_logfiles! 2013-08-10 16:56:56 13628 [Note] InnoDB: Database was not shutdown normally! 2013-08-10 16:56:56 13628 [Note] InnoDB: Starting crash recovery. 2013-08-10 16:56:56 13628 [Note] InnoDB: Reading tablespace information from the .ibd files... 2013-08-10 16:56:56 13628 [Note] InnoDB: Restoring possible half-written data pages 2013-08-10 16:56:56 13628 [Note] InnoDB: from the doublewrite buffer... InnoDB: Last MySQL binlog file position 0 1272, file name mysql-bin.000001 2013-08-10 16:56:56 13628 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-10 16:56:56 13628 [Note] InnoDB: Waiting for purge to start 2013-08-10 16:56:56 13628 [Note] InnoDB: 5.6.12 started; log sequence number 1670975 2013-08-10 16:56:56 13628 [Note] Recovering after a crash using /var/lib/mysql/data/mysql-bin 2013-08-10 16:56:56 13628 [Note] Starting crash recovery... 2013-08-10 16:56:56 13628 [Note] Crash recovery finished. 2013-08-10 16:56:56 13628 [Note] Server hostname (bind-address): '*'; port: 3306 2013-08-10 16:56:56 13628 [Note] IPv6 is available. 2013-08-10 16:56:56 13628 [Note] - '::' resolves to '::'; 2013-08-10 16:56:56 13628 [Note] Server socket created on IP: '::'. 2013-08-10 16:56:56 13628 [Warning] 'proxies_priv' entry '@ root@localhost.localdomain' ignored in --skip-name-resolve mode. 2013-08-10 16:56:56 13628 [Note] Event Scheduler: Loaded 0 events 2013-08-10 16:56:56 13628 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.12-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-08-10 17:03:49 7f9f48231700 InnoDB: Assertion failure in thread 140322086786816 in file btr0btr.cc line 693 InnoDB: Failing assertion: mach_read_from_4(seg_header + FSEG_HDR_SPACE) == space InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 21:03:49 UTC - mysqld got signal 6 ; 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=1 max_threads=10000 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3983660 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x3872970 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 = 7f9f48230e48 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8c70d5] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x65cbe4] /lib64/libpthread.so.0[0x3d2440f500] /lib64/libc.so.6(gsignal+0x35)[0x3d23c328a5] /lib64/libc.so.6(abort+0x175)[0x3d23c34085] /usr/sbin/mysqld[0x9c5c31] /usr/sbin/mysqld[0x9c631f] /usr/sbin/mysqld[0xa036ce] /usr/sbin/mysqld[0x98a2c0] /usr/sbin/mysqld[0x98b701] /usr/sbin/mysqld[0x94bd18] /usr/sbin/mysqld[0x94c225] /usr/sbin/mysqld[0x9726b8] /usr/sbin/mysqld[0x8ed21b] /usr/sbin/mysqld(_Z15ha_delete_tableP3THDP10handlertonPKcS4_S4_b+0xbe)[0x5a76de] /usr/sbin/mysqld(_Z23mysql_rm_table_no_locksP3THDP10TABLE_LISTbbbb+0xd12)[0x723f12] /usr/sbin/mysqld(_Z14mysql_rm_tableP3THDP10TABLE_LISTcc+0x16d)[0x724e9d] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x22ae)[0x6d7b4e] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x32f)[0x6da5ff] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xe0c)[0x6db4fc] /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0xcf)[0x6a90ff] /usr/sbin/mysqld(handle_one_connection+0x47)[0x6a9227] /lib64/libpthread.so.0[0x3d24407851] /lib64/libc.so.6(clone+0x6d)[0x3d23ce890d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f9f10004be0): is an invalid pointer Connection ID (thread ID): 1 Status: NOT_KILLED 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. 130810 17:03:49 mysqld_safe Number of processes running now: 0 130810 17:03:49 mysqld_safe mysqld restarted 2013-08-10 17:03:49 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-08-10 17:03:49 13717 [Note] Plugin 'FEDERATED' is disabled. 2013-08-10 17:03:49 13717 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-10 17:03:49 13717 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-10 17:03:49 13717 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-10 17:03:49 13717 [Note] InnoDB: Using Linux native AIO 2013-08-10 17:03:49 13717 [Note] InnoDB: Using CPU crc32 instructions 2013-08-10 17:03:49 13717 [Note] InnoDB: Initializing buffer pool, size = 256.0M 2013-08-10 17:03:49 13717 [Note] InnoDB: Completed initialization of buffer pool 2013-08-10 17:03:49 13717 [Note] InnoDB: Highest supported file format is Barracuda. 2013-08-10 17:03:49 13717 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1670985 2013-08-10 17:03:49 13717 [Note] InnoDB: Database was not shutdown normally! 2013-08-10 17:03:49 13717 [Note] InnoDB: Starting crash recovery. 2013-08-10 17:03:49 13717 [Note] InnoDB: Reading tablespace information from the .ibd files... 2013-08-10 17:03:49 13717 [Note] InnoDB: Restoring possible half-written data pages 2013-08-10 17:03:49 13717 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 1673811 2013-08-10 17:03:49 13717 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 50 51 52 53 54 55 56 57 58 59 60 61 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 1272, file name mysql-bin.000001 2013-08-10 17:03:50 13717 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-10 17:03:50 13717 [Note] InnoDB: Waiting for purge to start 2013-08-10 17:03:50 13717 [Note] InnoDB: 5.6.12 started; log sequence number 1673811 2013-08-10 17:03:50 13717 [Note] Recovering after a crash using /var/lib/mysql/data/mysql-bin 2013-08-10 17:03:50 13717 [Note] Starting crash recovery... 2013-08-10 17:03:50 13717 [Note] Crash recovery finished. 2013-08-10 17:03:50 13717 [Note] Server hostname (bind-address): '*'; port: 3306 2013-08-10 17:03:50 13717 [Note] IPv6 is available. 2013-08-10 17:03:50 13717 [Note] - '::' resolves to '::'; 2013-08-10 17:03:50 13717 [Note] Server socket created on IP: '::'. 2013-08-10 17:03:50 13717 [Warning] 'proxies_priv' entry '@ root@localhost.localdomain' ignored in --skip-name-resolve mode. 2013-08-10 17:03:50 13717 [Note] Event Scheduler: Loaded 0 events 2013-08-10 17:03:50 13717 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.12-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) InnoDB: flag mismatch in space 6 page 4 index id of table test/test_it 2013-08-10 17:05:16 7f932bfff700 InnoDB: Page dump in ascii and hex (16384 bytes): len 16384; hex 00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000; asc ; InnoDB: End of page dump 2013-08-10 17:05:16 7f932bfff700 InnoDB: uncompressed page, stored checksum in field1 0, calculated checksums for field1: crc32 536728786, innodb 1575996416, none 3735928559, stored checksum in field2 0, calculated checksums for field2: crc32 536728786, innodb 1371122432, none 3735928559, page LSN 0 0, low 4 bytes of LSN at page end 0, page number (if stored to page already) 0, space id (if created with >= MySQL-4.1.1 and stored already) 0 InnoDB: Page may be a freshly allocated page 2013-08-10 17:05:16 7f932bfff700 InnoDB: Assertion failure in thread 140270075115264 in file btr0btr.cc line 722 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 21:05:16 UTC - mysqld got signal 6 ; 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=1 max_threads=10000 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3983660 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x31c1e50 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 = 7f932bffee48 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8c70d5] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x65cbe4] /lib64/libpthread.so.0[0x3d2440f500] /lib64/libc.so.6(gsignal+0x35)[0x3d23c328a5] /lib64/libc.so.6(abort+0x175)[0x3d23c34085] /usr/sbin/mysqld[0x9c65b2] /usr/sbin/mysqld[0x9c6899] /usr/sbin/mysqld[0xa22406] /usr/sbin/mysqld[0xa247fa] /usr/sbin/mysqld[0xa248e5] /usr/sbin/mysqld[0x8ef839] /usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcii+0x3e)[0x5a31be] /usr/sbin/mysqld(_Z21open_table_from_shareP3THDP11TABLE_SHAREPKcjjjP5TABLEb+0x624)[0x75f764] /usr/sbin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0x1eb)[0x692c4b] /usr/sbin/mysqld(_Z11open_tablesP3THDPP10TABLE_LISTPjjP19Prelocking_strategy+0xcaa)[0x69541a] /usr/sbin/mysqld(_Z30open_normal_and_derived_tablesP3THDP10TABLE_LISTj+0x4f)[0x69553f] /usr/sbin/mysqld(_Z18mysqld_list_fieldsP3THDP10TABLE_LISTPKc+0x25)[0x70ca55] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1baf)[0x6dc29f] /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0xcf)[0x6a90ff] /usr/sbin/mysqld(handle_one_connection+0x47)[0x6a9227] /lib64/libpthread.so.0[0x3d24407851] /lib64/libc.so.6(clone+0x6d)[0x3d23ce890d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f9320004c10): is an invalid pointer Connection ID (thread ID): 1 Status: NOT_KILLED 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. 130810 17:05:16 mysqld_safe Number of processes running now: 0 130810 17:05:16 mysqld_safe mysqld restarted 2013-08-10 17:05:16 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-08-10 17:05:16 13763 [Note] Plugin 'FEDERATED' is disabled. 2013-08-10 17:05:16 13763 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-10 17:05:16 13763 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-10 17:05:16 13763 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-10 17:05:16 13763 [Note] InnoDB: Using Linux native AIO 2013-08-10 17:05:16 13763 [Note] InnoDB: Using CPU crc32 instructions 2013-08-10 17:05:16 13763 [Note] InnoDB: Initializing buffer pool, size = 256.0M 2013-08-10 17:05:16 13763 [Note] InnoDB: Completed initialization of buffer pool 2013-08-10 17:05:16 13763 [Note] InnoDB: Highest supported file format is Barracuda. 2013-08-10 17:05:16 13763 [Note] InnoDB: The log sequence numbers 1670965 and 1670965 in ibdata files do not match the log sequence number 1674001 in the ib_logfiles! 2013-08-10 17:05:16 13763 [Note] InnoDB: Database was not shutdown normally! 2013-08-10 17:05:16 13763 [Note] InnoDB: Starting crash recovery. 2013-08-10 17:05:16 13763 [Note] InnoDB: Reading tablespace information from the .ibd files... 2013-08-10 17:05:16 13763 [Note] InnoDB: Restoring possible half-written data pages 2013-08-10 17:05:16 13763 [Note] InnoDB: from the doublewrite buffer... InnoDB: Last MySQL binlog file position 0 1272, file name mysql-bin.000001 2013-08-10 17:05:17 13763 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-10 17:05:17 13763 [Note] InnoDB: Waiting for purge to start 2013-08-10 17:05:17 13763 [Note] InnoDB: 5.6.12 started; log sequence number 1674001 2013-08-10 17:05:17 13763 [Note] Recovering after a crash using /var/lib/mysql/data/mysql-bin 2013-08-10 17:05:17 13763 [Note] Starting crash recovery... 2013-08-10 17:05:17 13763 [Note] Crash recovery finished. 2013-08-10 17:05:17 13763 [Note] Server hostname (bind-address): '*'; port: 3306 2013-08-10 17:05:17 13763 [Note] IPv6 is available. 2013-08-10 17:05:17 13763 [Note] - '::' resolves to '::'; 2013-08-10 17:05:17 13763 [Note] Server socket created on IP: '::'. 2013-08-10 17:05:17 13763 [Warning] 'proxies_priv' entry '@ root@localhost.localdomain' ignored in --skip-name-resolve mode. 2013-08-10 17:05:17 13763 [Note] Event Scheduler: Loaded 0 events 2013-08-10 17:05:17 13763 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.12-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) InnoDB: flag mismatch in space 6 page 4 index id of table test/test_it 2013-08-10 17:06:40 7f7a5968d700 InnoDB: Page dump in ascii and hex (16384 bytes): len 16384; hex 00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000; asc ; InnoDB: End of page dump 2013-08-10 17:06:40 7f7a5968d700 InnoDB: uncompressed page, stored checksum in field1 0, calculated checksums for field1: crc32 536728786, innodb 1575996416, none 3735928559, stored checksum in field2 0, calculated checksums for field2: crc32 536728786, innodb 1371122432, none 3735928559, page LSN 0 0, low 4 bytes of LSN at page end 0, page number (if stored to page already) 0, space id (if created with >= MySQL-4.1.1 and stored already) 0 InnoDB: Page may be a freshly allocated page 2013-08-10 17:06:40 7f7a5968d700 InnoDB: Assertion failure in thread 140163462780672 in file btr0btr.cc line 722 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 21:06:40 UTC - mysqld got signal 6 ; 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=1 max_threads=10000 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3983660 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2164a40 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 = 7f7a5968ce48 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8c70d5] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x65cbe4] /lib64/libpthread.so.0[0x3d2440f500] /lib64/libc.so.6(gsignal+0x35)[0x3d23c328a5] /lib64/libc.so.6(abort+0x175)[0x3d23c34085] /usr/sbin/mysqld[0x9c65b2] /usr/sbin/mysqld[0x9c6899] /usr/sbin/mysqld[0xa22406] /usr/sbin/mysqld[0xa247fa] /usr/sbin/mysqld[0xa248e5] /usr/sbin/mysqld[0x8ef839] /usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcii+0x3e)[0x5a31be] /usr/sbin/mysqld(_Z21open_table_from_shareP3THDP11TABLE_SHAREPKcjjjP5TABLEb+0x624)[0x75f764] /usr/sbin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0x1eb)[0x692c4b] /usr/sbin/mysqld(_Z11open_tablesP3THDPP10TABLE_LISTPjjP19Prelocking_strategy+0xcaa)[0x69541a] /usr/sbin/mysqld(_Z30open_normal_and_derived_tablesP3THDP10TABLE_LISTj+0x4f)[0x69553f] /usr/sbin/mysqld(_Z18mysqld_list_fieldsP3THDP10TABLE_LISTPKc+0x25)[0x70ca55] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1baf)[0x6dc29f] /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0xcf)[0x6a90ff] /usr/sbin/mysqld(handle_one_connection+0x47)[0x6a9227] /lib64/libpthread.so.0[0x3d24407851] /lib64/libc.so.6(clone+0x6d)[0x3d23ce890d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f7a3c004c10): is an invalid pointer Connection ID (thread ID): 1 Status: NOT_KILLED 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. 130810 17:06:40 mysqld_safe Number of processes running now: 0 130810 17:06:40 mysqld_safe mysqld restarted 2013-08-10 17:06:40 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-08-10 17:06:40 13807 [Note] Plugin 'FEDERATED' is disabled. 2013-08-10 17:06:40 13807 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-10 17:06:40 13807 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-10 17:06:40 13807 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-10 17:06:40 13807 [Note] InnoDB: Using Linux native AIO 2013-08-10 17:06:40 13807 [Note] InnoDB: Using CPU crc32 instructions 2013-08-10 17:06:40 13807 [Note] InnoDB: Initializing buffer pool, size = 256.0M 2013-08-10 17:06:40 13807 [Note] InnoDB: Completed initialization of buffer pool 2013-08-10 17:06:40 13807 [Note] InnoDB: Highest supported file format is Barracuda. 2013-08-10 17:06:40 13807 [Note] InnoDB: The log sequence numbers 1670965 and 1670965 in ibdata files do not match the log sequence number 1674011 in the ib_logfiles! 2013-08-10 17:06:40 13807 [Note] InnoDB: Database was not shutdown normally! 2013-08-10 17:06:40 13807 [Note] InnoDB: Starting crash recovery. 2013-08-10 17:06:40 13807 [Note] InnoDB: Reading tablespace information from the .ibd files... 2013-08-10 17:06:40 13807 [Note] InnoDB: Restoring possible half-written data pages 2013-08-10 17:06:40 13807 [Note] InnoDB: from the doublewrite buffer... InnoDB: Last MySQL binlog file position 0 1272, file name mysql-bin.000001 2013-08-10 17:06:40 13807 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-10 17:06:40 13807 [Note] InnoDB: Waiting for purge to start 2013-08-10 17:06:40 13807 [Note] InnoDB: 5.6.12 started; log sequence number 1674011 2013-08-10 17:06:40 13807 [Note] Recovering after a crash using /var/lib/mysql/data/mysql-bin 2013-08-10 17:06:40 13807 [Note] Starting crash recovery... 2013-08-10 17:06:40 13807 [Note] Crash recovery finished. 2013-08-10 17:06:40 13807 [Note] Server hostname (bind-address): '*'; port: 3306 2013-08-10 17:06:40 13807 [Note] IPv6 is available. 2013-08-10 17:06:40 13807 [Note] - '::' resolves to '::'; 2013-08-10 17:06:40 13807 [Note] Server socket created on IP: '::'. 2013-08-10 17:06:40 13807 [Warning] 'proxies_priv' entry '@ root@localhost.localdomain' ignored in --skip-name-resolve mode. 2013-08-10 17:06:40 13807 [Note] Event Scheduler: Loaded 0 events 2013-08-10 17:06:40 13807 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.12-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)