Resolved MariaDB database upgrade 10.2.44 to 10.11 not progressing beyond Upgrading the structure of all tables

[pleskuser67553]

Server operating system version

CentOS 7.9 (covered by TuxCare ELS)

Plesk version and microupdate number

Plesk Obsidian 18.0.79

In Database Servers I have clicked the Upgrade Now button in the user interface, its passed several stages with green ticks but it's apparently stalled during the Upgrading the structure of all tables stage. All I see is a series of table names in that box followed by 'OK' . It appears to have checked all the Plesk tables and is now on to the first customer database tables. The last table name in the list appears to be truncated, there is no 'OK' and the animated bar (presumably just a superficial CSS animation) continues to animate. There are no error messages that I can see.

Last few lines

redacted.redacted_wishlist_item                   OK
redacted.redacted_wishlist_item_option            OK
redacted.redacted_wsalogger_log                   OK
redacted.redacted_xmlconnect_application          OK
redacted.redacted_xmlconnect_config_data          OK
redacted.redacted_xmlconnect_history              OK
redacted.redacted_x

I have Repair Kit and SSH open in other tabs. Please what can I do/check?

 

[pleskuser67553]

Okay, it appears to be okay. That page did not progress, but I guess the interface itself got stuck because in SSH I typed systemctl status mariadb and it said running 10.11.9 etc. and I was able to load customer websites and the Plesk home screen okay in other browser tabs.

 

[pleskuser67553]

It's worth doing a Diagnose & Repair afterwards. It found 58 issues but was able to repair them all.