Hallo,
in Contao 4.13.0 lässt sich bei der Systemwartung der Suchindex nicht aktualisieren.
Er beginnt und hängt dann bei 40% fest.
Woran kann das liegen?
Hier ein Screen vom Putty:
Unbenannt-1.jpg
und in der log > prod steht dies hier:
PHP-Code:
[2022-03-08T15:44:38.885123+01:00] request.INFO: Matched route "contao_backend". {"route":"contao_backend","route_parameters":{"_route":"contao_backend","_scope":"backend","_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\BackendController::mainAction"},"request_uri":"https://xxxxxx.de/contao?act=crawl&crawl_subscriber_names%5B0%5D=search-index&do=maintenance&jobId=1daf9fa9-354f-4872-b361-1332aaf011e0&ref=F5Yz8Mtd","method":"POST"} []
[2022-03-08T15:44:39.626717+01:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1100 Table 'tl_crawl_queue' was not locked with LOCK TABLES" at /html/cto/cto_413_0/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 119 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1100): An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1100 Table 'tl_crawl_queue' was not locked with LOCK TABLES at /html/cto/cto_413_0/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:119)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1100): SQLSTATE[HY000]: General error: 1100 Table 'tl_crawl_queue' was not locked with LOCK TABLES at /html/cto/cto_413_0/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30)\n[previous exception] [object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 1100 Table 'tl_crawl_queue' was not locked with LOCK TABLES at /html/cto/cto_413_0/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:101)"} []
Lesezeichen