Re: FWD: Fw: Load data infile & replication - 3.23.56

> > Replication doesn't seem to be replicating LOAD DATA INFILE correctly in
> > 3.23.56. Starting with a master and slave that were in sync, I imported a
> > file:
> >
> > ---------------------------
> > MASTER
> > mysql> select count(*) from list where sourceID=0;
> > +----------+
> > | count(*) |
> > +----------+
> > | 0 |
> > +----------+
> > 1 row in set (0.01 sec)
> >
> > mysql> load data infile '/home/stuff/new50001.txt'
> > -> ignore
> > -> into table list
> > -> (info);
> > Query OK, 189662 rows affected (1 min 18.43 sec)
> > Records: 190660 Deleted: 0 Skipped: 998 Warnings: 0
> >
> > mysql> select count(*) from list where sourceID=0;
> > +----------+
> > | count(*) |
> > +----------+
> > | 189662 |
> > +----------+
> > 1 row in set (0.24 sec)
> >
> > SLAVE
> > mysql> select count(*) from list where sourceID=0;
> > +----------+
> > | count(*) |
> > +----------+
> > | 190660 |
> > +----------+
> > 1 row in set (0.21 sec)
> > ---------------------------
> >
> > Notice that the slave doesn't skip the records that the master does

Hi,

could you please send me the output of
'SHOW CREATE TABLE list;'
run on the master and then on the slave.
Please take the time to run this command on the two machines and send
the two exact outputs.
Thank you.

Regards,
Guilhem

--
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