Rebuild database fault> Update from 7.2.7 to 7.3.3

[alexisc]

PHP 8.0.28
MySQL 5.7.33

[2023-03-01 08:29:08] ALERT: Rebuild database fault: PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'email' already exists in /home/today/iscisis.www/www/CRM/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:72 Stack trace: #0 /home/today/iscisis.www/www/CRM/vendor/doctrine/dbal/src/Driver/PDO/Connection.php(72): PDO->query('CREATE TABLE em...') #1 /home/today/iscisis.www/www/CRM/vendor/doctrine/dbal/src/Connection.php(1049): Doctrine\DBAL\Driver\PDO\Connection->query('CREATE TABLE em...') #2 /home/today/iscisis.www/www/CRM/application/Espo/Core/Utils/Database/Schema/Schema.php(218): Doctrine\DBAL\Connection->executeQuery('CREATE TABLE em...') #3 /home/today/iscisis.www/www/CRM/application/Espo/Core/Utils/Database/Schema/SchemaProxy.php(58): Espo\Core\Utils\Database\Schema\Schema->rebuild() #4 /home/today/iscisis.www/www/CRM/application/Espo/Core/DataManager.php(145): Espo\Core\Utils\Database\Schema\SchemaProxy->rebuild(NULL) #5 /home/today/iscisis.www/www/CRM/application/Espo/Core/DataManager.php(110): Espo\Core\DataManager->rebuildDatabase(NULL) #6 /home/today/iscisis.www/www/CRM/application/Espo/Controllers/Admin.php(87): Espo\Core\DataManager->rebuild() #7 /home/today/iscisis.www/www/CRM/application/Espo/Core/Api/ActionProcessor.php(123): Espo\Controllers\Admin->postActionRebuild(Array, '', Object(Espo\Core\Api\RequestWrapper), Object(Espo\Core\Api\ResponseWrapper)) #8 /home/today/iscisis.www/www/CRM/application/Espo/Core/Api/RequestProcessor.php(141): Espo\Core\Api\ActionProcessor->process('Admin', 'rebuild', Object(Espo\Core\Api\RequestWrapper), Object(Espo\Core\Api\ResponseWrapper)) #9 /home/today/iscisis.www/www/CRM/application/Espo/Core/Api/RequestProcessor.php(112): Espo\Core\Api\RequestProcessor->proceed(Object(Espo\Core\Api\RequestWrapper), Object(Espo\Core\Api\ResponseWrapper)) #10 /home/today/iscisis.www/www/CRM/application/Espo/Core/Api/RequestProcessor.php(83): Espo\Core\Api\RequestProcessor->processInternal(Object(Espo\Core\Api\Route), Object(Espo\Core\Api\RequestWrapper), Object(Espo\Core\Api\ResponseWrapper)) #11 /home/today/iscisis.www/www/CRM/application/Espo/Core/Api/Starter.php(103): Espo\Core\Api\RequestProcessor->process(Object(Espo\Core\Api\Route), Object(Espo\Core\Api\RequestWrapper), Object(Espo\Core\Api\ResponseWrapper)) #12 /home/today/iscisis.www/www/CRM/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(43): Espo\Core\Api\Starter->Espo\Core\Api\{closure}(Object(Slim\Psr7\Request), Object(Slim\Psr7\Response), Array) #13 /home/today/iscisis.www/www/CRM/vendor/slim/slim/Slim/Routing/Route.php(384): Slim\Handlers\Strategies\RequestResponse->__invoke(Object(Closure), Object(Slim\Psr7\Request), Object(Slim\Psr7\Response), Array) #14 /home/today/iscisis.www/www/CRM/vendor/slim/slim/Slim/MiddlewareDispatcher.php(81): Slim\Routing\Route->handle(Object(Slim\Psr7\Request)) #15 /home/today/iscisis.www/www/CRM/vendor/slim/slim/Slim/MiddlewareDispatcher.php(81): Slim\MiddlewareDispatcher->handle(Object(Slim\Psr7\Request)) #16 /home/today/iscisis.www/www/CRM/vendor/slim/slim/Slim/Routing/Route.php(341): Slim\MiddlewareDispatcher->handle(Object(Slim\Psr7\Request)) #17 /home/today/iscisis.www/www/CRM/vendor/slim/slim/Slim/Routing/RouteRunner.php(84): Slim\Routing\Route->run(Object(Slim\Psr7\Request)) #18 /home/today/iscisis.www/www/CRM/vendor/slim/slim/Slim/Middleware/RoutingMiddleware.php(59): Slim\Routing\RouteRunner->handle(Object(Slim\Psr7\Request)) #19 /home/today/iscisis.www/www/CRM/vendor/slim/slim/Slim/MiddlewareDispatcher.php(147): Slim\Middleware\RoutingMiddleware->process(Object(Slim\Psr7\Request), Object(Slim\Routing\RouteRunner)) #20 /home/today/iscisis.www/www/CRM/vendor/slim/slim/Slim/Middleware/ErrorMiddleware.php(107): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Slim\Psr7\Request)) #21 /home/today/iscisis.www/www/CRM/vendor/slim/slim/Slim/MiddlewareDispatcher.php(147): Slim\Middleware\ErrorMiddleware->process(Object(Slim\Psr7\Request), Object(Psr\Http\Server\RequestHandlerInterface@anonymous)) #22 /home/today/iscisis.www/www/CRM/vendor/slim/slim/Slim/MiddlewareDispatcher.php(81): Psr\Http\Server\RequestHandlerInterface@anonymous->handle(Object(Slim\Psr7\Request)) #23 /home/today/iscisis.www/www/CRM/vendor/slim/slim/Slim/App.php(215): Slim\MiddlewareDispatcher->handle(Object(Slim\Psr7\Request)) #24 /home/today/iscisis.www/www/CRM/vendor/slim/slim/Slim/App.php(199): Slim\App->handle(Object(Slim\Psr7\Request)) #25 /home/today/iscisis.www/www/CRM/application/Espo/Core/Api/Starter.php(79): Slim\App->run() #26 /home/today/iscisis.www/www/CRM/application/Espo/Core/ApplicationRunners/Api.php(49): Espo\Core\Api\Starter->start() #27 /home/today/iscisis.www/www/CRM/application/Espo/Core/Application/RunnerRunner.php(85): Espo\Core\ApplicationRunners\Api->run() #28 /home/today/iscisis.www/www/CRM/application/Espo/Core/Application.php(81): Espo\Core\Application\RunnerRunner->run('Espo\\Core\\Appli...', NULL) #29 /home/today... [] []

Base table or view already exists: 1050 Table 'email' already exists

I don't understand what is the problem, please help

[yuri]

Not to be in bug reports.

[alexisc]

you mean that there should be no such error?

[dimyy]

How big is your table?

[alexisc]

How big is your table?

database 4666.91Мб
Table 'email - 35000 lines

[dimyy]

Perhaps it makes sense to create indexes on the email table manually

[alexisc]

I will try to update in another way, and let you know the result

[alexisc]

updated for the second time without problems, the issue is closed, thank you all!