Hello,
Still on this database consistency problem with FLUSH TABLES WITH
READ LOCK... I've tried upgrading to MySQL 4.0.5a binary distribution
(instead of source), but the problem does not disappear.
So I've made a little test. I open too shells.
-> Shell 1:
I launch the MySQL client. Then type :
mysql> FLUSH TABLES WITH READ LOCK;
Query OK, 0 rows affected (1.00 sec)
I don't close the client.
-> Shell 2:
I go the MySQL data directory and type:
myisamchk -Ts */*.MYI
I get:
myisamchk: MyISAM file isis_international/delta_flow.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
MyISAM-table 'isis_international/delta_flow.MYI' is usable but should be
fixed
I abort after this first error as checking 20 GB of database would be too
long.
-> Shell 1:
mysql> UNLOCK TABLES;
Query OK, 0 rows affected (0.00 sec)
mysql> CHECK TABLE isis_international.delta_flow;
+-------------------------------+-------+----------+--------------------------------------------------------+|
+ Table | Op | Msg_type | Msg_text
|
+-------------------------------+-------+----------+--------------------------------------------------------+|
+ isis_international.delta_flow | check | warning | 1 clients is using or
hasn't closed the table properly |
| isis_international.delta_flow | check | status | OK
|
+-------------------------------+-------+----------+--------------------------------------------------------+2
+ rows in set (0.06 sec)
This confirms that FLUSH TABLES WITH READ LOCK has not closed all tables
properly. Some data has been lost and/or corrupted on the way.
By the way : the system has SCSI drives and ECC memory. I've never
experienced any data corruption outside of the FLUSH TABLES WITH READ
LOCK problem.
System: Linux *.fr 2.4.19 #3 SMP Fri Aug 9 15:18:06 CEST 2002 i686 unknown
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/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.3 2.96-113)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc'
CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jul 18 13:18 /lib/libc.so.6 ->
libc-2.2.5.so
-rwxr-xr-x 1 root root 1260480 Apr 15 2002 /lib/libc-2.2.5.so
-rw-r--r-- 1 root root 2310808 Apr 15 2002 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Apr 15 2002 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql'
'--with-comment=Official MySQL-standard binary'
'--with-extra-charsets=complex' '--with-server-suffix=-standard'
'--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler'
'--disable-shared' '--with-client-ldflags=-all-static'
'--with-mysqld-ldflags=-all-static' '--with-innodb' 'CFLAGS=-O2
-mcpu=pentiumpro' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors'
'CXX=gcc'
Is there something I can do to investigate further into this ?
Thank you
Antoine.
---------------------------------------------------------------------
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
