The drainer component does not report errors, but binlog data is not synchronized to the downstream

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: drainer组件不报错,但是binlog数据不同步到下游

| username: vesa

【TiDB Usage Environment】Production\Testing Environment\POC
【TiDB Version】6.1.0
【Encountered Problem】The drainer component does not report errors, but binlog data is not synchronized to the downstream
【Reproduction Path】

  1. BR backup database;
  2. Restore the database to the downstream TiDB
  3. Scale-out drainer on the original TiDB to transfer binlog real-time data to the downstream;
    The transmission network between upstream and downstream is fine;
    Drainer logs do not report errors;
    Checkpoint records can also be found in the downstream binlog database;
    The commit_ts of drainer synchronized data is the timestamp of the backup database;
    【Problem Phenomenon and Impact】
    Real-time data is not synchronized, binlog is not written to the downstream database;
    【Attachments】
  • Relevant logs, configuration files, Grafana monitoring (https://metricstool.pingcap.com/)
  • TiUP Cluster Display information
  • TiUP Cluster Edit config information
  • TiDB-Overview monitoring
  • Corresponding module Grafana monitoring (if any, such as BR, TiDB-binlog, TiCDC, etc.)
  • Corresponding module logs (including logs 1 hour before and after the issue)

If the question is related to performance optimization or troubleshooting, please download the script and run it. Please select all and copy-paste the terminal output results for upload.

| username: xfworld | Original post link

I recommend using TiCDC


Refer to my comments:

| username: qizheng | Original post link

It could also be that TiDB binlog is not enabled, or after the TiDB server encounters an error while writing the binlog, it stops writing the binlog.

| username: buddyyuan | Original post link

Please upload the binlog monitoring from Grafana.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.