DM同步数据报错

  • 【TiDB 版本】:4.0.0-beta1
  • 【问题描述】: DM 增量同步数据报错

“msg”: “[code=30015:class=relay-unit:scope=upstream:level=high] TCPReader get relay event with error: ERROR 1236 (HY000): Binary log is not open\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”, “error”: null

这个要怎么处理呢。。。

您好: 1. 请问您要使用 DM 从上游同步 MySQL 数据到 TiDB 吗? 需要开启上游 MySQL 的 binlog ,产生binlog 文件才行, 开启 MySQL binlog 可以搜索网上的方法,多谢

已经开启binlog了。 mysql> show variables like ‘%log_bin%’; ±--------------------------------±-------------------------------+ | Variable_name | Value | ±--------------------------------±-------------------------------+ | log_bin | ON |

6 rows in set (0.00 sec)

resume-relay -w 172.16.8.36:8262
使用这个命令就恢复啦。:smiley:

:+1:

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