Upgrade MariaDB uninstall-error

[sdesp]

Trying up upgrade EspoCRM, getting stuck in update MariaDB.


CentOS 7

yum -y update
---> Package MariaDB-server.x86_64 0:10.0.38-1.el7.centos will be updated
---> Package MariaDB-server.x86_64 0:10.4.12-1.el7.centos will be an update

..
A manual upgrade is required.
..

This is a brief description of the upgrade process. Important details
can be found in the MariaDB manual, in the Upgrading section.
************************************************** ****************
error: %pre(MariaDB-server-10.4.12-1.el7.centos.x86_64) scriptlet failed, exit status 1
Error in PREIN scriptlet in rpm package MariaDB-server-10.4.12-1.el7.centos.x86_64
MariaDB-server-10.0.38-1.el7.centos.x86_64 was supposed to be removed but is not!
Verifying : MariaDB-server-10.0.38-1.el7.centos.x86_64 1/2
Verifying : MariaDB-server-10.4.12-1.el7.centos.x86_64 2/2

Failed:
MariaDB-server.x86_64 0:10.0.38-1.el7.centos MariaDB-server.x86_64 0:10.4.12-1.el7.centos


I already stopped the service (directadmin)

mysqld

mysqld (pid 64600 64672 )

And tried: rpm -qa | grep -i '^mysql-'

And did: yum remove MariaDB-server

but the 10.0 seems to be stuck. Any tips?

[espcrm]

Can't help you sdesp. Only tip I can give is: if you are hosting this with Host provider, you can seek their help with the Upgrade then ask them how or get them teach you how to do it.

If you are self-host then I leave it to another user to provide you with some guidance.

[sdesp]

Found it. The Host helped… It's a VPS. Upgrading works fine when using the DirectAdmin upgrade procedure.

https://help.directadmin.com/item.php?id=240

It's now updated to:

requiredMariadbVersion

10.3.22-MariaDB

Success

Maybe this is of any help for the next person.

[sdesp]

Updating to

5.7.11

went fine. Now I do get:

[LEFT][COLOR=#000000][FONT=Helvetica]php command.php upgrade[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#000000][FONT=Helvetica]Current version is 5.7.11.[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#000000][FONT=Helvetica]EspoCRM will be upgraded to version 5.8.4 now. Enter [Y] to continue.[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#000000][FONT=Helvetica]y[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#000000][FONT=Helvetica]Downloading...[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#000000][FONT=Helvetica]Upgrading... This may take a while...[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#000000][FONT=Helvetica]Error occurred while EspoCRM rebuild. Please see the log for more detail.[/FONT][/COLOR][/LEFT]
[LEFT][COLOR=#000000][FONT=Helvetica][/FONT][/COLOR][/LEFT]

[sdesp]

Then the log shows:

[2020-04-15 17:12:04] Espo.DEBUG: Schema\Converter - Start: building schema [] []
[2020-04-15 17:12:04] Espo.DEBUG: Schema\Converter - End: building schema [] []
[2020-04-15 17:12:04] Espo.INFO: SCHEMA, Execute Query: ALTER TABLE `email_account` CHANGE `port` `port` INT DEFAULT '143' COLLATE utf8mb4_unicode_ci [] []
[2020-04-15 17:12:04] Espo.INFO: SCHEMA, Execute Query: ALTER TABLE `inbound_email` CHANGE `port` `port` INT DEFAULT '143' COLLATE utf8mb4_unicode_ci [] []
[2020-04-15 17:12:04] Espo.INFO: SCHEMA, Execute Query: ALTER TABLE `contact` ADD `middle_name` VARCHAR(100) DEFAULT NULL COLLATE utf8mb4_unicode_ci [] []
[2020-04-15 17:12:04] Espo.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 /public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:699 Stack trace: #0 /public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(699): PDO->query('ALTER TABLE `co...') #1 /public_html/application/Espo/Core/Utils/Database/Schema/Schema.php(196): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `co...') #2 /public_html/application/Espo/Core/DataManager.php(97): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /public_html/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /public_html/application/Espo/Core/Upgrades/Actions/Base.php(708): Espo\Core\DataManager->rebuild() #5 /public_html/application/Espo/Core/Upgrades/Actions/Base/Install.php(173): Espo\Core\Upgrades\Actions\Base->systemRebuild() #6 /public_html/application/Espo/Core/Upgrades/Base.php(130): Espo\Core\Upgrades\Actions\Base\Install->stepRebuild(Array) #7 /public_html/application/Espo/Core/Upgrades/Base.php(113): Espo\Core\Upgrades\Base->runActionStep('install', 'rebuild', Array) #8 /public_html/application/Espo/Core/Console/Commands/Upgrade.php(265): Espo\Core\Upgrades\Base->runInstallStep('rebuild', Array) #9 /public_html/application/Espo/Core/Console/Commands/Upgrade.php(255): Espo\Core\Console\Commands\Upgrade->runStepsInSingleProcess('5e97405f167979e...', Array) #10 /public_html/application/Espo/Core/Console/Commands/Upgrade.php(200): Espo\Core\Console\Commands\Upgrade->runUpgradeProcess('5e97405f167979e...', Array) #11 /public_html/application/Espo/Core/Console/Commands/Upgrade.php(62): Espo\Core\Console\Commands\Upgrade->runRemoteUpgrade(Array) #12 /public_html/application/Espo/Core/Console/CommandManager.php(76): Espo\Core\Console\Commands\Upgrade->run(Array, Array, Array) #13 /public_html/application/Espo/Core/Application.php(224): Espo\Core\Console\CommandManager->run('Upgrade') #14 /public_html/command.php(39): Espo\Core\Application->runCommand('upgrade') #15 {main}  Next Doctrine\DBAL\DBALException: An exception occurred while executing 'ALTER TABLE `contact` ADD `middle_name` VARCHAR(100) DEFAULT NULL COLLATE utf8mb4_unicode_ci':  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 /public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'ALTER TABLE `co...', Array) #1 /public_html/application/Espo/Core/Utils/Database/Schema/Schema.php(196): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `co...') #2 /public_html/application/Espo/Core/DataManager.php(97): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /public_html/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /public_html/application/Espo/Core/Upgrades/Actions/Base.php(708): Espo\Core\DataManager->rebuild() #5 /public_html/application/Espo/Core/Upgrades/Actions/Base/Install.php(173): Espo\Core\Upgrades\Actions\Base->systemRebuild() #6 /public_html/application/Espo/Core/Upgrades/Base.php(130): Espo\Core\Upgrades\Actions\Base\Install->stepRebuild(Array) #7 /public_html/application/Espo/Core/Upgrades/Base.php(113): Espo\Core\Upgrades\Base->runActionStep('install', 'rebuild', Array) #8 /public_html/application/Espo/Core/Console/Commands/Upgrade.php(265): Espo\Core\Upgrades\Base->runInstallStep('rebuild', Array) #9 /public_html/application/Espo/Core/Console/Commands/Upgrade.php(255): Espo\Core\Console\Commands\Upgrade->runStepsInSingleProcess('5e97405f167979e...', Array) #10 /public_html/application/Espo/Core/Console/Commands/Upgrade.php(200): Espo\Core\Console\Commands\U... [] []
[2020-04-15 17:12:04] Espo.INFO: SCHEMA, Execute Query: ALTER TABLE `lead` ADD `middle_name` VARCHAR(100) DEFAULT NULL COLLATE utf8mb4_unicode_ci [] []
[2020-04-15 17:12:04] Espo.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 /public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:699 Stack trace: #0 /public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(699): PDO->query('ALTER TABLE `le...') #1 /public_html/application/Espo/Core/Utils/Database/Schema/Schema.php(196): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `le...') #2 /public_html/application/Espo/Core/DataManager.php(97): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /public_html/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /public_html/application/Espo/Core/Upgrades/Actions/Base.php(708): Espo\Core\DataManager->rebuild() #5 /public_html/application/Espo/Core/Upgrades/Actions/Base/Install.php(173): Espo\Core\Upgrades\Actions\Base->systemRebuild() #6 /public_html/application/Espo/Core/Upgrades/Base.php(130): Espo\Core\Upgrades\Actions\Base\Install->stepRebuild(Array) #7 /public_html/application/Espo/Core/Upgrades/Base.php(113): Espo\Core\Upgrades\Base->runActionStep('install', 'rebuild', Array) #8 /public_html/application/Espo/Core/Console/Commands/Upgrade.php(265): Espo\Core\Upgrades\Base->runInstallStep('rebuild', Array) #9 /public_html/application/Espo/Core/Console/Commands/Upgrade.php(255): Espo\Core\Console\Commands\Upgrade->runStepsInSingleProcess('5e97405f167979e...', Array) #10 /public_html/application/Espo/Core/Console/Commands/Upgrade.php(200): Espo\Core\Console\Commands\Upgrade->runUpgradeProcess('5e97405f167979e...', Array) #11 /public_html/application/Espo/Core/Console/Commands/Upgrade.php(62): Espo\Core\Console\Commands\Upgrade->runRemoteUpgrade(Array) #12 /public_html/application/Espo/Core/Console/CommandManager.php(76): Espo\Core\Console\Commands\Upgrade->run(Array, Array, Array) #13 /public_html/application/Espo/Core/Application.php(224): Espo\Core\Console\CommandManager->run('Upgrade') #14 /public_html/command.php(39): Espo\Core\Application->runCommand('upgrade') #15 {main}  Next Doctrine\DBAL\DBALException: An exception occurred while executing 'ALTER TABLE `lead` ADD `middle_name` VARCHAR(100) DEFAULT NULL COLLATE utf8mb4_unicode_ci':  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 /public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'ALTER TABLE `le...', Array) #1 /public_html/application/Espo/Core/Utils/Database/Schema/Schema.php(196): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `le...') #2 /public_html/application/Espo/Core/DataManager.php(97): Espo\Core\Utils\Database\Schema\Schema->rebuild(NULL) #3 /public_html/application/Espo/Core/DataManager.php(62): Espo\Core\DataManager->rebuildDatabase(NULL) #4 /public_html/application/Espo/Core/Upgrades/Actions/Base.php(708): Espo\Core\DataManager->rebuild() #5 /public_html/application/Espo/Core/Upgrades/Actions/Base/Install.php(173): Espo\Core\Upgrades\Actions\Base->systemRebuild() #6 /public_html/application/Espo/Core/Upgrades/Base.php(130): Espo\Core\Upgrades\Actions\Base\Install->stepRebuild(Array) #7 /public_html/application/Espo/Core/Upgrades/Base.php(113): Espo\Core\Upgrades\Base->runActionStep('install', 'rebuild', Array) #8 /public_html/application/Espo/Core/Console/Commands/Upgrade.php(265): Espo\Core\Upgrades\Base->runInstallStep('rebuild', Array) #9 /public_html/application/Espo/Core/Console/Commands/Upgrade.php(255): Espo\Core\Console\Commands\Upgrade->runStepsInSingleProcess('5e97405f167979e...', Array) #10 /public_html/application/Espo/Core/Console/Commands/Upgrade.php(200): Espo\Core\Console\Commands\Upgr... [] []
[2020-04-15 17:12:04] Espo.INFO: SCHEMA, Execute Query: CREATE INDEX IDX_CONTACT_ID ON `opportunity` (`contact_id`) [] []
[2020-04-15 17:12:04] Espo.ERROR: Database rebuild failure, details: Error while rebuilding database. See log file for details.. [] []
[2020-04-15 17:12:04] Espo.INFO: Installer: Restore previous files. [] []

Where should I start looking?

[Maximus]

Hi,
The error occurred when an installation process tried to:
1. ADD `middle_name` VARCHAR(100) to Contact
2. ADD `middle_name` VARCHAR(100) to Lead

The error says that you don't have enough space for these fields. Try to add them manually in your DB.
1. If you will create them w/o problem, then run the upgrade again.
2. If you will get the same error upon the field addition change VARCHAR(100) to VARCHAR(50) and try again.

[sdesp]

Thank you again!
Going to phpMyAdmin (I guess most people use). Interestingly indeed the same error when adding the row. BUT the solution was simple. The error did only occur when adding it to the end of the table. Adding it between first and last name, worked fine.

Then the upgrade, run normally.

Conclusion: #SOLVED - CASE CLOSED