Foreign Key Constraints Cause Drainer to Go Down

Translated
1

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

Original topic: 外键约束 导致使用drainer down

| username: TiDBer_GWyrPeql

【TiDB Usage Environment】Production\Test Environment\POC Production Environment 【TiDB Version】v5.4.0 【Encountered Problem】Data cannot be synchronized due to foreign key constraints 【Reproduction Path】What operations were performed to cause the problem`
【Problem Phenomenon and Impact】
【Attachment】

%E6%8D%95%E8%8E%B7
%E6%8D%95%E8%8E%B7984×717 161 KB

For questions related to performance optimization and troubleshooting, please download the script and run it. Please select all and copy-paste the terminal output results for upload.

2
| username: Minorli-PingCAP | Original post link

In this scenario, after manually confirming that the data is correct, disable the constraints.

3
| username: Tank001 | Original post link

I remember that TiDB does not support foreign key constraints, so it’s better to check the data and then disable it.

4
| username: wuxiangdong | Original post link

Disable foreign keys.

5
| username: 裤衩儿飞上天 | Original post link

TiDB does not support foreign key constraints.

6
| username: alfred | Original post link

Indeed, foreign keys are not supported.

7
| username: system | Original post link

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