From: rogelio
To: [EMAIL PROTECTED]
Subject: bug in mysqlimport with many rows
> Description:
if I split a 30000 rows file in 5000 chuncks, I can run mysqlimport
on each one over a deleted table
but if I don't use --delete, the first mysqlimport work ok but
the second hangs, and hang mysqld too.
it's the same thing if I try to mysqlimport the 30000 rows file.
I stop and start the hanged server, then when I try to read the
table with a select I get an error 145, can't open file TGLFA00.MYD
> How-To-Repeat:
I send you the construct sql and I can't send the file to import
zipped, don't let me, but I'll do on request
> Fix:
> Submitter-Id: rogeliotg
> Originator: Rogelio Trivi�o
> Organization:
freelance
> MySQL support: none
> Synopsis: bug in mysqlimport with many rows
> Severity: critical
> Priority: high
> Category: mysql
> Class: sw-bug
Release: mysql-3.23.49 (Official MySQL Binary)
> Environment:
System: Linux mercurio 2.4.17-16mdk #1 Fri Feb 8 16:00:03 CET 2002 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/i586-mandrake-linux-gnu/2.96/specs
gcc version 2.96 20000731 (Mandrake Linux 8.2 2.96-0.74mdk)
Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type
-Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts
-Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses
-Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3
-fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type
-Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts
-Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses
-Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline
-Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor
-felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3
-fno-omit-frame-pointer' LDFLAGS=''
LIBC: lrwxrwxrwx 1 root root 13 feb 20 10:24
/lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x 1 root root 1275588 feb 6 12:36 /lib/libc-2.2.4.so
-rw-r--r-- 1 root root 27541546 feb 6 12:12 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 feb 6 12:12 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql
--enable-assembler --with-extra-charsets=complex
--enable-thread-safe-client --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static
--with-other-libc=/usr/local/mysql-glibc '--with-comment=Official MySQL
Binary' --prefix=/usr/local/mysql --with-extra-charset=complex
--enable-thread-safe-client --enable-local-infile 'CFLAGS=-Wimplicit
-Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W
-Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int
-Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro
-O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type
-Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts
-Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses
-Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline
-Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor
-felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3
-fno-omit-frame-pointer' CXX=gcc
------------------------------------------------------------------------
#DROP TABLE TGFAC00;
CREATE TABLE TGFAC00 (
COD_FACT VARCHAR(2) NOT NULL,
NUM_FACT VARCHAR(10) NOT NULL,
DES_PROD VARCHAR(20) NULL,
DES_TIPO VARCHAR(30) NULL,
FEC_FACTU DATE NULL,
NIF_FACTURA VARCHAR(9) NULL,
FEC_EXIGI DATE NULL,
EXT_NIF_FACTURA VARCHAR(1) NULL,
IMP_NETO FLOAT NULL,
IMP_IMPUE FLOAT NULL,
IMP_TOTAL FLOAT NULL,
COD_MONED VARCHAR(3) NULL
)
;
ALTER TABLE TGFAC00
ADD ( PRIMARY KEY (COD_FACT, NUM_FACT)
) ;
#DROP TABLE TGLFA00;
CREATE TABLE TGLFA00 (
COD_FACT VARCHAR(2) NOT NULL,
NUM_FACT VARCHAR(10) NOT NULL,
NUM_CONTR VARCHAR(11) NOT NULL
,
CONCEPTO VARCHAR(30) NOT NULL,
NUM_VENC INT(3) NOT NULL,
NUM_LINEA INT(5) NOT NULL,
IMP_NETO FLOAT NULL,
DESC_IMPU VARCHAR(6) NULL,
FEC_INIC DATE NULL,
TASA_IMPU FLOAT NULL,
IMP_IMPU FLOAT NULL,
TOTAL_IMP_LINEA FLOAT NULL
)
;
ALTER TABLE TGLFA00
ADD ( PRIMARY KEY (COD_FACT, NUM_FACT, NUM_CONTR, CONCEPTO,
NUM_VENC, NUM_LINEA)
) ;
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
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
