MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: rsakhale on 2020-03-09, 12:51:35

Title: Upgrade MariaDB to 10.4
Post by: rsakhale on 2020-03-09, 12:51:35
I tried doing

Code: [Select]
sh /script/mariadb-upgrade 10.4
However, this failed at the end

Code: [Select]
=====================================================================================================================================================
 Package                           Arch                      Version                                       Repository                           Size
=====================================================================================================================================================
Installing:
 MariaDB-server                    x86_64                    10.4.12-1.el7.centos                          mratwork-mariadb                     26 M
Installing for dependencies:
 galera-4                          x86_64                    26.4.3-1.rhel7.el7.centos                     mratwork-mariadb                    9.3 M

Transaction Summary
=====================================================================================================================================================
Install  1 Package (+1 Dependent package)

Total size: 35 M
Installed size: 135 M
Downloading packages:
Running transaction check
Running transaction test


Transaction check error:
  file /usr/bin/garbd from install of galera-4-26.4.3-1.rhel7.el7.centos.x86_64 conflicts with file from package galera-25.3.28-1.rhel7.el7.centos.x86_64

Error Summary
-------------


- For help, type '/script/restart-mysql [--help|-h]'
/script/mariadb-upgrade: line 35: mysql_upgrade: command not found

- For help, type '/script/restart-mysql [--help|-h]'
- End process...

* Note:
  - Format: /script/mariadb-upgrade [target-version]
    where [target-version] = 10.2 (by default)

Now, after this mysql doesn't seem to work normally.
Title: Re: Upgrade MariaDB to 10.4
Post by: tkumar.patna on 2020-05-05, 07:58:35
Finally i upgraded to mariadb 10.4 successfully on kloxo mr 7 under centos 7
Title: Re: Upgrade MariaDB to 10.4
Post by: India220 on 2020-06-14, 06:02:26
latest version of mariadb has strict policy due to this kloxo MR crash.
i like to stick with 10.1
Title: Re: Upgrade MariaDB to 10.4
Post by: rsakhale on 2020-06-29, 20:30:13
Upgrade to 10.2 to get benefits of JSON data type and related functions

However, for one of our servers we are using VestaCP and that is running smooth on latest versions