Plesk and websites are inaccessible after updating Plesk to Obsidian 18.0.43 on RHEL 8-based OS: DB query failed: SQLSTATE[HY000] [2002] No such file or directory

Taras Ermoshin

Updated December 19, 2022 23:45

Plesk for Linux kb: fixed kb: bug

Applicable to:

The following error appears after updating Plesk to Obsidian 18.0.43 on RHEL/AlmaLinux/Rocky Linux 8:
CONFIG_TEXT: Server Error
500 Plesk\Exception\Database
DB query failed: SQLSTATE[HY000] [2002] No such file or directory
MariaDB service cannot be started after upgrade:
CONFIG_TEXT: 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.

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)

Please consider updating your server:

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