Michael, your database is probably corrupt.
The normal procedure in this case is to use the my.cnf option set-variable=innodb_force_recovery=4 and dump your tables and recreate the whole tablespace. But, please do not do that yet. I will send you a new version of /mysql/innobase/ibuf/ibuf0ibuf.c which will print a lot of diagnostic information. I want to see what it prints. A general note: you are using a very old Linux kernel 2.2.14. Some combinations of Linux + hardware seem to cause sporadic table corruption. One user was able to resolve the problem by upgrading to a stock kernel 2.4.20. Regards, Heikki Innobase Oy sql query ----- Original Message ----- From: ""Michael T. Babcock"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, February 21, 2003 9:23 PM Subject: Re: InnoDB Crash [more info] > Michael T. Babcock wrote: > > >I've got a nice MySQL crash that happened during the night last night and I > >can't seem to get it to come back online for me without --skip-innodb. > > > > > > Follow-up with mysql's bug report: > > MySQL support: none > Synopsis: InnoDB Crashing on Startup > Severity: critical > Priority: medium > Category: mysql > Class: sw-bug > Release: mysql-3.23.55 (yes) > > Environment: > System: Linux web.fibrespeed.net 2.2.14-10.0 #21 Fri Apr 21 00:22:11 EDT > 2000 i686 unknown > Architecture: i686 > > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc > /usr/bin/cc > GCC: Reading specs from > /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs > gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) > > Compilation info: CC='gcc' CFLAGS='-O2 -march=pentium' CXX='gcc' > CXXFLAGS='-O2 -march=pentium' LDFLAGS='-static' > > LIBC: > lrwxrwxrwx 1 root root 13 Apr 10 2000 /lib/libc.so.6 > -> libc-2.1.3.so > -rwxr-xr-x 1 root root 4101836 Jan 15 2001 /lib/libc-2.1.3.so > -rw-r--r-- 1 root root 20273324 Jan 15 2001 /usr/lib/libc.a > -rw-r--r-- 1 root root 178 Jan 15 2001 /usr/lib/libc.so > lrwxrwxrwx 1 root root 10 Jul 20 2001 > /usr/lib/libc-client.a -> c-client.a > > Configure command: ./configure '--sysconfdir=/etc' '--prefix=/usr' > '--localstatedir=/var/mysql' '--enable-assembler' '--with-berkeley-db' > '--with-innodb' '--with-comment' '--enable-thread-safe-client' 'CC=gcc' > 'CFLAGS=-O2 -march=pentium' 'CXXFLAGS=-O2 -march=pentium' 'CXX=gcc' > 'LDFLAGS=-static' > > -- > Michael T. Babcock > C.T.O., FibreSpeed Ltd. > http://www.fibrespeed.net/~mbabcock > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php