Issue Update failed (MariaDB issue?)

[Dave22]

Server operating system version

CentOS Linux 7.9.2009 (Core)

Plesk version and microupdate number

Plesk Obsidian v18.0.45_build1800220722.09 os_CentOS 7

Hello,

Second day i'm getting the error after plesk is trying to update.
Is something wrong with the MariaDB yum repositories? Thank you

Link to error code: Untitled - TextBin
Password: pl22

Thank you very much

 

[Maarten]

MariaDB 10.2 is end-of-life, so the mirrors of that version are cleared:

MariaDB

Check end-of-life, release policy and support schedule for MariaDB.

endoflife.date

It would be best if you upgraded to a newer version like MariaDB 10.6 (LTS), using this instruction:

 How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.x on Linux?

Applicable to: Plesk for Linux Question How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.X on Linux? Answer This article provides instructions for upgrading MySQL 5.5 to 5.6/5.7 and Mari...

support.plesk.com

 

[Dave22]

Thank you very much,

Is it better to do the automatic update or manual? And i only have to change the version to 10.6? Because in the manual it says 10.5

Thanks a lot.

(wget https://support.plesk.com/hc/en-us/article_attachments/4584125667858/c7-mariadb-10.5-upgrade.sh && chmod +x c7-mariadb-10.5-upgrade.sh
)

 

[Dave W]

10.5 is a current release.

 

[IgorG]

Error message:

http://yum.mariadb.org/10.2/centos7-amd64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found

can be fixed by replacing baseurl line to

baseurl = https://archive.mariadb.org/mariadb-10.2.9/yum/centos7-amd64/

in /etc/yum.repos.d/MariaDB.repo file.

 

[Maarten]

You can use either 10.5 or 10.6. The 10.6 version will last longer before you have to upgrade again.

 

[Dave22]

Error message:

can be fixed by replacing baseurl line to

baseurl = https://archive.mariadb.org/mariadb-10.2.9/yum/centos7-amd64/

in /etc/yum.repos.d/MariaDB.repo file.

Thanks, but when i change it to 10.2.9 it will stay on 10.2 right? So i still have to upgrade to 10.5?

 

[IgorG]

Thanks, but when i change it to 10.2.9 it will stay on 10.2 right? So i still have to upgrade to 10.5?

It's up to you. For example, my personal Plesk server works on MariaDB 10.2.9, and I do not hurry up to perform upgrades.

 

[Fronobulax]

It's up to you. For example, my personal Plesk server works on MariaDB 10.2.9, and I do not hurry up to perform upgrades.

Just wondering, what version of Plesk do you run/recommend?

 

[Dave22]

Is it also possible to just replace the baseurl line to the 10.5 version? Or is it better to do the upgrade with backups / remove / install?

 

[Maarten]

Replacing the baseurl is not the recommended step:

Upgrading from MariaDB 10.4 to MariaDB 10.5

How to upgrade from MariaDB 10.4 to MariaDB 10.5.

mariadb.com

It sounds like a significant upgrade (backup -> remove -> install), but it can be done in a few minutes. I suggest using the manual steps, not the upgrade script from the Plesk support article. That way, you have a better grasp of what's going on and more control over the upgrade process.

After the upgrade, run a # plesk repair db

 

[Dave22]

Replacing the baseurl is not the recommended step:

Upgrading from MariaDB 10.4 to MariaDB 10.5

How to upgrade from MariaDB 10.4 to MariaDB 10.5.

mariadb.com

It sounds like a significant upgrade (backup -> remove -> install), but it can be done in a few minutes. I suggest using the manual steps, not the upgrade script from the Plesk support article. That way, you have a better grasp of what's going on and more control over the upgrade process.

After the upgrade, run a # plesk repair db

Thanks Maarten, i'll try tomorrow.

Maybe its better to use your first link: https://support.plesk.com/hc/en-us/...-7-or-MariaDB-5-5-to-10-0-10-1-10-2-on-Linux-

Thank you for your help

 

[Maarten]

Thanks Maarten, i'll try tomorrow.

Maybe its better to use your first link: https://support.plesk.com/hc/en-us/...-7-or-MariaDB-5-5-to-10-0-10-1-10-2-on-Linux-

Thank you for your help

True, but the other link was to let you see what MariaDB itself recommends when you want to upgrade an existing MariaDB database server.

 

[IgorG]

Just wondering, what version of Plesk do you run/recommend?

I have Plesk 18.0.46 on CentOS7