Greetings all.
I have a bit of a problem here, a database i'm administering was somehow corrupted, and i'm unable to recover it in any way. Is there any way at all to recover a corrupt InnoDB database? (I read on innodb.com that it is impossible, but hope it is not)
When I run a query from any InnoDB table in the database MySQL crashes with the following stack trace and errors.
I'm running a GNU/Linux system and MySQL 4.0.13 from the Debian unstable.
Error: trying to access field 4294967295 in rec
030807 13:53:24 InnoDB: Assertion failure in thread 180234 in file rem0rec.c line 111
InnoDB: Failing assertion: 0
....
thd=0x86e3990
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=0xbe7fe898, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x8102bc3
0x401ad75a
0x82b9a60
0x8230d50
0x822e42c
0x816952f
0x8169c84
0x816bf6a
0x816c2be
0x815e77f
0x8178c60
0x810f8e8
0x8112a15
0x810db3d
0x810d6cc
0x810d059
0x401a7d53
0x4038a3f7
New value of fp=(nil) failed sanity check, terminating stack trace!
....
0x8102bc3 mysql_binlog_send__FP3THDPcUxUs + 1419
0x401ad75a _end + 936375294
0x82b9a60 _tr_flush_block + 640
0x8230d50 page_cur_delete_rec + 5780
0x822e42c page_copy_rec_list_end_to_created_page + 392
0x816952f yyparse + 3855
0x8169c84 yylex + 1572
0x816bf6a opt_search_plan_for_table + 742
0x816c2be opt_search_plan_for_table + 1594
0x815e77f row_upd_clust_step + 431
0x8178c60 btr_compress + 3852
0x810f8e8 srv_master_thread + 172
0x8112a15 innobase_start_or_create_for_mysql + 1297
0x810db3d srv_sprintf_innodb_monitor + 425
0x810d6cc srv_suspend_mysql_thread + 1372
0x810d059 srv_table_reserve_slot_for_mysql + 473
0x401a7d53 _end + 936352247
0x4038a3f7 _end + 938328219
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw
