关于MySQL出现
lock wait timeout exceeded; try restarting transaction
的解决方案。
一、问题抛出
在做查询语句时,MySQL 抛出了这样的异常:
MySQL server error report:Array
(
[0] => Array
(
[message] => MySQL Query Error
)
[1] => Array
(
[sql] => SELECT * FROM taobao_trade WHERE order_status = 1 and orderID ='2018061812306547' AND is_tran_success=0 for update
)
[2] => Array
(
[error] => Lock wait timeout exceeded; try restarting transaction
)
[3] => Array
(
[errno] => 1205
)
)
即Lock wait timeout exceeded; try restarting transaction
的异常,错误提示的意思,很明显,是因为这条语句被锁住了,所以释放这个锁。
二、解决方案
我们可以通过到