Resolved Error upgrading MariaDB in Plesk

[passfeder]

Server operating system version

Ubuntu 20.04.6 LTS

Plesk version and microupdate number

v18.0.74_build1800251204.13

Hello, I have mariadb 10.3.39 installed. I'm encountering errors when upgrading to version 10.11 or 11.4. What can I do? Thank you for your help.
The database server upgrade could not be completed.

• Task is not responding: id=52980, pid=1614009, type=upgrade-database-server, clientRemoteAddr=93.241.196.227, current_stage=disableService, dbServerId=1, redirect=/cp/server/db/, releaseId=mariadb_11.4, runTaskUnderLogin=admin, withDump=1

Upgrading packages (mariadb-server mariadb-client mariadb-server-compat mariadb-client-compat) ...
Hit:1 Index of /pool/PSA_18.0.74_18022 focal InRelease
Hit:2 Index of /ubuntu focal InRelease
Hit:4 Index of /pool/PHP_7.1.33_98 focal InRelease
Hit:5 Index of /ubuntu focal-updates InRelease
Hit:6 Index of /pool/PHP_7.3.33_248 focal InRelease
Hit:7 Index of /ubuntu focal-backports InRelease
Hit:8 Index of /PHP74_17 focal InRelease
Hit:9 https://dlm.mariadb.com/repo/mariadb-server/11.4/repo/ubuntu focal InRelease
Hit:10 Index of /PHP80_17 focal InRelease
Hit:11 Index of /PHP81_17 focal InRelease
Hit:12 Index of /grafana/deb stable InRelease
Hit:13 Index of /DRWEB_6.0.2.9.1 focal InRelease
Hit:14 Index of /PHP82_17 focal InRelease
Hit:15 Index of /PHP83_17 focal InRelease
Hit:16 https://repo.tuxcare.com/ubuntu20_04-els/updates focal InRelease
Hit:17 Index of /ubuntu/20.04/slot-1/ focal InRelease
Hit:18 Index of /ubuntu/20.04/slot-2/ focal InRelease
Hit:19 Index of /ubuntu/20.04/slot-3/ focal InRelease
Hit:3 Index of /legacy/tools/ubuntu/ focal InRelease
Hit:20 Index of /ubuntu/20.04/slot-4/ focal InRelease
Hit:21 Index of /ubuntu/20.04/slot-5/ focal InRelease
Hit:22 Index of /ubuntu/20.04/slot-6/ focal InRelease
Hit:23 Index of /ubuntu/20.04/slot-7/ focal InRelease
Hit:24 Index of /ubuntu/20.04/slot-8/ focal InRelease
Hit:25 Index of /ubuntu focal-security InRelease
Hit:26 Index of /imunify360/ubuntu/20.04/ focal InRelease
Hit:27 Index of /alt-common/deb/ubuntu/20.04/stable/ focal InRelease
Reading package lists...
Reading package lists...
Building dependency tree...
Reading state information...
The following additional packages will be installed:
galera-4 libmariadb3 mariadb-client-core mariadb-common mariadb-server-core
Suggested packages:
mariadb-test
Recommended packages:
pv
The following packages will be REMOVED:
galera-3* mariadb-client-10.3* mariadb-client-core-10.3*
mariadb-server-10.3* mariadb-server-core-10.3*
The following NEW packages will be installed:
galera-4 libmariadb3 mariadb-client mariadb-client-compat
mariadb-client-core mariadb-server-compat mariadb-server-core
The following packages will be upgraded:
mariadb-common mariadb-server
2 upgraded, 7 newly installed, 5 to remove and 8 not upgraded.
Need to get 28.5 MB of archives.
After this operation, 91.7 MB of additional disk space will be used.
Ign:1 https://dlm.mariadb.com/repo/mariadb-server/11.4/repo/ubuntu focal/main amd64 mariadb-common all 1:11.4.7+maria~ubu2004

Err:2 https://dlm.mariadb.com/repo/mariadb-server/11.4/repo/ubuntu focal/main amd64 mariadb-server amd64 1:11.4.7+maria~ubu2004
404 Not Found [IP: 104.18.135.24 443]
Err:3 https://dlm.mariadb.com/repo/mariadb-server/11.4/repo/ubuntu focal/main amd64 galera-4 amd64 26.4.22-ubu2004
404 Not Found [IP: 104.18.135.24 443]
Err:4 https://dlm.mariadb.com/repo/mariadb-server/11.4/repo/ubuntu focal/main amd64 libmariadb3 amd64 1:11.4.7+maria~ubu2004
404 Not Found [IP: 104.18.135.24 443]
Err:5 https://dlm.mariadb.com/repo/mariadb-server/11.4/repo/ubuntu focal/main amd64 mariadb-client-core amd64 1:11.4.7+maria~ubu2004
404 Not Found [IP: 104.18.135.24 443]
Err:6 https://dlm.mariadb.com/repo/mariadb-server/11.4/repo/ubuntu focal/main amd64 mariadb-client amd64 1:11.4.7+maria~ubu2004
404 Not Found [IP: 104.18.135.24 443]
Err:7 https://dlm.mariadb.com/repo/mariadb-server/11.4/repo/ubuntu focal/main amd64 mariadb-server-core amd64 1:11.4.7+maria~ubu2004
404 Not Found [IP: 104.18.135.24 443]
Ign:8 https://dlm.mariadb.com/repo/mariadb-server/11.4/repo/ubuntu focal/main amd64 mariadb-client-compat all 1:11.4.7+maria~ubu2004
Ign:9 https://dlm.mariadb.com/repo/mariadb-server/11.4/repo/ubuntu focal/main amd64 mariadb-server-compat all 1:11.4.7+maria~ubu2004
Err:1 https://dlm.mariadb.com/repo/mariadb-server/11.4/repo/ubuntu focal/main amd64 mariadb-common all 1:11.4.7+maria~ubu2004
404 Not Found [IP: 104.18.135.24 443]
Err:8 https://dlm.mariadb.com/repo/mariadb-server/11.4/repo/ubuntu focal/main amd64 mariadb-client-compat all 1:11.4.7+maria~ubu2004
404 Not Found [IP: 104.18.135.24 443]
Err:9 https://dlm.mariadb.com/repo/mariadb-server/11.4/repo/ubuntu focal/main amd64 mariadb-server-compat all 1:11.4.7+maria~ubu2004
404 Not Found [IP: 104.18.135.24 443]

E: Failed to fetch https://dlm.mariadb.com/repo/mariad...b/mariadb-common_11.4.7+maria~ubu2004_all.deb 404 Not Found [IP: 104.18.135.24 443]

E: Failed to fetch https://dlm.mariadb.com/repo/mariad...mariadb-server_11.4.7+maria~ubu2004_amd64.deb 404 Not Found [IP: 104.18.135.24 443]

E: Failed to fetch https://dlm.mariadb.com/repo/mariad...g/galera-4/galera-4_26.4.22-ubu2004_amd64.deb 404 Not Found [IP: 104.18.135.24 443]

E: Failed to fetch https://dlm.mariadb.com/repo/mariad...db/libmariadb3_11.4.7+maria~ubu2004_amd64.deb 404 Not Found [IP: 104.18.135.24 443]

E: Failed to fetch https://dlm.mariadb.com/repo/mariad...db-client-core_11.4.7+maria~ubu2004_amd64.deb 404 Not Found [IP: 104.18.135.24 443]

E: Failed to fetch https://dlm.mariadb.com/repo/mariad...mariadb-client_11.4.7+maria~ubu2004_amd64.deb 404 Not Found [IP: 104.18.135.24 443]

E: Failed to fetch https://dlm.mariadb.com/repo/mariad...db-server-core_11.4.7+maria~ubu2004_amd64.deb 404 Not Found [IP: 104.18.135.24 443]

E: Failed to fetch https://dlm.mariadb.com/repo/mariad...db-client-compat_11.4.7+maria~ubu2004_all.deb 404 Not Found [IP: 104.18.135.24 443]

E: Failed to fetch https://dlm.mariadb.com/repo/mariad...db-server-compat_11.4.7+maria~ubu2004_all.deb 404 Not Found [IP: 104.18.135.24 443]

E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?

 

[ErikW]

Hello, im also on Ubuntu 20.04.6 LTS with multiple servers and i have the same error on every server. I think MariaDB changed the repos and now the links are not working anymore. I would also be very happy to find a solution

 

[Sebahat.hadzhi]

As mentioned by @ErikW the MariaDB repository for Ubuntu 20 has been moved to the MariaDB archive as ubuntu 20.04 has reached its end of life:

• All Files - Community Server 10.11

We have a registered bug identified with ID PPPM-15230. The fix will be introduced in Plesk 18.0.75, which will be released soon. In the meantime, the only workaround is to perform a manual upgrade.

 

[passfeder]

Thank you for your reply. I couldn't get it to work manually. I'll wait until version 18.0.75 is released.Regards, Kai

 

[Sebahat.hadzhi]

We have released an update today which fixes the issue with MariaDB upgrades. If you have automatic updates enabled this update should be installed automatically overnight. Plesk Obsidian 18.0.75:

Fixed the issue where MariaDB failed to upgrade on Ubuntu® 20 servers. (PPPM-15230)

Please let us know if you face any further issues.

 

[ErikW]

Thank you very much for the fast reply and fix! This helps a lot!

 

[passfeder]

I installed the update today.
Thank you so much, it worked perfectly.