为提高效率,请提供以下信息,问题描述清晰能够更快得到解决:
【 TiDB 使用环境】
v4.0.5
【概述】 场景 + 问题概述
新建cdc任务后,状态显示正常,但是checkpoint-ts一直不推进,新增数据无法同步到下游集群。
changefeed信息如下,cdc日志请见附件。
{
“info”: {
“sink-uri”: “mysql://XXX@XXX/”,
“opts”: {},
“create-time”: “2022-02-07T18:48:54.688253051+08:00”,
“start-ts”: 431024065001553923,
“target-ts”: 0,
“admin-job-type”: 2,
“sort-engine”: “unified”,
“sort-dir”: “.”,
“config”: {
“case-sensitive”: true,
“enable-old-value”: true,
“filter”: {
“rules”: [
“biz_mall.*”
],
“ignore-txn-start-ts”: null,
“ddl-allow-list”: null
},
“mounter”: {
“worker-num”: 16
},
“sink”: {
“dispatchers”: null,
“protocol”: “default”
},
“cyclic-replication”: {
“enable”: false,
“replica-id”: 0,
“filter-replica-ids”: null,
“id-buckets”: 0,
“sync-ddl”: false
},
“scheduler”: {
“type”: “table-number”,
“polling-time”: -1
}
},
“state”: “normal”,
“history”: [
1644235022251,
1644235029315,
1644235036380,
1644235043435,
1644235050507,
1644235149747,
1644235156803,
1644235163867,
1644235170931,
1644235177995,
1644235277251,
1644235284315,
1644235291371,
1644235298435,
1644235305491,
1644235404747,
1644235411811,
1644235418867,
1644235425923,
1644235432995
],
“error”: null
},
“status”: {
“resolved-ts”: 0,
“checkpoint-ts”: 431024065001553923,
“admin-job-type”: 0
},
“count”: 0,
“task-status”: [
{
“capture-id”: “cc76fd01-4dac-4d01-8ec8-72fa3e1d5460”,
“status”: {
“tables”: {
“65”: {
“start-ts”: 431024065001553923,
“mark-table-id”: 0
},
“86”: {
“start-ts”: 431024065001553923,
“mark-table-id”: 0
}
},
“operation”: {
“65”: {
“delete”: false,
“boundary_ts”: 431024065001553923,
“done”: false
},
“86”: {
“delete”: false,
“boundary_ts”: 431024065001553923,
“done”: false
}
},
“admin-job-type”: 1
}
}
]
}cdc.log.tar.gz (299.6 KB)
【备份和数据迁移策略逻辑】
【背景】 做过哪些操作
【现象】 业务和数据库现象
【问题】 当前遇到的问题
【业务影响】
【TiDB 版本】
【附件】
- 相关日志、配置文件、Grafana 监控(https://metricstool.pingcap.com/)
- TiUP Cluster Display 信息
- TiUP CLuster Edit config 信息
- TiDB-Overview 监控
- 对应模块的 Grafana 监控(如有 BR、TiDB-binlog、TiCDC 等)
- 对应模块日志(包含问题前后 1 小时日志)
若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。