Resolved Updated Maria, my server is now broken - DB query failed: SQLSTATE[HY000] [2002] No such file or directory

[jazzydan]

Server operating system version

CentOS7

Plesk version and microupdate number

Can't log-in to check.

I've tried to follow this article to update Maria on a Plesk server (usually works no issues).

 How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.x on Linux?

Applicable to: Plesk for Linux Question How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.X on Linux? Answer This article provides instructions for upgrading MySQL 5.5 to 5.6/5.7 and Mari...

support.plesk.com

I now get this error message when going to the Plesk log-in page.

Server Error

500 Plesk\Exception\Database​

DB query failed: SQLSTATE[HY000] [2002] No such file or directory

Type	Plesk\Exception\Database
Message	DB query failed: SQLSTATE[HY000] [2002] No such file or directory
File	Mysql.php
Line	79

When I run Plesk repair all, I get the folowing

DB query failed: SQLSTATE[HY000] [2002] No such file or directory

exit status 1

when I try and start sql I get the following...

Failed to restart mysql.service: Unit not found.

Any ideas how I go about fixing this?

Thanks

Dan

 

[Monty]

Which version of MariaDB did you install?

You may have old init-scripts (SysV) for mysql that cause a conflict, try this:

systemctl stop mysql
systemctl stop mariadb
chkconfig --del mysql
systemctl disable mysql
systemctl disable mariadb
systemctl enable mariadb.service
systemctl start mariadb.service

This should cleanup the systemctl service config for MySQL/MariaDB

 

[jazzydan]

Which version of MariaDB did you install?

You may have old init-scripts (SysV) for mysql that cause a conflict, try this:

systemctl stop mysql
systemctl stop mariadb
chkconfig --del mysql
systemctl disable mysql
systemctl disable mariadb
systemctl enable mariadb.service
systemctl start mariadb.service

This should cleanup the systemctl service config for MySQL/MariaDB

Thank you, but unfortunately none of those commands work...

[root@77-68-115-204 ~]# systemctl stop mysql

Failed to stop mysql.service: Unit mysql.service not loaded.

[root@77-68-115-204 ~]# systemctl stop mariadb

Failed to stop mariadb.service: Unit mariadb.service not loaded.

[root@77-68-115-204 ~]# --del mysql

-bash: --del: command not found

[root@77-68-115-204 ~]# chkconfig --del mysql

error reading information on service mysql: No such file or directory

[root@77-68-115-204 ~]# systemctl disable mysql

Failed to execute operation: No such file or directory

[root@77-68-115-204 ~]# systemctl disable mariadb

Failed to execute operation: No such file or directory

[root@77-68-115-204 ~]# systemctl enable mariadb.service

Failed to execute operation: No such file or directory

[root@77-68-115-204 ~]# systemctl start mariadb.service

Failed to start mariadb.service: Unit not found.

[root@77-68-115-204 ~]#

 

[Monty]

What's your output of:

rpm -qa | grep -i mariadb

and

rpm -qa | grep -i mysql

 

[jazzydan]

What's your output of:

rpm -qa | grep -i mariadb

and

rpm -qa | grep -i mysql

this

[root@77-68-115-204 ~]# rpm -qa | grep -i mariadb

plesk-libmariadbclient-3.1-3.1.8-1centos.7.220909.0858.x86_64

MariaDB-common-10.2.44-1.el7.centos.x86_64

MariaDB-client-10.2.44-1.el7.centos.x86_64

MariaDB-compat-10.2.44-1.el7.centos.x86_64

plesk-libmariadbclient-3.0-3.0.9-1centos.7.200430.1921.x86_64

[root@77-68-115-204 ~]# rpm -qa | grep -i mysql

plesk-php81-mysql-8.1.16-1centos.7.230220.1355.x86_64

plesk-mysql-server-18.0.2-2.centos.7+p18.0.44.0+t220518.2121.noarch

plesk-php74-mysql-7.4.33-1centos.7.221109.0743.x86_64

plesk-php73-mysql-7.3.33-1centos.7.211118.1928.x86_64

perl-DBD-MySQL-4.023-6.el7.x86_64

plesk-php80-mysql-8.0.28-1centos.7.230220.1355.x86_64

[root@77-68-115-204 ~]#

Thanks again

 

[jazzydan]

Any ideas any one? Sorry to be a pest, but I have some sites down, and clients are starting to notice, and are understandably not pleased.
I can't raise a support ticket, as I can't get in to the server to get the licence number.
Thanks

 

[Peter Debik]

As server and client still show version 10.2 maybe the upgrade process has not been done as prescribed in the instructions. At least the step where a new server is installed has been omitted. You could go back into the step-by-step guide and check each step.

 

[jazzydan]

As server and client still show version 10.2 maybe the upgrade process has not been done as prescribed in the instructions. At least the step where a new server is installed has been omitted. You could go back into the step-by-step guide and check each step.

Perfect, thats done it. Thanks a million

 

[jazzydan]

I think I used the script version, and it must have stopped halfway. So redoing it with the manual version seems to have fixed everything. I'll start breathing again now.

 

[dotmaki]

Hey @jazzydan could you describe step by step how did u manage to fix that issue ? I'm facing the same error.

 

[savtechnologie]

Bonjour,

500 Plesk\Exception\Base de données​

Échec de la requête de base de données : SQLSTATE[HY000] [2002] No such file or directory

Cône	Plesk\Exception\Base de données
Message	Échec de la requête de base de données : SQLSTATE[HY000] [2002] No such file or directory
Déposer	MySQL.php
Doubleur	79

After installing mariaDB 10.4, when I try to start SQL. I get the following... Stopped

I can't connect to plesk pannel !

Do you have any ideas on how to solve this problem?

My sites no longer work (URGENT)

Thanks

Laurent

 

[Peter Debik]

@savtechnologie Which of the above mentioned hints and which solutions from the Plesk Knowledge Base have you already tried?

plesk "no such file or directory" database 500 - Google Suche

 

[pleskpanel]

I think I used the script version, and it must have stopped halfway. So redoing it with the manual version seems to have fixed everything. I'll start breathing again now.

We've seen issues with the script version but they weren't consistent enough to reproduce so our SOP from now on has been to use the manual approach.