TiCDC Unable to Retrieve Change Data

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

Original topic: ticdc 获取不到变更数据

| username: 消息终结者

[TiDB Usage Environment] Poc
[TiDB Version] v6.5.2

[Encountered Issue: Problem Phenomenon and Impact]
We are only synchronizing two tables from TiDB to downstream MySQL. After installing TiCDC, the connection to MySQL from the TiCDC server was successful, the task was created successfully, and the logs appear normal.



Phenomenon:
New data in the upstream, but no data in the downstream database.

I don’t know how to troubleshoot this… Suspecting whether TiCDC is functional.

| username: Jellybean | Original post link

Execute this to see if there is any specific error information.

| username: 小龙虾爱大龙虾 | Original post link

Your doubt about whether TiCDC can be used is quite amusing. Many customers are using it, and it’s even in production. :rofl: :rofl: :rofl:

| username: TiDBer_lBAxWjWQ | Original post link

Haha :sweat_smile::sweat_smile::sweat_smile:

| username: 消息终结者 | Original post link

Resolved.
The reason was that the DBA installed TiCDC on the TiKV cluster…
After reinstalling it on the TiDB cluster, data can be retrieved.

| username: 消息终结者 | Original post link

Got emotional :innocent:

| username: 消息终结者 | Original post link

Thank you, boss. It was a lucky mistake. While looking for the PD address, the DBA discovered that the wrong cluster was installed.

| username: 小龙虾爱大龙虾 | Original post link

So I suspect there is an issue with your environment. I’ve been asking you to check the environment problem, and I have a feeling you might be dealing with the wrong CDC cluster. :joy_cat:

| username: Jellybean | Original post link

Haha, I didn’t expect it to be for this reason. The new version of the TiCDC synchronization tool is very powerful and is used in many production environments.

| username: 消息终结者 | Original post link

Yes, I also suspect that we are not using it correctly. Not sure about the cluster deployed by the DBA.

| username: dba远航 | Original post link

Obviously, it was a misunderstanding.

| username: system | Original post link

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