Author Topic: Yum Manager and # yum update failing to update Maria SQL  (Read 370 times)

0 Members and 2 Guests are viewing this topic.

Offline
*
Yum Manager and # yum update failing to update Maria SQL
« on: October 29, 2018, 05:35:35 AM »
Hi When I use Yum Manager in pro version it does not update the latest MariaDB-server.x86_64

Also if I run *Yum update in SSH, I get this error :

error: %pre(MariaDB-server-10.2.18-1.el7.centos.x86_64) scriptlet failed, exit status 1
Error in PREIN scriptlet in rpm package MariaDB-server-10.2.18-1.el7.centos.x86_64
MariaDB-server-10.1.36-1.el7.centos.x86_64 was supposed to be removed but is not!
  Verifying  : MariaDB-server-10.1.36-1.el7.centos.x86_64                   1/2
  Verifying  : MariaDB-server-10.2.18-1.el7.centos.x86_64                   2/2

Failed:
  MariaDB-server.x86_64 0:10.1.36-1.el7.centos
  MariaDB-server.x86_64 0:10.2.18-1.el7.centos

Complete!

Is anyone else having this issue?

Greets


Offline
***
Re: Yum Manager and # yum update failing to update Maria SQL
« Reply #1 on: October 29, 2018, 07:26:22 AM »
..me too
+1

Offline
*****
Re: Yum Manager and # yum update failing to update Maria SQL
« Reply #2 on: October 29, 2018, 11:34:41 AM »
Hi, that's weird.
How exactly was installed MariaDB before? I couldn't reproduce it with my server.

Offline
***
Re: Yum Manager and # yum update failing to update Maria SQL
« Reply #3 on: October 29, 2018, 03:21:26 PM »
with the installation of the CWP package...

Offline
*
Re: Yum Manager and # yum update failing to update Maria SQL
« Reply #4 on: October 29, 2018, 04:02:38 PM »
Happening on 2 of my VPS's.

Offline
*****
Re: Yum Manager and # yum update failing to update Maria SQL
« Reply #5 on: October 29, 2018, 05:39:44 PM »
That's weird.
It will be investigated.

Offline
*
Re: Yum Manager and # yum update failing to update Maria SQL
« Reply #6 on: October 30, 2018, 12:30:53 AM »
That's weird.
It will be investigated.

Thank you kind support.

Offline
*
Re: Yum Manager and # yum update failing to update Maria SQL
« Reply #7 on: October 31, 2018, 02:37:42 AM »
The update of MariaDB from version 10.1.36-1 to 10.2.18-1 is a major update, and must have be done manually.
This update introduced some differences on behavior of "default" fields of my tables, that you have caution to update.

Follow the procedure descripted at:
https://mariadb.com/kb/en/library/upgrading-from-mariadb-101-to-mariadb-102/

(Adapted to CentOS)
1) Set innodb_fast_shutdown to 0 (this step is not necessary when upgrading to MariaDB 10.2.5 or later - omitting it can make the upgrade process far faster - see MDEV-12289).

2) Execute: yum update (enter 'yes', to update all packges as possible)
    (Possibly the only one package not updated is 'MariaDB-server-10.2.18-1')

3) Take a backup (this is the perfect time to take a backup of your databases)
CAUTION: Believe me. Do backups right now by dumping them due that differences pointed. Be advised!

4) Uninstall MariaDB-server-10.1.36-1. Execute:
    yum remove MariaDB-server-10.1.36-1

5) Install MariaDB-server-10.2.18-1
    yum install MariaDB-server-10.2.18-1
    (or to install all other packages: yum install MariaDB*)

6) Run: mysql_upgrade

mysql_upgrade does two things:
- Upgrades the permission tables in the mysql database with some new fields
- Does a very quick check of all tables and marks them as compatible with MariaDB 10.2
In most cases this should be a fast operation (depending of course on the number of tables)

7) Add new options to my.cnf to enable features

If you change my.cnf then you need to restart mariadb

Regards,
Netino
« Last Edit: October 31, 2018, 02:47:54 AM by Netino »

Offline
***
Re: Yum Manager and # yum update failing to update Maria SQL
« Reply #8 on: November 03, 2018, 04:50:05 AM »
The update of MariaDB from version 10.1.36-1 to 10.2.18-1 is a major update, and must have be done manually.
This update introduced some differences on behavior of "default" fields of my tables, that you have caution to update.

Follow the procedure descripted at:
https://mariadb.com/kb/en/library/upgr.....

Regards,
Netino

try to install it manually or expect an automatic script ?!?