TiDB Update Error 1105: Context Canceled

Translated
1

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

Original topic: tidb 更新报错 1105 context canceled

| username: leoones

Scenario + Problem Overview
TiDB update operation error (1105, ‘context canceled’)
This error occurs during concurrent updates. Not all updates have this issue.

image
image1862×917 62.4 KB

2
| username: xfworld | Original post link

Check the context. I feel that the transaction timed out and was then canceled.

3
| username: wuxiangdong | Original post link

Is the program connection disconnected?

4
| username: leoones | Original post link

It is caused by a transaction waiting for a lock timeout, and this error message is not very obvious.

5
| username: xfworld | Original post link

It’s quite clear, it’s either success or failure, there’s no other state… It’s relatively easy to judge.

6
| username: leoones | Original post link

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction. It should report this timeout error, right?

7
| username: 特雷西-迈克-格雷迪 | Original post link

Is the text too long, or are there illegal characters in it?

8
| username: zhouzeru | Original post link

The other UDs are fine. Could it be that this UD has a logical issue?

9
| username: system | Original post link

This topic was automatically closed 1 minute after the last reply. No new replies are allowed.