>Description:
When we run the mysql database for any length of time, we end up with
corruptions such as:
/usr/local/mysql/bin/myisamchk: error: record delete-link-chain
corrupted MyISAM-table 'CollectedValue' is corrupted
CollectedValue is a table from our schema:
create table CollectedValue(oid varchar(255) binary not null,
instance varchar(80) binary not null,
timeOfCollection timestamp not null,
collectionName varchar(20) binary not null,
collectingNode varchar(30) binary not null,
cellId smallint not null,
value varchar(255) binary not null,
index(timeOfCollection),
index(collectingNode,cellId),
primary key(oid, instance, timeOfCollection, collectionName,
collectingNode));
However, we have seen the corruption on other tables.
After the corruption we get the following error trying to insert into
the table:
General error: Can't open file: 'CollectedValue.MYD'. (errno: 144)
SQLState: S1000 ErrorCode: 1016 query INSERT INTO CollectedValue ( oid,
instance, timeOfCollection, collectionName, collectingNode, cellId,
value) VALUES ('1.3.6.1.4.1.5586.3.2.2.2.5.3.1.5', '1.1',
'20031118235003', 'mike', '10.2.63.114', 1, '0')
>How-To-Repeat:
We don't know what is causing these corruptions or how to reproduce them
>Fix:
Close mysql and repair with "/usr/loca/mysql/bin/myisamchk -r -f -o
CollectedValue"
>Submitter-Id: [EMAIL PROTECTED]
>Originator: Neil Edgar
>Organization: IPWireless
>MySQL support: none
>Synopsis: error: record delete-link-chain corrupted MyISAM-table
>Severity: serious
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.56 (Official MySQL binary)
>Server: /db/mysql/mysql/bin/mysqladmin Ver 8.23 Distrib 3.23.56, for
sun-solaris2.8 on sparc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.56
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 2 days 18 hours 4 min 6 sec
Threads: 2 Questions: 285910 Slow queries: 12 Opens: 157 Flush
tables: 1 Open tables: 6 Queries per second avg: 1.202
>Environment:
System: SunOS sun03 5.8 Generic_108528-03 sun4u sparc SUNW,Ultra-5_10
Architecture: sun4
Some paths: /usr/bin/perl /usr/ucb/cc
Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer'
CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors
-fno-except
ions -fno-rtti' LDFLAGS=''
LIBC:
-rw-r--r-- 1 root bin 1749356 Jul 20 2000 /lib/libc.a
lrwxrwxrwx 1 root root 11 Jan 25 2001 /lib/libc.so ->
./libc.so.1
-rwxr-xr-x 1 root bin 1135056 Jul 20 2000 /lib/libc.so.1
-rw-r--r-- 1 root bin 1749356 Jul 20 2000 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Jan 25 2001 /usr/lib/libc.so
-> ./libc.so.1
-rwxr-xr-x 1 root bin 1135056 Jul 20 2000 /usr/lib/libc.so.1
Configure command: ./configure '--prefix=/usr/local/mysql'
'--with-comment=Official MySQL binary' '--with-extra-charsets=complex'
'--with-server-su
ffix=' '--enable-thread-safe-client' '--enable-local-infile'
'--enable-assembler' '--with-named-z-libs=no'
'--with-named-curses-libs=-lcurses' '--d
isable-shared' '--without-innodb' 'CC=gcc' 'CFLAGS=-O3
-fno-omit-frame-pointer' 'CXXFLAGS=-O3 -fno-omit-frame-pointer
-felide-constructors -fno-exc
eptions -fno-rtti' 'CXX=gcc'
Perl: This is perl, version 5.005_03 built for sun4-solaris
