Not the answer you need?
Register and ask your own question!

perl-DBD-MySQL dependencies causing problem with Galera Cluster

YeePYeeP ContributorCurrent User Role Beginner
Server OS: CentOS 7

The system has the following MySQL server files:
MariaDB-Galera-5.5.54-centos7-x86_64-server.rpm
MariaDB-5.5.54-centos7-x86_64-client.rpm
MariaDB-5.5.54-centos7-x86_64-common.rpm

So I am testing changing our system over to xtrabackup-v2 (from rsync) but when installing the perl-DBD-MySQL dependency for percona-xtrabackup-24-2.4.6-1.el7.x86_64.rpm, I am running into a conflict.
○ sudo yum install "perl(DBD::mysql)"
Installing:
 perl-DBD-MySQL 
Installing for dependencies:
 mysql-community-common 
 mysql-community-libs

At this point, I stopped because I already have MariaDB-5.5.54-centos7-x86_64-common.rpm and I am guessing there will be a conflict. After some messing around with other ideas, and the fact that this is on a vagrant box currently to test for the change to xtrabackup, I went ahead and run the install. Conflicts are below:
Transaction check error:
  file /usr/share/mysql/charsets/Index.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/armscii8.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/ascii.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/cp1250.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/cp1256.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/cp1257.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/cp850.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/cp852.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/cp866.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/dec8.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/geostd8.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/greek.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/hebrew.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/hp8.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/keybcs2.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/koi8r.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/koi8u.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/latin1.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/latin2.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/latin5.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/latin7.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/macce.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/macroman.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/charsets/swe7.xml from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-common-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/czech/errmsg.sys from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-Galera-server-5.5.54-1.el7.centos.x86_64
<SNIP>
  file /usr/share/mysql/slovak/errmsg.sys from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-Galera-server-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/spanish/errmsg.sys from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-Galera-server-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/swedish/errmsg.sys from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-Galera-server-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/ukrainian/errmsg.sys from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-Galera-server-5.5.54-1.el7.centos.x86_64
  file /usr/share/mysql/errmsg-utf8.txt from install of mysql-community-common-5.7.12-1.el7.x86_64 conflicts with file from package MariaDB-Galera-server-5.5.54-1.el7.centos.x86_64

I then obtained the rpm package and attempted a --nodeps install to get around it.
○ sudo rpm -ivh --nodeps perl-DBD-MySQL-4.023-5.el7.src.rpm
Updating / installing...
   1:perl-DBD-MySQL-4.023-5.el7       ################################# [100%]
warning: user mockbuild does not exist - using root
warning: group mockbuild does not exist - using root
warning: user mockbuild does not exist - using root
warning: group mockbuild does not exist - using root

However, the errors must have been enough to not have a legitimate install because I still see a failed dependency:
○ sudo rpm -ivh percona-xtrabackup-24-2.4.6-1.el7.x86_64.rpm
warning: percona-xtrabackup-24-2.4.6-1.el7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
        perl(DBD::mysql) is needed by percona-xtrabackup-24-2.4.6-1.el7.x86_64


Any tips would be much appreciated.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.