# trouble installing p-t after MySQL 5.6-\>5.7 upgrade

**URL:** <https://forums.percona.com/t/trouble-installing-p-t-after-mysql-5-6-5-7-upgrade/5805>\
**Category:** Percona Toolkit\
**Created:** [August 10, 2017, 2:09pm UTC](https://forums.percona.com/t/trouble-installing-p-t-after-mysql-5-6-5-7-upgrade/5805 "2017-08-10T14:09:03Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![pblazek](https://avatars.discourse-cdn.com/v4/letter/p/f08c70/32.png) [@pblazek](https://forums.percona.com/u/pblazek)\
**Post date:** [August 10, 2017, 2:09pm UTC](https://forums.percona.com/t/trouble-installing-p-t-after-mysql-5-6-5-7-upgrade/5805/1 "2017-08-10T14:09:03Z")

</div>

I am trying to upgrade MySQL from 5.6 to 5.7 using the yum repository. During my first attempt there was a conflict of dependencies, so I did

yum remove perl-DBD-MySQL

which also removed percona-toolkit. After seeing the upgrade succeed and MySQL restart successfully, I tried to reinstall percona-toolkit. Here are the results:

yum install percona-toolkit  
Loaded plugins: fastestmirror, langpacks  
Loading mirror speeds from cached hostfile

- base: [mirror.solarvps.com](http://mirror.solarvps.com)
- epel: [mirror.cogentco.com](http://mirror.cogentco.com)
- extras: [mirror.beyondhosting.net](http://mirror.beyondhosting.net)
- updates: [repo1.dal.innoscale.net](http://repo1.dal.innoscale.net)  
Resolving Dependencies  
 → Running transaction check  
—\> Package percona-toolkit.x86\_64 0:3.0.4-1.el7 will be installed  
 → Processing Dependency: perl(DBD::mysql) \>= 1.0 for package: percona-toolkit-3.0.4-1.el7.x86\_64  
 → Running transaction check  
—\> Package perl-DBD-MySQL.x86\_64 0:4.023-5.el7 will be installed  
 → Processing Dependency: libmysqlclient.so.18(libmysqlclient\_18)(64bit) for package: perl-DBD-MySQL-4.023-5.el7.x86\_64  
 → Processing Dependency: libmysqlclient.so.18()(64bit) for package: perl-DBD-MySQL-4.023-5.el7.x86\_64  
 → Running transaction check  
—\> Package Percona-Server-shared-56.x86\_64 0:5.6.36-rel82.1.el7 will be installed  
 → Finished Dependency Resolution

Dependencies Resolved

# ========================================================================================================================= Package Arch Version Repository Size

Installing:  
percona-toolkit x86\_64 3.0.4-1.el7 percona-release-x86\_64 4.8 M  
Installing for dependencies:  
Percona-Server-shared-56 x86\_64 5.6.36-rel82.1.el7 percona-release-x86\_64 619 k  
perl-DBD-MySQL x86\_64 4.023-5.el7 base 140 k

# Transaction Summary

Install 1 Package (+2 Dependent packages)

Total size: 5.5 M  
Installed size: 5.7 M  
Is this ok [y/d/N]: y  
Downloading packages:  
Running transaction check  
Running transaction test

Transaction check error:  
file /etc/my.cnf from install of Percona-Server-shared-56-5.6.36-rel82.1.el7.x86\_64 conflicts with file from package mysql-community-server-5.7.19-1.el7.x86\_64

## Error Summary

yum list installed|grep -i MySQL shows:

mysql-community-client.x86\_64 5.7.19-1.el7 @mysql57-community  
mysql-community-common.x86\_64 5.7.19-1.el7 @mysql57-community  
mysql-community-libs.x86\_64 5.7.19-1.el7 @mysql57-community  
mysql-community-server.x86\_64 5.7.19-1.el7 @mysql57-community  
mysql57-community-release.noarch el7-10

I’m not sure how to resolve the dependency or why the Transaction check error refers to /etc/my.cnf. Has anyone else experienced this?

Thanks,  
Paul

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [August 17, 2017, 1:55am UTC](https://forums.percona.com/t/trouble-installing-p-t-after-mysql-5-6-5-7-upgrade/5805/2 "2017-08-17T01:55:56Z")

</div>

Can you share the output of:

$ rpm -qa | egrep -i “percona|mysql”

---

<div class="post-metadata">

**Author:** ![pblazek](https://avatars.discourse-cdn.com/v4/letter/p/f08c70/32.png) [@pblazek](https://forums.percona.com/u/pblazek)\
**Post date:** [August 17, 2017, 8:46am UTC](https://forums.percona.com/t/trouble-installing-p-t-after-mysql-5-6-5-7-upgrade/5805/3 "2017-08-17T08:46:42Z")

</div>

I tried a few things and some googling, ended up installing mysql-community-libs-compat-5.7.19-1.el7.x86\_64 with yum localinstall. After that percona-toolkit installed fine. RPM output below:

rpm -qa | egrep -i “percona|mysql”  
mysql-community-libs-compat-5.7.19-1.el7.x86\_64  
percona-release-0.1-4.noarch  
mysql-community-client-5.7.19-1.el7.x86\_64  
percona-toolkit-3.0.4-1.el7.x86\_64  
mysql-community-libs-5.7.19-1.el7.x86\_64  
perl-DBD-MySQL-4.023-5.el7.x86\_64  
mysql57-community-release-el7-10.noarch  
mysql-community-server-5.7.19-1.el7.x86\_64  
mysql-community-common-5.7.19-1.el7.x86\_64

Thanks for the response.

---

<div class="post-metadata">

**Author:** ![DmytroKh](https://avatars.discourse-cdn.com/v4/letter/d/e79b87/32.png) [@DmytroKh](https://forums.percona.com/u/DmytroKh)\
**Post date:** [December 3, 2017, 5:51am UTC](https://forums.percona.com/t/trouble-installing-p-t-after-mysql-5-6-5-7-upgrade/5805/4 "2017-12-03T05:51:11Z")

</div>

I’ve met the same issue trying to install percona-toolkit 3.0.5 along with percona-server-server-5.7  
it looks like packages depends on conflicting mysql conector libraries  
Is there a way to resolve it ?  
Any info on fixes in further releases ?

---

<div class="post-metadata">

**Author:** ![Evgeniy\_Patlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/evgeniy_patlan/32/41_2.png) [@Evgeniy\_Patlan](https://forums.percona.com/u/Evgeniy_Patlan)\
**Post date:** [December 4, 2017, 8:00am UTC](https://forums.percona.com/t/trouble-installing-p-t-after-mysql-5-6-5-7-upgrade/5805/5 "2017-12-04T08:00:04Z")

</div>

> [@DmytroKh;50239](#):
>
> I’ve met the same issue trying to install percona-toolkit 3.0.5 along with percona-server-server-5.7  
> it looks like packages depends on conflicting mysql conector libraries  
> Is there a way to resolve it ?  
> Any info on fixes in further releases ?

I wasn’t able to reproduce this issue. Could you please inform on what OS did you face this issue?

---

<div class="post-metadata">

**Author:** ![Evgeniy\_Patlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/evgeniy_patlan/32/41_2.png) [@Evgeniy\_Patlan](https://forums.percona.com/u/Evgeniy_Patlan)\
**Post date:** [December 4, 2017, 8:02am UTC](https://forums.percona.com/t/trouble-installing-p-t-after-mysql-5-6-5-7-upgrade/5805/6 "2017-12-04T08:02:37Z")

</div>

> [@pblazek;49436](#):
>
> I tried a few things and some googling, ended up installing mysql-community-libs-compat-5.7.19-1.el7.x86\_64 with yum localinstall. After that percona-toolkit installed fine. RPM output below:
> 
> rpm -qa | egrep -i “percona|mysql”  
> mysql-community-libs-compat-5.7.19-1.el7.x86\_64  
> percona-release-0.1-4.noarch  
> mysql-community-client-5.7.19-1.el7.x86\_64  
> percona-toolkit-3.0.4-1.el7.x86\_64  
> mysql-community-libs-5.7.19-1.el7.x86\_64  
> perl-DBD-MySQL-4.023-5.el7.x86\_64  
> mysql57-community-release-el7-10.noarch  
> mysql-community-server-5.7.19-1.el7.x86\_64  
> mysql-community-common-5.7.19-1.el7.x86\_64
> 
> Thanks for the response.

You should install perl-DBD-MySQL in the following way:  
yum install perl-DBD-MySQL --disablerepo percona-release\*  
and after that please try to install percona-toolkit

---

<div class="post-metadata">

**Author:** ![DmytroKh](https://avatars.discourse-cdn.com/v4/letter/d/e79b87/32.png) [@DmytroKh](https://forums.percona.com/u/DmytroKh)\
**Post date:** [December 26, 2017, 9:29am UTC](https://forums.percona.com/t/trouble-installing-p-t-after-mysql-5-6-5-7-upgrade/5805/7 "2017-12-26T09:29:24Z")

</div>

> [@Evgeniy.Patlan;50249](#):
>
> I wasn’t able to reproduce this issue. Could you please inform on what OS did you face this issue?

Looks like I’ve mixed up percona and mysql repositories and that caused the issue. Sorry for any trouble caused and thank you.
