MySQL Bugs: #67965: mysql-libs conflicts with MySQL-shared again.

Bug #67965	mysql-libs conflicts with MySQL-shared again.
Submitted:	22 Dec 2012 12:22	Modified:	18 Jan 2013 14:15
Reporter:	Sadao Hiratsuka	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Packaging	Severity:	S3 (Non-critical)
Version:	5.5.29	OS:	Linux (RHEL 6)
Assigned to:	Balasubramanian Kandasamy	CPU Architecture:	Any
Tags:	regression

Description:
RHEL bundled mysql-libs conflicts with MySQL-shared again.

How to repeat:
5.5.28
# rpm -q mysql-libs
mysql-libs-5.1.66-2.el6_3.x86_64
# rpm -U MySQL-shared-compat-5.5.28-1.el6.x86_64.rpm 
# rpm -U MySQL-shared-5.5.28-1.el6.x86_64.rpm 
# rpm -qa | grep -i mysql
MySQL-shared-compat-5.5.28-1.el6.x86_64
MySQL-shared-5.5.28-1.el6.x86_64

5.5.29
# rpm -q mysql-libs
mysql-libs-5.1.66-2.el6_3.x86_64
# rpm -U MySQL-shared-compat-5.5.29-1.el6.x86_64.rpm 
# rpm -U MySQL-shared-5.5.29-1.el6.x86_64.rpm 
error: Failed dependencies:
	mysql-libs conflicts with MySQL-shared-5.5.29-1.el6.x86_64

Suggested fix:
I think 'Conflicts: mysql-libs' is wrong.

mysql.5.5.29.spec
# ----------------------------------------------------------------------------
%package -n MySQL-shared%{product_suffix}
Summary:	MySQL - Shared libraries
Group:		Applications/Databases
Provides:	MySQL-shared
Conflicts:	mysql-libs mysql-libs-advanced

This is easy to verify:

[root@chief tmp]# rpm -U MySQL-shared-5.5.29-1.el6.x86_64.rpm
error: Failed dependencies:
        mysql-libs conflicts with MySQL-shared-5.5.29-1.el6.x86_64
[root@chief tmp]# rpm -q -a | grep -i mysql
mysql-5.1.60-1.fc14.x86_64
mysql-devel-5.1.60-1.fc14.x86_64
mysql-libs-5.1.60-1.fc14.x86_64

I wonder what this report is waiting for...

To upgrade to 5.5.29, kindly follow the below steps. 

1) Read the manual and check whether the schema etc is compatible with 5.5 
2) Uninstall ("rpm -e") "mysql-*" (RedHat) RPMs,this will break the "postfix" 
requirement, so stop postfix and use "rpm -e --force". 
3) Install ("rpm -i") our "MySQL-*" ones, including "shared-compat", this 
will satisfy the "postfix" requirement, 
4) Start the server (or reboot the machine, our RPMs configure autostart), 
5) Start "postfix". 

Our RPMs (both traditional and ULN ones) prevent a cross-series "rpm -U" 
(say, 5.1 -> 5.5) in the spec file, intentionally. 

As of MySQL 5.5.23, the MySQL-shared-compat RPM package enables 
users of Red Hat-provided mysql-*-5.1 RPM packages to migrate to 
Oracle-provided MySQL-*-5.5 packages. MySQL-shared-compat replaces 
the Red Hat mysql-libs package by replacing libmysqlclient.so files 
of the latter package, thus satisfying dependencies of other 
packages on mysql-libs. This change affects only users of Red Hat 
(or Red Hat-compatible) RPM packages. Nothing is different for users 
of Oracle RPM packages. 

Please refer to below documentation for more information 

http://dev.mysql.com/doc/refman/5.5/en/linux-installation-rpm.html

Bug#68018 was marked as a duplicate.

Why people should use some other procedure instead of simple rpm -U? Here we have a workaround documented, but why not to fix the problem?

This is indeed a bug : setting to Verified. See interesting comments in the duplicate.

Hi,

Fix has been uploaded to dev.mysql and MyOracleSupport now.

Thanks,
Bala

Noted in 5.5.29 changelog.

RHEL RPM packages had a conflict between mysql-libs and mysql-shared.