为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:v4.0.7
- 【问题描述】:drainer同步建表语句,tidb可以 mysql报错,导致drainer直接飞掉 ;有没有什么设置可以忽略错误继续执行 不要让应用飞掉
2021/01/19 10:07:26.247 +08:00] [ERROR] [server.go:289] [“syncer exited abnormal”] [error=“failed to add item: Error 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs”] [errorVerbose=“Error(upload://rk8QVECFr8RIPyGMPT9wZoAPDfF.txt) (6.0 KB) 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs\ngithub.com/pingcap/errors.AddStack\ \t/home/jenkins/agent/workspace/build_binlog_multi_branch_v4.0.7/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20190809092503-95897b64e011/errors.go:174\ github.com/pingcap/errors.Trace\ \t/home/jenkins/agent/workspace/build_binlog_multi_branch_v4.0.7/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20190809092503-95897b64e011/juju_adaptor.go:15\ github.com/pingcap/tidb-binlog/pkg/loader.(*loaderImpl).execDDL\ \t/home/jenkins/agent/workspace/build_binlog_multi_branch_v4.0.7/go/src/github.com/pingcap/tidb-binlog/pkg/loader/load.go:431\ngithub.com/pingcap/tidb-binlog/pkg/loader.(*batchManager).execDDL\ \t/home/jenkins/agent/workspace/build_binlog_multi_branch_v4.0.7/go/src/github.com/pingcap/tidb-binlog/pkg/loader/load.go:748\ngithub.com/pingcap/tidb-binlog/pkg/loader.(*batchManager).put\ \t/home/jenkins/agent/workspace/build_binlog_multi_branch_v4.0.7/go/src/github.com/pingcap/tidb-binlog/pkg/loader/load.go:770\ngithub.com/pingcap/tidb-binlog/pkg/loader.(*loaderImpl).Run\ \t/home/jenkins/agent/workspace/build_binlog_multi_branch_v4.0.7/go/src/github.com/pingcap/tidb-binlog/pkg/loader/load.go:624\ngithub.com/pingcap/tidb-binlog/drainer/sync.(*MysqlSyncer).run\ \t/home/jenkins/agent/workspace/build_binlog_multi_branch_v4.0.7/go/src/github.com/pingcap/tidb-binlog/drainer/sync/mysql.go:237\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1357\ failed to add item”]