An error was found while checking the log

WeDog

The forum can be used normally, but I don't know what causes this error. Can the administrator determine the cause of the problem through the log? Thank you very much.
论坛能正常使用，但不知道是什么原因导致的这个错误，管理员能通过日志确定问题的原因吗？非常感谢！

Next Illuminate\Database\QueryException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: update `tags` set `position` = 0, `parent_id` = 1 where `id` = 8) in /www/wwwroot/myDomainName/vendor/illuminate/database/Connection.php:664
Stack trace:
#0 /www/wwwroot/myDomainName/vendor/illuminate/database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('update `tags` s...', Array, Object(Closure))
#1 /www/wwwroot/myDomainName/vendor/illuminate/database/Connection.php(490): Illuminate\Database\Connection->run('update `tags` s...', Array, Object(Closure))
#2 /www/wwwroot/myDomainName/vendor/illuminate/database/Connection.php(423): Illuminate\Database\Connection->affectingStatement('update `tags` s...', Array)
#3 /www/wwwroot/myDomainName/vendor/illuminate/database/Query/Builder.php(2659): Illuminate\Database\Connection->update('update `tags` s...', Array)
#4 /www/wwwroot/myDomainName/vendor/illuminate/database/Eloquent/Builder.php(818): Illuminate\Database\Query\Builder->update(Array)
#5 /www/wwwroot/myDomainName/vendor/flarum/tags/src/Api/Controller/OrderTagsController.php(50): Illuminate\Database\Eloquent\Builder->update(Array)
#6 /www/wwwroot/myDomainName/vendor/flarum/core/src/Http/RouteHandlerFactory.php(38): Flarum\Tags\Api\Controller\OrderTagsController->handle(Object(Laminas\Diactoros\ServerRequest))
#7 /www/wwwroot/myDomainName/vendor/flarum/core/src/Http/Middleware/DispatchRoute.php(65): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}(Object(Laminas\Diactoros\ServerRequest), Array)
#8 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\DispatchRoute->process(Object(Laminas\Diactoros\ServerRequest), Object(Closure))
#9 /www/wwwroot/myDomainName/vendor/flarum/core/src/Http/Middleware/SetLocale.php(50): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#10 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\SetLocale->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#11 /www/wwwroot/myDomainName/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(45): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#12 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\CheckCsrfToken->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#13 /www/wwwroot/myDomainName/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(55): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#14 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithHeader->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#15 /www/wwwroot/myDomainName/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(32): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#16 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithSession->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#17 /www/wwwroot/myDomainName/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(51): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#18 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\RememberFromCookie->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#19 /www/wwwroot/myDomainName/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#20 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\StartSession->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#21 /www/wwwroot/myDomainName/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#22 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\FakeHttpMethods->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#23 /www/wwwroot/myDomainName/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#24 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ParseJsonBody->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#25 /www/wwwroot/myDomainName/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#26 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\HandleErrors->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#27 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#28 /www/wwwroot/myDomainName/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#29 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\RequestHandler->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#30 /www/wwwroot/myDomainName/vendor/middlewares/base-path-router/src/BasePathRouter.php(97): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#31 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePathRouter->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#32 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#33 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\Stratigility\Middleware\OriginalMessages->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#34 /www/wwwroot/myDomainName/vendor/middlewares/base-path/src/BasePath.php(53): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#35 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePath->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#36 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#37 /www/wwwroot/myDomainName/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\EmptyPipelineHandler))
#38 /www/wwwroot/myDomainName/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle(Object(Laminas\Diactoros\ServerRequest))
#39 /www/wwwroot/myDomainName/vendor/flarum/core/src/Http/Server.php(42): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#40 /www/wwwroot/myDomainName/public/index.php(26): Flarum\Http\Server->listen()
#41 {main}

clarkwinkelmann

WeDog does it happen every single time you try moving tags?

The error message mentions a database dead lock. Is that a high traffic forum?

If nothing is happening on the forum and the database is still dead locked, maybe try restarting the database.

WeDog

clarkwinkelmann If this error is related to the tags move operation, then I understand, thank you very much! Sometimes the operation speed is too fast and its order will be disordered, but it will resume after refreshing the page.
如果此错误与标签移动操作有关，那么我理解了，非常感谢！有时操作速度太快，其顺序会混乱，但是刷新页面后会恢复。