mysql 4.0.12 replication bug with load data infile
am 06.05.2003 07:56:48 von jason justmanDescription:
enviroment is a master->slave configuration that runs properly. on
attempting to execute LOAD DATA INFILE on the master with options of
FIELDS TERMINATED BY ',' ENCLOSED BY '\"', the data is properly loaded
into the master. Once the slaves have caught up, it appears that they
don't honor the fields terminated or enclosed by tags. there are the
correct # of recods, abliet all EMPTY or NULL values because of the
weird formatting of the source file
>How-To-Repeat:
-- On master:
drop table l_test;
create table l_test
(
id varchar(4),
description varchar(64)
);
load data infile '/web/mmg_dev/db/location.txt' into table l_test FIELDS
TERMINATED BY ',' ENCLOSED BY '\"'
select * from l_test;
-- on slave
select * from l_test;
-- exampe data set:
"01","Alcona County"
"02","Alger County"
"03","Allegan County"
"04","Alpena County"
"05","Antrim County"
"06","Arenac County"
"07","Baraga County"
"08","Barry County"
"09","Bay County"
"10","Benzie County"
>Fix:
after loading data from infile, use normal procedures to re-establish
the slaves snapshot and bring them up again.
>>MySQL support: none
>>Synopsis: load data doesn't populate properly to replicated slaves
>>Severity: serious
>>Priority: high
>>Category: mysql
>>Class: sw-bug
>>Release: mysql-4.0.12-standard (Official MySQL-standard binary)
>
>
>>C compiler: gcc (GCC) 3.1 20020420 (prerelease)
>>C++ compiler: gcc (GCC) 3.1 20020420 (prerelease)
>>Environment:
>
>
System: Darwin ellison 6.5 Darwin Kernel Version 6.5: Mon Apr 7
17:05:38 PDT 2003; root:xnu/xnu-344.32.obj~1/RELEASE_PPC Power
Macintosh powerpc
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/libexec/gcc/darwin/ppc/3.1/specs
Thread model: posix
Apple Computer, Inc. GCC version 1151, based on gcc version 3.1 20020420
(prerelease)
Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer'
CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxr-xr-x 1 root wheel 15 Apr 14 19:13 /usr/lib/libc.dylib ->
libSystem.dylib
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' '--disable-shared'
'--with-innodb' 'CC=gcc' 'CFLAGS=-O3 -fno-omit-frame-pointer'
'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti' 'CXX=gcc'
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org