workerman每次运行一段时间就出错 SQLSTATE[HY000]: General error: 1205

sheji2
2019-04-15 14:30:11 pid:1 think\exception\PDOException: SQLSTATE: General error: 1205 Lock wait timeout exceeded; try restarting transaction in D:\wwwroot\pay_server\thinkphp\library\think\db\Connection.php:453
Stack trace:
#0 D:\wwwroot\pay_server\thinkphp\library\think\db\Query.php(269): think\db\Connection->execute('UPDATE `orders`...', Array, Object(think\db\Query))
#1 D:\wwwroot\pay_server\thinkphp\library\think\db\Query.php(2437): think\db\Query->execute('UPDATE `orders`...', Array, Object(think\db\Query))
#2 D:\wwwroot\pay_server\application\push\controller\Worker.php(106): think\db\Query->update(Array)
#3 : app\push\controller\Worker->onMessage(Object(Workerman\Connection\TcpConnection), '{\n  "type" : "s...')
#4 D:\wwwroot\pay_server\vendor\workerman\workerman\Connection\TcpConnection.php(650): call_user_func(Array, Object(Workerman\Connection\TcpConnection), '{\n  "type" : "s...')
#5 : Workerman\Connection\TcpConnection->baseRead(Resource id #80330)
#6 D:\wwwroot\pay_server\vendor\workerman\workerman\Events\Select.php(289): call_user_func_array(Array, Array)
#7 D:\wwwroot\pay_server\vendor\workerman\workerman\Worker.php(2235): Workerman\Events\Select->loop()
#8 D:\wwwroot\pay_server\vendor\workerman\workerman\Worker.php(1225): Workerman\Worker->run()
#9 D:\wwwroot\pay_server\vendor\workerman\workerman\Worker.php(1168): Workerman\Worker::forkWorkersForWindows()
#10 D:\wwwroot\pay_server\vendor\workerman\workerman\Worker.php(478): Workerman\Worker::forkWorkers()
#11 D:\wwwroot\pay_server\vendor\topthink\think-worker\src\Server.php(48): Workerman\Worker::runAll()
#12 : think\worker\Server->__construct()
#13 D:\wwwroot\pay_server\thinkphp\library\think\App.php(359): ReflectionClass->newInstanceArgs(Array)
#14 D:\wwwroot\pay_server\thinkphp\library\think\Loader.php(479): think\App::invokeClass('app\\push\\contro...')
#15 D:\wwwroot\pay_server\thinkphp\library\think\App.php(580): think\Loader::controller('worker', 'controller', false, 'Error')
#16 D:\wwwroot\pay_server\thinkphp\library\think\App.php(456): think\App::module(Array, Array, true)
#17 D:\wwwroot\pay_server\thinkphp\library\think\App.php(139): think\App::exec(Array, Array)
#18 D:\wwwroot\pay_server\thinkphp\start.php(19): think\App::run()
#19 D:\wwwroot\pay_server\server.php(5): require('D:\\wwwroot\\pay_...')
#20 {main}
2019-04-15 14:30:11 pid:1 Worker process terminated

每次运行几个小时候就出错   10几天了   什么设置断线重连都设置了都没用

3628 1 0
1个回答

walkor 打赏

这个报错和workerman没有关系,百度下 Lock wait timeout exceeded; try restarting transaction

  • 暂无评论
年代过于久远,无法发表回答
×
🔝