Announcement

Announcement Module
Collapse
No announcement yet.

yum update -- RHEL 6.4 MySQL 5.1 vs Percona-Server-shared-56

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • yum update -- RHEL 6.4 MySQL 5.1 vs Percona-Server-shared-56

    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.
    Code:
     [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:
    Code:
     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
    Code:
    yum --security update-minimal
    This gave the output:
    Code:
     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:

    Code:
     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:

    Code:
      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.
Working...
X