Not the answer you need?
Register and ask your own question!

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

GertJGertJ Current User Role Contributor
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


  • 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

Answers

  • Evgeniy PatlanEvgeniy Patlan Percona Percona Staff Role
    edited July 13
    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
    [[email protected] ~]$ pt-show-grants --version
    pt-show-grants 3.0.13
    [[email protected] ~]$ 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) <[email protected]>"
    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!
    [[email protected] ~]$ 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
  • PeterPeter Percona CEO Percona Moderator Role
    What is your repository configuration specifically ? 
  • GertJGertJ Current User Role Contributor
    Hi
    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

    # yum repolistLoaded plugins: fastestmirror
    as I still was on 3.0.12, i followed Percona guides
    $ sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
    and
    sudo percona-release enable original
    $ sudo 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
    No packages marked for update
    $
    Still was 3.0.12

  • Evgeniy PatlanEvgeniy Patlan Percona Percona Staff Role
    Hi @GertJ
    I still was not able to reproduce this issue.
    Could you please show the output of `yum repolist` command?
  • GertJGertJ Current User Role Contributor
    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]#

  • Evgeniy PatlanEvgeniy Patlan Percona Percona Staff Role
    Please provide with output of ` yum info percona-toolkit `
  • GertJGertJ Current User Role Contributor
    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         : http://www.percona.com/software/percona-toolkit/
    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         : http://www.percona.com/software/percona-toolkit/
    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/.




  • Evgeniy PatlanEvgeniy Patlan Percona Percona Staff Role
    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
  • GertJGertJ Current User Role Contributor
    okay thx
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.