>Description:
We're running mysql version 3.23.36-1 under Redhat i386 7.1. The machine
is a two processor Va Linux box with 512 Mb of RAM. This is the command
line we're running:
/usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--log=/var/run/mysql-query-log --old-protocol
--set-variable max_connections=200
The problem is that a particular table (named link) in a particular database
indent: Standard input:1: Warning:Unterminated character constant
(named burmalibrary) repeatadly becomes corrupted. We've gone through this
cycle three times and the problem continues to reoccur.
It reoccurs very quickly (a couple of days) if I fix the corrupted table
with myisamchk. It reoccurs somewhat less quickly (a week or two) if I do a
mysqldump of the fixed table, drop the original, and re-import the data
from the ASCII dump.
Examining the logs, the time of corruption corresponds to an UPDATE, but
there's nothing particularly suspicious about that command itself.
Unfortunately this version of mysql doesn't seem to support binary logs
so I can't replay the list of commands.
I've put together a package that contains copies of the tables and the
log file for particular stages of the problem. I've uploaded the whole
package to ftp://support.mysql.com/pub/mysql/secret/burmalibrary-corrupt.tar.gz
(beware, although the compressed archive is only 20 megs, unpacked it's
more like 400 mb).
Here's the chronology again:
October 10: found the link table corrupted (files: 10Oct01-originally-corrupted)
October 10: Ran myisamchk on corrupted table (results:
10Oct01-AfterRunningMyisamchk)
October 12: found the link table corrupted again (files: 12Oct01-CorruptedAgain)
the log file at the time of corruption is
12Oct01-MysqlQueryLogAtCorruption
October 12: Did a myisamchk and and mysqldump on the link table
(result: 12Oct01-LinkTableAsciiDump). Reimported the ASCII dump.
October 29: found the link table corrupted again. (files:
29Oct01-CorruptedAfterReimportingData). The log is saved as
29Oct01-MysqlQueryLogAtLastCorruption
As I said, this is the third or so time we've been through this entire
saga. It's just the most recent time that I've actually saved all
the data.
>Submitter-Id: [EMAIL PROTECTED]
>Originator: jem
>Organization: UNC Ibiblio/Metalab/Sunsite/Whatever
>MySQL support: none
>Synopsis: Repeated table corruption under 3.23.36
>Severity: serious
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.36 (Source distribution)
>Environment:
System: Linux trance.metalab.unc.edu 2.4.7-2 #2 SMP Thu Aug 23 17:23:39 EDT 2001 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/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-81)
Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++'
CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 May 31 14:26 /lib/libc.so.6 -> libc-2.2.2.so
-rwxr-xr-x 1 root root 1236396 Apr 6 2001 /lib/libc-2.2.2.so
-rw-r--r-- 1 root root 26350254 Apr 6 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Apr 6 2001 /usr/lib/libc.so
Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr
--bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
--includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec
--localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man
--infodir=/usr/share/info --without-debug --without-readline --enable-shared
--with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql
--with-extra-charsets=all --with-berkeley-db
---------------------------------------------------------------------
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
