I have the same problem.
I'm trying to copy all table from serverA to serverB, this process copy all rows, but the last one, this don't copy and then I need insert this last row manually.
I tested in pt-archiver 2.2.4 and 2.2.8
Steps
- In serverA
mysql> use sample
Database changed
mysql> show tables;
+------------------+
| Tables_in_sample |
+------------------+
| random_data |
+------------------+
1 row in set (0.00 sec)
mysql> select count(*) from random_data;
+----------+
| count(*) |
+----------+
| 30000 |
+----------+
1 row in set (0.06 sec)
I have the same problem.
I'm trying to copy all table from serverA to serverB, this process copy all rows, but the last one, this don't copy and then I need insert this last row manually.
I tested in pt-archiver 2.2.4 and 2.2.8
Steps ------- -----+ ------- -----+ ------- -----+
- In serverA
mysql> use sample
Database changed
mysql> show tables;
+------
| Tables_in_sample |
+------
| random_data |
+------
1 row in set (0.00 sec)
mysql> select count(*) from random_data;
+----------+
| count(*) |
+----------+
| 30000 |
+----------+
1 row in set (0.06 sec)
mysql> select * from random_data order by id desc limit 5; -+----- --+---- ---+--- ----+-- -----+ -+----- --+---- ---+--- ----+-- -----+ ------- ------- ----- this row not copy -+----- --+---- ---+--- ----+-- -----+
+------
| id | c1 | c2 | c3 | c4 |
+------
| 30000 | 67938 | 80318 | 97774 | 47916 | <------
| 29999 | 50083 | 36562 | 32562 | 53125 |
| 29998 | 74207 | 20502 | 79891 | 37951 |
| 29997 | 69171 | 88837 | 36671 | 16844 |
| 29996 | 75947 | 45070 | 97510 | 52340 |
+------
5 rows in set (0.00 sec)
- Run pt-archiver in serverA D=sample, t=random_ data --where "1=1" --dest h=192.168.88.22 --user sync --ask-pass --txn-size 10000 --no-delete --progress 10000 --limit 10000
pt-archiver --source h=localhost,
Enter password:
Enter password:
TIME ELAPSED COUNT
2014-06-05T08:18:00 0 0
2014-06-05T08:18:10 9 10000
2014-06-05T08:18:20 19 20000
2014-06-05T08:18:29 28 29999
- Test serverB -+----- --+---- ---+--- ----+-- -----+ -+----- --+---- ---+--- ----+-- -----+ -+----- --+---- ---+--- ----+-- -----+
mysql> select * from random_data order by id desc limit 5;
+------
| id | c1 | c2 | c3 | c4 |
+------
| 29999 | 50083 | 36562 | 32562 | 53125 |
| 29998 | 74207 | 20502 | 79891 | 37951 |
| 29997 | 69171 | 88837 | 36671 | 16844 |
| 29996 | 75947 | 45070 | 97510 | 52340 |
| 29995 | 82478 | 74942 | 27276 | 11555 |
+------
5 rows in set (0.00 sec)
mysql> select count(*) from random_data;
+----------+
| count(*) |
+----------+
| 29999 |
+----------+
1 row in set (0.02 sec)
Thanks in advance