完整错误信息如下:
“msg”: “[code=30015:class=relay-unit:scope=upstream:level=high] TCPReader get relay event with error: ERROR 1236 (HY000): Could not find first log file name in binary log index file\ngithub.com/pingcap/dm/pkg/terror.(*Error).Delegate\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/terror/terror.go:267\ngithub.com/pingcap/dm/pkg/binlog/reader.(*TCPReader).GetEvent\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/pkg/binlog/reader/tcp.go:151\ngithub.com/pingcap/dm/relay/reader.(*reader).GetEvent\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/relay/reader/reader.go:144\ngithub.com/pingcap/dm/relay.(*Relay).handleEvents\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/relay/relay.go:382\ngithub.com/pingcap/dm/relay.(*Relay).process\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/relay/relay.go:292\ngithub.com/pingcap/dm/relay.(*Relay).Process\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/relay/relay.go:191\ngithub.com/pingcap/dm/dm/worker.(*realRelayHolder).run\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/worker/relay.go:167\ngithub.com/pingcap/dm/dm/worker.(*realRelayHolder).Start.func1\
\t/home/jenkins/agent/workspace/build_dm_master/go/src/github.com/pingcap/dm/dm/worker/relay.go:143\
runtime.goexit\
\t/usr/local/go/src/runtime/asm_amd64.s:1357”
[问题描述]
DM版本: Release Version: v1.1.0-alpha-76-g340487fGit
问题描述:DM同步报错 ERROR 1236 (HY000): Could not find first log file name in binary log index file
[问题分析]
1.启动dm-worker成功,loader成功导入
2.查看relay log没有拉取上游日志,查看relay log目录属主权限都正确
3.由于使用的是alpha版本,修改了relay log自动拉取方式,需要配置参数才能在dm-worker启动后自动拉取relay log
[解决方案]
在dm-worker.toml文件配置参数enable-relay = true,对其格式,和server-id在一个标签页下.
重新启动dm-worker,可以自动拉取relay log.
[问题根因]
1.alpha版本是测试版本,尽量不要在生产环境使用,稳定版本会有修改配置的介绍。 2.对于lastest版本的管控,我们也会尽快做出调整,多谢