为提高效率,请提供以下信息,问题描述清晰能够更快得到解决:
【TiDB 版本】v.4.0.8
【问题描述】在TiDB端执行update命令,有时无法同步到MySQL,具体信息如下:
TiDB侧:
MySQL [sync_test]> update cl_user_old_1 set aid=‘aaa’ limit 2000;
Query OK, 2000 rows affected (0.12 sec)
Rows matched: 2000 Changed: 2000 Warnings: 0
MySQL [sync_test]> select count() from cl_user_old_1 where aid=‘aaa’;
±---------+
| count() |
±---------+
| 2000 |
±---------+
1 row in set (0.30 sec)
MySQL [sync_test]> update cl_user_old_1 set aid=‘bbb’ limit 1;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MySQL侧:
MySQL [sync_test]> select count() from cl_user_old_1 where aid=‘aaa’;
±---------+
| count() |
±---------+
| 0 |
±---------+
1 row in set (0.40 sec)
MySQL [sync_test]> select count() from cl_user_old_1 where aid=‘bbb’;
±---------+
| count() |
±---------+
| 0 |
±---------+
1 row in set (0.39 sec)
TiCDC日志:
[2021/02/20 10:47:53.430 +08:00] [INFO] [statistics.go:118] [“sink replication status”] [name=mysql] [changefeed=sync-test-repl-task] [captureaddr=10.60.79.168:8300] [count=0] [qps=0]
[2021/02/20 10:48:23.460 +08:00] [INFO] [statistics.go:118] [“sink replication status”] [name=mysql] [changefeed=sync-test-repl-task] [captureaddr=10.60.79.168:8300] [count=0] [qps=0]
[2021/02/20 10:48:53.984 +08:00] [INFO] [statistics.go:118] [“sink replication status”] [name=mysql] [changefeed=sync-test-repl-task] [captureaddr=10.60.79.168:8300] [count=0] [qps=0]
[2021/02/20 10:49:24.015 +08:00] [INFO] [statistics.go:118] [“sink replication status”] [name=mysql] [changefeed=sync-test-repl-task] [captureaddr=10.60.79.168:8300] [count=2000] [qps=66]
[2021/02/20 10:49:54.015 +08:00] [INFO] [statistics.go:118] [“sink replication status”] [name=mysql] [changefeed=sync-test-repl-task] [captureaddr=10.60.79.168:8300] [count=0] [qps=0]
[2021/02/20 10:50:24.015 +08:00] [INFO] [statistics.go:118] [“sink replication status”] [name=mysql] [changefeed=sync-test-repl-task] [captureaddr=10.60.79.168:8300] [count=0] [qps=0]
[2021/02/20 10:50:54.065 +08:00] [INFO] [statistics.go:118] [“sink replication status”] [name=mysql] [changefeed=sync-test-repl-task] [captureaddr=10.60.79.168:8300] [count=0] [qps=0]
[2021/02/20 10:51:24.115 +08:00] [INFO] [statistics.go:118] [“sink replication status”] [name=mysql] [changefeed=sync-test-repl-task] [captureaddr=10.60.79.168:8300] [count=0] [qps=0]
[2021/02/20 10:51:54.115 +08:00] [INFO] [statistics.go:118] [“sink replication status”] [name=mysql] [changefeed=sync-test-repl-task] [captureaddr=10.60.79.168:8300] [count=1] [qps=0]
TiCDC任务显示正常:
tiup ctl cdc changefeed list --pd=http://10.60.79.168:2379
Starting component ctl
: /root/.tiup/components/ctl/v5.0.0-rc/ctl cdc changefeed list --pd=http://10.60.79.168:2379
[
{
“id”: “sync-test-repl-task”,
“summary”: {
“state”: “normal”,
“tso”: 423045195223269378,
“checkpoint”: “2021-02-20 10:49:09.454”,
“error”: null
}
}
]
若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。