通过DM-Portal可视化界面配置合库合表yml文件，check-start 报异常

🪐 TiDB 技术问题 备份&数据迁移
1

在同一个mysql实例下，我有10个库，每个库下面有同样的两张表test1,test2 我打算把这个mysql同步到同一个TIDB库下，合库合表，一个库两个表 通过dm-portal 可视化界面配置以后， Welcome to dmctl Release Version: v1.0.0-9-gac64db13 Git Commit Hash: ac64db13f24ace3c1bf61790de11519ee88f148a Git Branch: master UTC Build Time: 2019-09-05 08:25:59 Go Version: go version go1.12 linux/amd64

» check-task ./new-task.yaml { “result”: false, “msg”: “[code=26002:class=dm-master:scope=upstream:level=high] fail to initial checker: failed to open DSN dm:***@192.168.1.2:3306 github.com/pingcap/dm/pkg/terror.(*Error).Generate /home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/terror/terror.go:232 github.com/pingcap/dm/checker.(*Checker).Init /home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/checker/checker.go:129 github.com/pingcap/dm/checker.CheckSyncConfig /home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/checker/cmd.go:50 github.com/pingcap/dm/dm/master.(*Server).generateSubTask /home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/master/server.go:1847 github.com/pingcap/dm/dm/master.(*Server).CheckTask /home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/master/server.go:1816 github.com/pingcap/dm/dm/pb._Master_CheckTask_Handler /home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/pb/dmmaster.pb.go:1818 google.golang.org/grpc.(*Server).processUnaryRPC /go/pkg/mod/google.golang.org/grpc@v1.23.0/server.go:995 google.golang.org/grpc.(*Server).handleStream /go/pkg/mod/google.golang.org/grpc@v1.23.0/server.go:1275 google.golang.org/grpc.(*Server).serveStreams.func1.1 /go/pkg/mod/google.golang.org/grpc@v1.23.0/server.go:710 runtime.goexit /usr/local/go/src/runtime/asm_amd64.s:1337” }

1 个赞
2

麻烦发一下 task 及相关配置文件，从报错信息看，数据库建立连接失败，确认一下上游数据库是可以正常访问的吗？用户是否有足够的权限

3

我确认过，数据库连接没有问题，上游数据库是可以访问的。 配置如下： name: increate task-mode: incremental is-sharding: true target-database: host: xxx port: 4000 user: xxx password: xxxx mysql-instances:

  • source-id: replica-1 meta: binlog-name: mysql-bin.0000253 binlog-pos: 4 filter-rules: [] route-rules:
    • replica-1.route_rules.6
    • replica-1.route_rules.8
    • replica-1.route_rules.10
    • replica-1.route_rules.13
    • replica-1.route_rules.16
    • replica-1.route_rules.21
    • replica-1.route_rules.1
    • replica-1.route_rules.4
    • replica-1.route_rules.5
    • replica-1.route_rules.18
    • replica-1.route_rules.19
    • replica-1.route_rules.20
    • replica-1.route_rules.22
    • replica-1.route_rules.24
    • replica-1.route_rules.27
    • replica-1.route_rules.2
    • replica-1.route_rules.7
    • replica-1.route_rules.17
    • replica-1.route_rules.25
    • replica-1.route_rules.29
    • replica-1.route_rules.3
    • replica-1.route_rules.9
    • replica-1.route_rules.31
    • replica-1.route_rules.14
    • replica-1.route_rules.23
    • replica-1.route_rules.30
    • replica-1.route_rules.11
    • replica-1.route_rules.12
    • replica-1.route_rules.15
    • replica-1.route_rules.26
    • replica-1.route_rules.28 black-white-list: replica-1.bw_list.1 mydumper-config-name: replica-1.dump routes: replica-1.route_rules.1: schema-pattern: test_10 table-pattern: “” target-schema: test target-table: “” replica-1.route_rules.2: schema-pattern: test_1 table-pattern: test_table_1 target-schema: test target-table: test_table_1 replica-1.route_rules.3: schema-pattern: test_10 table-pattern: test_table_1 target-schema: test target-table: test_table_1 replica-1.route_rules.4: schema-pattern: test_11 table-pattern: test_table_1 target-schema: test target-table: test_table_1 replica-1.route_rules.5: schema-pattern: test_12 table-pattern: test_table_1 target-schema: test target-table: test_table_1 replica-1.route_rules.6: schema-pattern: test_13 table-pattern: test_table_1 target-schema: test target-table: test_table_1 replica-1.route_rules.7: schema-pattern: test_14 table-pattern: test_table_1 target-schema: test target-table: test_table_1 replica-1.route_rules.8: schema-pattern: test_15 table-pattern: test_table_1 target-schema: test target-table: test_table_1 replica-1.route_rules.9: schema-pattern: test_2 table-pattern: test_table_1 target-schema: test target-table: test_table_1 replica-1.route_rules.10: schema-pattern: test_3 table-pattern: test_table_1 target-schema: test target-table: test_table_1 replica-1.route_rules.11: schema-pattern: test_4 table-pattern: test_table_1 target-schema: test target-table: test_table_1 replica-1.route_rules.12: schema-pattern: test_5 table-pattern: test_table_1 target-schema: test target-table: test_table_1 replica-1.route_rules.13: schema-pattern: test_6 table-pattern: test_table_1 target-schema: test target-table: test_table_1 replica-1.route_rules.14: schema-pattern: test_7 table-pattern: test_table_1 target-schema: test target-table: test_table_1 replica-1.route_rules.15: schema-pattern: test_8 table-pattern: test_table_1 target-schema: test target-table: test_table_1 replica-1.route_rules.16: schema-pattern: test_9 table-pattern: test_table_1 target-schema: test target-table: test_table_1 replica-1.route_rules.17: schema-pattern: test_1 table-pattern: test_table_2 target-schema: test target-table: test_table_2 replica-1.route_rules.18: schema-pattern: test_10 table-pattern: test_table_2 target-schema: test target-table: test_table_2 replica-1.route_rules.19: schema-pattern: test_11 table-pattern: test_table_2 target-schema: test target-table: test_table_2 replica-1.route_rules.20: schema-pattern: test_12 table-pattern: test_table_2 target-schema: test target-table: test_table_2 replica-1.route_rules.21: schema-pattern: test_13 table-pattern: test_table_2 target-schema: test target-table: test_table_2 replica-1.route_rules.22: schema-pattern: test_14 table-pattern: test_table_2 target-schema: test target-table: test_table_2 replica-1.route_rules.23: schema-pattern: test_15 table-pattern: test_table_2 target-schema: test target-table: test_table_2 replica-1.route_rules.24: schema-pattern: test_2 table-pattern: test_table_2 target-schema: test target-table: test_table_2 replica-1.route_rules.25: schema-pattern: test_3 table-pattern: test_table_2 target-schema: test target-table: test_table_2 replica-1.route_rules.26: schema-pattern: test_4 table-pattern: test_table_2 target-schema: test target-table: test_table_2 replica-1.route_rules.27: schema-pattern: test_5 table-pattern: test_table_2 target-schema: test target-table: test_table_2 replica-1.route_rules.28: schema-pattern: test_6 table-pattern: test_table_2 target-schema: test target-table: test_table_2 replica-1.route_rules.29: schema-pattern: test_7 table-pattern: test_table_2 target-schema: test target-table: test_table_2 replica-1.route_rules.30: schema-pattern: test_8 table-pattern: test_table_2 target-schema: test target-table: test_table_2 replica-1.route_rules.31: schema-pattern: test_9 table-pattern: test_table_2 target-schema: test target-table: test_table_2 filters: {} black-white-list: replica-1.bw_list.1: do-tables:
      • db-name: test_1 tbl-name: test_table_1
      • db-name: test_1 tbl-name: test_table_2
      • db-name: test_10 tbl-name: test_table_1
      • db-name: test_10 tbl-name: test_table_2
      • db-name: test_11 tbl-name: test_table_1
      • db-name: test_11 tbl-name: test_table_2
      • db-name: test_12 tbl-name: test_table_1
      • db-name: test_12 tbl-name: test_table_2
      • db-name: test_13 tbl-name: test_table_1
      • db-name: test_13 tbl-name: test_table_2
      • db-name: test_14 tbl-name: test_table_1
      • db-name: test_14 tbl-name: test_table_2
      • db-name: test_15 tbl-name: test_table_1
      • db-name: test_15 tbl-name: test_table_2
      • db-name: test_2 tbl-name: test_table_1
      • db-name: test_2 tbl-name: test_table_2
      • db-name: test_3 tbl-name: test_table_1
      • db-name: test_3 tbl-name: test_table_2
      • db-name: test_4 tbl-name: test_table_1
      • db-name: test_4 tbl-name: test_table_2
      • db-name: test_5 tbl-name: test_table_1
      • db-name: test_5 tbl-name: test_table_2
      • db-name: test_6 tbl-name: test_table_1
      • db-name: test_6 tbl-name: test_table_2
      • db-name: test_7 tbl-name: test_table_1
      • db-name: test_7 tbl-name: test_table_2
      • db-name: test_8 tbl-name: test_table_1
      • db-name: test_8 tbl-name: test_table_2
      • db-name: test_9 tbl-name: test_table_1
      • db-name: test_9 tbl-name: test_table_2 do-dbs: [] ignore-tables:
      • db-name: xx_tmp tbl-name: xxx ignore-dbs: [] mydumpers: replica-1.dump: mydumper-path: bin/mydumper threads: 4 chunk-filesize: 64 skip-tz-utc: true extra-args: -T test_1.test_table_1,test_1.test_table_2,test_10.test_table_1,test_10.test_table_2,test_11.test_table_1,test_11.test_table_2,test_12.test_table_1,test_12.test_table_2,test_13.test_table_1,test_13.test_table_2,test_14.test_table_1,test_14.test_table_2,test_15.test_table_1,test_15.test_table_2,test_2.test_table_1,test_2.test_table_2,test_3.test_table_1,test_3.test_table_2,test_4.test_table_1,test_4.test_table_2,test_5.test_table_1,test_5.test_table_2,test_6.test_table_1,test_6.test_table_2,test_7.test_table_1,test_7.test_table_2,test_8.test_table_1,test_8.test_table_2,test_9.test_table_1,test_9.test_table_2
4

@xqwbx163 能麻烦执行 query-status 看一下当前的 relayStatus? 另外，在部署 DM 时，在 inventory.ini 内配置的上游 MySQL 密码是使用 dmctl 加密后的吗

5

此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。