Hi Leute,
führe grad ein Update Contao 4.12.6 durch.
Im BA bei der Systemwartung hängt die Funktion "Suchindex aktualisieren" nach einer Weile fest (gerade bei 30%, und das schon seit 1 Stunde).
Ich hatte das Ganze schon mal abgebrochen, alle Daten bereinigt und den Suchindex aktualisieren neu gestartet. Das geht anfangs gut voran, und dann frisst er sich fest.
Woran kann das liegen?
In der Datei var/logs gibt es folgende Fehlermeldungen:
[2022-02-09T10:42:19.978101+01:00] request.INFO: Matched route "contao_backend". {"route":"contao_backend","route_parameters":{"_ro ute":"contao_backend","_scope":"backend","_token_c heck":true,"_controller":"Contao\\CoreBundle\\Cont roller\\BackendController::mainAction"},"request_u ri":"https://DOMAIN.de/contao?act=crawl&crawl_subscriber_names%5B0%5D=sea rch-index&do=maintenance&jobId=7eb2e0c8-7dc7-4c8c-92cf-44d43bab2822&ref=AquGWr27","method":"POST"} []
[2022-02-09T10:42:22.533808+01:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'SELECT uri, level, processed, found_on, tags FROM tl_crawl_queue WHERE (job_id = ?) AND (uri_hash = ?) LIMIT 1' with params ["7eb2e0c8-7dc7-4c8c-92cf-44d43bab2822", "e3c5715516145fd20d1325cfb104b2befbd8cae9"]: SQLSTATE[HY000]: General error: 1100 Table 'tl_crawl_queue' was not locked with LOCK TABLES" at /html/cto/cto4_12_5/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'SELECT uri, level, processed, found_on, tags FROM tl_crawl_queue WHERE (job_id = ?) AND (uri_hash = ?) LIMIT 1' with params ["7eb2e0c8-7dc7-4c8c-92cf-44d43bab2822", "e3c5715516145fd20d1325cfb104b2befbd8cae9"]:\n\nSQLSTATE[HY000]: General error: 1100 Table 'tl_crawl_queue' was not locked with LOCK TABLES at /html/cto/cto4_12_5/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: HY000): SQLSTATE[HY000]: General error: 1100 Table 'tl_crawl_queue' was not locked with LOCK TABLES at /html/cto/cto4_12_5/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18)\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/cto4_12_5/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} []
Wie lassen sich die Probleme lösen?
VG Thomas
Lesezeichen