mysql数据库bug_mysql bug 求解

111125 16:15:35 InnoDB: Assertion failure in thread 1095162176 in file row/row0mysql.c line 1534

InnoDB: Failing assertion: index->type & DICT_CLUSTERED

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.1/en/forcing-recovery.html

InnoDB: about forcing recovery.

111125 16:15:35 - 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=1048576

max_used_connections=30

max_threads=1000

threads_connected=14

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 9234379 K

bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

thd: 0xb8bf170

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 = 0x4146d100 thread_stack 0x30000

/opt/mysql/product/5.1/bin/mysqld(my_print_stacktrace+0x2e)[0x8a74ce]

/opt/mysql/product/5.1/bin/mysqld(handle_segfault+0x322)[0x5dc992]

/lib64/libpthread.so.0[0x357980eb10]

/lib64/libc.so.6(gsignal+0x35)[0x3578c30265]

/lib64/libc.so.6(abort+0x110)[0x3578c31d10]

/opt/mysql/product/5.1/bin/mysqld(row_unlock_for_mysql+0x2f2)[0x7f4a52]

/opt/mysql/product/5.1/bin/mysqld(row_search_for_mysql+0x22e1)[0x802591]

/opt/mysql/product/5.1/bin/mysqld(_ZN11ha_innobase10index_readEPhPKhj16ha_rkey_function+0x192)[0x7724d2]

/opt/mysql/product/5.1/bin/mysqld(_ZN7handler16read_range_firstEPK12st_key_rangeS2_bb+0xbe)[0x6caa9e]

/opt/mysql/product/5.1/bin/mysqld(_ZN7handler22read_multi_range_firstEPP18st_key_multi_rangeS1_jbP17st_handler_buffer+0xce)[0x6c85be]

/opt/mysql/product/5.1/bin/mysqld(_ZN18QUICK_RANGE_SELECT8get_nextEv+0x127)[0x6aa557]

/opt/mysql/product/5.1/bin/mysqld[0x6c415d]

/opt/mysql/product/5.1/bin/mysqld(_Z12mysql_deleteP3THDP10TABLE_LISTP4ItemP11st_sql_listyyb+0x86c)[0x66fc5c]

/opt/mysql/product/5.1/bin/mysqld(_Z21mysql_execute_commandP3THD+0x38bf)[0x5f03af]

/opt/mysql/product/5.1/bin/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x357)[0x5f25e7]

/opt/mysql/product/5.1/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xe63)[0x5f3453]

/opt/mysql/product/5.1/bin/mysqld(_Z10do_commandP3THD+0xe6)[0x5f3d16]

/opt/mysql/product/5.1/bin/mysqld(handle_one_connection+0x236)[0x5e66d6]

/lib64/libpthread.so.0[0x357980673d]

/lib64/libc.so.6(clone+0x6d)[0x3578cd3d1d]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort...

thd->query at 0x2aab4890fcd0 is an invalid pointer

thd->thread_id=62259

thd->killed=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.

111125 16:15:35 mysqld_safe Number of processes running now: 0

111125 16:15:35 mysqld_safe mysqld restarted

InnoDB: Log scan progressed past the checkpoint lsn 0 694228728

111125 16:15:36 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...

InnoDB: Doing recovery: scanned up to log sequence number 0 694229872

111125 16:15:36 InnoDB: Starting an apply batch of log records to the database...

InnoDB: Progress in percents: 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 5

6 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 1397027, file name /opt/mysql/mysqldata/mysqllog/mysqlbin.000149

111125 16:15:37 InnoDB: Started; log sequence number 0 694229872

111125 16:15:37 [Note] Recovering after a crash using /opt/mysql/mysqldata/mysqllog/mysqlbin

111125 16:15:37 [Note] Starting crash recovery...

111125 16:15:37 [Note] Crash recovery finished.