不知道什么原因突然服务全部停止了,去哪里看详细日志?

kid1296

问题描述

不知道什么原因突然服务全部停止了,去哪里看详细日志?
只有nginx的日志

报错信息

2026/05/23 09:22:33 [error] 761288#0: *1349137 upstream timed out (110: Connection timed out) while reading response header from upstream, client:
2026/05/23 09:22:34 [error] 761286#0: *1349360 upstream timed out (110: Connection timed out) while reading response header from upstream, client:

操作系统及workerman/webman等框架组件具体版本

"require": {
    "php": ">=8.1",
    "workerman/webman-framework": "^2.1",
    "monolog/monolog": "^2.0",
    "shopwwi/webman-auth": "^2.0",
    "webman/database": "^2.1",
    "webman/redis": "^2.1",
    "illuminate/events": "^12.14",
    "webman/captcha": "^1.0",
    "illuminate/redis": "^12.15",
    "webman/event": "^1.0.5",
    "illuminate/pagination": "^12.15",
    "symfony/var-dumper": "^7.2",
    "topthink/think-template": "^3.0",
    "chillerlan/php-qrcode": "^5.0",
    "webman/log": "^2.1",
    "wechatpay/wechatpay": "^1.4",
    "workerman/crontab": "^1.0",
    "wechatpay/wechatpay-guzzle-middleware": "^0.2.2",
    "phpseclib/phpseclib": "*",
    "zoujingli/ip2region": "^3.0",
    "webman/console": "*",
    "guzzlehttp/guzzle": "^7.0",
    "phpoffice/phpspreadsheet": "*",
    "lpilp/guomi": "*",
    "webman/redis-queue": "~2.1",
    "workerman/workerman": "^5.1.6",
    "revolt/event-loop": "*"
  }
27 2 0
2个回答

kid1296

看了一下webman日志,这个错误

PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction in /www/wwwroot/milupay.ahxhsm.cn/vendor/illuminate/database/Connection.php:593
Stack trace:

但是实际上没有用到数据库事物,也都加了索引

  • kid1296 4小时前
    Stack trace:
    #0 /www/wwwroot/****/vendor/illuminate/database/Connection.php(776): Illuminate\Database\Connection->runQueryCallback()
    #1 /www/wwwroot/****/vendor/illuminate/database/Connection.php(581): Illuminate\Database\Connection->run()
    #2 /www/wwwroot/****/vendor/illuminate/database/Connection.php(533): Illuminate\Database\Connection->affectingStatement()
    #3 /www/wwwroot/****/vendor/illuminate/database/Query/Builder.php(3849): Illuminate\Database\Connection->update()
    #4 /www/wwwroot/****/vendor/illuminate/database/Eloquent/Builder.php(1235): Illuminate\Database\Query\Builder->update()
    #5 /www/wwwroot/****/vendor/illuminate/database/Eloquent/Model.php(1288): Illuminate\Database\Eloquent\Builder->update()
    #6 /www/wwwroot/****/vendor/illuminate/database/Eloquent/Model.php(1205): Illuminate\Database\Eloquent\Model->performUpdate()
    #7 /www/wwwroot/****/app/api/controller/PayController.php(33): Illuminate\Database\Eloquent\Model->save()
    #8 /www/wwwroot/****/vendor/workerman/webman-framework/src/App.php(428): app\api\controller\PayController->index()
    #9 /www/wwwroot/****/vendor/workerman/webman-framework/src/App.php(452): Webman\App::Webman\{closure}()
    #10 /www/wwwroot/****/vendor/webman/log/src/Middleware.php(97): Webman\App::Webman\{closure}()
    #11 /www/wwwroot/****/vendor/workerman/webman-framework/src/App.php(468): Webman\Log\Middleware->process()
    #12 /www/wwwroot/****/vendor/workerman/webman-framework/src/App.php(159): Webman\App::Webman\{closure}()
    #13 /www/wwwroot/****/vendor/workerman/workerman/src/Connection/TcpConnection.php(805): Webman\App->onMessage()
    #14 /www/wwwroot/****/vendor/workerman/workerman/src/Events/Swoole.php(288): Workerman\Connection\TcpConnection->baseRead()
    #15 [internal function]: Workerman\Events\Swoole->Workerman\Events\{closure}()
    #16 {main}  
JackDx

你让AI帮你排查下,肯定是锁没有释放,尤其是多进程的情况下,抢锁了。

  • 暂无评论
🔝