Michael, how do I send you email? A 'Spamcop' seems to block email to you.
Regards, Heikki ----- Original Message ----- From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: ""Michael T. Babcock"" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, February 21, 2003 10:33 PM Subject: Re: InnoDB Crash [more info] > 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