Issue Plesk Update Failed

[Mike Flanagan]

Currently experiencing an issue with a VPS we have Plesk installed on. The core update is failing.

===> Upgrading database

 Trying to start service mariadb... active
done
 Trying to establish test connection... ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
ERROR 1049 (42000): Unknown database 'mysql'
failed

ERROR while trying to establish test connection
Check the error reason(see log file: /var/log/plesk/install/plesk_12.5.30_installation.log), fix and try again

Stopping sw-cp-server (via systemctl):  [  OK  ]
Starting sw_engine service... done
Starting sw_cp_server service... done
Starting mysql service... already started
Starting named service... already started
Starting mailer service... already started
Starting spamfilter service... already started
Starting tomcat service... not installed
Starting apache service... already started
Starting superserver service... already started
Starting sw_engine service... already started
Starting drweb service... already started
*****  problem report *****
ERROR while trying to establish test connection
Check the error reason(see log file: /var/log/plesk/install/plesk_12.5.30_installation.log), fix and try again

ERROR: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
Warning! Not all packages were installed.
Please check if your system services are operable.
Please resolve this issue and try installing the packages again.
If you cannot resolve the issue on your own, contact product technical support for assistance.

 

[Mike Flanagan]

Has anybody else experienced this?

System details:

Version Plesk v12.5.30_build1205150826.19 os_CentOS 7
OS CentOS Linux 7.2.1511 (Core)

 

[Mike Flanagan]

Anybody?

 

[UFHH01]

Hi Mike Flanagan,

you somehow "destroyed"/deleted your databases ( at least the "mysql" - database, which is essential for your mysql - server ), so pls. consider to restore your latest ( working ) backup from "/var/lib/psa/dumps/".

An example how to do that can be found at: => How to backup/restore a Plesk database dump? ( KB - article 881 )

 

[Mike Flanagan]

The server hasn't been touched, other than to install a WordPress installation...

 

[Mike Flanagan]

I have just checked and there isn't a 'mysql' table dump in there at all