dm全量同步时如何微调下游tidb中的表结构,以便性能更好

来了老弟 · 2020 年7 月 1 日 14:08

你好，

load 检查表名相同时，会忽略该表的表结构并正常执行 sql。

qq悟空:

报错信息是

"msg": "[code=34012:class=load-unit:scope=internal:level=high] invalid data sql file, cannot find db - pt_buyer_vuqf_0009.buyer_gift_pack_148.sql\
github.com/pingcap/dm/pkg/terror.(*Error).Generate\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/terror/terror.go:232\
github.com/pingcap/dm/loader.(*Loader).prepareDataFiles\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:893\
github.com/pingcap/dm/loader.(*Loader).prepare\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:964\
github.com/pingcap/dm/loader.(*Loader).Restore\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:560\
github.com/pingcap/dm/loader.(*Loader).Process\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:488\
github.com/pingcap/dm/loader.(*Loader).Resume\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/loader/loader.go:678\
runtime.goexit\
\t/usr/local/go/src/runtime/asm_amd64.s:1357",

实际上库和该文件都是存在的，辛苦大佬帮看看解决方案

回归到这个报错，看下 query-status 完整信息，再看下 load 指定 mydumper 的路径是否正确