pt-archiver --where does not work

Bug #1740470 reported by weichun tang
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
New
Undecided
Unassigned

Bug Description

my command is as blow:
pt-archiver --source A=utf8,h=127.0.0.1,P=3306,D=db_name,t=table_name --dest A=utf8,h=10.30.151.225,P=3307,D=db_name,t=table_name --where "id <=73748386" --user=ptcheck --password=check123 --check-slave-lag "h=10.45.236.77,P=3306" --max-lag=200 --check-interval=60 --statistics --progress 1000 --limit 1000 --txn-size 1000 --purge

column "id"is primary key,the command archived data of "where id>73748386",it confused me,thanks for any help!

Revision history for this message
weichun tang (twc19890523) wrote :

my mysql server version is MySQL5.6.30,binlog_format=row

Revision history for this message
weichun tang (twc19890523) wrote :

pt-archiver 3.0.5

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1468

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.