Hi all
I’m having some issues with what appears to be a clash of libraries.
When initially attempting to install XtraBackup on RHEL 6.4 (MySQL 5.1), I followed the instructions for the xtrabackup 2.1 install, and added the Percona repo to yum.
[percona]
name = CentOS $releasever - Percona
baseurl=http://repo.percona.com/centos/$releasever/os/$basearch/
enabled = 1
gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-percona
gpgcheck = 1
This wouldn’t work so I went with the 2.0 manual install:
sudo rpm -ivh percona-xtrabackup-2.0.7-552.rhel6.x86_64.rpm
I left the Percona repo active.
I also installed percona-nagios-plugins along the way.
Then I did a
yum --security update-minimal
This gave the output:
Packages Altered:
Obsoleting Percona-Server-shared-56-5.6.15-rel63.0.519.rhel6.x86_64 @percona
Obsoleting Percona-Server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64 @percona
Updated mysql-5.1.69-1.el6_4.x86_64 @rhel-x86_64-server-6
Update 5.1.73-3.el6_5.x86_64 @rhel-x86_64-server-6
Obsoleted mysql-libs-5.1.69-1.el6_4.x86_64 @rhel-x86_64-server-6
Updated mysql-server-5.1.69-1.el6_4.x86_64 @rhel-x86_64-server-6
Update 5.1.73-3.el6_5.x86_64 @rhel-x86_64-server-6Scriptlet output:
2 warning: /etc/my.cnf saved as /etc/my.cnf.rpmsave
When I restarted the server, MySQL refused to start.
I get the following in the logs:
140410 18:42:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140410 18:42:17 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys'
140410 18:42:17 InnoDB: Initializing buffer pool, size = 8.0M
140410 18:42:17 InnoDB: Completed initialization of buffer pool
140410 18:42:17 InnoDB: Started; log sequence number 9 1165654261
140410 18:42:17 [ERROR] Aborting
140410 18:42:17 InnoDB: Starting shutdown...
140410 18:42:22 InnoDB: Shutdown completed; log sequence number 9 1165654261
I have successfully removed Percona-Server-shared-56-5.6.15-rel63.0.519.rhel6.x86_64 but when I try to remove Percona-Server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64, i get:
yum remove Percona-Server-shared-compat-5.5.35-rel33.0.611.rhel6.x86_64
Loaded plugins: product-id, rhnplugin, security, subscription-manager
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package Percona-Server-shared-compat.x86_64 0:5.5.35-rel33.0.611.rhel6 will be erased
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: nagios-plugins-mysql-1.4.16-10.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: mysql-5.1.73-3.el6_5.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: mysql-server-5.1.73-3.el6_5.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: nagios-plugins-mysql-1.4.16-10.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: mysql-5.1.73-3.el6_5.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: mysql-server-5.1.73-3.el6_5.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient_r.so.16()(64bit) for package: mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
--> Processing Dependency: libmysqlclient_r.so.16()(64bit) for package: mysql-5.1.73-3.el6_5.x86_64
--> Processing Dependency: libmysqlclient_r.so.16()(64bit) for package: mysql-server-5.1.73-3.el6_5.x86_64
--> Processing Dependency: libmysqlclient_r.so.16()(64bit) for package: MySQL-python-1.2.3-0.3.c1.1.el6.x86_64
--> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16)(64bit) for package: mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
--> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16)(64bit) for package: mysql-5.1.73-3.el6_5.x86_64
--> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16)(64bit) for package: mysql-server-5.1.73-3.el6_5.x86_64
--> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16)(64bit) for package: MySQL-python-1.2.3-0.3.c1.1.el6.x86_64
--> Processing Dependency: mysql-libs = 5.1.73-3.el6_5 for package: mysql-5.1.73-3.el6_5.x86_64
--> Processing Dependency: mysql-libs for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Running transaction check
---> Package MySQL-python.x86_64 0:1.2.3-0.3.c1.1.el6 will be erased
---> Package mysql.x86_64 0:5.1.73-3.el6_5 will be erased
---> Package mysql-connector-odbc.x86_64 0:5.1.5r1144-7.el6 will be erased
---> Package mysql-server.x86_64 0:5.1.73-3.el6_5 will be erased
---> Package nagios-plugins-mysql.x86_64 0:1.4.16-10.el6 will be erased
--> Processing Dependency: nagios-plugins-mysql for package: nagios-plugins-all-1.4.16-5.el6.x86_64
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be erased
---> Package postfix.x86_64 2:2.6.6-6.el6_5 will be erased
--> Processing Dependency: /usr/bin/mailq for package: nagios-plugins-mailq-1.4.16-10.el6.x86_64
--> Processing Dependency: /usr/sbin/sendmail for package: cronie-1.4.4-7.el6.x86_64
--> Running transaction check
---> Package cronie.x86_64 0:1.4.4-7.el6 will be erased
--> Processing Dependency: cronie = 1.4.4-7.el6 for package: cronie-anacron-1.4.4-7.el6.x86_64
---> Package nagios-plugins-all.x86_64 0:1.4.16-5.el6 will be erased
---> Package nagios-plugins-mailq.x86_64 0:1.4.16-10.el6 will be erased
--> Running transaction check
---> Package cronie-anacron.x86_64 0:1.4.4-7.el6 will be erased
--> Processing Dependency: /etc/cron.d for package: crontabs-1.10-33.el6.noarch
--> Processing Dependency: /etc/cron.d for package: sysstat-9.0.4-20.el6.x86_64
--> Processing Dependency: /usr/bin/mysql for package: percona-xtrabackup-2.0.7-552.rhel6.x86_64
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package crontabs.noarch 0:1.10-33.el6 will be erased
---> Package percona-xtrabackup.x86_64 0:2.0.7-552.rhel6 will be erased
---> Package sysstat.x86_64 0:9.0.4-20.el6 will be erased
--> Finished Dependency Resolution
Dependencies Resolved
Removing:
Percona-Server-shared-compat x86_64 5.5.35-rel33.0.611.rhel6 @percona 9.8 M
Removing for dependencies:
MySQL-python x86_64 1.2.3-0.3.c1.1.el6 @rhel-x86_64-server-6 246 k
...
mysql-connector-odbc x86_64 5.1.5r1144-7.el6 @rhel-x86_64-server-6 345 k
mysql-server x86_64 5.1.73-3.el6_5 @rhel-x86_64-server-6 25 M
nagios-plugins-all x86_64 1.4.16-5.el6 @epel 0.0
nagios-plugins-mailq x86_64 1.4.16-10.el6 @epel 20 k
nagios-plugins-mysql x86_64 1.4.16-10.el6 @epel 100 k
percona-xtrabackup x86_64 2.0.7-552.rhel6 installed 22 M
perl-DBD-MySQL x86_64 4.013-3.el6 @rhel-x86_64-server-6 338 k
...
This is a production database, now running from a master/master/ passive failover which has the same updates applied but has not been restarted. So it’s a very precarious position I find myself in!
I’ve seen a few posts around (particularly wrt ‘errmsg.sys’ err) but none with definitive solution for this scenario.
So I guess my question is basically what kind of options do I have?
Can I get @RHEL MySQL 5.1 libraries back?
And keep all the data?
And bring the primary master back up to receive replication data?
Or is an upgrade the only way to go?
Thanks
Caoimh.