- 论坛徽章:
- 0
|
-144 ISAM error: key value locked.
除了设置等待锁时间之外,还有其他解决办法吗?
关于这段解释
The current operation inserts a row with a certain primary key value or
updates a row with a certain primary key value, but a transaction that
has not yet been committed has deleted that key value from the index.
This error occurs only when the lock mode is set to NOT WAIT. Treat it
the same as error -107 (record is locked). Roll back the current
transaction, and re-execute it after a delay. Then, if the other
transaction was committed, the lock no longer exists. If it was rolled
back, the key exists, and this operation receives a duplicate-key
error.
英语不是很好,看的有点迷糊:
谁能帮我解释一下这段话吗?
The current operation inserts a row with a certain primary key value or
updates a row with a certain primary key value, but a transaction that
has not yet been committed has deleted that key value from the index. |
|