>Description:
Tables marks "crashed" after few minutes after repair.
I repair it with `myisamchk -sfo /var/db/mysql/*/*.MYI` and after a while
(2-15 minutes) some
tables (which is with high loading, I suppose) corrupts:
# myisamchk -se /var/db/mysql/*/*.MYI
[...skiped...]
myisamchk: MyISAM file /var/db/mysql/sibdom/board_msgs.MYI
myisamchk: warning: Table is marked as crashed
myisamchk: error: Size of datafile is: 171752 Should be: 172184
myisamchk: error: Found key at page 5120 that points to record outside datafile
myisamchk: warning: Found 405 parts Should be: 406 parts
MyISAM-table '/var/db/mysql/sibdom/board_msgs.MYI' is corrupted
Fix it using switch "-r" or "-o"
[...skiped...]
myisamchk: MyISAM file /var/db/mysql/voodoo/place.MYI
myisamchk: warning: Found row where the auto_increment column has the value 0
myisamchk: MyISAM file /var/db/mysql/voodoo/skm_forum.MYI
myisamchk: warning: Table is marked as crashed
myisamchk: error: Found key at page 13312 that points to record outside datafile
myisamchk: warning: Found 1591 parts Should be: 1592 parts
MyISAM-table '/var/db/mysql/voodoo/skm_forum.MYI' is corrupted
Fix it using switch "-r" or "-o"
Filesystem check complite with no warnings. MySQL was stoped at repair time.
This box is web-hosting server with mostly high loading. I can send log,
created
by --log commandline option on request or turn on extended logging while
situation repeats.
Please Cc: me on replay.
>Originator: Andrew I. Baznikin
>Organization:
ISP "TEL" JSC
>MySQL support: none
>Synopsis: Tables marks "crashed" after few minutes after repair.
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.53 (FreeBSD port: mysql-server-3.23.53_4)
>Environment:
System: FreeBSD 4.6-STABLE i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.4 20020320 [FreeBSD]
Compilation info: CC='cc' CFLAGS='-O -pipe ' CXX='cc' CXXFLAGS='-O -pipe
-felide-constructors -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1219594 Nov 13 18:13 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 9 Nov 13 18:13 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 575856 Nov 13 18:13 /usr/lib/libc.so.4
Configure command: ./configure --localstatedir=/var/db/mysql --without-perl
--without-debug --without-readline --without-bench --with-mit-threads=no
--with-libwrap --with-low-memory '--with-comment=FreeBSD port: mysql-server-3.23.53_4'
--program-prefix= --with-innodb --enable-assembler --with-berkeley-db
--with-charset=koi8_ru --prefix=/usr/local i386-portbld-freebsd4.6 'CFLAGS=-O -pipe '
CXX=cc host_alias=i386-portbld-freebsd4.6 build_alias=i386-portbld-freebsd4.6
target_alias=i386-portbld-freebsd4.6 CC=cc 'CXXFLAGS=-O -pipe -felide-constructors
-fno-rtti -fno-exceptions'
Perl: This is perl, version 5.005_03 built for i386-freebsd
---------------------------------------------------------------------
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
