root@127.0.0.1:4000 [sync_test] : Sat Feb 20 13:22:43 2021 > select count() from cl_user_old_1 where aid=‘xxxxx’ ;
±---------+
| count() |
±---------+
| 0 |
±---------+
1 row in set (0.31 sec)
root@127.0.0.1:4000 [sync_test] : Sat Feb 20 13:22:51 2021 > update cl_user_old_1 set aid=‘xxxxx’ limit 2000;
Query OK, 2000 rows affected (0.13 sec)
Rows matched: 2000 Changed: 2000 Warnings: 0
root@127.0.0.1:4000 [sync_test] : Sat Feb 20 13:23:24 2021 > select count() from cl_user_old_1 where aid=‘xxxxx’ ;
±---------+
| count() |
±---------+
| 2000 |
±---------+
1 row in set (0.26 sec)
root@127.0.0.1:4000 [sync_test] : Sat Feb 20 13:25:18 2021 > select uname from cl_user_old_1 where aid=‘xxxxx’ limit 5;
±------------------+
| uname |
±------------------+
| Amur |
| galaxy.jax |
| JasmineRobinson |
| FernandoD.Ventura |
| EverardoTorres |
±------------------+
5 rows in set (0.00 sec) MySQL侧:
opsadmin@rds-test.ct7cj9f0ldac.us-east-1.rds.amazonaws.com:3306 [sync_test] : Sat Feb 20 13:24:37 2021 > select count() from cl_user_old_1 where aid=‘xxxxx’ ;
±---------+
| count() |
±---------+
| 0 |
±---------+
1 row in set (0.38 sec)
dbadmin@rds-test.ct7cj9f0ldac.us-east-1.rds.amazonaws.com:3306 [sync_test] : Sat Feb 20 13:24:39 2021 >select uname from cl_user_old_1 where aid=‘xxxxx’ limit 5;
Empty set (0.39 sec)
dbadmin@rds-test.ct7cj9f0ldac.us-east-1.rds.amazonaws.com:3306 [sync_test] : Sat Feb 20 13:26:04 2021 > select count() from cl_user_old_1 where aid=‘xxxxx’ ;
±---------+
| count() |
±---------+
| 0 |
±---------+
1 row in set (0.37 sec)
TiCDC日志:
[2021/02/20 13:23:44.590 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:23:45.591 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:23:46.592 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:23:47.593 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:23:48.594 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:23:49.595 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:23:50.596 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:23:51.055 +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 13:23:51.598 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:23:52.598 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:23:53.599 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:23:54.600 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:23:55.601 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:23:56.602 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:23:57.603 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:23:58.604 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:23:59.605 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:00.606 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:01.607 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:02.608 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:03.609 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:04.610 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:05.611 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:06.612 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:07.613 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:08.614 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:09.615 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:10.616 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:11.617 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:12.618 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:13.619 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:14.619 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:15.620 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:16.622 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:17.622 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:18.624 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:19.625 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:20.625 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:21.105 +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 13:24:21.627 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:22.627 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:23.628 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:24.629 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]
[2021/02/20 13:24:25.630 +08:00] [WARN] [client.go:1200] [“drop resolved ts due to region feed stopped”] [regionID=2] [requestID=97] [addr=10.60.79.168:20160]