060930 17:37:39InnoDB: Assertion failure in thread 213005 in file lock0lock.c line 4356 InnoDB: Failing assertion: !is_waiting 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/mysql/en/Forcing_recovery.html InnoDB: about forcing recovery. 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=8388572 read_buffer_size=131072 max_used_connections=31 max_connections=100 threads_connected=31 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225788 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8c982b0 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... Cannot determine thread, fp=0xbe1fe868, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x80bf1b7 _Z12init_signalsv + 139 0x837931d __pthread_sighandler_rt + 141 0x82989b2 lock_table_queue_validate + 392 0x8299f99 lock_rec_validate_page + 952 0x8298276 lock_print_info_all_transactions + 137 0x81b8c07 srv_printf_innodb_monitor + 282 0x8162e84 _Z18innodb_show_statusP3THD + 228 0x80d46a5 _Z21mysql_execute_commandP3THD + 5165 0x80d983e _Z17add_field_to_listP3THDPc16enum_field_typesS1_S1_jP4ItemS4_P13st_lex_stringS1_P4ListI6StringEP15charset_info_stj + 22 0x80d22d0 _Z16dispatch_command19enum_server_commandP3THDPcj + 2218 0x80d1b7a _Z16dispatch_command19enum_server_commandP3THDPcj + 340 0x80d0fca handle_one_connection + 994 0x83741f1 pthread_start_thread + 1 0x83a8b6a __init_misc + 74 New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x8d986a0 = show innodb status thd->thread_id=5 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. InnoDB: Thread 163850 stopped in file ha_innodb.cc line 529 Number of processes running now: 0 060930 17:37:39 mysqld restarted InnoDB: !!!!!!!!!!!!!! UNIV_DEBUG switched on !!!!!!!!!!!!!!! 060930 17:37:39 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 060930 17:37:40 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 89692. InnoDB: Doing recovery: scanned up to log sequence number 0 472254 060930 17:37:40 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 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 4, file name ./11211_bin.000003 060930 17:37:40 InnoDB: Flushing modified pages from the buffer pool... 060930 17:37:43 InnoDB: Started; log sequence number 0 472254 /home/sbester/server/4.1/mysql-4.1-bk/mysql-4.1.22-suse-linux-i686/bin/mysqld: ready for connections. Version: '4.1.22-debug' socket: '/tmp/mysql.sock' port: 3306 yes