percona-toolkit does not get updated to latest update via PERCONA repo servers

MySQL & MariaDB Other MySQL® Questions
1

percona-toolkit does not get updated to latest update via PERCONA repo servers:
had the PT-1673 bug for long, and tried to get latest update for pt-show-grants installed, but it kept saying 3.0.12, and there are a 3.0.13 release
Then forced it to install https://repo.percona.com/yum/release/7Server/RPMS/x86_64/percona-toolkit-3.2.0-1.el7.x86_64.rpm


  • Distro Name: CentOS Linux release 7.8.2003 (Core)

  • Kernel Version: 3.10.0-1127.13.1.el7.x86_64
  • Platform: x86_64 vmware
  • MySQL version: 10.1.45-MariaDB
Now pt-show-grants 3.2.0, and issue PT-1673 has been fixed.

/GertJ
2

Hi @GertJ
I tried to reproduce your issue but without success. Packages was updated correctly.
Here is my STR:

  • install percona-toolkit 3.0.13
  • check version
  • execute yum update percona-toolkit
  • check version
[vagrant@localhost ~]$ pt-show-grants --version
pt-show-grants 3.0.13
[vagrant@localhost ~]$ sudo yum update percona-toolkit
Failed to set locale, defaulting to C
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.mirohost.net
* extras: mirror.mirohost.net
* updates: mirror.mirohost.net
percona-release-noarch                                                                                          | 2.9 kB  00:00:00      
percona-release-x86_64                                                                                          | 2.9 kB  00:00:00      
(1/2): percona-release-noarch/7/primary_db                                                                      |  23 kB  00:00:00      
(2/2): percona-release-x86_64/7/primary_db                                                                      | 1.1 MB  00:00:00      
Resolving Dependencies
–> Running transaction check
—> Package percona-toolkit.x86_64 0:3.0.13-1.el7 will be updated
—> Package percona-toolkit.x86_64 0:3.2.0-1.el7 will be an update
–> Finished Dependency Resolution
Dependencies Resolved
=======================================================================================================================================
Package                          Arch                    Version                        Repository                               Size
=======================================================================================================================================
Updating:
percona-toolkit                  x86_64                  3.2.0-1.el7                    percona-release-x86_64                   12 M
Transaction Summary
=======================================================================================================================================
Upgrade  1 Package
Total download size: 12 M
Is this ok [y/d/N]: y
Downloading packages:
No Presto metadata available for percona-release-x86_64
warning: /var/cache/yum/x86_64/7/percona-release-x86_64/packages/percona-toolkit-3.2.0-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature
, key ID 8507efa5: NOKEY
Public key for percona-toolkit-3.2.0-1.el7.x86_64.rpm is not installed
percona-toolkit-3.2.0-1.el7.x86_64.rpm                                                                          |  12 MB  00:00:03      
Retrieving key from file:///etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY
Importing GPG key 0x8507EFA5:
Userid     : “Percona MySQL Development Team (Packaging key) <mysql-dev@percona.com>”
Fingerprint: 4d1b b29d 63d9 8e42 2b21 13b1 9334 a25f 8507 efa5
Package    : percona-release-1.0-21.noarch (installed)
From       : /etc/pki/rpm-gpg/PERCONA-PACKAGING-KEY
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
 Updating   : percona-toolkit-3.2.0-1.el7.x86_64                                                                                  1/2  
 Cleanup    : percona-toolkit-3.0.13-1.el7.x86_64                                                                                 2/2  
 Verifying  : percona-toolkit-3.2.0-1.el7.x86_64                                                                                  1/2  
 Verifying  : percona-toolkit-3.0.13-1.el7.x86_64                                                                                 2/2  

Updated:
 percona-toolkit.x86_64 0:3.2.0-1.el7                                                                                                  
Complete!
[vagrant@localhost ~]$ pt-show-grants --version        
pt-show-grants 3.2.0
Most probably you didn’t have enable percona repository and that is why there weren’t any available updates.
In order to enable our repository it is needed to install percona-release package and enable needed repository using percona-release script. 
You can find more info here: https://www.percona.com/doc/percona-repo-config/percona-release.html

3

What is your repository configuration specifically ? 

4

Hi @Evgeniy Patlan
That will not test you get to lasted, as you directly installed the release that I did not get updated to.My installation are years old, before 3.0.13 was released, following this guide http://centos-webpanel.com/installation-instructions

@Peter

# yum repolistLoaded plugins: fastestmirror<br>Loading mirror speeds from cached hostfile<br>&nbsp;* base: mirror.fysik.dtu.dk<br>&nbsp;* epel: mirrors.dotsrc.org<br>&nbsp;* extras: mirror.fysik.dtu.dk<br>&nbsp;* updates: mirror.fysik.dtu.dk<br>repo id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; repo name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; status<br>base/7/x86_64&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CentOS-7 - Base&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.070<br>cwp/x86_64&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CentOS Web Panel repo for Linux 7 - x86_64&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 77<br>epel/x86_64&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Extra Packages for Enterprise Linux 7 - x86_64&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13.376<br>extras/7/x86_64&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CentOS-7 - Extras&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 412<br>mariadb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MariaDB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 86<br>percona-release-noarch/7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Percona Original release/noarch YUM repository&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 59<br>percona-release-x86_64/7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Percona Original release/x86_64 YUM repository&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.086<br>updates/7/x86_64&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CentOS-7 - Updates&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 890<br>repolist: 27.056

as I still was on 3.0.12, i followed Percona guideshttps://www.percona.com/doc/percona-repo-config/percona-release.html

$ sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm

and 

$ sudo percona-release enable original<br>$ sudo yum update<br>Loaded plugins: fastestmirror<br>Loading mirror speeds from cached hostfile<br> * base: mirror.fysik.dtu.dk<br> * epel: mirrors.dotsrc.org<br> * extras: mirror.fysik.dtu.dk<br> * updates: mirror.fysik.dtu.dk<br>No packages marked for update<br>

Still was 3.0.12

5

Hi @GertJ
I still was not able to reproduce this issue.
Could you please show the output of yum repolist command?

6

sorry I did added in last post @Peter , but somehow  the <code> got cut to only 1 line (same for code just before “and”)so now listing without as code
[root]# sudo percona-release enable original
* Enabling the Percona Original repository
<> All done!

[root]# yum update
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
  base: mirror.fysik.dtu.dk
 * epel: mirrors.dotsrc.org
 * extras: mirror.fysik.dtu.dk
 * updates: mirror.fysik.dtu.dk
percona-release-noarch                                                        | 2.9 kB  00:00:00
percona-release-x86_64                                                        | 2.9 kB  00:00:00
No packages marked for update

[root]# yum repolist
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.fysik.dtu.dk
 * epel: mirrors.dotsrc.org
 * extras: mirror.fysik.dtu.dk
 * updates: mirror.fysik.dtu.dk
repo id                             repo name                                                  status
base/7/x86_64                       CentOS-7 - Base                                            10.070
cwp/x86_64                          CentOS Web Panel repo for Linux 7 - x86_64                     77
epel/x86_64                         Extra Packages for Enterprise Linux 7 - x86_64             13.376
extras/7/x86_64                     CentOS-7 - Extras                                             412
mariadb                             MariaDB                                                        86
percona-release-noarch/7            Percona Original release/noarch YUM repository                 59
percona-release-x86_64/7            Percona Original release/x86_64 YUM repository              2.086
updates/7/x86_64                    CentOS-7 - Updates                                            890
repolist: 27.056
[root]#

7

Please provide with output of yum info percona-toolkit

8

sure but as stated before initial post I forced 3.2.0 installed

[root]# yum info percona-toolkit
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.fysik.dtu.dk
 * epel: mirrors.dotsrc.org
 * extras: mirror.fysik.dtu.dk
 * updates: mirror.fysik.dtu.dk
Installed Packages
Name        : percona-toolkit
Arch        : x86_64
Version     : 3.2.0
Release     : 1.el7
Size        : 38 M
Repo        : installed
From repo   : /percona-toolkit-3.2.0-1.el7.x86_64
Summary     : Advanced MySQL and system command-line tools
URL         : MySQL Tools and Management Software to Perform System Tasks by Percona
License     : GPLv2
Description : Percona Toolkit is a collection of advanced command-line tools used by
            : Percona (http://www.percona.com/) support staff to perform a variety of
            : MySQL and system tasks that are too difficult or complex to perform manually.
            :
            : These tools are ideal alternatives to private or “one-off” scripts because
            : they are professionally developed, formally tested, and fully documented.
            : They are also fully self-contained, so installation is quick and easy and
            : no libraries are installed.
            :
            : Percona Toolkit is developed and supported by Percona.  For more
            : information and other free, open-source software developed by Percona,
            : visit http://www.percona.com/software/.

Available Packages
Name        : percona-toolkit
Arch        : noarch
Version     : 2.2.20
Release     : 1
Size        : 1.7 M
Repo        : percona-release-noarch/7
Summary     : Advanced MySQL and system command-line tools
URL         : MySQL Tools and Management Software to Perform System Tasks by Percona
License     : GPLv2
Description : Percona Toolkit is a collection of advanced command-line tools used by
            : Percona (http://www.percona.com/) support staff to perform a variety of
            : MySQL and system tasks that are too difficult or complex to perform manually.
            :
            : These tools are ideal alternatives to private or “one-off” scripts because
            : they are professionally developed, formally tested, and fully documented.
            : They are also fully self-contained, so installation is quick and easy and
            : no libraries are installed.
            :
            : Percona Toolkit is developed and supported by Percona.  For more
            : information and other free, open-source software developed by Percona,
            : visit http://www.percona.com/software/.




9

Yeah sure it would be better to get this output before installing package. From my side I cannot reproduce this issue.
If you face this issue again please notify us. You can also create ticket in our Jira regarding such issues

10

okay thx