[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-bugs
Subject:    LOAD INFILE to temporary table breaks replication
From:       andy-spamsucks- () grandvirtual ! com
Date:       2002-06-21 19:20:13
[Download RAW message or body]

> Description:
        I have 2 servers setup.  One is a master, the other a read-only
slave.  I am replicationg all databases except for the permission DB
(mysql).  I noticed that replication breaks if the LOAD INFILE syntax is
used to populate a temporary table.  The query completes normally on the
master, but the following error is recorded on the slave:

020621 14:10:23  Slave: connected to master  'replication@master:3306',
replication started in log 'master-bin.001' at position 32620370
020621 14:57:01  Slave: Error 'Table '%-.64s.%-.64s' doesn't exist'
running load data infile
020621 14:57:01  Error running query, slave aborted. Fix the problem, and
re-start the slave thread with "mysqladmin start-slave". We stopped at log
'master-bin.001' position 61759262
020621 14:57:01  Slave thread exiting, replication stopped in log
'master-bin.001' at position 61759262

> How-To-Repeat:

On master do:

CREATE TEMPORARY TABLE foo(bar VARCHAR(50) NOT NULL);
LOAD DATA INFILE '/tmp/baz.txt' INTO TABLE foo FIELDS TERMINATED BY '|';


> Fix:
        Don't know, I'm not familiar enough with MySQL source


> Submitter-Id:  <submitter ID>
> Originator:    Andrew Shoemaker
> Organization:
> MySQL support: none
> Synopsis:      LOAD INFILE to temporary table breaks replication
> Severity:      serious
> Priority:      medium
> Category:      mysql
> Class:         sw-bug
> Release:       mysql-3.23.49 (Official MySQL Binary)

> Environment:
System: Linux foo 2.4.18 #1 SMP Wed Jun 19 18:40:37 EDT 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/i386-slackware-linux/2.95.3/specs
gcc version 2.95.3 20010315 (release)
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 May 28 12:21 /lib/libc.so.6 -> \
                libc-2.2.3.so
-rwxr-xr-x    1 root     root      4783716 May 25  2001 /lib/libc-2.2.3.so
-rw-r--r--    1 root     root     24721042 May 25  2001 /usr/lib/libc.a
-rw-r--r--    1 root     root          178 May 25  2001 /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


***Note: Remove "-spamsucks-" from my address for any responses.



---------------------------------------------------------------------
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 bugs-thread12128@lists.mysql.com
To unsubscribe, e-mail <bugs-unsubscribe@lists.mysql.com>


[prev in list] [next in list] [prev in thread] [next in thread]