RE: Replication and LOAD DATA INFILE

Another guess... How big is the LOAD file? There are (were) network limits on the order of 8MB default (16MB hard limit).

> -----Original Message-----
> From: Mark Callaghan [mailto:mcallaghan@google.com]
> Sent: Thursday, August 30, 2007 7:57 AM
> To: Andrej Pintar
> Cc: replication@lists.mysql.com
> Subject: Re: Replication and LOAD DATA INFILE
>
> This is a guess and something for you to rule out. I used to
> get a lot of
> 1236 errors and the cause was malloc failures on the server
> while trying to
> send large binlog events to slaves. The MySQL server did not
> do a good job
> of reporting the real cause of the problem and our MySQL
> server had a memory
> leak (in code added by us).
>
> On 8/30/07, Andrej Pintar <api984@gmail.com> wrote:
> >
> > Hello to you all people,
> >
> > I don't know if this is a good time to be asking
> question. But I
> > will
> > try to describe this problem the best I can. Ok. Let's see.
> We have 1
> > MASTER
> > and 1 SLAVE.
> > Both having MySQL 5.0.41. My.conf are configured with lots
> of thought and
> > calculations. The big thing is that the replication breaks
> every day. Now
> > we
> > have a
> > pretty good reason after viewing the position where it
> breaks is the DATA
> > from the text file.
> >
> > example..
> > Opened with ultra edit.
> > -this is how the data starts from the file.... some mysql encrypted
> > commands, looks like it... however I copied and some
> characters are not
> > like
> > in ultra edit....
> > -but you know what it is...
> > -i copied this from the bin file MYSERVER.000001
> >
> > C8 oKe  LOTS of data
> >
> > oXOF
> > R µLe 0
> 
> >
> >    N @
P std   tur LOAD
> DATA INFILE
> > 'c:\\database\\qiqo\\WTRACS\\UNILINE\\FIALA\\FIALA1.asc' INTO TABLE
> > `A070829133101717559` (ID_polje)?XOF
> >
> > And now comes the command
> >
> > MASTER loads the data nicely. But the slave breaks.
> >
> > Slave err. file
> > 070829 13:40:35 [ERROR] Error reading packet from server:
> error reading
> > log
> > entry ( server_errno=1236)
> > 070829 13:40:35 [ERROR] Got fatal error 1236: 'error
> reading log entry'
> > from
> > master when reading data from binary log
> > 070829 13:40:35 [Note] Slave I/O thread exiting, read up to log
> > 'ULFS01_LOGbv2.000001', position 70026728
> >
> > So if could give me some advice on this. Master loads the
> data .... puts
> > the
> > data in the binary log..... and the slave can't read... replication
> > breaks...
> > That would be for now.....
> >
>
>
>
> --
> Mark Callaghan
> mcallaghan@google.com
>

-- 
MySQL Replication Mailing List
For list archives: 
http://lists.mysql.com/replication
To unsubscribe:    
http://lists.mysql.com/replication?unsub=lists@pantek.com