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
