Comment 5 for bug 1096274

I have a similar issue....
when there are records remaining that are LESS than the LIMIT - they are not copied.

In the following - there are 20111 records in the data set under the WHERE condition. But I only end up with
20000 records copied over.

pt-archiver --source h=10.0.10.140,D=db,t=tbl,u=perconatool,p=pswd--dest h=10.0.2.116,D=db,t=tbl_2014Q3_Cont,u=perconatool,p=pswd--where "DTime<='2014-08-19' and DTime>'2014-07-30'" --limit 500 --txn-size 500 --statistics --progress 500 --max-lag 10 --retries 10 --no-delete --password pswd --check-slave-lag h=10.0.10.137 --check-slave-lag h=10.0.10.138 --check-slave-lag h=10.0.10.139

I have played with this for a while now....seems that every time - if the LIMIT is set higher than the remaining records - it will just copy over everything except for the very last records that are under the LIMIT.

Also if you attempt to copy over a small number of records - say 100 and your LIMIT is set to 500 - the tool will not Copy ANYTHING! It just hangs!!!