130808 06:21:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2013-08-08 06:21:33 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-08-08 06:21:33 3160 [Note] Plugin 'FEDERATED' is disabled. 2013-08-08 06:21:33 3160 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-08 06:21:33 3160 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-08 06:21:33 3160 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-08 06:21:33 3160 [Note] InnoDB: Using Linux native AIO 2013-08-08 06:21:33 3160 [Note] InnoDB: Not using CPU crc32 instructions 2013-08-08 06:21:33 3160 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2013-08-08 06:21:33 3160 [Note] InnoDB: Completed initialization of buffer pool 2013-08-08 06:21:33 3160 [Note] InnoDB: Highest supported file format is Barracuda. 2013-08-08 06:21:33 3160 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-08 06:21:33 3160 [Note] InnoDB: Waiting for purge to start 2013-08-08 06:21:33 3160 [Note] InnoDB: 5.6.12 started; log sequence number 1625987 2013-08-08 06:21:33 3160 [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: dc9f26ec-ffc8-11e2-8175-080027d5492c. 2013-08-08 06:21:33 3160 [Note] Server hostname (bind-address): '*'; port: 3306 2013-08-08 06:21:33 3160 [Note] IPv6 is available. 2013-08-08 06:21:33 3160 [Note] - '::' resolves to '::'; 2013-08-08 06:21:33 3160 [Note] Server socket created on IP: '::'. 2013-08-08 06:21:33 3160 [Note] Event Scheduler: Loaded 0 events 2013-08-08 06:21:33 3160 [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-08 06:34:22 3160 [Note] /usr/sbin/mysqld: Normal shutdown 2013-08-08 06:34:22 3160 [Note] Giving 0 client threads a chance to die gracefully 2013-08-08 06:34:22 3160 [Note] Event Scheduler: Purging the queue. 0 events 2013-08-08 06:34:22 3160 [Note] Shutting down slave threads 2013-08-08 06:34:22 3160 [Note] Forcefully disconnecting 0 remaining clients 2013-08-08 06:34:22 3160 [Note] Binlog end 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'partition' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'ARCHIVE' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'BLACKHOLE' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_METRICS' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_CMP' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'INNODB_TRX' 2013-08-08 06:34:22 3160 [Note] Shutting down plugin 'InnoDB' 2013-08-08 06:34:22 3160 [Note] InnoDB: FTS optimize thread exiting. 2013-08-08 06:34:22 3160 [Note] InnoDB: Starting shutdown... 2013-08-08 06:34:24 3160 [Note] InnoDB: Shutdown completed; log sequence number 1625997 2013-08-08 06:34:24 3160 [Note] Shutting down plugin 'MRG_MYISAM' 2013-08-08 06:34:24 3160 [Note] Shutting down plugin 'CSV' 2013-08-08 06:34:24 3160 [Note] Shutting down plugin 'MEMORY' 2013-08-08 06:34:24 3160 [Note] Shutting down plugin 'MyISAM' 2013-08-08 06:34:24 3160 [Note] Shutting down plugin 'sha256_password' 2013-08-08 06:34:24 3160 [Note] Shutting down plugin 'mysql_old_password' 2013-08-08 06:34:24 3160 [Note] Shutting down plugin 'mysql_native_password' 2013-08-08 06:34:24 3160 [Note] Shutting down plugin 'binlog' 2013-08-08 06:34:24 3160 [Note] /usr/sbin/mysqld: Shutdown complete 130808 06:34:24 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended 130808 06:34:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2013-08-08 06:34: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-08 06:34:25 4203 [Warning] Buffered warning: option 'max_connections': unsigned value 0 adjusted to 1 2013-08-08 06:34:25 4203 [Note] Plugin 'FEDERATED' is disabled. 2013-08-08 06:34:25 4203 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-08 06:34:25 4203 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-08 06:34:25 4203 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-08 06:34:25 4203 [Note] InnoDB: Using Linux native AIO 2013-08-08 06:34:25 4203 [Note] InnoDB: Not using CPU crc32 instructions 2013-08-08 06:34:25 4203 [Note] InnoDB: Initializing buffer pool, size = 256.0M 2013-08-08 06:34:25 4203 [Note] InnoDB: Completed initialization of buffer pool 2013-08-08 06:34:25 4203 [Note] InnoDB: Highest supported file format is Barracuda. 2013-08-08 06:34:25 4203 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*4096 pages, LSN=1625997 2013-08-08 06:34:25 4203 [Warning] InnoDB: Starting to delete and rewrite log files. 2013-08-08 06:34:25 4203 [Note] InnoDB: Setting log file ./ib_logfile101 size to 64 MB 2013-08-08 06:34:25 4203 [Note] InnoDB: Setting log file ./ib_logfile1 size to 64 MB 2013-08-08 06:34:26 4203 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2013-08-08 06:34:26 4203 [Warning] InnoDB: New log files created, LSN=1625997 2013-08-08 06:34:26 4203 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-08 06:34:26 4203 [Note] InnoDB: Waiting for purge to start 2013-08-08 06:34:26 4203 [Note] InnoDB: 5.6.12 started; log sequence number 1625997 2013-08-08 06:34:26 4203 [Note] Server hostname (bind-address): '*'; port: 3306 2013-08-08 06:34:26 4203 [Note] IPv6 is available. 2013-08-08 06:34:26 4203 [Note] - '::' resolves to '::'; 2013-08-08 06:34:26 4203 [Note] Server socket created on IP: '::'. 2013-08-08 06:34:26 4203 [Warning] 'proxies_priv' entry '@ root@localhost.localdomain' ignored in --skip-name-resolve mode. 2013-08-08 06:34:26 4203 [Note] Event Scheduler: Loaded 0 events 2013-08-08 06:34:26 4203 [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-08 07:13:37 4203 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='localhost', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. 2013-08-08 07:13:37 4203 [Warning] Storing MySQL user name or password information in the master.info repository is not secure and is therefore not recommended. Please see the MySQL Manual for more about this issue and possible alternatives. 2013-08-08 07:13:37 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 1, Error_code: 1040 2013-08-08 07:13:37 4203 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/lib/mysql/data/mysql-relay-bin.000001' position: 4 2013-08-08 07:14:37 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 2, Error_code: 1045 2013-08-08 07:14:42 4203 [Note] Error reading relay log event: slave SQL thread was killed 2013-08-08 07:14:42 4203 [Note] Slave I/O thread killed while connecting to master 2013-08-08 07:14:42 4203 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4 2013-08-08 07:14:42 4203 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='localhost', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='localhost', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. 2013-08-08 07:14:42 4203 [Warning] Storing MySQL user name or password information in the master.info repository is not secure and is therefore not recommended. Please see the MySQL Manual for more about this issue and possible alternatives. 2013-08-08 07:14:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 1, Error_code: 1040 2013-08-08 07:14:42 4203 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/lib/mysql/data/mysql-relay-bin.000001' position: 4 2013-08-08 07:15:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 2, Error_code: 1045 2013-08-08 07:16:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 3, Error_code: 1045 2013-08-08 07:17:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 4, Error_code: 1045 2013-08-08 07:18:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 5, Error_code: 1045 2013-08-08 07:19:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 6, Error_code: 1045 2013-08-08 07:20:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 7, Error_code: 1045 2013-08-08 07:21:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 8, Error_code: 1045 2013-08-08 07:22:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 9, Error_code: 1045 2013-08-08 07:23:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 10, Error_code: 1045 2013-08-08 07:24:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 11, Error_code: 1045 2013-08-08 07:25:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 12, Error_code: 1045 2013-08-08 07:26:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 13, Error_code: 1045 2013-08-08 07:27:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 14, Error_code: 1045 2013-08-08 07:28:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 15, Error_code: 1045 2013-08-08 07:29:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 16, Error_code: 1045 2013-08-08 07:30:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 17, Error_code: 1045 2013-08-08 07:31:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 18, Error_code: 1045 2013-08-08 07:32:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 19, Error_code: 1045 2013-08-08 07:33:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 20, Error_code: 1045 2013-08-08 07:34:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 21, Error_code: 1045 2013-08-08 07:35:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 22, Error_code: 1045 2013-08-08 07:36:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 23, Error_code: 1045 2013-08-08 07:37:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 24, Error_code: 1045 2013-08-08 07:38:42 4203 [ERROR] Slave I/O: error connecting to master 'repl@localhost:3306' - retry-time: 60 retries: 25, Error_code: 1045 2013-08-08 07:39:24 4203 [Note] /usr/sbin/mysqld: Normal shutdown 2013-08-08 07:39:24 4203 [Note] Giving 4 client threads a chance to die gracefully 2013-08-08 07:39:24 4203 [Note] Event Scheduler: Purging the queue. 0 events 2013-08-08 07:39:24 4203 [Note] Shutting down slave threads 2013-08-08 07:39:24 4203 [Note] Error reading relay log event: slave SQL thread was killed 2013-08-08 07:39:24 4203 [Note] Slave I/O thread killed while connecting to master 2013-08-08 07:39:24 4203 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4 2013-08-08 07:39:24 4203 [Note] Forcefully disconnecting 0 remaining clients 2013-08-08 07:39:24 4203 [Note] Binlog end 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'partition' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'ARCHIVE' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'BLACKHOLE' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_METRICS' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_CMPMEM' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_CMP' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_LOCKS' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'INNODB_TRX' 2013-08-08 07:39:24 4203 [Note] Shutting down plugin 'InnoDB' 2013-08-08 07:39:24 4203 [Note] InnoDB: FTS optimize thread exiting. 2013-08-08 07:39:24 4203 [Note] InnoDB: Starting shutdown... 2013-08-08 07:39:26 7fc23080e700 InnoDB: Assertion failure in thread 140472014137088 in file trx0rseg.cc line 125 InnoDB: Failing assertion: UT_LIST_GET_LEN(rseg->update_undo_list) == 0 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. 02:39:26 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=2 max_threads=1 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 8589 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8c70d5] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x65cbe4] /lib64/libpthread.so.0(+0xf500)[0x7fc2344c4500] /lib64/libc.so.6(gsignal+0x35)[0x7fc23316f8a5] /lib64/libc.so.6(abort+0x175)[0x7fc233171085] /usr/sbin/mysqld[0x9ae4f8] /usr/sbin/mysqld[0x9b0939] /usr/sbin/mysqld[0x997aef] /usr/sbin/mysqld[0x8e2144] /usr/sbin/mysqld(_Z22ha_finalize_handlertonP13st_plugin_int+0x2e)[0x5a163e] /usr/sbin/mysqld[0x6e35ce] /usr/sbin/mysqld(_Z15plugin_shutdownv+0x233)[0x6e3fd3] /usr/sbin/mysqld[0x595b58] /usr/sbin/mysqld(_Z10unireg_endv+0xe)[0x595efe] /usr/sbin/mysqld[0x598de8] /usr/sbin/mysqld(kill_server_thread+0xe)[0x598f9e] /usr/sbin/mysqld(pfs_spawn_thread+0x139)[0xae79f9] /lib64/libpthread.so.0(+0x7851)[0x7fc2344bc851] /lib64/libc.so.6(clone+0x6d)[0x7fc23322590d] 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. 130808 07:39:26 mysqld_safe Number of processes running now: 0 130808 07:39:26 mysqld_safe mysqld restarted 2013-08-08 07:39: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-08 07:39:26 4667 [Warning] Buffered warning: option 'max_connections': unsigned value 0 adjusted to 1 2013-08-08 07:39:26 4667 [Note] Plugin 'FEDERATED' is disabled. 2013-08-08 07:39:26 4667 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-08 07:39:26 4667 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-08 07:39:26 4667 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-08 07:39:26 4667 [Note] InnoDB: Using Linux native AIO 2013-08-08 07:39:26 4667 [Note] InnoDB: Not using CPU crc32 instructions 2013-08-08 07:39:26 4667 [Note] InnoDB: Initializing buffer pool, size = 256.0M 2013-08-08 07:39:26 4667 [Note] InnoDB: Completed initialization of buffer pool 2013-08-08 07:39:26 4667 [Note] InnoDB: Highest supported file format is Barracuda. InnoDB: 1 transaction(s) which must be rolled back or cleaned up InnoDB: in total 2 row operations to undo InnoDB: Trx id counter is 2816 2013-08-08 07:39:26 7fac0031a720 InnoDB: Error: a record lock wait happens in a dictionary operation! InnoDB: index "CLUST_IND" of table "SYS_INDEXES". InnoDB: Submit a detailed bug report to http://bugs.mysql.com 2013-08-08 07:39:26 7fac0031a720 InnoDB: Assertion failure in thread 140376714356512 in file lock0wait.cc line 297 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. 02:39:26 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=0 max_threads=1 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 8589 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8c70d5] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x65cbe4] /lib64/libpthread.so.0(+0xf500)[0x7fac01907500] /lib64/libc.so.6(gsignal+0x35)[0x7fac005b28a5] /lib64/libc.so.6(abort+0x175)[0x7fac005b4085] /usr/sbin/mysqld[0x9171c5] /usr/sbin/mysqld[0x94bd64] /usr/sbin/mysqld[0x94c225] /usr/sbin/mysqld[0x963d97] /usr/sbin/mysqld[0x91d1b5] /usr/sbin/mysqld[0x99aad4] /usr/sbin/mysqld[0x8e311d] /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x48)[0x5a36c8] /usr/sbin/mysqld[0x6e13c1] /usr/sbin/mysqld(_Z11plugin_initPiPPci+0xb16)[0x6e4f76] /usr/sbin/mysqld[0x596921] /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x405)[0x59b4a5] /lib64/libc.so.6(__libc_start_main+0xfd)[0x7fac0059ecdd] /usr/sbin/mysqld[0x58d701] 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. 130808 07:39:26 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended 130808 07:39:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2013-08-08 07:39:27 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-08-08 07:39:27 5472 [Warning] Buffered warning: option 'max_connections': unsigned value 0 adjusted to 1 2013-08-08 07:39:27 5472 [Note] Plugin 'FEDERATED' is disabled. 2013-08-08 07:39:27 5472 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-08 07:39:27 5472 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2013-08-08 07:39:27 5472 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-08 07:39:27 5472 [Note] InnoDB: Using Linux native AIO 2013-08-08 07:39:27 5472 [Note] InnoDB: Not using CPU crc32 instructions 2013-08-08 07:39:27 5472 [Note] InnoDB: Initializing buffer pool, size = 256.0M 2013-08-08 07:39:27 5472 [Note] InnoDB: Completed initialization of buffer pool 2013-08-08 07:39:27 5472 [Note] InnoDB: Highest supported file format is Barracuda. InnoDB: 1 transaction(s) which must be rolled back or cleaned up InnoDB: in total 2 row operations to undo InnoDB: Trx id counter is 2816 2013-08-08 07:39:27 7fa161fec720 InnoDB: Error: a record lock wait happens in a dictionary operation! InnoDB: index "CLUST_IND" of table "SYS_INDEXES". InnoDB: Submit a detailed bug report to http://bugs.mysql.com 2013-08-08 07:39:27 7fa161fec720 InnoDB: Assertion failure in thread 140331110549280 in file lock0wait.cc line 297 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. 02:39:27 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=0 max_threads=1 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 8589 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8c70d5] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x65cbe4] /lib64/libpthread.so.0(+0xf500)[0x7fa1635d9500] /lib64/libc.so.6(gsignal+0x35)[0x7fa1622848a5] /lib64/libc.so.6(abort+0x175)[0x7fa162286085] /usr/sbin/mysqld[0x9171c5] /usr/sbin/mysqld[0x94bd64] /usr/sbin/mysqld[0x94c225] /usr/sbin/mysqld[0x963d97] /usr/sbin/mysqld[0x91d1b5] /usr/sbin/mysqld[0x99aad4] /usr/sbin/mysqld[0x8e311d] /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x48)[0x5a36c8] /usr/sbin/mysqld[0x6e13c1] /usr/sbin/mysqld(_Z11plugin_initPiPPci+0xb16)[0x6e4f76] /usr/sbin/mysqld[0x596921] /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x405)[0x59b4a5] /lib64/libc.so.6(__libc_start_main+0xfd)[0x7fa162270cdd] /usr/sbin/mysqld[0x58d701] 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. 130808 07:39:27 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended