Thanks for the tip. I'll see about upgrading, but it won't be a small task. Any reason why 2.4.18 problems wouldn't have effected MySQL 3.23? I'm trying to search for a solution that does not involve upgrading kernels on 20 machines that are in production use right now. Thanks again!
Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 ----- Original Message ----- From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 15, 2003 3:45 PM Subject: Re: Frequent Table Corruption - Please Help > Richard, > > you are running a Red Hat kernel 2.4.18? Kernels 2.4.20 seem to be much more > reliable. > > Best regards, > > Heikki Tuuri > Innobase Oy > http://www.innodb.com > Transactions, foreign keys, and a hot backup tool for MySQL > Order MySQL technical support from https://order.mysql.com/ > > ----- Original Message ----- > From: "Richard Gabriel" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.mysql > Sent: Tuesday, July 15, 2003 9:52 PM > Subject: Frequent Table Corruption - Please Help > > > > Hi everyone, > > > > Since we upgraded to MySQL 4.0.13 from 3.23, we have been getting table > > corruption often. It happens about twice per week (with about 500 > > queries per second average). I have even set up a cron to run > > mysqlcheck every hour to try to do some damage control. The biggest > > problem is that once the table is corrupted, it seems to be locked. > > Well, no clients can read from it. Once repaired, just one record is > > usually lost for each time the corruption occurs. I am not sure if this > > is a MySQL bug or even how to reproduce it, but I was hoping that > > someone here could help. I have included all the information that I > > have about this below. Any insight is greatly appreciated! > > > > > > Here is the mysqlbug information: > > > > >Release: mysql-4.0.13 (Official MySQL RPM) > > > > >C compiler: 2.95.3 > > >C++ compiler: 2.95.3 > > >Environment: > > System: Linux *****.com 2.4.18-14smp #1 SMP Wed Sep 4 12:34:47 EDT 2002 > > i686 i686 i386 GNU/Linux > > Architecture: i686 > > > > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc > > /usr/bin/ccGCC: Reading specs from > > /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs > > Configured with: ../configure --prefix=/usr --mandir=/usr/share/man > > --infodir=/usr/share/info --enable-shared --enable-threads=posix > > --disable-checking --host=i386-redhat-linux --with-system-zlib > > --enable-__cxa_atexit > > Thread model: posix > > gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) > > Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer > > -mpentium' CXX='g++' CXXFLAGS='-O6 -fno-omit-frame-pointer > > -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' > > ASFLAGS='' > > LIBC: > > lrwxrwxrwx 1 root root 14 Nov 1 2002 /lib/libc.so.6 > > -> libc-2.2.93.so > > -rwxr-xr-x 1 root root 1235468 Sep 5 2002 > > /lib/libc-2.2.93.so > > -rw-r--r-- 1 root root 2233342 Sep 5 2002 /usr/lib/libc.a > > -rw-r--r-- 1 root root 178 Sep 5 2002 /usr/lib/libc.so > > Configure command: ./configure '--disable-shared' > > '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' > > '--without-berkeley-db' '--with-innodb' '--without-vio' > > '--without-openssl' '--enable-assembler' '--enable-local-infile' > > '--with-mysqld-user=mysql' > > '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' > > '--with-extra-charsets=complex' '--exec-prefix=/usr' > > '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' > > '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' > > '--includedir=/usr/include' '--mandir=/usr/share/man' > > '--with-embedded-server' '--enable-thread-safe-client' > > '--with-comment=Official MySQL RPM' 'CFLAGS=-O6 -fno-omit-frame-pointer > > -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer > > -felide-constructors -fno-exceptions -fno-rtti -mpentium' > > > > > > > > Other System Information: > > The system is running hardware RAID-10 with SCSI drives. It has 4 Xeon > > processors at 2.2GHz each, 2GB RAM. > > > > > > > > MySQL Configuration (my.cnf): > > [mysqld] > > set-variable = max_connections=1000 > > set-variable = delayed_queue_size=100000 > > > > innodb_data_file_path=ibdata:30M:autoextend:max:2000M > > # Set buffer pool size to > > # 50 - 80 % of your computer's > > # memory > > set-variable = innodb_buffer_pool_size=1G > > set-variable = innodb_additional_mem_pool_size=20M > > # Set the log file size to about > > # 15 % of the buffer pool size > > set-variable = innodb_log_file_size=150M > > set-variable = innodb_log_buffer_size=8M > > # > > > > log-bin > > server-id=1 > > master-host=192.168.1.3 > > master-user=repl > > master-password=***** > > master-port=3306 > > > > set-variable = query_cache_size=268435456 > > > > > > > > Log Entries: > > [The first entry is repeated many times. The second is from the > > mysqlcheck cron that repairs the tables] > > > > 030715 0:43:49 read_const: Got error 127 when reading table **** > > 030715 2:00:31 Note: Found 23550 of 23551 rows when repairing **** > > > > > > Thanks again for your help in advance! > > > > -- > > Richard Gabriel <[EMAIL PROTECTED]> > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
