Resolved MariaDB Upgrade via Plesk

[JohanV]

Server operating system version

Centos 7.9

Plesk version and microupdate number

18.0.61 #5

Hi,

I did an update via Plesk to MariaDB 10.11.8
Everything went smooth but than it started with Upgrading the structure of all tables. Step 1 of 8
For more than an hour, the upgrade now pauses at wp_jphpb.i9dW2P_actionscheduler_logs
Should I just keep waiting now or is there a way to fix this? Those logs are not exceptionally large.

Syncing system components is the next step which is a must?

 

[Kaspar@Plesk]

Hi there, you can try to run the command MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin to manually upgrade the table structures.

 

[JohanV]

Hi Kaspar,

many thanks that worked!
Syncing system components also needed?

 

[Kaspar@Plesk]

Yes. Unfortunately I don't have any suggestions how to do those manually. Has upgrade finished in Plesk? Or is it still stuck?

 

[JohanV]

Hi Kaspar,

I don't see any updates in Plesk. It works for a while now. I don't know if Syncing System has need to be done too.
I simply will try to reboot the system.

 

[Kaspar@Plesk]

Good to read that at least your server is working fine.

Does the MariaDB version shown in Plesk (Tools & Settings > Database Servers) match the version shown in phpMyAdmin for example (or if you run the command mariadb -V)?

 

[JohanV]

Yess! Everything seems to be fine.

 

[Me2]

Hi there, you can try to run the command MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin to manually upgrade the table structures.

Having same issue where 'Upgrading the structure of all tables' is stuck on a small table.
Do I just exit out of the upgrade and then run this via SSH?
"MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin"

MariaDB version shown in Plesk (Tools & Settings > Database Servers) does match the version shown in phpMyAdmin

 

[Sebahat.hadzhi]

Yes, please. Exit the upgrade and try executing the command mentioned by Kaspar.

 

[websavers]

Same issue occurred here on one of our boxes, and it had completed successfully in the background, but the UI lost its connection apparently. If you open Plesk fresh in a new tab, it'll likely show you that it was completed successfully with a notification in the lower right corner.

The updating system components part that the UI says it hasn't done yet (because it got stuck) is where it shows the correct MariaDB version under Tools & Settings > Database Servers, which is why Kaspar asked about that - if it's been updated there, then you're all good.

 

[Azurel]

Same here, which is annoying. A new browser tab shows me the Plesk login. However, it seems that the upgrade was successfully completed, as the new version is available and mysql_upgrade appears to have been executed.

Here its hangs


However, I don't know if all the steps have been completed, as I have no idea what else still needs to be done.