Hi My mysql server suddenly crashed. Not it does not start and dumps the following stack trace. I suspect some table corruption. Please help me to start it.
<mysql@lists.mysql.com>stack_bottom = (nil) thread_stack 0x40000 /usr/sbin/mysqld(my_print_stacktrace+0x24) [0x84fd84] /usr/sbin/mysqld(handle_segfault+0x320) [0x58a870] /lib/libpthread.so.0 [0x7fe50b3145f0] /lib/libc.so.6(gsignal+0x35) [0x7fe50a7f9c85] /lib/libc.so.6(abort+0x10e) [0x7fe50a7fafee] /usr/sbin/mysqld [0x785ebd] /usr/sbin/mysqld [0x77442f] /usr/sbin/mysqld [0x77579d] /usr/sbin/mysqld [0x72aef7] /usr/sbin/mysqld [0x7366c1] /usr/sbin/mysqld [0x736c06] /usr/sbin/mysqld [0x72e9d2] /usr/sbin/mysqld [0x762d31] /usr/sbin/mysqld [0x7eaf6d] /usr/sbin/mysqld [0x7c3800] /usr/sbin/mysqld [0x70bde5] /usr/sbin/mysqld(ha_initialize_handlerton(st_plugin_int*)+0x31) [0x679a31] /usr/sbin/mysqld [0x6f214a] /usr/sbin/mysqld(plugin_init(int*, char**, int)+0x812) [0x6f5682] /usr/sbin/mysqld [0x58bc8b] /usr/sbin/mysqld(main+0x405) [0x58ef25] /lib/libc.so.6(__libc_start_main+0xf4) [0x7fe50a7e6ff4] /usr/sbin/mysqld [0x4c9a39] Things I tried: 1. Start with inndb_force_recovery = 4, but it failed with the same stack trace. 2. Took backup of all data files and put them on other machine. There also it did not start and gave the same error. Any idea what is going wrong? Thanks Garima
