Feb 17 10:45:35 server01 mysqld: 130217 10:45:35 InnoDB: Assertion failure in thread 140339814749952 in file row0mysql.c line 3685 Feb 17 10:45:35 server01 mysqld: InnoDB: Failing assertion: table Feb 17 10:45:35 server01 mysqld: InnoDB: We intentionally generate a memory trap. Feb 17 10:45:35 server01 mysqld: InnoDB: Submit a detailed bug report to http://bugs.mysql.com. Feb 17 10:45:35 server01 mysqld: InnoDB: If you get repeated assertion failures or crashes, even Feb 17 10:45:35 server01 mysqld: InnoDB: immediately after the mysqld startup, there may be Feb 17 10:45:35 server01 mysqld: InnoDB: corruption in the InnoDB tablespace. Please refer to Feb 17 10:45:35 server01 mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html Feb 17 10:45:35 server01 mysqld: InnoDB: about forcing recovery. Feb 17 10:45:35 server01 mysqld: Feb 17 10:45:35 server01 mysqld: Memory status: Feb 17 10:45:35 server01 mysqld: Non-mmapped space allocated from system: 32076944 Feb 17 10:45:35 server01 mysqld: Number of free chunks:#011#011#011 7 Feb 17 10:45:35 server01 mysqld: Number of fastbin blocks:#011#011 0 Feb 17 10:45:35 server01 mysqld: Number of mmapped regions:#011#011 18 Feb 17 10:45:35 server01 mysqld: Space in mmapped regions:#011#011 -1851191296 Feb 17 10:45:35 server01 mysqld: Maximum total allocated space:#011#011 0 Feb 17 10:45:35 server01 mysqld: Space available in freed fastbin blocks: 0 Feb 17 10:45:35 server01 mysqld: Total allocated space:#011#011#011 31584848 Feb 17 10:45:35 server01 mysqld: Total free space:#011#011#011 492096 Feb 17 10:45:35 server01 mysqld: Top-most, releasable space:#011#011 130704 Feb 17 10:45:35 server01 mysqld: Estimated memory (with thread stack): -1818327920 Feb 17 10:45:35 server01 mysqld: Feb 17 10:45:35 server01 mysqld: Feb 17 10:45:35 server01 mysqld: Feb 17 10:45:35 server01 mysqld: Events status: Feb 17 10:45:35 server01 mysqld: LLA = Last Locked At LUA = Last Unlocked At Feb 17 10:45:35 server01 mysqld: WOC = Waiting On Condition DL = Data Locked Feb 17 10:45:35 server01 mysqld: Feb 17 10:45:35 server01 mysqld: Event scheduler status: Feb 17 10:45:35 server01 mysqld: State : INITIALIZED Feb 17 10:45:35 server01 mysqld: Thread id : 0 Feb 17 10:45:35 server01 mysqld: LLA : n/a:0 Feb 17 10:45:35 server01 mysqld: LUA : n/a:0 Feb 17 10:45:35 server01 mysqld: WOC : NO Feb 17 10:45:35 server01 mysqld: Workers : 0 Feb 17 10:45:35 server01 mysqld: Executed : 0 Feb 17 10:45:35 server01 mysqld: Data locked: NO Feb 17 10:45:35 server01 mysqld: Feb 17 10:45:35 server01 mysqld: Event queue status: Feb 17 10:45:35 server01 mysqld: Element count : 0 Feb 17 10:45:35 server01 mysqld: Data locked : NO Feb 17 10:45:35 server01 mysqld: Attempting lock : NO Feb 17 10:45:35 server01 mysqld: LLA : init_queue:139 Feb 17 10:45:35 server01 mysqld: LUA : init_queue:149 Feb 17 10:45:35 server01 mysqld: WOC : NO Feb 17 10:45:35 server01 mysqld: Next activation : never Feb 17 10:45:35 server01 mysqld: 09:45:35 UTC - mysqld got signal 6 ; Feb 17 10:45:35 server01 mysqld: This could be because you hit a bug. It is also possible that this binary Feb 17 10:45:35 server01 mysqld: or one of the libraries it was linked against is corrupt, improperly built, Feb 17 10:45:35 server01 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware. Feb 17 10:45:35 server01 mysqld: We will try our best to scrape up some info that will hopefully help Feb 17 10:45:35 server01 mysqld: diagnose the problem, but since we have already crashed, Feb 17 10:45:35 server01 mysqld: something is definitely wrong and this may fail. Feb 17 10:45:35 server01 mysqld: Feb 17 10:45:35 server01 mysqld: key_buffer_size=2147483648 Feb 17 10:45:35 server01 mysqld: read_buffer_size=131072 Feb 17 10:45:35 server01 mysqld: max_used_connections=90 Feb 17 10:45:35 server01 mysqld: max_threads=120 Feb 17 10:45:35 server01 mysqld: thread_count=64 Feb 17 10:45:35 server01 mysqld: connection_count=64 Feb 17 10:45:35 server01 mysqld: It is possible that mysqld could use up to Feb 17 10:45:35 server01 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2359640 K bytes of memory Feb 17 10:45:35 server01 mysqld: Hope that's ok; if not, decrease some variables in the equation. Feb 17 10:45:35 server01 mysqld: Feb 17 10:45:35 server01 mysqld: Thread pointer: 0x7fa35e4960f0 Feb 17 10:45:35 server01 mysqld: Attempting backtrace. You can use the following information to find out Feb 17 10:45:35 server01 mysqld: where mysqld died. If you see no messages after this, something went Feb 17 10:45:35 server01 mysqld: terribly wrong... Feb 17 10:45:35 server01 mysqld: stack_bottom = 7fa368ce4e88 thread_stack 0x40000 Feb 17 10:45:35 server01 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7fa4253ae04e] Feb 17 10:45:35 server01 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x493)[0x7fa425266603] Feb 17 10:45:35 server01 mysqld: /lib/libpthread.so.0(+0xeff0)[0x7fa424a22ff0] Feb 17 10:45:35 server01 mysqld: /lib/libc.so.6(gsignal+0x35)[0x7fa4232d41b5] Feb 17 10:45:35 server01 mysqld: /lib/libc.so.6(abort+0x180)[0x7fa4232d6fc0] Feb 17 10:45:35 server01 mysqld: /usr/sbin/mysqld(+0x5f1350)[0x7fa425441350] Feb 17 10:45:35 server01 mysqld: /usr/sbin/mysqld(+0x5d97b1)[0x7fa4254297b1] Feb 17 10:45:35 server01 mysqld: /usr/sbin/mysqld(+0x41667f)[0x7fa42526667f] Feb 17 10:45:35 server01 mysqld: /usr/sbin/mysqld(_Z24plugin_foreach_with_maskP3THDPFcS0_P13st_plugin_intPvEijS3_+0x209)[0x7fa4251654d9] Feb 17 10:45:35 server01 mysqld: /usr/sbin/mysqld(_Z11mysql_rm_dbP3THDPcbb+0x9f6)[0x7fa42513a2d6] Feb 17 10:45:35 server01 mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x2537)[0x7fa42515b877] Feb 17 10:45:35 server01 mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x24e)[0x7fa42515dabe] Feb 17 10:45:35 server01 mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x13e6)[0x7fa42515ef66] Feb 17 10:45:35 server01 mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x10e)[0x7fa4251ffb0e] Feb 17 10:45:35 server01 mysqld: /usr/sbin/mysqld(handle_one_connection+0x50)[0x7fa4251ffc30] Feb 17 10:45:35 server01 mysqld: /lib/libpthread.so.0(+0x68ca)[0x7fa424a1a8ca] Feb 17 10:45:35 server01 mysqld: /lib/libc.so.6(clone+0x6d)[0x7fa423371b6d] Feb 17 10:45:35 server01 mysqld: Feb 17 10:45:35 server01 mysqld: Trying to get some variables. Feb 17 10:45:35 server01 mysqld: Some pointers may be invalid and cause the dump to abort. Feb 17 10:45:35 server01 mysqld: Query (7fa33e68fb00): is an invalid pointer Feb 17 10:45:35 server01 mysqld: Connection ID (thread ID): 202368601 Feb 17 10:45:35 server01 mysqld: Status: NOT_KILLED Feb 17 10:45:35 server01 mysqld: Feb 17 10:45:35 server01 mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Feb 17 10:45:35 server01 mysqld: information that should help you find out what is causing the crash. Feb 17 10:45:36 server01 mysqld_safe: Number of processes running now: 0 Feb 17 10:45:36 server01 mysqld_safe: mysqld restarted Feb 17 10:45:37 server01 mysqld: 130217 10:45:37 [ERROR] An old style --language value with language specific part detected: /usr/share/mysql/english/ Feb 17 10:45:37 server01 mysqld: 130217 10:45:37 [ERROR] Use --lc-messages-dir without language specific part instead. Feb 17 10:45:37 server01 mysqld: 130217 10:45:37 [Note] Plugin 'FEDERATED' is disabled. Feb 17 10:45:37 server01 mysqld: 130217 10:45:37 InnoDB: The InnoDB memory heap is disabled Feb 17 10:45:37 server01 mysqld: 130217 10:45:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins Feb 17 10:45:37 server01 mysqld: 130217 10:45:37 InnoDB: Compressed tables use zlib 1.2.3.4 Feb 17 10:45:37 server01 mysqld: 130217 10:45:37 InnoDB: Using Linux native AIO Feb 17 10:45:37 server01 mysqld: 130217 10:45:37 InnoDB: Initializing buffer pool, size = 512.0M Feb 17 10:45:38 server01 mysqld: 130217 10:45:38 InnoDB: Completed initialization of buffer pool Feb 17 10:45:38 server01 mysqld: 130217 10:45:38 InnoDB: highest supported file format is Barracuda. Feb 17 10:45:38 server01 mysqld: InnoDB: Log scan progressed past the checkpoint lsn 406891075175 Feb 17 10:45:38 server01 mysqld: 130217 10:45:38 InnoDB: Database was not shut down normally! Feb 17 10:45:38 server01 mysqld: InnoDB: Starting crash recovery. Feb 17 10:45:38 server01 mysqld: InnoDB: Reading tablespace information from the .ibd files...