laravel5.3 队列 出现数据库jobs表锁死 然后队列就不再执行了
local.ERROR: exception 'PDOException' with message 'SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction'
Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: update jobs
set reserved_at
= 1480939453, attempts
= 1 where id
= 7536)'
Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (SQL: insert into jobs
(queue
, attempts
, reserved_at
, available_at
, created_at
, payload
) values (high, 0, , 1480939632, 1480939632, {"job":"Illuminate\Queue\CallQueuedHandler@call","data":{"commandName":"App\Jobs\AccessTask","command":"O:19:\"App\Jobs\AccessTask\":8:{s:5:\"\u0000\u0000id\";i:6742;s:9:\"\u0000\u0000access\";O:45:\"Illuminate\Contracts\Database\ModelIdentifier\":2:{s:5:\"class\";s:17:\"App\Models\CodeCP\";s:2:\"id\";i:2;}s:7:\"\u0000\u0000code\";O:45:\"Illuminate\Contracts\Database\ModelIdentifier\":2:{s:5:\"class\";s:15:\"App\Models\Code\";s:2:\"id\";i:2;}s:9:\"\u0000\u0000params\";a:8:{s:6:\"mobile\";s:11:\"13766097108\";s:8:\"province\";s:6:\"\u5409\u6797\";s:4:\"city\";s:6:\"\u8fbd\u6e90\";s:5:\"order\";s:22:\"13766097108-1480939423\";s:4:\"call\";s:11:\"12590610404\";s:5:\"begin\";s:19:\"2016-12-05 20:03:43\";s:3:\"end\";s:19:\"2016-12-05 20:06:53\";s:8:\"duration\";s:3:\"190\";}s:6:\"\u0000*\u0000job\";N;s:10:\"connection\";N;s:5:\"queue\";s:4:\"high\";s:5:\"delay\";N;}"}}))'
请教大神 怎么破???
1 Comment
@tosslife#416 你得把死锁的原因找出来并解决啊