From: Eric Bergen
Date: October 13 2004 11:57pm
Subject: Re: Replication and LOAD DATA LOCAL INFILE
List-Archive: http://lists.mysql.com/mysql/174145
Message-Id: <11b1bd99041013165727350ec8@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

My best guess would be that your slave tables have slightly different
data/structure than your master table. Try taking a fresh snapshot
from the master and trying again.


-Eric


On Tue, 12 Oct 2004 10:33:24 -0700, Kenneth Lim <klim@stripped> wrote:
> Hi -
> 
> I'm seeing these error/warning messages on my replication slave:
> 
>   [ERROR] Slave: load data infile on table 'DeviceItem' at log position
> 38844696 in log 'db1-bin.000001' produced 6 warning(s).  Default database:
> 'senvidsysdb'
> 
> I was wondering if anyone has seen similar messages.
> I have master-slave replication setup on 2 Linux boxes running
> MySQL 4.1.5-gamma.  On a Windows client, I execute a script that
> contains a bunch of LOAD DATA LOCAL INFILE statements.
> 
> The master error log does not complain.  But the slave error log
> has the error/warning messages above.  The data seems to be the
> same on master and slave.
> 
> Are there special considerations for using LOAD DATA LOCAL INFILE
> statements with a replication setup?
> 
> Thanks.
> -ken
> 
> Kenneth Lim
> Software Engineer
> Senvid, Inc.
> 2445 Faber Place, Suite #200
> Palo Alto, CA  94303
> phone: 650-354-3612
> fax: 650-354-8890
> email: klim@stripped
> http://www.senvid.com
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.bergen@stripped
> 
> 


-- 
Eric Bergen
eric.bergen@stripped