Question Try our new tool to upgrade your old MariaDB server from Plesk UI

[dash]

Server operating system version

Ubuntu 22.04

Plesk version and microupdate number

18.0.58

Hi all,

In the latest Plesk Obsidian 18.0.58 we have released our new tool to upgrade MariaDB to a supported LTS branch from Plesk UI.
To upgrade your MariaDB server without this tool you need to execute a lot of steps in SSH terminal on the source and destination version of the MariaDB server.
Our tool checks configuration, performs DB backup, configures MariaDB package repositories, performs the upgrade, and runs necessary post-upgrade actions.

Currently, this function is in the public Beta stage, and would like to ask you to try it and send us your feedback.
To enable the feature, add the following lines to the panel.ini file. You can do it using the command line or our Panel Ini Editor Extension
[databaseManagement]
features.canBeUpgraded = 1

==> "Upgrade Now" will be available on "Tools & Settings -> Database Servers" page.

After the upgrade please fill out our very short feedback form: MariaDB upgrade by Plesk

 

[JulianDot]

done and done

 

[n0fear]

@dash nice new feature but got a question on that. i upgraded manually to 10.11.6 some weeks ago. thats the latest version that is supported by plesk, right? On the Tools & Settings page i get a icon telling "You are allready on the lts version. Plesk will automaticaly update to point releases". Can i let the setting on, too or is this not recommended? Normaly i upgrade via apt get upgrade

Hi all,

In the latest Plesk Obsidian 18.0.58 we have released our new tool to upgrade MariaDB to a supported LTS branch from Plesk UI.
To upgrade your MariaDB server without this tool you need to execute a lot of steps in SSH terminal on the source and destination version of the MariaDB server.
Our tool checks configuration, performs DB backup, configures MariaDB package repositories, performs the upgrade, and runs necessary post-upgrade actions.

Currently, this function is in the public Beta stage, and would like to ask you to try it and send us your feedback.
To enable the feature, add the following lines to the panel.ini file. You can do it using the command line or our Panel Ini Editor Extension
[databaseManagement]
features.canBeUpgraded = 1

==> "Upgrade Now" will be available on "Tools & Settings -> Database Servers" page.

After the upgrade please fill out our very short feedback form: MariaDB upgrade by Ples

 

[dash]

@n0fear Hi, I think it's no problem to keep updating your MariaDB instance with apt get as you usually do. Thanks!

 

[MRW]

Hi,

upgrades are also offered for mariadb docker cts :


You can still start the upgrade which then leads to localhost mariadb being upgraded. In my case 10.11.5 => 10.11.6.

I belive this is an error and should not be possible.

 

[dash]

Thanks for your report, @MRW, we haven't taken this case into account
I'll pass this case to the developers.

 

[ChristophRo]

Upgrade tool does not work if there are any temporary/memory? tables in a database:

 

[dash]

Upgrade tool does not work if there are any temporary/memory? tables in a database:

Hi @ChristophRo, thanks for your feedback! we are investigating this case, for now, we consider this pre-upgrade check blocker as a false positive and plan to rework it.
Thanks,

 

[n0fear]

Hi all,

In the latest Plesk Obsidian 18.0.58 we have released our new tool to upgrade MariaDB to a supported LTS branch from Plesk UI.
To upgrade your MariaDB server without this tool you need to execute a lot of steps in SSH terminal on the source and destination version of the MariaDB server.
Our tool checks configuration, performs DB backup, configures MariaDB package repositories, performs the upgrade, and runs necessary post-upgrade actions.

Currently, this function is in the public Beta stage, and would like to ask you to try it and send us your feedback.
To enable the feature, add the following lines to the panel.ini file. You can do it using the command line or our Panel Ini Editor Extension
[databaseManagement]
features.canBeUpgraded = 1

==> "Upgrade Now" will be available on "Tools & Settings -> Database Servers" page.

After the upgrade please fill out our very short feedback form: MariaDB upgrade by Plesk

View attachment 25236

Does not work on a fresh installed Ubunut 22.04 server. Wanted to try it this way instead of manuel install this time. but shows this error

 

[VNick]

Does not work on a fresh installed Ubunut 22.04 server.

Please run the following command and paste it's entire output here:
bash -x /usr/lib/plesk-9.0/mariadb_repo_setup --mariadb-server-version mariadb-10.11 --skip-maxscale --skip-check-installed

 

[Polli]

The update from MariaDB 10.5. to 10.11.6 went without any problems. Done with Debian 12. Thanks for the tool.

 

[dash]

Hi @ChristophRo, thanks for your feedback! we are investigating this case, for now, we consider this pre-upgrade check blocker as a false positive and plan to rework it.
Thanks,

@ChristophRo
Hi, we fixed the issue (false positive pre-check failure) in Plesk 18.0.58 update #2 last week, thanks for your report!

 

[NITROFOX]

@ChristophRo
Hi, we fixed the issue (false positive pre-check failure) in Plesk 18.0.58 update #2 last week, thanks for your report!

Any solutions to this (update to 10.5 tool)?

Removing previous mariadb-server provider ...
Removing previous packages (MariaDB-devel-10.5.23-1.el8.x86_64) ...
Upgrading packages (MariaDB-server MariaDB-client MariaDB-shared MariaDB-common MariaDB-devel MariaDB-backup) ...
AlmaLinux 8 - BaseOS 12 MB/s | 5.2 MB 00:00
AlmaLinux 8 - AppStream 22 MB/s | 12 MB 00:00
AlmaLinux 8 - Extras 61 kB/s | 20 kB 00:00
AlmaLinux 8 - PowerTools 7.8 MB/s | 3.1 MB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 35 MB/s | 16 MB 00:00
kernelcare 41 kB/s | 47 kB 00:01
MariaDB Server 460 kB/s | 622 kB 00:01
...grafana extension repository 1.4 MB/s | 108 kB 00:00
panel-migrator extension repository 600 kB/s | 34 kB 00:00
site-import extension repository 684 kB/s | 34 kB 00:00
sophos-av extension repository 21 kB/s | 1.3 kB 00:00
All matches were filtered out by exclude filtering for argument: MariaDB-server
* Maybe you meant: mariadb-server
Package MariaDB-client-10.4.32-1.el8.x86_64 is already installed.
Package MariaDB-shared-10.5.23-1.el8.x86_64 is already installed.
Package MariaDB-common-10.5.23-1.el8.x86_64 is already installed.
Package MariaDB-backup-10.5.23-1.el8.x86_64 is already installed.
Error: Unable to find a match: MariaDB-server



Removing previous mariadb-server provider ...
Removing previous packages (MariaDB-devel-10.5.23-1.el8.x86_64) ...
Upgrading packages (MariaDB-server MariaDB-client MariaDB-shared MariaDB-common MariaDB-devel MariaDB-backup) ...
AlmaLinux 8 - BaseOS 12 MB/s | 5.2 MB 00:00
AlmaLinux 8 - AppStream 22 MB/s | 12 MB 00:00
AlmaLinux 8 - Extras 61 kB/s | 20 kB 00:00
AlmaLinux 8 - PowerTools 7.8 MB/s | 3.1 MB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 35 MB/s | 16 MB 00:00
kernelcare 41 kB/s | 47 kB 00:01
MariaDB Server 460 kB/s | 622 kB 00:01
...site-import extension repository 684 kB/s | 34 kB 00:00
sophos-av extension repository 21 kB/s | 1.3 kB 00:00
All matches were filtered out by exclude filtering for argument: MariaDB-server
* Maybe you meant: mariadb-server
Package MariaDB-client-10.4.32-1.el8.x86_64 is already installed.
Package MariaDB-shared-10.5.23-1.el8.x86_64 is already installed.
Package MariaDB-common-10.5.23-1.el8.x86_64 is already installed.
Package MariaDB-backup-10.5.23-1.el8.x86_64 is already installed.
Error: Unable to find a match: MariaDB-server
Service mariadb doesn't exist

Usage: register_service {--enable service [options] | --disable service | --list | --full-list}
Enables or disables the specified service.

--enable enable the specified service
--disable disable the specified service
--list show list of services
--full-list show list of services with status

enable options:
--with-resource-controller register the service in Plesk Resource Controller

There is a thread of mine (Issue - Update MariaDB from 10.4.32 to 10.5) already on the subject but no solution.

Question, will I get the same error if I try to upgrade directly to 10.11 instead of 10.5?

 

[VNick]

Any solutions to this (update to 10.5 tool)?

All matches were filtered out by exclude filtering for argument: MariaDB-server

Remove the exclude from your DNF configuration.

Question, will I get the same error if I try to upgrade directly to 10.11 instead of 10.5?

Yes.

 

[NITROFOX]

Remove the exclude from your DNF configuration.

Yes.

Thanks for help me.

How remove this? Where is DNF configuration?


Thank you

 

[VNick]

How remove this? Where is DNF configuration?

grep -r exclude /etc/yum*

should show you. Unless this is due to DNF module exclusions (which I don't believe it is).

 

[NITROFOX]

grep -r exclude /etc/yum*

should show you. Unless this is due to DNF module exclusions (which I don't believe it is).

Thank you.

I run the command "grep -r exclude /etc/yum*" and "grep -r exclude /etc/yum", and nothing happened, no information in the shh terminal

[root@ns340238 ~]# grep -r exclude /etc/yum*
[root@ns340238 ~]# grep -r exclude /etc/yum
[root@ns340238 ~]#

 

[VNick]

Please compare and show the output of:

# yum info MariaDB-server
# yum info --disableexcludes=all MariaDB-server

 

[NITROFOX]

Please compare and show the output of:

# yum info MariaDB-server
# yum info --disableexcludes=all MariaDB-server

Thank you.

I run commands:

[root@ns340238 ~]# yum info MariaDB-server
Last metadata expiration check: 2:55:20 ago on Fri 02 Feb 2024 09:51:24 AM WET.
Installed Packages
Name : MariaDB-server
Version : 10.4.32
Release : 1.el8
Architecture : x86_64
Size : 127 M
Source : MariaDB-server-10.4.32-1.el8.src.rpm
Repository : @System
From repo : mariadb
Summary : MariaDB database server binaries
URL : MariaDB Foundation - MariaDB.org
License : GPLv2
Description : MariaDB: a very fast and robust SQL database server
:
: It is GPL v2 licensed, which means you can use the it free of
: charge under the conditions of the GNU General Public License
: Version 2 (Licenses - GNU Project - Free Software Foundation).
:
: MariaDB documentation can be found at MariaDB Knowledge Base
: MariaDB bug reports should be submitted through
: System Dashboard - Jira

Available Packages
Name : mariadb-server
Epoch : 3
Version : 10.3.39
Release : 1.module_el8.8.0+3609+204d4ab0
Architecture : x86_64
Size : 16 M
Source : mariadb-10.3.39-1.module_el8.8.0+3609+204d4ab0.src.rpm
Repository : appstream
Summary : The MariaDB server and related files
URL : MariaDB Foundation - MariaDB.org
License : GPLv2 with exceptions and LGPLv2 and BSD
Description : MariaDB is a multi-user, multi-threaded SQL database server. It
: is a client/server implementation consisting of a server daemon
: (mysqld) and many different client programs and libraries. This
: package contains the MariaDB server and some accompanying files
: and directories. MariaDB is a community developed branch of
: MySQL.

[root@ns340238 ~]# yum info --disableexcludes=all MariaDB-server
Last metadata expiration check: 2:55:43 ago on Fri 02 Feb 2024 09:51:24 AM WET.
Installed Packages
Name : MariaDB-server
Version : 10.4.32
Release : 1.el8
Architecture : x86_64
Size : 127 M
Source : MariaDB-server-10.4.32-1.el8.src.rpm
Repository : @System
From repo : mariadb
Summary : MariaDB database server binaries
URL : MariaDB Foundation - MariaDB.org
License : GPLv2
Description : MariaDB: a very fast and robust SQL database server
:
: It is GPL v2 licensed, which means you can use the it free of
: charge under the conditions of the GNU General Public License
: Version 2 (Licenses - GNU Project - Free Software Foundation).
:
: MariaDB documentation can be found at MariaDB Knowledge Base
: MariaDB bug reports should be submitted through
: System Dashboard - Jira

Available Packages
Name : mariadb-server
Epoch : 3
Version : 10.3.39
Release : 1.module_el8.8.0+3609+204d4ab0
Architecture : x86_64
Size : 16 M
Source : mariadb-10.3.39-1.module_el8.8.0+3609+204d4ab0.src.rpm
Repository : appstream
Summary : The MariaDB server and related files
URL : MariaDB Foundation - MariaDB.org
License : GPLv2 with exceptions and LGPLv2 and BSD
Description : MariaDB is a multi-user, multi-threaded SQL database server. It
: is a client/server implementation consisting of a server daemon
: (mysqld) and many different client programs and libraries. This
: package contains the MariaDB server and some accompanying files
: and directories. MariaDB is a community developed branch of
: MySQL.

[root@ns340238 ~]#

 

[VNick]

Either you've already fixed your configuration or the problem is in a completely different place. I suggest either retrying installation or addressing support.