Error while rebuilding database. See log file for details.

[SPO]

Hallo zusammen,
hat jemand auch schon mal diesen Fehler angezeigt bekommen?

Espo update ausgeführt auf Version 7.3.4


Felder in der Entität lassen sich nicht mehr anlegen.
Rebuild Datenbank gleicher Fehler.
Suche ohne Filter funktioniert nicht mehr.

data log:[2023-03-19 12:09:02] ERROR: (500) Error while rebuilding database. See log file for details.; POST /Admin/rebuild; line: 157, file: /var/www/html/espo/application/Espo/Core/DataManager.php []

Auszug DataManager.php

$this->log->error(
"Failed to rebuild database schema. Details: ". $e->getMessage() .
" at " . $e->getFile() . ":" . $e->getLine()
);
}

if (!$result) {
throw new Error("Error while rebuilding database. See log file for details.");
}

Danke

[shalmaxb]

Gab es da nicht mehr Meldungen im log-file? Der hier zitierte sagt ja nur aus, dass rebuild fehlgeschlagen ist. Der code aus der datamangager.php hilft da nicht weiter.
Error 500 hat in der Regel mit der Datenbank zu tun.

Wie wurde das upgrade gemacht?

[SPO]

Das Upgrade wurde über CLI gemacht.

Hier der gesamte Fehler


ALERT: Rebuild database fault: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs in /var/www/html/espocrm/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:72 Stack trace: #0 /var/www/html/espocrm/vendor/doctrine/dbal/src/Driver/PDO/Connection.php(72): PDO->query() EspoCRM Forum /var/www/html/espocrm/vendor/doctrine/dbal/src/Connection.php(1049): Doctrine\DBAL\Driver\PDO\Connection->query() Forum /var/www/html/espocrm/application/Espo/Core/Utils/Database/Schema/Schema.php(218): Doctrine\DBAL\Connection->executeQuery() #3 /var/www/html/espocrm/application/Espo/Core/Utils/Database/Schema/SchemaProxy.php(58): Espo\Core\Utils\Database\Schema\Schema->rebuild() #4 /var/www/html/espocrm/application/Espo/Core/DataManager.php(145): Espo\Core\Utils\Database\Schema\SchemaProxy->rebuild() Groups /var/www/html/espocrm/application/Espo/Core/DataManager.php(110): Espo\Core\DataManager->rebuildDatabase() Uncategorized Groups /var/www/html/espocrm/application/Espo/Controllers/Admin.php(79): Espo\Core\DataManager->rebuild() Special /var/www/html/espocrm/application/Espo/Core/Api/ActionProcessor.php(111): Espo\Controllers\Admin->postActionRebuild() Visitor Messages /var/www/html/espocrm/application/Espo/Core/Api/RequestProcessor.php(124): Espo\Core\Api\ActionProcessor->process() Private Messages /var/www/html/espocrm/application/Espo/Core/Api/RequestProcessor.php(95): Espo\Core\Api\RequestProcessor->proceed() Albums /var/www/html/espocrm/application/Espo/Core/Api/RequestProcessor.php(62): Espo\Core\Api\RequestProcessor->processInternal() #11 /var/www/html/espocrm/application/Espo/Core/Api/Starter.php(86): Espo\Core\Api\RequestProcessor->process() #12 /var/www/html/espocrm/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(43): Espo\Core\Api\Starter->Espo\Core\Api\{closure}() CSS Examples /var/www/html/espocrm/vendor/slim/slim/Slim/Routing/Route.php(384): Slim\Handlers\Strategies\RequestResponse->__invoke() #14 /var/www/html/espocrm/vendor/slim/slim/Slim/MiddlewareDispatcher.php(81): Slim\Routing\Route->handle() General Discussion /var/www/html/espocrm/vendor/slim/slim/Slim/MiddlewareDispatcher.php(81): Slim\MiddlewareDispatcher->handle() Announcements /var/www/html/espocrm/vendor/slim/slim/Slim/Routing/Route.php(341): Slim\MiddlewareDispatcher->handle() Feature Requests /var/www/html/espocrm/vendor/slim/slim/Slim/Routing/RouteRunner.php(84): Slim\Routing\Route->run() Installation and Upgrade Help /var/www/html/espocrm/vendor/slim/slim/Slim/Middleware/RoutingMiddleware.php(59): Slim\Routing\RouteRunner->handle() Extensions /var/www/html/espocrm/vendor/slim/slim/Slim/MiddlewareDispatcher.php(147): Slim\Middleware\RoutingMiddleware->process() Developer Help /var/www/html/espocrm/vendor/slim/slim/Slim/Middleware/ErrorMiddleware.php(107): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() Bug Reports /var/www/html/espocrm/vendor/slim/slim/Slim/MiddlewareDispatcher.php(147): Slim\Middleware\ErrorMiddleware->process() Unminify assets or how to recreate t...o.min.js file? /var/www/html/espocrm/vendor/slim/slim/Slim/MiddlewareDispatcher.php(81): Psr\Http\Server\RequestHandlerInterface@anonymous->handle() /var/www/html/espocrm/vendor/slim/slim/Slim/App.php(215): Slim\MiddlewareDispatcher->handle() #24 /var/www/html/espocrm/vendor/slim/slim/Slim/App.php(199): Slim\App->handle() /var/www/html/espocrm/application/Espo/Core/Api/Starter.php(62): Slim\App->run() how to upgrade ? /var/www/html/espocrm/application/Espo/Core/ApplicationRunners/Api.php(45): Espo\Core\Api\Starter->start() /var/www/html/espocrm/application/Espo/Core/Application/RunnerRunner.php(87): Espo\Core\ApplicationRunners\Api->run() #28 /var/www/html/espocrm/application/Espo/Core/Application.php(78): Espo\Core\Application\RunnerRunner->run() #29 /var/www/html/espocrm/public/api/v1/index.php(37): Espo\Core\Application->run() #30 {main} Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs in /var/www/html/espocrm/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30 Stack trace: #0 /var/www/html/espocrm/vendor/doctrine/dbal/src/Driver/PDO/Connection.php(77): Doctrine\DBAL\Driver\PDO\Exception::new() EspoCRM Forum /var/www/html/espocrm/vendor/doctrine/dbal/src/Connection.php(1049): Doctrine\DBAL\Driver\PDO\Connection->query() Forum /var/www/html/espocrm/application/Espo/Core/Utils/Database/Schema/Schema.php(218): Doctrine\DBAL\Connection->executeQuery() #3 /var/www/html/espocrm/application/Espo/Core/Utils/Database/Schema/SchemaProxy.php(58): Espo\Core\Utils\Database\Schema\Schema->rebuild() #4 /var/www/html/espocrm/application/Espo/Core/DataManager.php(145): Espo\Core\Utils\Database\Schema\SchemaProxy->rebuild() Groups /var/www/html/espocrm/app... [] []

[shalmaxb]

This is a common error, because you use too many textfields (varchar 255). You can heal this by deleting some of those and create them again as textbox (up to 65000 bit). In the field configuration make them 1 line height, so they look the same as textfields before.

This behaviour of MySQL is not easy to understand, but there are a lot of explanations of that problem by searching in the web.

[SPO]

Okay, danke erst einmal.

[SPO]

Hallo

Bei mir lag der Fehler in der Tabelle Lead.
Ich habe Felder mit der Möglichkeit Bilder hochzuladen angelegt.

Hier wird Typ varchar 24 angelegt.
Nach Erhöhung auf varchar 255 war das Problem behoben.

Danke für den Richtungshinweis!