tidb8.5.3 DM实时同步速度非常慢，请大佬们支持

wenyi · 2025 年8 月 18 日 09:14

【TiDB 使用环境】生产环境
【TiDB 版本】8.5.3
【操作系统】rocky9.6
【部署方式】物理机部署，SSD磁盘
【集群数据量】350G
【集群节点数】3个节点
mysql5.7.38通过dm实时同步到tidb8.5.3，实时同步非常慢
1、上游mysql负载说明
mysql备库，专为tidb实时同步准备，无任何业务运行

2、DM负载情况

3、TIDB集群负载

4、问题
dm实时同步太慢，tidb数据滞后mysql 五个小时左右

wenyi · 2025 年8 月 18 日 09:18

[2025/08/18 17:14:15.906 +08:00] [INFO] [ddl.go:459] [“finish to handle ddls in normal mode”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [mode=normal] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS ahis_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660303493), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152888,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660303948), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152888:10002152890,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660303948), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152888:10002152890,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), trackInfos: {originDDL: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), routedDDL: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), sourceTables: aier_center_log.ahis_logs, targetTables: aier_center_log.ahis_logs}}”]
[2025/08/18 17:14:15.906 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.906 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.906 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.906 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.906 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.906 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.906 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.906 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.906 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.906 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.906 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.906 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.906 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.907 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.907 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.907 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.907 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.907 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.907 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.907 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.907 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.907 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.907 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.907 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.907 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.907 +08:00] [INFO] [ddl.go:955] [“parse ddl”] [task=tidb-logdb] [unit=“binlog replication”] [event=query] [“query event context”=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS ahis_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660336531), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152914,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660336986), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660336986), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: , trackInfos: }”]
[2025/08/18 17:14:15.907 +08:00] [INFO] [ddl.go:309] [“ready to split ddl”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS ahis_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660336531), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152914,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660336986), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660336986), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: , trackInfos: }”]
[2025/08/18 17:14:15.907 +08:00] [INFO] [ddl.go:1127] [“get ddl event type”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event_type=“create table”]
[2025/08/18 17:14:15.907 +08:00] [INFO] [ddl.go:329] [“resolve sql”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event=query] [appliedDDLs=“["CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id))"]”] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS ahis_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660336531), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152914,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660336986), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660336986), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: , trackInfos: }”]
[2025/08/18 17:14:15.907 +08:00] [INFO] [ddl.go:390] [“prepare to handle ddls”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS ahis_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660336531), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152914,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660336986), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660336986), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), trackInfos: {originDDL: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), routedDDL: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), sourceTables: aier_center_log.ahis_logs, targetTables: aier_center_log.ahis_logs}}”]
[2025/08/18 17:14:15.907 +08:00] [INFO] [syncer.go:3212] [“flush all jobs”] [task=tidb-logdb] [unit=“binlog replication”] [“global checkpoint”=“location(position: (mysql-bin.025884, 660336466), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152914,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1) (flushed location(position: (mysql-bin.025884, 660303948), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152888:10002152890,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1))”] [“flush job seq”=168413]
[2025/08/18 17:14:15.911 +08:00] [INFO] [checkpoint_flush_worker.go:67] [“about to sync flush checkpoint snapshot”] [task=tidb-logdb] [unit=“binlog replication”] [snapshot_id=336824]
[2025/08/18 17:14:15.917 +08:00] [INFO] [checkpoint_flush_worker.go:108] [“sync flush checkpoint snapshot successfully”] [task=tidb-logdb] [unit=“binlog replication”] [snapshot_id=336824] [pos=“position: (mysql-bin.025884, 660336466), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152914,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1”]
[2025/08/18 17:14:15.917 +08:00] [INFO] [syncer.go:1372] [“after sync flushed checkpoint, gc all causality keys”] [task=tidb-logdb] [unit=“binlog replication”]
[2025/08/18 17:14:15.917 +08:00] [INFO] [ddl.go:418] [“start to handle ddls in normal mode”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [mode=normal] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS ahis_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660336531), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152914,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660336986), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660336986), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), trackInfos: {originDDL: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), routedDDL: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), sourceTables: aier_center_log.ahis_logs, targetTables: aier_center_log.ahis_logs}}”]
[2025/08/18 17:14:15.920 +08:00] [INFO] [checkpoint_flush_worker.go:67] [“about to sync flush checkpoint snapshot”] [task=tidb-logdb] [unit=“binlog replication”] [snapshot_id=336825]
[2025/08/18 17:14:15.923 +08:00] [INFO] [checkpoint_flush_worker.go:108] [“sync flush checkpoint snapshot successfully”] [task=tidb-logdb] [unit=“binlog replication”] [snapshot_id=336825] [pos=“position: (mysql-bin.025884, 660336986), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1”]
[2025/08/18 17:14:15.923 +08:00] [INFO] [syncer.go:1372] [“after sync flushed checkpoint, gc all causality keys”] [task=tidb-logdb] [unit=“binlog replication”]
[2025/08/18 17:14:15.923 +08:00] [INFO] [ddl.go:459] [“finish to handle ddls in normal mode”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [mode=normal] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS ahis_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660336531), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152914,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660336986), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660336986), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), trackInfos: {originDDL: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), routedDDL: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), sourceTables: aier_center_log.ahis_logs, targetTables: aier_center_log.ahis_logs}}”]
[2025/08/18 17:14:15.924 +08:00] [INFO] [ddl.go:955] [“parse ddl”] [task=tidb-logdb] [unit=“binlog replication”] [event=query] [“query event context”=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS ahis_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660337051), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660337506), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152916,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660337506), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152916,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: , trackInfos: }”]
[2025/08/18 17:14:15.924 +08:00] [INFO] [ddl.go:309] [“ready to split ddl”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS ahis_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660337051), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660337506), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152916,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660337506), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152916,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: , trackInfos: }”]
[2025/08/18 17:14:15.924 +08:00] [INFO] [ddl.go:1127] [“get ddl event type”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event_type=“create table”]
[2025/08/18 17:14:15.924 +08:00] [INFO] [ddl.go:329] [“resolve sql”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event=query] [appliedDDLs=“["CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id))"]”] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS ahis_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660337051), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660337506), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152916,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660337506), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152916,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: , trackInfos: }”]
[2025/08/18 17:14:15.924 +08:00] [INFO] [ddl.go:390] [“prepare to handle ddls”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS ahis_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660337051), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660337506), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152916,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660337506), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152916,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), trackInfos: {originDDL: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), routedDDL: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), sourceTables: aier_center_log.ahis_logs, targetTables: aier_center_log.ahis_logs}}”]
[2025/08/18 17:14:15.924 +08:00] [INFO] [syncer.go:3212] [“flush all jobs”] [task=tidb-logdb] [unit=“binlog replication”] [“global checkpoint”=“location(position: (mysql-bin.025884, 660336986), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1) (flushed location(position: (mysql-bin.025884, 660336986), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1))”] [“flush job seq”=168414]
[2025/08/18 17:14:15.924 +08:00] [INFO] [ddl.go:418] [“start to handle ddls in normal mode”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [mode=normal] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS ahis_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660337051), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660337506), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152916,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660337506), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152916,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), trackInfos: {originDDL: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), routedDDL: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), sourceTables: aier_center_log.ahis_logs, targetTables: aier_center_log.ahis_logs}}”]
[2025/08/18 17:14:15.927 +08:00] [INFO] [checkpoint_flush_worker.go:67] [“about to sync flush checkpoint snapshot”] [task=tidb-logdb] [unit=“binlog replication”] [snapshot_id=336827]
[2025/08/18 17:14:15.930 +08:00] [INFO] [checkpoint_flush_worker.go:108] [“sync flush checkpoint snapshot successfully”] [task=tidb-logdb] [unit=“binlog replication”] [snapshot_id=336827] [pos=“position: (mysql-bin.025884, 660337506), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152916,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1”]
[2025/08/18 17:14:15.930 +08:00] [INFO] [syncer.go:1372] [“after sync flushed checkpoint, gc all causality keys”] [task=tidb-logdb] [unit=“binlog replication”]
[2025/08/18 17:14:15.930 +08:00] [INFO] [ddl.go:459] [“finish to handle ddls in normal mode”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [mode=normal] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS ahis_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660337051), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152915,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660337506), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152916,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660337506), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152916,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), trackInfos: {originDDL: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), routedDDL: CREATE TABLE IF NOT EXISTS aier_center_log.ahis_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), sourceTables: aier_center_log.ahis_logs, targetTables: aier_center_log.ahis_logs}}”]
[2025/08/18 17:14:15.930 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.930 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.930 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.930 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.930 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.930 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.930 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.930 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.931 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.931 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.931 +08:00] [INFO] [ddl.go:955] [“parse ddl”] [task=tidb-logdb] [unit=“binlog replication”] [event=query] [“query event context”=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660375720), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152926,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660376179), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660376179), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: , trackInfos: }”]
[2025/08/18 17:14:15.931 +08:00] [INFO] [ddl.go:309] [“ready to split ddl”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660375720), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152926,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660376179), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660376179), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: , trackInfos: }”]
[2025/08/18 17:14:15.931 +08:00] [INFO] [ddl.go:1127] [“get ddl event type”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event_type=“create table”]
[2025/08/18 17:14:15.931 +08:00] [INFO] [ddl.go:329] [“resolve sql”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event=query] [appliedDDLs=“["CREATE TABLE IF NOT EXISTS aier_center_log.payQueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id))"]”] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660375720), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152926,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660376179), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660376179), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: , trackInfos: }”]
[2025/08/18 17:14:15.931 +08:00] [INFO] [ddl.go:390] [“prepare to handle ddls”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660375720), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152926,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660376179), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660376179), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: CREATE TABLE IF NOT EXISTS aier_center_log.payqueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), trackInfos: {originDDL: CREATE TABLE IF NOT EXISTS aier_center_log.payQueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), routedDDL: CREATE TABLE IF NOT EXISTS aier_center_log.payqueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), sourceTables: aier_center_log.payqueue_logs, targetTables: aier_center_log.payqueue_logs}}”]
[2025/08/18 17:14:15.931 +08:00] [INFO] [syncer.go:3212] [“flush all jobs”] [task=tidb-logdb] [unit=“binlog replication”] [“global checkpoint”=“location(position: (mysql-bin.025884, 660375655), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152926,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1) (flushed location(position: (mysql-bin.025884, 660337506), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152916,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1))”] [“flush job seq”=168415]
[2025/08/18 17:14:15.933 +08:00] [INFO] [checkpoint_flush_worker.go:67] [“about to sync flush checkpoint snapshot”] [task=tidb-logdb] [unit=“binlog replication”] [snapshot_id=336828]
[2025/08/18 17:14:15.939 +08:00] [INFO] [checkpoint_flush_worker.go:108] [“sync flush checkpoint snapshot successfully”] [task=tidb-logdb] [unit=“binlog replication”] [snapshot_id=336828] [pos=“position: (mysql-bin.025884, 660375655), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152926,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1”]
[2025/08/18 17:14:15.939 +08:00] [INFO] [syncer.go:1372] [“after sync flushed checkpoint, gc all causality keys”] [task=tidb-logdb] [unit=“binlog replication”]
[2025/08/18 17:14:15.939 +08:00] [INFO] [ddl.go:418] [“start to handle ddls in normal mode”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [mode=normal] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660375720), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152926,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660376179), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660376179), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: CREATE TABLE IF NOT EXISTS aier_center_log.payqueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), trackInfos: {originDDL: CREATE TABLE IF NOT EXISTS aier_center_log.payQueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), routedDDL: CREATE TABLE IF NOT EXISTS aier_center_log.payqueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), sourceTables: aier_center_log.payqueue_logs, targetTables: aier_center_log.payqueue_logs}}”]
[2025/08/18 17:14:15.941 +08:00] [INFO] [checkpoint_flush_worker.go:67] [“about to sync flush checkpoint snapshot”] [task=tidb-logdb] [unit=“binlog replication”] [snapshot_id=336829]
[2025/08/18 17:14:15.945 +08:00] [INFO] [checkpoint_flush_worker.go:108] [“sync flush checkpoint snapshot successfully”] [task=tidb-logdb] [unit=“binlog replication”] [snapshot_id=336829] [pos=“position: (mysql-bin.025884, 660376179), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1”]
[2025/08/18 17:14:15.945 +08:00] [INFO] [syncer.go:1372] [“after sync flushed checkpoint, gc all causality keys”] [task=tidb-logdb] [unit=“binlog replication”]
[2025/08/18 17:14:15.945 +08:00] [INFO] [ddl.go:459] [“finish to handle ddls in normal mode”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [mode=normal] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660375720), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152926,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660376179), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660376179), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: CREATE TABLE IF NOT EXISTS aier_center_log.payqueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), trackInfos: {originDDL: CREATE TABLE IF NOT EXISTS aier_center_log.payQueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), routedDDL: CREATE TABLE IF NOT EXISTS aier_center_log.payqueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), sourceTables: aier_center_log.payqueue_logs, targetTables: aier_center_log.payqueue_logs}}”]
[2025/08/18 17:14:15.945 +08:00] [INFO] [ddl.go:955] [“parse ddl”] [task=tidb-logdb] [unit=“binlog replication”] [event=query] [“query event context”=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660376244), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660376703), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152928,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660376703), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152928,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: , trackInfos: }”]
[2025/08/18 17:14:15.946 +08:00] [INFO] [ddl.go:309] [“ready to split ddl”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660376244), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660376703), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152928,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660376703), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152928,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: , trackInfos: }”]
[2025/08/18 17:14:15.946 +08:00] [INFO] [ddl.go:1127] [“get ddl event type”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event_type=“create table”]
[2025/08/18 17:14:15.946 +08:00] [INFO] [ddl.go:329] [“resolve sql”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event=query] [appliedDDLs=“["CREATE TABLE IF NOT EXISTS aier_center_log.payQueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id))"]”] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660376244), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660376703), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152928,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660376703), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152928,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: , trackInfos: }”]
[2025/08/18 17:14:15.946 +08:00] [INFO] [ddl.go:390] [“prepare to handle ddls”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660376244), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660376703), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152928,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660376703), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152928,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: CREATE TABLE IF NOT EXISTS aier_center_log.payqueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), trackInfos: {originDDL: CREATE TABLE IF NOT EXISTS aier_center_log.payQueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), routedDDL: CREATE TABLE IF NOT EXISTS aier_center_log.payqueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), sourceTables: aier_center_log.payqueue_logs, targetTables: aier_center_log.payqueue_logs}}”]
[2025/08/18 17:14:15.946 +08:00] [INFO] [syncer.go:3212] [“flush all jobs”] [task=tidb-logdb] [unit=“binlog replication”] [“global checkpoint”=“location(position: (mysql-bin.025884, 660376179), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1) (flushed location(position: (mysql-bin.025884, 660376179), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1))”] [“flush job seq”=168416]
[2025/08/18 17:14:15.946 +08:00] [INFO] [ddl.go:418] [“start to handle ddls in normal mode”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [mode=normal] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660376244), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660376703), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152928,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660376703), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152928,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: CREATE TABLE IF NOT EXISTS aier_center_log.payqueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), trackInfos: {originDDL: CREATE TABLE IF NOT EXISTS aier_center_log.payQueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), routedDDL: CREATE TABLE IF NOT EXISTS aier_center_log.payqueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), sourceTables: aier_center_log.payqueue_logs, targetTables: aier_center_log.payqueue_logs}}”]
[2025/08/18 17:14:15.949 +08:00] [INFO] [checkpoint_flush_worker.go:67] [“about to sync flush checkpoint snapshot”] [task=tidb-logdb] [unit=“binlog replication”] [snapshot_id=336831]
[2025/08/18 17:14:15.952 +08:00] [INFO] [checkpoint_flush_worker.go:108] [“sync flush checkpoint snapshot successfully”] [task=tidb-logdb] [unit=“binlog replication”] [snapshot_id=336831] [pos=“position: (mysql-bin.025884, 660376703), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152928,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1”]
[2025/08/18 17:14:15.952 +08:00] [INFO] [syncer.go:1372] [“after sync flushed checkpoint, gc all causality keys”] [task=tidb-logdb] [unit=“binlog replication”]
[2025/08/18 17:14:15.952 +08:00] [INFO] [ddl.go:459] [“finish to handle ddls in normal mode”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [mode=normal] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660376244), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152927,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660376703), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152928,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660376703), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152928,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: CREATE TABLE IF NOT EXISTS aier_center_log.payqueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), trackInfos: {originDDL: CREATE TABLE IF NOT EXISTS aier_center_log.payQueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), routedDDL: CREATE TABLE IF NOT EXISTS aier_center_log.payqueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), sourceTables: aier_center_log.payqueue_logs, targetTables: aier_center_log.payqueue_logs}}”]
[2025/08/18 17:14:15.952 +08:00] [WARN] [syncer.go:2456] [“unhandled event”] [task=tidb-logdb] [unit=“binlog replication”] [type=*replication.RowsQueryEvent]
[2025/08/18 17:14:15.953 +08:00] [INFO] [ddl.go:955] [“parse ddl”] [task=tidb-logdb] [unit=“binlog replication”] [event=query] [“query event context”=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660378504), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152929,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660378963), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152930,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660378963), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152930,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: , trackInfos: }”]
[2025/08/18 17:14:15.953 +08:00] [INFO] [ddl.go:309] [“ready to split ddl”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660378504), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152929,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660378963), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152930,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660378963), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152930,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: , trackInfos: }”]
[2025/08/18 17:14:15.953 +08:00] [INFO] [ddl.go:1127] [“get ddl event type”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event_type=“create table”]
[2025/08/18 17:14:15.953 +08:00] [INFO] [ddl.go:329] [“resolve sql”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event=query] [appliedDDLs=“["CREATE TABLE IF NOT EXISTS aier_center_log.payQueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id))"]”] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660378504), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152929,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660378963), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152930,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660378963), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152930,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: , trackInfos: }”]
[2025/08/18 17:14:15.953 +08:00] [INFO] [ddl.go:390] [“prepare to handle ddls”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660378504), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152929,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660378963), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152930,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660378963), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152930,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: CREATE TABLE IF NOT EXISTS aier_center_log.payqueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), trackInfos: {originDDL: CREATE TABLE IF NOT EXISTS aier_center_log.payQueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), routedDDL: CREATE TABLE IF NOT EXISTS aier_center_log.payqueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), sourceTables: aier_center_log.payqueue_logs, targetTables: aier_center_log.payqueue_logs}}”]
[2025/08/18 17:14:15.953 +08:00] [INFO] [syncer.go:3212] [“flush all jobs”] [task=tidb-logdb] [unit=“binlog replication”] [“global checkpoint”=“location(position: (mysql-bin.025884, 660378439), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152929,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1) (flushed location(position: (mysql-bin.025884, 660376703), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152928,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1))”] [“flush job seq”=168417]
[2025/08/18 17:14:15.954 +08:00] [INFO] [checkpoint_flush_worker.go:67] [“about to sync flush checkpoint snapshot”] [task=tidb-logdb] [unit=“binlog replication”] [snapshot_id=336832]
[2025/08/18 17:14:15.958 +08:00] [INFO] [checkpoint_flush_worker.go:108] [“sync flush checkpoint snapshot successfully”] [task=tidb-logdb] [unit=“binlog replication”] [snapshot_id=336832] [pos=“position: (mysql-bin.025884, 660378439), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152929,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1”]
[2025/08/18 17:14:15.958 +08:00] [INFO] [syncer.go:1372] [“after sync flushed checkpoint, gc all causality keys”] [task=tidb-logdb] [unit=“binlog replication”]
[2025/08/18 17:14:15.958 +08:00] [INFO] [ddl.go:418] [“start to handle ddls in normal mode”] [task=tidb-logdb] [unit=“binlog replication”] [component=ddl] [mode=normal] [event=query] [queryEventContext=“{schema: aier_center_log, originSQL: CREATE TABLE IF NOT EXISTS payQueue_logs ( id bigint NOT NULL, platform varchar(50) NOT NULL, level int, module varchar(200), location varchar(200), inst_name varchar(80), dept_name varchar(80), content text, consume_time bigint, create_date datetime NOT NULL, creator varchar(50) NOT NULL, hosp_id int, PRIMARY KEY (id)), startLocation: position: (mysql-bin.025884, 660378504), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152929,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, endLocation: position: (mysql-bin.025884, 660378963), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152930,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, lastLocation: position: (mysql-bin.025884, 660378963), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152930,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1, re-sync: , needHandleDDLs: CREATE TABLE IF NOT EXISTS aier_center_log.payqueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), trackInfos: {originDDL: CREATE TABLE IF NOT EXISTS aier_center_log.payQueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), routedDDL: CREATE TABLE IF NOT EXISTS aier_center_log.payqueue_logs (id BIGINT NOT NULL,platform VARCHAR(50) NOT NULL,level INT,module VARCHAR(200),location VARCHAR(200),inst_name VARCHAR(80),dept_name VARCHAR(80),content TEXT,consume_time BIGINT,create_date DATETIME NOT NULL,creator VARCHAR(50) NOT NULL,hosp_id INT,PRIMARY KEY(id)), sourceTables: aier_center_log.payqueue_logs, targetTables: aier_center_log.payqueue_logs}}”]
[2025/08/18 17:14:15.961 +08:00] [INFO] [checkpoint_flush_worker.go:67] [“about to sync flush checkpoint snapshot”] [task=tidb-logdb] [unit=“binlog replication”] [snapshot_id=336833]
[2025/08/18 17:14:15.966 +08:00] [INFO] [checkpoint_flush_worker.go:108] [“sync flush checkpoint snapshot successfully”] [task=tidb-logdb] [unit=“binlog replication”] [snapshot_id=336833] [pos=“position: (mysql-bin.025884, 660378963), gtid-set: 25a5d480-0d91-11ed-aed9-5c6f69e9ad70:1-10002152930,68257c4e-0d93-11ed-8343-5c6f69ea3b60:1”]
[2025/08/18 17:14:15.966 +08:00] [INFO] [syncer.go:1372] [“after sync flushed checkpoint, gc all causality keys”] [task=tidb-logdb] [unit=“binlog replication”]