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;}"}}))'

请教大神 怎么破???


点赞 取消点赞 收藏 取消收藏

<< 上一篇: 训练在线编程,挑战《剑指offer》

>> 下一篇: laravel csrf_token无法识别的问题