DM Sync Task Causing Write Conflict Error: 9007

Translated
1

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

Original topic: DM 同步任务导致写入冲突 error ：9007

| username: jerry

【TiDB Environment】Test environment
【TiDB Version】5.4 【DM】6.0
【Encountered Issue】
【Reproduction Path】Load testing in the test environment
【Problem Phenomenon and Impact】

image
image1827×367 40.9 KB

2
| username: db_user | Original post link

Can you locate this transaction and check if the specific SQL queries are using the index properly and whether the execution time is excessively long?

3
| username: jerry | Original post link

Hello, so what should I do? Could you please advise?

4
| username: cs58_dba | Original post link

Prompt indicates a conflict.

5
| username: db_user | Original post link

You can refer to this document for troubleshooting to see where the specific conflict occurs and whether it can be resolved from the business side:

Also, check the safe-mode of your DM. If it is set to true, try changing it to false to see if it alleviates the issue.

6
| username: Hacker007 | Original post link

Write conflict? Aren’t there transactions? How could this happen?

7
| username: forever | Original post link

Are you using pessimistic locking or optimistic locking?

8
| username: system | Original post link

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