hrboy
(话筒)
1
为提高效率,提问时请尽量提供详细背景信息,问题描述清晰可优先响应。以下信息点请尽量提供:
- 系统版本 & 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,使用限制参考下述链接:
https://pingcap.com/docs-cn/v3.0/reference/tools/data-migration/overview/#使用限制
目前针对 DM + DRDS 没有做过相关场景测试~~~
ericsyh
(Eric Shen)
3
另外 DM 的版本麻烦提供下。
以及确认下用的数据库密码是否使用了 dmctl 进行加密?
hrboy
(话筒)
4
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”
hrboy
(话筒)
5
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文件
ericsyh
(Eric Shen)
6
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 文件?
system
(system)
关闭
7
此话题已在最后回复的 1 分钟后被自动关闭。不再允许新回复。