Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 单表只有一个链接在更新此表，出现获取锁超时的情况，是什么问题
|
username: Running
The image you uploaded is not visible. Please provide the text you need translated.
|
username: Running
|
username: The previous DML was not completed, which locked the subsequent update records.
|
username: No locks were found. This issue occurs occasionally, possibly because the lock was already released by the time the query was made.
|
username: Is the table large? This looks like a full table update. Could it be that the update time is too long?
How big is this table? Don’t update it all at once, try updating it in batches.