Issue MySQL not starting after update

[dotmaki]

Server operating system version

Ubuntu 20.04

Plesk version and microupdate number

Plesk Obsidian 18.0.49.2

Hello, yesterday i did an update on packages and while everything was working ok tomorrow i was greeted with this:




This is when i try to restart mariadb


I've tried to use plesk repair mysql but i get this error =>

I have tried other relative topics in the forums but couldn't get it to work. Any ideas?

 

[Peter Debik]

Do you see any MySQL or MariaDB related entries in /var/log/messages?

 

[dotmaki]

Do you see any MySQL or MariaDB related entries in /var/log/messages?

Seems empty :/

 

[dotmaki]

I have managed to get MySQL / MariaDB up and running following this guide: https://support.plesk.com/hc/en-us/articles/12377928655767
Seems that MySQL table was somehow deleted so i manually created it and then restored the dump from the day before the update.

Is there another table i should restore in order to get the Plesk frontend to work ?
The issue on the Plesk frontend still persists.

 

[dotmaki]

Finally i updated / upgraded plesk with this guide through the CLI and everything seems to be back to normal

 How to upgrade Plesk to the next release - Support Cases from Plesk Knowledge Base

 How to upgrade Plesk to the next release - Support Cases - Plesk Knowledge Base

www.plesk.com

 

[Peter Debik]

Did you attempt an upgrade of Plesk before the database issue occured and have there been any errors logged in /var/log/plesk/install/autoinstaller3.log on that attempt?

 

[dotmaki]

Yes as stated in the initial question this happened after a Plesk upgrade. I scanned it briefly but couldn't locate any errors.

Here's a screenshot around the time this i believe happened.

 

[Peter Debik]

Do you have a support subscription or was your license purchased from Plesk so that it includes support? I've seen a similar report on the Facebook group, but so far none of the users opened a ticket on it, so that we have not yet seen how an update could cause a missing database table. It would need to be examined in detail on an affected system. This is also strange, because after your update your system seems to having been stable and only later tables from the database went missing.

 

[dotmaki]

Do you have a support subscription or was your license purchased from Plesk so that it includes support? I've seen a similar report on the Facebook group, but so far none of the users opened a ticket on it, so that we have not yet seen how an update could cause a missing database table. It would need to be examined in detail on an affected system. This is also strange, because after your update your system seems to having been stable and only later tables from the database went missing.

I've purchased my license along with my dedicated so i get billed through my dedicated provider for plesk but no i haven't made any Facebook group posts.

I'll gladly can provide you a dump if you guide me through it

 

[Peter Debik]

Could you please do one check for me on your system? I'd like to know, what output
# grep "mysql." /var/www/vhosts/plesk/install/autoinstaller3.log
shows. In a similar case a user found entries showing that the mysql database was damaged. We know that Plesk only detected it and is not the cause, but as the other case is also Ubuntu and occured after an update, I'd be interested in learning whether there is an issue with some package upgrade of Ubuntu that causes a mysql database corruption.

 

[MartinT]

Had a same issue at Monday, my soulution was to follow the steps https://support.plesk.com/hc/en-us/articles/12377928655767. The restart solve the problem, then I forgot the step 9 of the instruction, after removing the skip and a da restart it worked well.