上游mysql修改表结构导致dm同步失败

为提高效率,提问时请尽量提供详细背景信息,问题描述清晰可优先响应。以下信息点请尽量提供:

  • 系统版本 & kernel 版本
  • TiDB 版本
  • 磁盘型号
  • 集群节点分布
  • 数据量 & region 数量 & 副本数
  • 问题描述(我做了什么)
  • 关键词】“msg”: “[code=10006:class=database:scope=downstream:level=high] execute statement failed: ALTER TABLE yx_center.game_activity MODIFY COLUMN sdate VARCHAR(255) CHARACTER SET UTF8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER type: Error 1105: unsupported modify charset from binary to utf8\ngithub.com/pingcap/dm/pkg/terror.(*Error).Delegate\n\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/terror/terror.go:267\ngithub.com/pingcap/dm/pkg/baseconn.(*BaseConn).ExecuteSQLWithIgnoreError\n\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/baseconn/conn.go:179\ngithub.com/pingcap/dm/syncer.(*Conn).executeSQLWithIgnore.func2\n\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/db.go:178\ngithub.com/pingcap/dm/pkg/retry.(*FiniteRetryStrategy).Apply\n\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/retry/strategy.go:71\ngithub.com/pingcap/dm/pkg/baseconn.(*BaseConn).ApplyRetryStrategy\n\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/baseconn/conn.go:200\ngithub.com/pingcap/dm/syncer.(*Conn).executeSQLWithIgnore\n\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/db.go:173\ngithub.com/pingcap/dm/syncer.(*Syncer).sync\n\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:932\ngithub.com/pingcap/dm/syncer.(*Syncer).Run.func3\n\t/home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:1068\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1337”

请提供下上游 MySQL、下游 TiDB ,以及DM 的版本~~

ERROR 1105 (HY000): unsupported modify charset from binary to utf8 出现了这个问题怎么解决

下上游 MySQL、下游 TiDB ,以及DM 的版本,在某些版本下,可能存在这个问题,请先提供相关版本信息