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, so the
master and slave are out of sync after the LOAD DATA INFILE executes. I am
running the 3.23.56 binaries, RedHat 7.3, on both machines. Also, is there
any way to find out what records were skipped and why?
Thanks,
--jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
