Hi, Sorry to disturb, but I cannot find any answer in online doc and web archive.
>Description: I insert 34000 rows in a simple table with all text fields, and myisamchk tells the table is corrupted, while a select into outfile does not give any error compared to the original file. >How-To-Repeat: 1) create the database under mysql console : create database test; use test; create table kompass( cyid text, dirtitre text, dirnom text, dirfonc text, sigle text, adr1 text, adr2 text, codepost text, ville text, telephone text, telefax text, siren text, siret text, nafcode text, effectif text, jurcode text, email text, cinsee text, posx text, posy text ); load data infile "importk.txt" into table kompass; 2) check the table under unix shell : local/mysql/bin> ./myisamchk ../data/cgctest/kompass.MYI Checking MyISAM file: ../data/cgctest/kompass.MYI Data records: 34715 Deleted blocks: 0 ./myisamchk: warning: 1 clients is using or hasn't closed the table properly - check file-size - check key delete-chain - check record delete-chain - check index reference - check record links MyISAM-table '../data/cgctest/kompass.MYI' is usable but should be fixed a 3Mb zip can be sent to you (I could not upload it at ftp://support.mysql.com/pub/mysql/secret/ because I have no password) >Fix: none >Submitter-Id: none >Originator: Riccardo Cohen >Organization: articque Les Roches 37230 Fondettes >MySQL support: none >Synopsis: table corrupted after an error free load >Severity: serious >Priority: high >Category: mysql >Class: >Release: mysql-3.23.36 (Official MySQL binary) >Environment: =========================================================== mysqlbug output : =========================================================== System: Linux jsp 2.2.14-5.0 #1 Tue Mar 7 21:07:39 EST 2000 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/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium ' CXX='gcc' CXXFLAGS='-O6 -mpentium -felide-constructors\ ' LDFLAGS='-static' LIBC: lrwxrwxrwx 1 root root 13 Apr 10 2001 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x 1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20272704 Feb 29 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Feb 29 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra- charsets=complex --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disa ble-shared Perl: This is perl, version 5.005_03 built for i386-linux =========================================================== it is a Redhat 6.2 system, on an PC/ celeron 466 processor, 128Mb memory, 5Go disk Filesystem 1k-blocks Used Available Use% Mounted on /dev/hda7 254244 37883 203234 16% / /dev/hda1 15856 2442 12584 16% /boot /dev/hda6 2679268 129876 2413292 5% /home /dev/hda5 2679268 1012324 1530844 40% /usr /dev/hda8 254244 40187 200930 17% /var running a web server apache, with JSP engine on java 1.2 with several applications but none overloaded. I installed the binary version (mysql-3.23.36-pc-linux-gnu-i686.tar.gz). The problem appears also on my own machine, 2 processors NT 4 Sp6a / mysql 3.23.24-beta binary version mysqldump : # MySQL dump 8.13 # # Host: localhost Database: cgctest #-------------------------------------------------------- # Server version 3.23.36 # # Table structure for table 'kompass' # CREATE TABLE kompass ( cyid text, dirtitre text, dirnom text, dirfonc text, sigle text, adr1 text, adr2 text, codepost text, ville text, telephone text, telefax text, siren text, siret text, nafcode text, effectif text, jurcode text, email text, cinsee text, posx text, posy text ) TYPE=MyISAM; There is nothing wrong in data/host.err This is the my.cnf configuration file : [mysqld] port = 3306 server-id = 1 skip-locking skip-name-resolve skip-show-database skip-thread-priority # cannot use that one on pthreaded system #skip-networking ############################################## # to accept many many connections arriving at the same time # (do the same in apache) set-variable = back_log=500 # max = 64M for a 256M ram (these megs are shared by all threads) set-variable = key_buffer_size=64M # pool is about 100/300 connections, multiply by the number of apps set-variable = max_connections=2000 # prepare threads before connections arrive set-variable = thread_cache_size=100 # sorting : not too big because it is allocated for each sort operation set-variable = sort_buffer=500000 # allocated for each thread and for each table where a sequential scan is done set-variable = record_buffer=150000 # sorting : not too big because it is allocated for each sort operation # only for repair in myisam tables set-variable = myisam_sort_buffer_size=500000 ##############################################" # for replication #log-bin basedir = /usr/local/mysql datadir = /usr/local/mysql/data pid-file = /usr/local/mysql/data/pid_file socket = /tmp/mysql.sock tmpdir = /home/mytmp/ #log-update = /usr/local/apache/logs/update.log [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] # rehash table & field completion #no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates # No message in output, just the result with tab separator #batch [isamchk] set-variable = key_buffer=128M set-variable = sort_buffer=128M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=128M set-variable = sort_buffer=128M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout Thanks a lot -- Riccardo Cohen Articque Les Roches 37230 Fondettes France email = [EMAIL PROTECTED] web = http://www.articque.com tel: +33 02 47 49 90 49 fax: +33 02 47 49 91 49 --------------------------------------------------------------------- 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php