Symptoms
- The following error appears after updating Plesk to Obsidian 18.0.43 on RHEL/AlmaLinux/Rocky Linux 8:
Server Error
500 PleskExceptionDatabase
DB query failed: SQLSTATE[HY000] [2002] No such file or directory - MariaDB service cannot be started after upgrade:
systemd[1]: mariadb.service: Main process exited, code=exited, status=7/NOTRUNNING
systemd[1]: mariadb.service: Failed with result 'exit-code'.
systemd[1]: Failed to start MariaDB 10.3 database server. - MySQL community server was installed previously.
Cause
Product issue:
-
#PPPM-13514 "Updating Plesk to version 18.0.43 no longer fails when MySQL Community Server is used."
Fixed in:- Plesk Obsidian 15 April 2022 (Linux)
Resolution
Workaround
If update is not possible for some reason you may try the following
workaround
- Connect to the server using SSH.
-
Back up all the MySQL data storage files. By default, they are located in the directory
/var/lib/mysql/.For example:
# cp -a /var/lib/mysql /root/mysql_backup
- Remove MariaDB packages:
# rpm -e --nodeps mariadb-3:10.3.28-1.module_el8.3.0+2177+7adc332a.x86_64
# rpm -e --nodeps mariadb-backup-3:10.3.28-1.module_el8.3.0+2177+7adc332a.x86_64
# rpm -e --nodeps mariadb-common-3:10.3.28-1.module_el8.3.0+2177+7adc332a.x86_64
# rpm -e --nodeps mariadb-errmsg-3:10.3.28-1.module_el8.3.0+2177+7adc332a.x86_64
# rpm -e --nodeps mariadb-gssapi-server-3:10.3.28-1.module_el8.3.0+2177+7adc332a.x86_64
# rpm -e --nodeps mariadb-server-3:10.3.28-1.module_el8.3.0+2177+7adc332a.x86_64
# rpm -e --nodeps mariadb-server-utils-3:10.3.28-1.module_el8.3.0+2177+7adc332a.x86_64 - Install MySQL server community:
# yum install mysql-server-8.0.26-1.module_el8.4.0+2532+b8928c02.x86_64
# yum install http://autoinstall.plesk.com/PSA_18.0.42/dist-rpm-RedHat-el8-x86_64/contrib/plesk-mysql-server-community-18.0-2.redhat.8+p18.0.42.0+t220211.2259.noarch.rpm - Start MySQL Server:
# systemctl start mysqld