DM 从DRDS取数据报错,请问有解决方案吗?

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

  • 系统版本 & kernel 版本:Linux 131 3.10.0-693.el7.x86_64 #1 SMP Tue Aug 22 21:09:27 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
  • TiDB 版本:V 1.1.0
  • 磁盘型号:
  • 集群节点分布:3
  • 数据量 & region 数量 & 副本数:
  • 集群 QPS、.999-Duration、读写比例:
  • 问题描述(我做了什么):DM 从DRDS 拉数据,配置之后提示msg": "[code=10001:class=database:scope=not-set:level=high] database driver error: Error 1045: [10.29.217.16:3306]Access denied for user ‘kfpt’@‘XXX.XXX.XXX.XXX’ngithub.com/pingcap/dm/pkg/terror.(*Error).Delegate /home/jenkins/wo 密码和及host地址确认正确

根据官方文档介绍目前 DM 支持的数据库类型为 MySQL 和 MariaDB,使用限制参考下述链接:

目前针对 DM + DRDS 没有做过相关场景测试~~~

另外 DM 的版本麻烦提供下。 以及确认下用的数据库密码是否使用了 dmctl 进行加密?

Dm v1.10 目前已经解决了这个问题,但还是报 “Type”: “UnknownError”, “msg”: “[code=30012:class=relay-unit:scope=upstream:level=high] start reader for UUID f93764dc-49de-11e8-a7bc-7cd30ae45794.000004: start sync from position (, 4): dial tcp: i/o timeoutngithub.com/pingcap/dm/pkg/terror.(*Error).Delegate /home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/terror/terror.go:267ngithub.com/pingcap/dm/pkg/binlog/reader.(*TCPReader).StartSyncByPos /home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/binlog/reader/tcp.go:79ngithub.com/pingcap/dm/relay/reader.(*reader).setUpReaderByPos /home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/relay/reader/reader.go:166ngithub.com/pingcap/dm/relay/reader.(*reader).Start /home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/relay/reader/reader.go:111ngithub.com/pingcap/dm/relay.(*Relay).setUpReader /home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/relay/relay.go:586ngithub.com/pingcap/dm/relay.(*Relay).process /home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/relay/relay.go:256ngithub.com/pingcap/dm/relay.(*Relay).Process /home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/relay/relay.go:191ngithub.com/pingcap/dm/dm/worker.(*realRelayHolder).run /home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/worker/relay.go:165ngithub.com/pingcap/dm/dm/worker.(*realRelayHolder).Start.func1 /home/jenkins/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/worker/relay.go:141 runtime.goexit /usr/local/go/src/runtime/asm_amd64.s:1337”

dm-worker1 ansible_host=172.16.10.11 source_id=“mysql-replica-01” server_id=102 relay_binlog_name=“mysql-bin.002171” mysql_host=drdsxxxxxxxxxxxxxxxx.drds.aliyuncs.com mysql_user=kXXX mysql_password=‘XXXXXXXXXXXXXXXXXXXXXXX==’ mysql_port=3306 已经配置了binglog文件

f93764dc-49de-11e8-a7bc-7cd30ae45794.000004: start sync from position (, 4) 看起来是 relay log 没拉到对应的 binlog 文件。麻烦看下 172.16.10.11 worker 的 relay log 目录中, f93764dc-49de-11e8-a7bc-7cd30ae45794.000004 下有没有相应的 binlog 文件?