Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MariaDB-server upgrade fails #8475

Closed
stegar123 opened this issue Jan 8, 2025 · 1 comment · Fixed by #8482
Closed

MariaDB-server upgrade fails #8475

stegar123 opened this issue Jan 8, 2025 · 1 comment · Fixed by #8482

Comments

@stegar123
Copy link
Contributor

Describe the bug
During pf upgrade, MariaDB server fails when passing from MariaDB-server-10.5.24-1.el8.x86_64 to MariaDB-server-10.11.6-1.el8.x86_64

error:



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-10.11.6-1.el8.x86_64) scriptlet failed, exit status 1

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

Failed:
  MariaDB-server-10.5.24-1.el8.x86_64                                                                                                   MariaDB-server-10.11.6-1.el8.x86_64                                                                                                  

Error: Transaction failed

To Reproduce
Steps to reproduce the behavior:

  1. install pf 14.0
  2. execute /usr/local/pf/addons/upgrade/do-upgrade.sh
@stegar123 stegar123 added this to the PacketFence-14.1 milestone Jan 8, 2025
@stegar123
Copy link
Contributor Author

It seems that MariaDB does not support upgrade from 10.5 to 10.11. To upgrade we have to remove than install

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

Upgrading directly from MySQL 10.5 to MariaDB 10.11 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.

@stegar123 stegar123 linked a pull request Jan 10, 2025 that will close this issue
4 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant