Issue Server Error 500 Plesk\Exception\Database

[Itsouly]

Server operating system version

Ubuntu 20.04 (64 Bit)

Plesk version and microupdate number

I have no idea

Hello guys I have more the 5 websites down and I have no idea how to fix the error please help I can't reinstall because I have important data

 

[Peter Debik]

Most commonly this error is caused by a lack of disk space. Please check whether your / partition has enough space left.

 

[Itsouly]

 

[Itsouly]

Space is good as u see in SS

 

[Peter Debik]

Is mariadb running (systemctl status mariadb)? If it is not, what log entries do you find in your syslog on mariadb that describe why it does not start?

 

[Itsouly]

Is mariadb running (systemctl status mariadb)? If it is not, what log entries do you find in your syslog on mariadb that describe why it does not start?

 

[Itsouly]

mariadb Not found I have no idea why that happend

 

[Peter Debik]

Do you see your database directories and files in /var/lib/mysql?

 

[Itsouly]

Do you see your database directories and files in /var/lib/mysql?

i am newbie at vps what a must type to check that?

 

[Itsouly]

​

root@ad:~# sudo systemctl start mysql.service​

Failed to start mysql.service: Unit mysql.service not found.​

root@ad:~# sudo apt install mysql-server​

N: Ignoring file 'mariadb.list.old_1' in directory '/etc/apt/sources.list.d/' as it has an invalid filename extension​

E: dpkg was interrupted, you must manually run 'sudo dpkg --configure -a' to correct the problem.​

root@ad:~# sudo mysql​

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)​

update-alternatives: warning: forcing reinstallation of alternative /etc/mysql/mariadb.cnf because link group my.cnf is broken
update-alternatives: warning: not replacing /etc/mysql/my.cnf with a link

when i try to reinstall mysql or mariadb

 

[Peter Debik]

i am newbie at vps what a must type to check that?

# cd /var/lib/mysql
# ls -la

 

[Itsouly]

root@ad:~# cd /var/lib/mysql
root@ad:/var/lib/mysql# ls -la
total 176948
drwxr-xr-x 22 mysql mysql 4096 Mar 10 01:56 .
drwxr-xr-x 52 root root 4096 Mar 9 16:41 ..
drwx------ 2 mysql mysql 4096 Oct 30 15:07 admin_bt
drwx------ 2 mysql mysql 4096 Mar 1 17:02 admin_cpanwork
drwx------ 2 mysql mysql 4096 Sep 25 17:21 admin_gefollow
drwx------ 2 mysql mysql 4096 Oct 30 02:36 admin_isrdatabase
drwx------ 2 mysql mysql 4096 Jul 20 2023 admin_Powers
drwx------ 2 mysql mysql 4096 Jul 20 2023 admin_selectsmm
drwx------ 2 mysql mysql 4096 Aug 10 2023 admin_smmpanel
drwx------ 2 mysql mysql 4096 Sep 10 2023 admin_soulaimane
drwx------ 2 mysql mysql 4096 Oct 1 20:57 admin_souly
drwx------ 2 mysql mysql 12288 Nov 8 03:57 admin_soulybt
drwx------ 2 mysql mysql 4096 Jul 17 2023 admin_space
drwx------ 2 mysql mysql 4096 Dec 25 00:40 admin_testpowers
drwx------ 2 mysql mysql 4096 Jul 16 2023 apsc
-rw-rw---- 1 mysql mysql 688128 Mar 9 16:42 aria_log.00000001
-rw-rw---- 1 mysql mysql 52 Mar 9 16:42 aria_log_control
-rw-r--r-- 1 root root 0 Jan 26 06:26 debian-10.3.flag
-rw-rw---- 1 mysql mysql 14507 Mar 9 16:42 ib_buffer_pool
-rw-rw---- 1 mysql mysql 79691776 Mar 9 16:42 ibdata1
-rw-rw---- 1 mysql mysql 50331648 Mar 9 16:42 ib_logfile0.bak
-rw-rw---- 1 mysql mysql 50331648 Mar 9 14:11 ib_logfile1
-rw-rw---- 1 mysql mysql 0 Jul 16 2023 multi-master.info
drwx------ 2 mysql mysql 4096 Jul 16 2023 mysql
-rw-r--r-- 1 mysql mysql 15 Jan 26 06:26 mysql_upgrade_info
drwx------ 2 mysql mysql 4096 Jan 26 06:26 performance_schema
drwx------ 2 mysql mysql 4096 Jul 16 2023 phpmyadmin
drwx------ 2 mysql mysql 20480 Feb 12 07:19 psa
drwx------ 2 mysql mysql 4096 Jul 16 2023 roundcubemail
drwx------ 2 mysql mysql 4096 Jul 17 2023 spacefol_space
drwx------ 2 mysql mysql 12288 Jan 7 18:02 wp_ezgy6

# cd /var/lib/mysql
# ls -la

 

[Peter Debik]

You will not want to install MySQL, but MariaDB. You'll also not want to do that before you backed up /var/lib/mysql with
# cp -v -a /var/lib/mysql/ /path/to/your/backup/directory/mysql_backup
because a reinstallation might change contents so that you might lose existing data.

 

[Itsouly]

You will not want to install MySQL, but MariaDB. You'll also not want to do that before you backed up /var/lib/mysql with
# cp -v -a /var/lib/mysql/ /path/to/your/backup/directory/mysql_backup
because a reinstallation might change contents so that you might lose existing data.

root@ad:/var/lib/mysql# cp -v -a /var/lib/mysql/ /path/to/your/backup/directory/mysql_backup
cp: cannot create directory '/path/to/your/backup/directory/mysql_backup': No such file or directory
root@ad:/var/lib/mysql#
when i try to backup i get this
and please tell me how to reinstallation

 

[Peter Debik]

Honestly, I can only recommend to let Plesk support do the installation of MariaDB for you or at least let them check the status of the server and give specific advice afterwards. If you choose to install MariaDB yourself, make sure you install the server and the client. Afterwards, make sure to run
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
because the version you are about to install might be newer than than one you had before.

 

[Peter Debik]

root@ad:/var/lib/mysql# cp -v -a /var/lib/mysql/ /path/to/your/backup/directory/mysql_backup
cp: cannot create directory '/path/to/your/backup/directory/mysql_backup': No such file or directory
root@ad:/var/lib/mysql#
when i try to backup i get this
and please tell me how to reinstallation

"/path/to/your/backup/directory" is an example. You need to enter a real path where you want your backup of the directory to go.

Please consider opening a support ticket and let support assist you with the process.

 

[Itsouly]

i would like to support do it how i can contact them to do that please? because i have licneses from vps company

 

[Peter Debik]

To sign-in to support please go to https://support.plesk.com

If you experience login issues, please see this KB article:
https://support.plesk.com/hc/en-us/...rt-plesk-com-and-password-reset-does-not-work

If you bought your license from a reseller, your reseller should provide support for you. If the reseller does not provide support, here is an alternative:
https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk-