Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-6983

mysql-common upgrade removes percona-server-server

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Won't Fix
    • Affects Version/s: 8.0.19-10
    • Fix Version/s: None
    • Component/s: Packaging
    • Labels:
      None
    • Environment:

      Ubuntu 18.04

      Description

      Forcing the upgrade of mysql-common that had been held back caused percona-server-server to be removed.

      Start-Date: 2020-04-09  12:05:44
      Commandline: apt-get upgrade --with-new-pkgs
      Requested-By: percona (1000)
      Upgrade: code:amd64 (1.43.2-1585036376, 1.44.0-1586345345)
      End-Date: 2020-04-09  12:06:02Start-Date: 2020-04-09  12:10:26
      
      Commandline: apt-get install mysql-common --only-upgrade --assume-no -qq
      Requested-By: percona (1000)
      Upgrade: mysql-common:amd64 (5.8+1.0.4, 8.0.19-1ubuntu18.04)
      Remove: percona-server-server:amd64 (8.0.19-10-1.bionic), percona-server-client:amd64 (8.0.19-10-1.bionic)
      End-Date: 2020-04-09  12:10:30Start-Date: 2020-04-09  12:24:28
      
      Commandline: apt-get purge percona-toolkit
      Requested-By: percona (1000)
      Purge: percona-toolkit:amd64 (3.1.0-2.bionic)
      End-Date: 2020-04-09  12:24:29Start-Date: 2020-04-09  12:26:31
      
      Commandline: apt-get purge libdbd-mysql-perl
      Requested-By: percona (1000)
      Purge: libdbd-mysql-perl:amd64 (4.046-1), percona-xtrabackup-80:amd64 (8.0.10-1.bionic)
      End-Date: 2020-04-09  12:26:33Start-Date: 2020-04-09  12:29:42
      
      Commandline: apt-get install --reinstall mysql-common
      Requested-By: percona (1000)
      Reinstall: mysql-common:amd64 (8.0.19-1ubuntu18.04)
      End-Date: 2020-04-09  12:29:43Start-Date: 2020-04-09  12:30:18
      
      Commandline: apt-get install --reinstall percona-server-common
      Requested-By: percona (1000)
      Reinstall: percona-server-common:amd64 (8.0.19-10-1.bionic)
      End-Date: 2020-04-09  12:30:20 

       
      Removing the toolkit, xtrabackup and the Perl driver did not resolve the issue and reinstalling percona-server-server results in mysql-common being removed:

      #> apt-get install --assume-no percona-server-server percona-server-common percona-server-client
      Reading package lists... Done
      Building dependency tree       
      Reading state information... Done
      percona-server-common is already the newest version (8.0.19-10-1.bionic).
      The following packages will be REMOVED
        blender epson-inkjet-printer-escpr flowblade frei0r-plugins gmic libgdal20 libmailutils5 libmysqlclient20 libopencv-highgui3.2 libopencv-imgcodecs3.2 libopencv-objdetect3.2 libopencv-videoio3.2
        libopenimageio1.7 libqt4-sql-mysql lsb lsb-core lsb-printing mailutils mysql-common
      The following NEW packages will be installed
        percona-server-client percona-server-server
      0 to upgrade, 2 to newly install, 19 to remove and 6 not to upgrade.
      Need to get 0 B/53.1 MB of archives.
      After this operation, 206 MB of additional disk space will be used.
      Do you want to continue? [Y/n] N
      Abort.
      

      Adding the following preference did not change anything regarding percona-server-server:

      Package: libdbd-mysql-perl
      Pin: release o=Percona Development Team,n=bionic,l=percona,c=experimental
      Pin-Priority: 900
      

      Adding mysql-common to the install command produces:

      #> apt-get install --assume-no percona-server-server percona-server-common percona-server-client mysql-common
      Reading package lists... Done
      Building dependency tree       
      Reading state information... Done
      mysql-common is already the newest version (8.0.19-1ubuntu18.04).
      percona-server-common is already the newest version (8.0.19-10-1.bionic).
      Some packages could not be installed. This may mean that you have
      requested an impossible situation or if you are using the unstable
      distribution that some required packages have not yet been created
      or been moved out of Incoming.
      The following information may help to resolve the situation:
      
      The following packages have unmet dependencies.
       mysql-common : Conflicts: mysql-client-8.0
                      Conflicts: mysql-client-core-8.0
                      Conflicts: mysql-server-8.0
                      Conflicts: mysql-server-core-8.0
      E: Unable to correct problems, you have held broken packages.
      

      Here are the Percona repos:

      #> apt-cache policy | ack percona
       500 http://repo.percona.com/tools/apt bionic/main i386 Packages
           release v=1.0,o=Percona Development Team,n=bionic,l=percona,c=main,b=i386
           origin repo.percona.com
       500 http://repo.percona.com/tools/apt bionic/main amd64 Packages
           release v=1.0,o=Percona Development Team,n=bionic,l=percona,c=main,b=amd64
           origin repo.percona.com
       500 http://repo.percona.com/tools/apt bionic/experimental i386 Packages
           release v=1.0,o=Percona Development Team,n=bionic,l=percona,c=experimental,b=i386
           origin repo.percona.com
       500 http://repo.percona.com/tools/apt bionic/experimental amd64 Packages
           release v=1.0,o=Percona Development Team,n=bionic,l=percona,c=experimental,b=amd64
           origin repo.percona.com
       500 http://repo.percona.com/ps-80/apt bionic/main amd64 Packages
           release v=1.0,o=Percona Development Team,n=bionic,l=percona,c=main,b=amd64
           origin repo.percona.com
       500 http://repo.percona.com/percona/apt bionic/main i386 Packages
           release v=1.0,o=Percona Development Team,n=bionic,l=percona,c=main,b=i386
           origin repo.percona.com
       500 http://repo.percona.com/percona/apt bionic/main amd64 Packages
           release v=1.0,o=Percona Development Team,n=bionic,l=percona,c=main,b=amd64
           origin repo.percona.com
      

      Here are the MySQL ones:

      #> apt-cache policy | ack mysql
       500 http://repo.mysql.com/apt/ubuntu bionic/mysql-tools i386 Packages
           release o=MySQL,n=bionic,l=MySQL,c=mysql-tools,b=i386
           origin repo.mysql.com
       500 http://repo.mysql.com/apt/ubuntu bionic/mysql-tools amd64 Packages
           release o=MySQL,n=bionic,l=MySQL,c=mysql-tools,b=amd64
           origin repo.mysql.com
       500 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 i386 Packages
           release o=MySQL,n=bionic,l=MySQL,c=mysql-8.0,b=i386
           origin repo.mysql.com
       500 http://repo.mysql.com/apt/ubuntu bionic/mysql-8.0 amd64 Packages
           release o=MySQL,n=bionic,l=MySQL,c=mysql-8.0,b=amd64
           origin repo.mysql.com
       500 http://repo.mysql.com/apt/ubuntu bionic/mysql-apt-config i386 Packages
           release o=MySQL,n=bionic,l=MySQL,c=mysql-apt-config,b=i386
           origin repo.mysql.com
       500 http://repo.mysql.com/apt/ubuntu bionic/mysql-apt-config amd64 Packages
           release o=MySQL,n=bionic,l=MySQL,c=mysql-apt-config,b=amd64
           origin repo.mysql.com
           libdbd-mysql-perl -> 1:4.050-1.bionic with priority 900
      

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                illia.pshonkin Illia Pshonkin
                Reporter:
                ceri.williams Ceri Williams
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 2 hours
                    2h