Unsupported modify column出现这样的同步错误怎么解决

[parker (Hacker M Eb72 Qza)]

“errors”: [
{
“Type”: “ExecSQL”,
“msg”: “[code=10006:class=database:scope=downstream:level=high] execute statement failed: ALTER TABLE devicecloud_q.zk_mac_online_biophoto_db MODIFY COLUMN FILE_NAME VARCHAR(40) CHARACTER SET UTF8 COLLATE utf8_general_ci NOT NULL COMMENT ‘生物特征图片的文件名，目前只支持jpg格式’ AFTER PIN_: Error 8200: Unsupported modify column: length 40 is less than origin 50\ngithub.com/pingcap/dm/pkg/terror.(*Error).Delegate\ \t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/terror/terror.go:267\ngithub.com/pingcap/dm/pkg/conn.(*BaseConn).ExecuteSQLWithIgnoreError\ \t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/conn/baseconn.go:159\ngithub.com/pingcap/dm/syncer.(*DBConn).executeSQLWithIgnore.func2\ \t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/db.go:257\ngithub.com/pingcap/dm/pkg/retry.(*FiniteRetryStrategy).Apply\ \t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/retry/strategy.go:71\ngithub.com/pingcap/dm/pkg/conn.(*BaseConn).ApplyRetryStrategy\ \t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/conn/baseconn.go:180\ngithub.com/pingcap/dm/syncer.(*DBConn).executeSQLWithIgnore\ \t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/db.go:252\ngithub.com/pingcap/dm/syncer.(*Syncer).syncDDL\ \t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:884\ngithub.com/pingcap/dm/syncer.(*Syncer).Run.func3\ \t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/syncer/syncer.go:1085\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1337”,
“error”: null
}
],

[来了老弟]

tidb 不支持字段类型的有损变更，可以使用 sql-skip 进行跳过下。