GoogleCodeExporter
commented
9 years ago How to reproduce:
1. Insert the following data onto the master:
create database base;
CREATE TABLE user1 (id int(11) NOT NULL, name varchar(255) NOT NULL);
INSERT INTO base.user1 (id, name) VALUES (1, 'test1');
INSERT INTO base.user1 (id, name) VALUES (2, 'test2');
INSERT INTO base.user1 (id, name) VALUES (3, 'test3');
INSERT INTO base.user1 (id, name) VALUES (4, 'test4');
CREATE TABLE user2 (id int(11) NOT NULL, name varchar(255) NOT NULL);
INSERT INTO base.user2 (id, name) VALUES (1, 'test1');
INSERT INTO base.user2 (id, name) VALUES (2, 'test2');
INSERT INTO base.user2 (id, name) VALUES (3, 'test3');
INSERT INTO base.user2 (id, name) VALUES (4, 'test4');
2. Create a master-slave replication and copy the data to the slave with
xtrabackup.
3. Create a mysqldump on the slave and swap the order of the data in table
user2:
INSERT INTO `user2` VALUES (1,'test1'),(2,'test2'),(3,'test3'),(4,'test4');
->
INSERT INTO `user2` VALUES (1,'test1'),(2,'test2'),(4,'test4'),(3,'test3');
4. Add the second slave to the replication and import the modified dump.
5. On master:
./trepctl check base.user1 - OK
./trepctl check base.user2 - works on the first slave (xtrabackup), fails on
second slave (mysqldump)
The master / slave1 (xtrabackup):
mysql> select * from user1;
+----+-------+
| id | name |
+----+-------+
| 1 | test1 |
| 2 | test2 |
| 3 | test3 |
| 4 | test4 |
+----+-------+
4 rows in set (0.00 sec)
mysql> select * from user2;
+----+-------+
| id | name |
+----+-------+
| 1 | test1 |
| 2 | test2 |
| 3 | test3 |
| 4 | test4 |
+----+-------+
4 rows in set (0.00 sec)
Slave2 (mysqldump):
mysql> select * from user1;
+----+-------+
| id | name |
+----+-------+
| 1 | test1 |
| 2 | test2 |
| 3 | test3 |
| 4 | test4 |
+----+-------+
4 rows in set (0.00 sec)
mysql> select * from user2;
+----+-------+
| id | name |
+----+-------+
| 1 | test1 |
| 2 | test2 |
| 4 | test4 |
| 3 | test3 |
+----+-------+
4 rows in set (0.00 sec)
Either way, the following SELECTs give the same result:
mysql> select * from user2 where id=1;
+----+-------+
| id | name |
+----+-------+
| 1 | test1 |
+----+-------+
1 row in set (0.00 sec)
mysql> select * from user2 where id=2;
+----+-------+
| id | name |
+----+-------+
| 2 | test2 |
+----+-------+
1 row in set (0.00 sec)
mysql> select * from user2 where id=3;
+----+-------+
| id | name |
+----+-------+
| 3 | test3 |
+----+-------+
1 row in set (0.00 sec)
mysql> select * from user2 where id=4;
+----+-------+
| id | name |
+----+-------+
| 4 | test4 |
+----+-------+
1 row in set (0.00 sec)Original comment by tomas.mo...@gmail.com on 23 Jan 2014 at 12:45
Original issue reported on code.google.com by
tomas.mo...@gmail.comon 23 Jan 2014 at 11:57