pt-archiver --where does not work

Bug #1740470 reported by weichun tang on 2017-12-29
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!

weichun tang (twc19890523) wrote :

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

weichun tang (twc19890523) wrote :

pt-archiver 3.0.5

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  Edit
Everyone can see this information.

Other bug subscribers