Issue Post Plesk Update - Server is inaccessible, MariaDB does not load

[mcglinn]

An automatic upgrade was applied to the server early this morning and all sites are now inacccessible. Initially, I was able to login to the back end where I carried out systems checks and all seemed fine apart from the fact that websites were not accessible. Any advice on how to proceed with this?

 

[Monty]

Are you running Ubuntu? If so, check this thread:

Issue - All Domains Apache2/Error 500

Files (.pdf, .ico ...) can be loaded, only index.php and so on cannot be loaded / displayed. Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator to inform of the time the error...

talk.plesk.com

Workaround is here:

Website on Plesk server suddenly started to show 500 error: AH10292: Invalid proxy UDS filename

Applicable to: Plesk Obsidian for Linux Symptoms Websites show the following error: AH10292: Invalid proxy UDS filename (proxy:unix:///var/www/vhosts/system/example.com/php-fpm.sock|fcgi://127...

support.plesk.com

Permanent fix for Ubuntu:

Issue - All Domains Apache2/Error 500

FYI: Canonical has released new apache2 packages some minutes ago which fix the regression: Change log : apache2 package : Ubuntu Bugreport: Bug #1945311 “Fix for CVE-2021-40438 breaks existing configs” : Bugs : apache2 package : Ubuntu

talk.plesk.com

 

[mcglinn]

I understand that the issue stems from the Apache upgrade, which is unfortuante. This should have been caught before the Plesk update was sanctioned for release.
Initially, although I could login to the Plesk administrator panel and run various checks to identify the cause of the downed sites, the system showed no errors. I tried restarting Apache from within Plesk and no change. When I restarted NGNIX, then Plesk went down completely and I have not been able to access it since with MariaDB showing a failure to load.

Could you suggest a way forward? Thank you.

 

[Monty]

You seem to have a much bigger problem than "just" the Apache problem of today.
You can try this: MySQL/MariaDB fails to start on a Plesk for Linux server: Can't open and lock privilege tables

If this doesn't help I suggest you contact Plesk support.

 

[mcglinn]

I was able to progress half way with the solution referenced above and restart mariaDB and mysql but not able to back up the databse. Plesk is now up and running. However, when looking at Local Mysql server in Plesk, I am seeing the following error:

Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mysql.user' doesn't exist.

Strangely, some sites are ableto run with FastCGI enabled but otherwise not. Suggestions?