yum -y update ///

Did someone have trouble updating MariaDB? The Server component is not updating for me. The "mariadb-server" package remains in version 10.11, while "mariadb-client" has been updated to version 11.

Using Almalinux 8


---------------------------------------------------------

Upgrading directly from MySQL 10.11 to MariaDB 11.0 may not
be safe in all cases.  A manual dump and restore using mysqldump is
recommended.  It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.

A manual upgrade is required.

- Ensure that you have a complete, working backup of your data and my.cnf
  files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages.  Usually this command will
  list the packages you should remove:
  rpm -qa | grep -i '^mysql-'

  You may choose to use 'rpm --nodeps -ev <package-name>' to remove
  the package which contains the mysqlclient shared library.  The
  library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by MariaDB Foundation
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program

This is a brief description of the upgrade process.  Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %prein(MariaDB-server-11.0.3-1.el8.x86_64) scriptlet failed, exit status 1

Error in PREIN scriptlet in rpm package MariaDB-server
  Verifying        : MariaDB-server-11.0.3-1.el8.x86_64                                                 1/2
  Verifying        : MariaDB-server-10.11.3-1.el8.x86_64                                                2/2

Failed:
  MariaDB-server-10.11.3-1.el8.x86_64                   MariaDB-server-11.0.3-1.el8.x86_64

Error: Transaction failed

Yes, I posted about that, that upgrading to MariaDB 11.x doesn't work.

Maria 10.11.x does though.

Nothing should have upgraded to 11.x unless you changed the mariadb.repo to download & install 11.x.

Not sure where you got those instructions from, but they are wrong for CWP.

The official MariaDB upgrade instructions can be found at: https://wiki.centos-webpanel.com/mariadb-upgrade-to-new-version

Where it is only safe to change the .repo up to 10.11

/////Not sure where you got those instructions from, but they are wrong for CWP. ////


running yum -y update from SSH console, I got that message.

I also tried changing the repository, but it doesn't work either.

Yea, that's not how yum/dnf update works.
Not to mention your post shows some kind of script was run - "error: %prein(MariaDB-server-11.0.3-1.el8.x86_64) scriptlet failed, exit status 1"

MySQL doesn't get installed with CWP, or even with the minimal install of AL 8 or 9.

Something else was done manually, since when you should be running dnf (not yum on 8.x/9.x) it refers to the .repo file for the version to be downloaded/updated.
By Default CWP installs MariaDB 10.4.x and the .repo for only that version.

Once you manually upgrade from MariaDB 10.11.x to 11.x, downgrading isn't really an option.

Best option is to start with a fresh minimal install as you should, and follow the step to step install guide that starts at:
https://control-webpanel.com/installation-instructions#step1

In other Server, I use the CWP Updates, and appear the same problem.

-----------------------------------------------------------------------------------
This message appear after Update :::


Update All
×
Package updated successfully.
--------------
Last metadata expiration check: 0:00:19 ago on Tue Aug 22 20:38:48 2023.
Dependencies resolved.
================================================================================
 Package              Architecture Version             Repository          Size
================================================================================
Upgrading:
 MariaDB-server       x86_64       11.0.3-1.el8        mariadb-main        27 M

Transaction Summary
================================================================================
Upgrade  1 Package

Total download size: 27 M
Downloading Packages:
MariaDB-server-11.0.3-1.el8.x86_64.rpm           24 MB/s |  27 MB     00:01   
--------------------------------------------------------------------------------
Total                                            23 MB/s |  27 MB     00:01     
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                        1/1
  Running scriptlet: MariaDB-server-11.0.3-1.el8.x86_64                     1/1
  Running scriptlet: MariaDB-server-11.0.3-1.el8.x86_64                     1/2

******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.11.3-1.el8.x86_64) is installed.

Upgrading directly from MySQL 10.11 to MariaDB 11.0 may not
be safe in all cases.  A manual dump and restore using mysqldump is
recommended.  It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.

A manual upgrade is required.

- Ensure that you have a complete, working backup of your data and my.cnf
  files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages.  Usually this command will
  list the packages you should remove:
  rpm -qa | grep -i '^mysql-'

  You may choose to use 'rpm --nodeps -ev ' to remove
  the package which contains the mysqlclient shared library.  The
  library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by MariaDB Foundation
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program

This is a brief description of the upgrade process.  Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %prein(MariaDB-server-11.0.3-1.el8.x86_64) scriptlet failed, exit status 1

  Verifying        : MariaDB-server-11.0.3-1.el8.x86_64                     1/2
  Verifying        : MariaDB-server-10.11.3-1.el8.x86_64                    2/2

Failed:
  MariaDB-server-10.11.3-1.el8.x86_64     MariaDB-server-11.0.3-1.el8.x86_64   

That's not from CWP.

Again their repo is for 10.4 Only:

cat > /etc/yum.repos.d/mariadb.repo
# MariaDB 10.4 CentOS repository list - created 2020-06-23 23:26 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4/centos8-amd64
module_hotfixes=1
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

This is directly from the Install script (cwp-el8-latest), and would have to be MANUALLY modified to another version.
NOTE: See how CWP even uses the CentOS version of MariaDB, not EL8.

It is one of the things we change after the install, we follow the wiki, and upgrade it to 10.11.x

All of our servers are running AlmaLinux 8.x, and it is NOT an upgrade from AL either.

SPAMMING the forum with your same question about some other non-CWP script you ran and corrupted your install isn't going to gain you any help or support.

Do a FRESH MINIMAL INSTALL and follow the install instructions, and leave it alone.

make the change in /etc/yum.repos.d/mariadb.repo and it works perfect !


thanxss !!!!