Resolved Server Error 500 Zend_Db_Adapter_Exception plesk

[Stefan Buntscheck]

Hello,

I despair of my Plesk instance.
i tried to fix a update issue (upgrade from 17.8.11 to 18)

but i did something wrong and now i get the Server Error 500 zend_db and all website are offline

service mysql status

● mysql.service - LSB: Start and stop the mysql database server daemon

Loaded: loaded (/etc/init.d/mysql)

Active: failed (Result: exit-code) since Wed 2019-12-25 23:19:20 CET; 30min ago

Process: 5581 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)


Dec 25 23:18:50 server.buntspecht-fashion.de mysqld[5751]: 191225 23:18:50 [Note] InnoDB: Percona XtraDB (Experts in Database Performance Management) 5.6.42-84...1128032

Dec 25 23:18:50 server.buntspecht-fashion.de mysqld[5751]: 191225 23:18:50 [Note] Plugin 'FEEDBACK' is disabled.

Dec 25 23:18:50 server.buntspecht-fashion.de mysqld[5751]: 191225 23:18:50 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgra...ate it.

Dec 25 23:18:50 server.buntspecht-fashion.de mysqld[5751]: 191225 23:18:50 [ERROR] Can't open and lock privilege tables: Table 'mysql.server...t exist

Dec 25 23:18:50 server.buntspecht-fashion.de mysqld[5751]: 191225 23:18:50 [Note] Server socket created on IP: '::'.

Dec 25 23:18:50 server.buntspecht-fashion.de mysqld[5751]: 191225 23:18:50 [ERROR] Fatal error: Can't open and lock privilege tables: Table ...t exist

Dec 25 23:19:20 server.buntspecht-fashion.de mysql[5581]: Starting MariaDB database server: mysqld . . . . . . . . . . . . . . . . . . . . ....failed!

Dec 25 23:19:20 server.buntspecht-fashion.de systemd[1]: mysql.service: control process exited, code=exited status=1

Dec 25 23:19:20 server.buntspecht-fashion.de systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.

Dec 25 23:19:20 server.buntspecht-fashion.de systemd[1]: Unit mysql.service entered failed state.

Hint: Some lines were ellipsized, use -l to show in full.

plesk repair db -y

Warning: Current locale is unusable. Using 'C' instead.

SQLSTATE[HY000] [2002] No such file or directory

exit status 3


is there somebody who can help me with this?

 

[IgorG]

Can't open and lock privilege tables: Table 'mysql.server.

Try to fix it with help of this KB article MySQL/MariaDB fails to start on a Plesk for Linux server: Can't open and lock privilege tables

 

[Stefan Buntscheck]

Thank you very much. After hours of working. i got it:

1. 
   Copy databases to the backup:
   # cp -a /var/lib/mysql{,_before_restore}
   
   
2. Re-initialized the global tables:
   # mysql_install_db
   
   
3. Restored Plesk database administrator account using manual method of the following article: Unable to access Plesk on Linux: Access denied for user 'admin'@'localhost' (using password: YES)
   
   
4. Restartув MySQL server:
   # systemctl restart mysql