Percona Server moved to https://jira.percona.com/projects/PS

Provide Percona-Server-shared-compat for 51 or common shared-compat for 51/55

Bug #893860 reported by Jaime Sicam
48
This bug affects 7 people
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Invalid
High
Unassigned
5.1
Fix Released
High
Ignacio Nin
Percona Server moved to https://jira.percona.com/projects/PS 5.1.69-14.7
5.5
Invalid
High
Unassigned
5.6
Invalid
High
Unassigned

Bug Description

Almost every RPM in the respository have 5.1 or 5.5 as parts of its RPM name except for:
Percona-Server-shared-compat.x86_64
Percona-SQL-shared-compat.x86_64

[root@centos5 ~]# yum search percona
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.web.com.ph
 * epel: mirror01.idc.hinet.net
 * extras: mirror.web.com.ph
 * ius: mirror.rackspace.hk
 * updates: mirror.web.com.ph
================================== Matched: percona ===================================
Percona-SQL-50-debuginfo.x86_64 : Debug information for package Percona-SQL-50
Percona-SQL-client-50.x86_64 : Percona SQL - Client
Percona-SQL-devel-50.x86_64 : Percona-SQL - Development header files and libraries
Percona-SQL-server-50.x86_64 : Percona-SQL Community Server (GPL) for Red Hat
                             : Enterprise Linux 5
Percona-SQL-shared-50.x86_64 : Percona-SQL - Shared libraries

Percona-SQL-shared-compat.x86_64 : MySQL shared client libraries for MySQL 5.0.92,
                                 : 5.0.92, 4.1.22 and 4.0.27

Percona-SQL-test-50.x86_64 : Percona-SQL - Test suite
Percona-Server-51-debuginfo.x86_64 : Debug information for package Percona-Server-51
Percona-Server-55-debuginfo.x86_64 : Debug information for package Percona-Server-55
Percona-Server-client-51.x86_64 : Percona-Server - Client
Percona-Server-client-55.x86_64 : Percona Server - Client
Percona-Server-devel-51.x86_64 : Percona-Server - Development header files and
                               : libraries
Percona-Server-devel-55.x86_64 : Percona Server - Development header files and
                               : libraries
Percona-Server-server-51.x86_64 : Percona Server (GPL), 12.8, Revision 233 for Red Hat
                                : Enterprise Linux 5
Percona-Server-server-55.x86_64 : Percona Server: a very fast and reliable SQL database
                                : server
Percona-Server-shared-51.x86_64 : Percona-Server - Shared libraries
Percona-Server-shared-55.x86_64 : Percona Server - Shared libraries

Percona-Server-shared-compat.x86_64 : MySQL shared client libraries for MySQL 5.5.8,
                                    : 5.0.91, 4.1.22 and 4.0.27

Percona-Server-test-51.x86_64 : Percona-Server - Test suite
Percona-Server-test-55.x86_64 : Percona Server - Test suite
holland-xtrabackup.noarch : Xtrabackup plugin for Holland
percona-release.x86_64 : Percona RPM repository
percona-toolkit.noarch : Advanced MySQL and system command-line tools
xtrabackup.x86_64 : XtraBackup online backup for MySQL / InnoDB
xtrabackup-debuginfo.x86_64 : Debug information for package xtrabackup

On my testbed, I only have Percona Server 5.1 installed:
[root@centos5 ~]# rpm -qa|grep Percona
Percona-Server-client-51-5.1.59-rel13.0.325.rhel5
Percona-Server-shared-51-5.1.59-rel13.0.325.rhel5
Percona-Server-devel-51-5.1.59-rel13.0.325.rhel5
Percona-Server-server-51-5.1.59-rel13.0.325.rhel5

When I try to install Percona-Server-shared-compat.x86_64, it prompts me to install the 5.5 version:

[root@centos5 ~]# yum install Percona-Server-shared-compat.x86_64
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.web.com.ph
 * epel: mirror01.idc.hinet.net
 * extras: mirror.web.com.ph
 * ius: mirror.rackspace.hk
 * updates: mirror.web.com.ph
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package Percona-Server-shared-compat.x86_64 0:5.5.17-rel22.1.197.rhel5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=======================================================================================
 Package Arch Version Repository
                                                                                  Size
=======================================================================================
Installing:
 Percona-Server-shared-compat x86_64 5.5.17-rel22.1.197.rhel5 percona 5.0 M

Transaction Summary
=======================================================================================
Install 1 Package(s)
Upgrade 0 Package(s)

Total download size: 5.0 M
Is this ok [y/N]: N
Exiting on user Command
Complete!

Tags: pkg

Related branches

lp:~ignacio-nin/percona-server/5.1-bug893860
Laurynas Biveinis (community): Approve
Diff: 46 lines (+9/-7)
1 file modified
build/percona-shared-compat.spec (+9/-7)
Stewart Smith (stewart)
Changed in percona-server:
importance: Undecided → High
tags: added: pkg
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

Percona-Server-shared-compat is meant to be used only by Percona Server 55

However, compat libraries are required on Percona Server 5.1 then Percona-SQL-shared-compat is the only way to go since installing Percona-Server-shared-compat will conflict with Percona-Servers-shared-51

yum install 'Percona-Server-shared-compat'

Dependencies Resolved

=========================================================================================================================================
 Package Arch Version Repository Size
=========================================================================================================================================
Installing:
 Percona-Server-shared-compat x86_64 5.5.27-rel28.1.296.rhel6 percona 3.8 M

Transaction Summary
=========================================================================================================================================
Install 1 Package(s)

Total size: 3.8 M
Installed size: 11 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test

Transaction Check Error:
  file /usr/lib64/libmysqlclient.so.16.0.0 from install of Percona-Server-shared-compat-5.5.27-rel28.1.296.rhel6.x86_64 conflicts with file from package Percona-Server-shared-51-5.1.65-rel14.0.475.rhel6.x86_64
  file /usr/lib64/libmysqlclient_r.so.16.0.0 from install of Percona-Server-shared-compat-5.5.27-rel28.1.296.rhel6.x86_64 conflicts with file from package Percona-Server-shared-51-5.1.65-rel14.0.475.rhel6.x86_64

rpm -ql Percona-SQL-shared-compat
/usr/lib64/libmysqlclient.so.12
/usr/lib64/libmysqlclient.so.12.0.0
/usr/lib64/libmysqlclient.so.14
/usr/lib64/libmysqlclient.so.14.0.0
/usr/lib64/libmysqlclient_r.so.12
/usr/lib64/libmysqlclient_r.so.12.0.0
/usr/lib64/libmysqlclient_r.so.14
/usr/lib64/libmysqlclient_r.so.14.0.0

However, this leaves

/usr/lib64/libmysqlclient.so.15
/usr/lib64/libmysqlclient.so.15.0.0
/usr/lib64/libmysqlclient_r.so.15
/usr/lib64/libmysqlclient_r.so.15.0.0

unavailable if Percona-Server-shared-51 is installed.

So, a Percona-Server-shared-compat-51 for 5.1 needs to be created with:

/usr/lib64/libmysqlclient.so.12
/usr/lib64/libmysqlclient.so.12.0.0
/usr/lib64/libmysqlclient.so.14
/usr/lib64/libmysqlclient.so.14.0.0
/usr/lib64/libmysqlclient.so.15
/usr/lib64/libmysqlclient.so.15.0.0
/usr/lib64/libmysqlclient_r.so.12
/usr/lib64/libmysqlclient_r.so.12.0.0
/usr/lib64/libmysqlclient_r.so.14
/usr/lib64/libmysqlclient_r.so.14.0.0
/usr/lib64/libmysqlclient_r.so.15
/usr/lib64/libmysqlclient_r.so.15.0.0

Changed in percona-server:
status: New → Invalid
Raghavendra D Prabhu (raghavendra-prabhu)
summary: - yum install Percona-Server-shared-compat.x86_64 will install 5.5 version
- even if you have 5.1 rpms installed
+ Provide Percona-Server-shared-compat for 51 or common shared-compat for
+ 51/55
Revision history for this message
zigi (ziegleka) wrote :

Hi,

 Why not build for each libmysqlclient separate package, something like:

  Percona-libmysql-12
  Percona-libmysql-14
  Percona-libmysql-15
  Percona-libmysql-16
  Percona-libmysql-18

 User can then choose, which to install.

Revision history for this message
zigi (ziegleka) wrote :

see https://bugs.launchpad.net/percona-server/+bug/1118484

Revision history for this message
Innocenzo Giminiani (innocenzogiminiani) wrote :

Hi,try:

1) Download mysql-community-libs-compat from mysql (https://dev.mysql.com/downloads/mysql/)
rpm -i mysql-community-libs-compat-5.7.17-1.el7.x86_64.rpm

2) Install perl-DBD-MySQL
yum install perl-DBD-MySQL

3) Install percona-xtrabackup
yum install percona-xtrabackup

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-515

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.