用pt-online-schema-change 进行大表加索引,但syncer同步不了

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

  • 【TiDB 版本】:V3.0.8
  • 【问题描述】:

2020/04/08 21:00:27 ddl.go:110: [warning] will split alter table statement: ALTER TABLE dyaccount._user_extend_new ADD index idx_userpin(user_pin)
2020/04/08 21:00:27 ast.go:521: [info] spec &{node:{text:} IfExists:false IfNotExists:false NoWriteToBinlog:false OnAllPartitions:false Tp:3 Name: Constraint:0xc0002ceb60 Options:[] OrderByList:[] NewTable: NewColumns:[] NewConstraints:[] OldColumnName: NewColumnName: Position: LockType: Algorithm:DEFAULT Comment: FromKey: ToKey: Partition: PartitionNames:[] PartDefinitions:[] WithValidation:false Num:0 Visibility:0 TiFlashReplica:}
2020/04/08 21:00:27 ddl.go:114: [warning] splitted alter table statement: [ALTER TABLE dyaccount._user_extend_new ADD INDEX idx_userpin (user_pin)]
2020/04/08 21:00:27 syncer.go:754: [info] [query]ALTER TABLE dyaccount._user_extend_new ADD index idx_userpin(user_pin) [current pos](mysql-bin.000240, 113641935) [next pos](mysql-bin.000240, 113642133) [current gtid set] [next gtid set]

您好,

task 中配置 online-ddl-scheme:"pt"
这里面正常上游执行 pt-osc ,dm 会跳过相关的拷贝表操作,但是不设置这个参数,dm 还会处理。
https://pingcap.com/docs-cn/tidb-data-migration/stable/feature-online-ddl-scheme/#online-schema-change-pt