DM同步时报错TCPReader get relay event with error: ERROR 1236 (HY000): Could not find first log file name in binary log index file

完整错误信息如下:
“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在一个标签页下.

image

重新启动dm-worker,可以自动拉取relay log.

[问题根因]

1.alpha版本是测试版本,尽量不要在生产环境使用,稳定版本会有修改配置的介绍。 2.对于lastest版本的管控,我们也会尽快做出调整,多谢