Percona-Server-shared-51 obsoletes mysql-libs but doesn't include my.cnf

[Tomislav Plavcic]

Percona-Server-shared-51 obsoletes mysql-libs but doesn't include my.cnf which if you do yum update/upgrade leads to that you don't have any my.cnf on the system.

Steps to reproduce:
System: centos6

1. yum upgrade (probably not needed as first step)

STATUS BEFORE PXC/PS INSTALL:
[vagrant@t-centos6-64 ~]$ sudo ls /etc/my.cnf
/etc/my.cnf

[vagrant@t-centos6-64 ~]$ sudo yum list installed|egrep "Percona|mysql"
mysql-libs.x86_64 5.1.73-5.el6_6 @base

2. install percona repository

3. sudo yum install Percona-XtraDB-Cluster-server-56
(I tried with PS 5.6 also and it's the same)

Dependencies Resolved

=======================================================================================================================================================================================================================================
 Package Arch Version Repository Size
=======================================================================================================================================================================================================================================
Installing:
 Percona-XtraDB-Cluster-server-56 x86_64 1:5.6.24-25.11.1.el6 percona-release-x86_64 19 M
Installing for dependencies:
 Percona-XtraDB-Cluster-client-56 x86_64 1:5.6.24-25.11.1.el6 percona-release-x86_64 6.1 M
 Percona-XtraDB-Cluster-galera-3 x86_64 3.11-1.rhel6 percona-release-x86_64 817 k
 Percona-XtraDB-Cluster-shared-56 x86_64 1:5.6.24-25.11.1.el6 percona-release-x86_64 684 k
 percona-xtrabackup x86_64 2.2.12-1.el6 percona-release-x86_64 4.8 M
 perl-DBD-MySQL x86_64 4.013-3.el6 base 134 k
 perl-DBI x86_64 1.609-4.el6 base 705 k
 perl-Time-HiRes x86_64 4:1.9721-141.el6 base 49 k
 socat x86_64 1.7.2.3-1.el6 epel 246 k

Transaction Summary
=======================================================================================================================================================================================================================================

AFTER INSTALL:
[vagrant@t-centos6-64 ~]$ sudo ls /etc/my.cnf
/etc/my.cnf

[vagrant@t-centos6-64 ~]$ sudo yum list installed|egrep "Percona|mysql"
Percona-XtraDB-Cluster-client-56.x86_64
Percona-XtraDB-Cluster-galera-3.x86_64
Percona-XtraDB-Cluster-server-56.x86_64
Percona-XtraDB-Cluster-shared-56.x86_64
mysql-libs.x86_64 5.1.73-5.el6_6 @base

4. yum upgrade
--> Running transaction check
---> Package Percona-Server-shared-51.x86_64 0:5.1.73-rel14.12.624.rhel6 will be obsoleting
---> Package mysql-libs.x86_64 0:5.1.73-5.el6_6 will be obsoleted
--> Finished Dependency Resolution

[vagrant@t-centos6-64 ~]$ sudo ls /etc/my.cnf
ls: cannot access /etc/my.cnf: No such file or directory
(and it's not anywhere else - in case you modified it/had your custom it gets saved into /etc/my.cnf.rpmsave on yum upgrade)

[vagrant@t-centos6-64 ~]$ sudo yum list installed|egrep "Percona|mysql"
Percona-Server-shared-51.x86_64 5.1.73-rel14.12.624.rhel6 @percona-release-x86_64
Percona-XtraDB-Cluster-client-56.x86_64
Percona-XtraDB-Cluster-galera-3.x86_64
Percona-XtraDB-Cluster-server-56.x86_64
Percona-XtraDB-Cluster-shared-56.x86_64

And seems you are left without a working my.cnf file.

[Tomislav Plavcic (tplavcic)]

From what I see there are two solutions for this:
- rebuild Percona-Server-shared-51 to NOT obsolete mysql-libs
- remove PS 5.1 from repository (not sure how much is it used anyway)
But I might be missing something here - some info from past why was this done.
Also not sure how was this not noticed before.

[John Beranek (john-redux)]

I raised this bug through Percona Support, so I'll add a reply to comment #1.

Percona-Server-shared-51 is required so that all the tools that RHEL/CentOS 6 build against /usr/lib64/libmysqlclient.so.16.0.0 will continue working.

[Tomislav Plavcic (tplavcic)]

@John: for that we will leave the system mysql-libs installed.
Decided in the end we'll not remove the PS 5.1 but just make a small change to that Percona-Server-shared-51 to not obsolete mysql-libs but just make a conflict so that they cannot be installed at the same time.
That package was automatically installing because of that Obsolete clause.
I have pushed that package in our testing repository (centos 6 only) and if there will be no problems will push it into release repo early next week.

Some checking:
#1: yum upgrade with just testing repo enabled
It doesn't offer to replace mysql-libs with 5.1 shared package any more.

[vagrant@t-centos6-64 ~]$ sudo yum upgrade
Loaded plugins: fastestmirror, security
Setting up Upgrade Process
Loading mirror speeds from cached hostfile
 * base: mirror.met.hu
 * extras: mirror.met.hu
 * updates: mirror.met.hu
No Packages marked for Update

[vagrant@t-centos6-64 ~]$ sudo yum list installed|grep mysql
mysql-libs.x86_64 5.1.73-5.el6_6 @base

[vagrant@t-centos6-64 ~]$ ls /etc/my.cnf
/etc/my.cnf

#2: install Percona-Server-server-56 and try upgrade after

[vagrant@t-centos6-64 ~]$ sudo yum install Percona-Server-server-56
Loaded plugins: fastestmirror, security
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: mirror.met.hu
 * extras: mirror.met.hu
 * updates: mirror.met.hu
Resolving Dependencies
--> Running transaction check
---> Package Percona-Server-server-56.x86_64 0:5.6.26-rel74.0.el6 will be installed
--> Processing Dependency: Percona-Server-client-56 for package: Percona-Server-server-56-5.6.26-rel74.0.el6.x86_64
--> Processing Dependency: Percona-Server-shared-56 for package: Percona-Server-server-56-5.6.26-rel74.0.el6.x86_64
--> Running transaction check
---> Package Percona-Server-client-56.x86_64 0:5.6.26-rel74.0.el6 will be installed
---> Package Percona-Server-shared-56.x86_64 0:5.6.26-rel74.0.el6 will be installed
--> Finished Dependency Resolution

[vagrant@t-centos6-64 ~]$ sudo yum list installed|egrep "mysql|Percona"
Percona-Server-client-56.x86_64 5.6.26-rel74.0.el6 @percona-testing-x86_64
Percona-Server-server-56.x86_64 5.6.26-rel74.0.el6 @percona-testing-x86_64
Percona-Server-shared-56.x86_64 5.6.26-rel74.0.el6 @percona-testing-x86_64
mysql-libs.x86_64 5.1.73-5.el6_6 @base

[vagrant@t-centos6-64 ~]$ ls /etc/my.cnf
/etc/my.cnf

[vagrant@t-centos6-64 ~]$ sudo yum upgrade
Loaded plugins: fastestmirror, security
Setting up Upgrade Process
Loading mirror speeds from cached hostfile
 * base: ftp.freepark.org
 * extras: ftp.freepark.org
 * updates: ftp.freepark.org
No Packages marked for Update

[Alexey Bychko (abychko)]

Great work, thanks. is it just an empty package now?

--
Alexey Bychko
Lead Release Manager, Percona (GMT +6)
skype: percona.abychko
email: <email address hidden>
https://www.percona.com/services/mysql-consulting

On 24 сентября 2015 г. at 19:31:06, Tomislav Plavcic (<email address hidden>) wrote:

@John: for that we will leave the system mysql-libs installed.
Decided in the end we'll not remove the PS 5.1 but just make a small change to that Percona-Server-shared-51 to not obsolete mysql-libs but just make a conflict so that they cannot be installed at the same time.
That package was automatically installing because of that Obsolete clause.
I have pushed that package in our testing repository (centos 6 only) and if there will be no problems will push it into release repo early next week.

Some checking:
#1: yum upgrade with just testing repo enabled
It doesn't offer to replace mysql-libs with 5.1 shared package any more.

[vagrant@t-centos6-64 ~]$ sudo yum upgrade
Loaded plugins: fastestmirror, security
Setting up Upgrade Process
Loading mirror speeds from cached hostfile
* base: mirror.met.hu
* extras: mirror.met.hu
* updates: mirror.met.hu
No Packages marked for Update

[vagrant@t-centos6-64 ~]$ sudo yum list installed|grep mysql
mysql-libs.x86_64 5.1.73-5.el6_6 @base

[vagrant@t-centos6-64 ~]$ ls /etc/my.cnf
/etc/my.cnf

#2: install Percona-Server-server-56 and try upgrade after

[vagrant@t-centos6-64 ~]$ sudo yum install Percona-Server-server-56
Loaded plugins: fastestmirror, security
Setting up Install Process
Loading mirror speeds from cached hostfile
* base: mirror.met.hu
* extras: mirror.met.hu
* updates: mirror.met.hu
Resolving Dependencies
--> Running transaction check
---> Package Percona-Server-server-56.x86_64 0:5.6.26-rel74.0.el6 will be installed
--> Processing Dependency: Percona-Server-client-56 for package: Percona-Server-server-56-5.6.26-rel74.0.el6.x86_64
--> Processing Dependency: Percona-Server-shared-56 for package: Percona-Server-server-56-5.6.26-rel74.0.el6.x86_64
--> Running transaction check
---> Package Percona-Server-client-56.x86_64 0:5.6.26-rel74.0.el6 will be installed
---> Package Percona-Server-shared-56.x86_64 0:5.6.26-rel74.0.el6 will be installed
--> Finished Dependency Resolution

[vagrant@t-centos6-64 ~]$ sudo yum list installed|egrep "mysql|Percona"
Percona-Server-client-56.x86_64 5.6.26-rel74.0.el6 @percona-testing-x86_64
Percona-Server-server-56.x86_64 5.6.26-rel74.0.el6 @percona-testing-x86_64
Percona-Server-shared-56.x86_64 5.6.26-rel74.0.el6 @percona-testing-x86_64
mysql-libs.x86_64 5.1.73-5.el6_6 @base

[vagrant@t-centos6-64 ~]$ ls /etc/my.cnf
/etc/my.cnf

[vagrant@t-centos6-64 ~]$ sudo yum upgrade
Loaded plugins: fastestmirror, security
Setting up Upgrade Process
Loading mirror speeds from cached hostfile
* base: ftp.freepark.org
* extras: ftp.freepark.org
* updates: ftp.freepark.org
No Packages marked for Update

** Changed in: percona-server/5.1
Status: Confirmed => Fix Committed

** Changed in: percona-xtradb-cluster/5.6
Status: Confirmed => Fix Committed

--
You received...

[Tomislav Plavcic (tplavcic)]

No, it includes the shared library but it it has a conflict with mysql-libs
(previously it had obsoletes) - so it will not be used if you install
5.5/5.6 or just do regular system upgrades with our repository.
It can be used for PS 5.1 but then you have to remove mysql-libs yourself.

On Fri, Sep 25, 2015 at 8:06 AM, Alexey Bychko <email address hidden>
wrote:

> Great work, thanks. is it just an empty package now?
>
> --
> Alexey Bychko
> Lead Release Manager, Percona (GMT +6)
> skype: percona.abychko
> email: <email address hidden>
> https://www.percona.com/services/mysql-consulting
>
> On 24 сентября 2015 г. at 19:31:06, Tomislav Plavcic
> (<email address hidden>) wrote:
>
> @John: for that we will leave the system mysql-libs installed.
> Decided in the end we'll not remove the PS 5.1 but just make a small
> change to that Percona-Server-shared-51 to not obsolete mysql-libs but just
> make a conflict so that they cannot be installed at the same time.
> That package was automatically installing because of that Obsolete clause.
> I have pushed that package in our testing repository (centos 6 only) and
> if there will be no problems will push it into release repo early next week.
>
> Some checking:
> #1: yum upgrade with just testing repo enabled
> It doesn't offer to replace mysql-libs with 5.1 shared package any more.
>
> [vagrant@t-centos6-64 ~]$ sudo yum upgrade
> Loaded plugins: fastestmirror, security
> Setting up Upgrade Process
> Loading mirror speeds from cached hostfile
> * base: mirror.met.hu
> * extras: mirror.met.hu
> * updates: mirror.met.hu
> No Packages marked for Update
>
> [vagrant@t-centos6-64 ~]$ sudo yum list installed|grep mysql
> mysql-libs.x86_64 5.1.73-5.el6_6 @base
>
> [vagrant@t-centos6-64 ~]$ ls /etc/my.cnf
> /etc/my.cnf
>
> #2: install Percona-Server-server-56 and try upgrade after
>
> [vagrant@t-centos6-64 ~]$ sudo yum install Percona-Server-server-56
> Loaded plugins: fastestmirror, security
> Setting up Install Process
> Loading mirror speeds from cached hostfile
> * base: mirror.met.hu
> * extras: mirror.met.hu
> * updates: mirror.met.hu
> Resolving Dependencies
> --> Running transaction check
> ---> Package Percona-Server-server-56.x86_64 0:5.6.26-rel74.0.el6 will be
> installed
> --> Processing Dependency: Percona-Server-client-56 for package:
> Percona-Server-server-56-5.6.26-rel74.0.el6.x86_64
> --> Processing Dependency: Percona-Server-shared-56 for package:
> Percona-Server-server-56-5.6.26-rel74.0.el6.x86_64
> --> Running transaction check
> ---> Package Percona-Server-client-56.x86_64 0:5.6.26-rel74.0.el6 will be
> installed
> ---> Package Percona-Server-shared-56.x86_64 0:5.6.26-rel74.0.el6 will be
> installed
> --> Finished Dependency Resolution
>
> [vagrant@t-centos6-64 ~]$ sudo yum list installed|egrep "mysql|Percona"
> Percona-Server-client-56.x86_64 5.6.26-rel74.0.el6 @percona-testing-x86_64
> Percona-Server-server-56.x86_64 5.6.26-rel74.0.el6 @percona-testing-x86_64
> Percona-Server-shared-56.x86_64 5.6.26-rel74.0.el6 @percona-testing-x86_64
> mysql-libs.x86_64 5.1.73-5.el6_6 @base
>
> [vagrant@t-centos6-64 ~]$ ls /etc/my.cnf
> /etc/my.cnf
>
> [vagrant@t-centos6-64 ~]$ sudo yum upg...

[Alexey Bychko (abychko)]

Ok, thanks

--
Alexey Bychko
Lead Release Manager, Percona (GMT +6)
skype: percona.abychko
email: <email address hidden>
https://www.percona.com/services/mysql-consulting

On 25 сентября 2015 г. at 12:30:55, Tomislav Plavcic (<email address hidden>) wrote:

No, it includes the shared library but it it has a conflict with mysql-libs
(previously it had obsoletes) - so it will not be used if you install
5.5/5.6 or just do regular system upgrades with our repository.
It can be used for PS 5.1 but then you have to remove mysql-libs yourself.

On Fri, Sep 25, 2015 at 8:06 AM, Alexey Bychko <email address hidden>
wrote:

> Great work, thanks. is it just an empty package now?
>
> --
> Alexey Bychko
> Lead Release Manager, Percona (GMT +6)
> skype: percona.abychko
> email: <email address hidden>
> https://www.percona.com/services/mysql-consulting
>
> On 24 сентября 2015 г. at 19:31:06, Tomislav Plavcic
> (<email address hidden>) wrote:
>
> @John: for that we will leave the system mysql-libs installed.
> Decided in the end we'll not remove the PS 5.1 but just make a small
> change to that Percona-Server-shared-51 to not obsolete mysql-libs but just
> make a conflict so that they cannot be installed at the same time.
> That package was automatically installing because of that Obsolete clause.
> I have pushed that package in our testing repository (centos 6 only) and
> if there will be no problems will push it into release repo early next week.
>
> Some checking:
> #1: yum upgrade with just testing repo enabled
> It doesn't offer to replace mysql-libs with 5.1 shared package any more.
>
> [vagrant@t-centos6-64 ~]$ sudo yum upgrade
> Loaded plugins: fastestmirror, security
> Setting up Upgrade Process
> Loading mirror speeds from cached hostfile
> * base: mirror.met.hu
> * extras: mirror.met.hu
> * updates: mirror.met.hu
> No Packages marked for Update
>
> [vagrant@t-centos6-64 ~]$ sudo yum list installed|grep mysql
> mysql-libs.x86_64 5.1.73-5.el6_6 @base
>
> [vagrant@t-centos6-64 ~]$ ls /etc/my.cnf
> /etc/my.cnf
>
> #2: install Percona-Server-server-56 and try upgrade after
>
> [vagrant@t-centos6-64 ~]$ sudo yum install Percona-Server-server-56
> Loaded plugins: fastestmirror, security
> Setting up Install Process
> Loading mirror speeds from cached hostfile
> * base: mirror.met.hu
> * extras: mirror.met.hu
> * updates: mirror.met.hu
> Resolving Dependencies
> --> Running transaction check
> ---> Package Percona-Server-server-56.x86_64 0:5.6.26-rel74.0.el6 will be
> installed
> --> Processing Dependency: Percona-Server-client-56 for package:
> Percona-Server-server-56-5.6.26-rel74.0.el6.x86_64
> --> Processing Dependency: Percona-Server-shared-56 for package:
> Percona-Server-server-56-5.6.26-rel74.0.el6.x86_64
> --> Running transaction check
> ---> Package Percona-Server-client-56.x86_64 0:5.6.26-rel74.0.el6 will be
> installed
> ---> Package Percona-Server-shared-56.x86_64 0:5.6.26-rel74.0.el6 will be
> installed
> --> Finished Dependency Resolution
>
> [vagrant@t-centos6-64 ~]$ sudo yum list...

[Tomislav Plavcic (tplavcic)]

It's pushed into release repository.

[Tomislav Plavcic (tplavcic)]

I'm reopening this because of: https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1503584

[Tomislav Plavcic (tplavcic)]

The -shared-51 package is created with my.cnf included and it's currently in testing repo.
The testing looks good, PS and PXC install normally and if we have custom my.cnf it doesn't get replaced.
Will push the package into main repository and change the bug status when it happens.

[Frank Grötzner (groetzner)]

I just reported bug https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1555684, which my be related to this one.
Is there any progress on this one?

[Shahriyar Rzayev (rzayev-sehriyar)]

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

[Shahriyar Rzayev (rzayev-sehriyar)]

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