MariaDB error while yum update with Centos 7

Hi,

we are trying to yum update in CentOS 7 but we receive the following error, it seems there is a conflict between MariaDB Server and MariaDB GaleraServer. ERPNext was installes with the script in Centos 7 and works correctly. v4.2.

Transaction check error:
  file /etc/init.d/mysql conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /etc/my.cnf.d/server.cnf conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/aria_chk conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/aria_dump_log conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/aria_ftdump conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/aria_pack conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/aria_read_log conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/my_print_defaults conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/myisam_ftdump conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/myisamchk conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/myisamlog conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/myisampack conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/mysql_tzinfo_to_sql conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/mysql_upgrade conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/mysqlbug conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/mysqld_multi conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/mysqld_safe conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/perror conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/resolve_stack_dump conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/resolveip conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/bin/tokuftdump conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/lib64/mysql/plugin/auth_pam.so conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/lib64/mysql/plugin/auth_socket.so conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/lib64/mysql/plugin/ha_innodb.so conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/lib64/mysql/plugin/ha_oqgraph.so conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/lib64/mysql/plugin/ha_sphinx.so conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/lib64/mysql/plugin/ha_tokudb.so conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/lib64/mysql/plugin/handlersocket.so conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/lib64/mysql/plugin/query_cache_info.so conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/lib64/mysql/plugin/semisync_master.so conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/lib64/mysql/plugin/semisync_slave.so conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/lib64/mysql/plugin/server_audit.so conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/lib64/mysql/plugin/sphinx.so conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/lib64/mysql/plugin/sql_errlog.so conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/sbin/mysqld conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64
  file /usr/share/mysql/mysql.server conflicts between attempted installs of MariaDB-server-5.5.41-1.el7.centos.x86_64 and MariaDB-Galera-server-5.5.41-1.el7.centos.x86_64

A workaround is exclude the MAriaDB packages from updating, to do it this can be done:
Open /etc/yum.conf file, and append the following line under [main] section:

exclude=mariadb*

This will allow you at least to update the rest of the packages. Would be nice to know why this incompatibility between MariaDB and Galera and how to solve it. Are both installed with the installation script?

1 Like

Galera would conflict but it’s not installed by the install script.

We are checking the installed packages of Maria:

mariadb.x86_64                  1:5.5.40-1.el7_0                       @updates 
mariadb-devel.x86_64            1:5.5.40-1.el7_0                       @updates 
mariadb-libs.x86_64             1:5.5.40-1.el7_0                       @updates 
mariadb-server.x86_64            1:5.5.40-1.el7_0                       @updates 

It seems that galera server is not installed as you say, but then why this conflict?

I don’t have a test system for this. My hunch is that it could be because mariadb is supplied by both, official repositories and the maraidb repository (from the mariadb foundation).

Is the script installing from the mariadb repository or from Centos 7?

We were installing a fresh instance of ERPNext in CentOS 7 and is retrieving correctly the latest MariaDB version. I think the problem will come when there is a new version of Maria, then the mariadb repo installed by the script will collide with the official release of CentOS 7 through yum update.

Does this make sense? Should the CentOS 7 users disable the mariadb repo after the install?

1 Like

If the script installs form CentOS repositories, I see a problem here. Otherwise, as MariaDB repos would have the greatest version number, it should upgrade to that without any conflicts.