Question MariaDB upgrade via Plesk fails

[mariodieck]

Server operating system version

Debian 12.12

Plesk version and microupdate number

Plesk Obsidian 18.0.74 Update #1

Hello everyone, my database server in Plesk is reporting a new update for MariaDB from version 10.11.14 to version 11.4, but unfortunately, the entire process fails after verification.


Checks before the upgrade:

WebSocket check: Pass
System compatibility check: Pass
Parse MariaDB configuration files: Pass
Analyze package manager configuration: Pass
Analyze databases with mysqlcheck: Error
Response not successful: Received status code 504


What could be the problem?

 

[Sebahat.hadzhi]

Hello, @mariodieck . Could you please try increasing the timeout and execution period according to this article:

• https://support.plesk.com/hc/en-us/...t-while-reading-response-header-from-upstream

Once done, please re-attempt the upgrade process.

 

[mariodieck]

Thank you for your reply. I followed the steps below. However, I am now receiving the following error message.

Analysiere die Paket-Manager-Konfiguration
MariaDB download URL 'https://downloads.mariadb.com/MariaDB/' cannot be accessed:
curl: (22) The requested URL returned error: 521

If you believe this is a temporary error, please try again later.
Otherwise ensure that the URL is accessible from the server.
For example, check your DNS, firewall, and /etc/hosts configuration.

 

[scsa20]

I had the same issue, it seems like MariaDB has updated their site. For now you can just manually upgrade through SSH. Since you're using Debian 12 (which is what I am using as well) this is what I did to update mine:

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /root/all-databases.sql
service mariadb stop
apt install apt-transport-https curl
curl -o /etc/apt/keyrings/mariadb-keyring.pgp 'https://mariadb.org/mariadb_release_signing_key.pgp'
cp -v -a /var/lib/mysql/ /var/lib/mysql_backup
curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=11.8
apt update
apt install mariadb-server
systemctl start mariadb.service
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
systemctl restart mariadb
plesk bin service_node --update local
plesk sbin packagemng -sdf

Please note of the following:

• This was all done under root.
• Each line is a new command.
• I made a snapshot of my VM before updating.
• The instructions was a mix from https://support.plesk.com/hc/en-us/articles/12388091703703-How-to-upgrade-MariaDB-on-Plesk-for-Linux and Download MariaDB Server - MariaDB.org
  • Some steps out of order since I wanted to make sure I have backups.
• I've installed 11.8 instead of 11.4 (since the change logs note that Plesk supports 11.8 now I figured might as well jump to that version).

After that the database is now on 11.8 (you can change the version number to 11.4 in line 6 where it has the mariadb-server-version set).