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

Debian 10 - cannot install PS 5.7.26 after percona-toolkit

    Details

    • Type: Bug
    • Status: In QA
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Packaging
    • Labels:
      None
    • Needs QA:
      Yes

      Description

      I have first installed percona-toolkit, these are the packages that got installed with it:

      vagrant@debian-buster:~$ sudo apt install percona-toolkit
      Reading package lists... Done
      Building dependency tree
      Reading state information... Done
      The following additional packages will be installed:
        libdbd-mysql-perl libdbi-perl libio-socket-ssl-perl libmariadb3 libnet-libidn-perl libnet-ssleay-perl libterm-readkey-perl mariadb-common mysql-common
        perl-openssl-defaults
      Suggested packages:
        libclone-perl libmldbm-perl libnet-daemon-perl libsql-statement-perl
      The following NEW packages will be installed:
        libdbd-mysql-perl libdbi-perl libio-socket-ssl-perl libmariadb3 libnet-libidn-perl libnet-ssleay-perl libterm-readkey-perl mariadb-common mysql-common
        percona-toolkit perl-openssl-defaults
      0 upgraded, 11 newly installed, 0 to remove and 0 not upgraded.
      Need to get 5.980 kB of archives.
      After this operation, 31,1 MB of additional disk space will be used.
      Do you want to continue? [Y/n] y
      

      notice that mysql-common and mariadb-common both got installed - which is strange and I'm suspecting that this is causing the problem.

      After that installing PS 5.7.26:

      vagrant@debian-buster:~$ sudo apt install percona-server-server-5.7
      Reading package lists... Done
      Building dependency tree
      Reading state information... Done
      The following additional packages will be installed:
        debsums libdpkg-perl libfile-fcntllock-perl libfile-fnmatch-perl libmecab2 percona-server-client-5.7 percona-server-common-5.7 psmisc
      Suggested packages:
        debian-keyring bzr
      The following NEW packages will be installed:
        debsums libdpkg-perl libfile-fcntllock-perl libfile-fnmatch-perl libmecab2 percona-server-client-5.7 percona-server-common-5.7 percona-server-server-5.7
        psmisc
      0 upgraded, 9 newly installed, 0 to remove and 0 not upgraded.
      Need to get 32,7 MB of archives.
      After this operation, 232 MB of additional disk space will be used.
      Do you want to continue? [Y/n] y
      Get:2 http://repo.percona.com/percona/apt buster/testing amd64 percona-server-common-5.7 amd64 5.7.26-29-1.buster [210 kB]
      Get:1 http://cdn-fastly.deb.debian.org/debian buster/main amd64 libdpkg-perl all 1.19.7 [1.414 kB]
      Get:3 http://cdn-fastly.deb.debian.org/debian buster/main amd64 libfile-fnmatch-perl amd64 0.02-2+b6 [10,4 kB]
      Get:4 http://cdn-fastly.deb.debian.org/debian buster/main amd64 debsums all 2.2.3 [49,8 kB]
      Get:5 http://cdn-fastly.deb.debian.org/debian buster/main amd64 libmecab2 amd64 0.996-6 [258 kB]
      Get:6 http://cdn-fastly.deb.debian.org/debian buster/main amd64 psmisc amd64 23.2-1 [126 kB]
      Get:7 http://cdn-fastly.deb.debian.org/debian buster/main amd64 libfile-fcntllock-perl amd64 0.22-3+b5 [35,4 kB]
      Get:8 http://repo.percona.com/percona/apt buster/testing amd64 percona-server-client-5.7 amd64 5.7.26-29-1.buster [2.307 kB]
      Get:9 http://repo.percona.com/percona/apt buster/testing amd64 percona-server-server-5.7 amd64 5.7.26-29-1.buster [28,2 MB]
      Fetched 32,7 MB in 23s (1.394 kB/s)
      Preconfiguring packages ...
      Selecting previously unselected package libdpkg-perl.
      (Reading database ... 35250 files and directories currently installed.)
      Preparing to unpack .../libdpkg-perl_1.19.7_all.deb ...
      Unpacking libdpkg-perl (1.19.7) ...
      Selecting previously unselected package libfile-fnmatch-perl.
      Preparing to unpack .../libfile-fnmatch-perl_0.02-2+b6_amd64.deb ...
      Unpacking libfile-fnmatch-perl (0.02-2+b6) ...
      Selecting previously unselected package debsums.
      Preparing to unpack .../archives/debsums_2.2.3_all.deb ...
      Unpacking debsums (2.2.3) ...
      Setting up libdpkg-perl (1.19.7) ...
      Setting up libfile-fnmatch-perl (0.02-2+b6) ...
      Setting up debsums (2.2.3) ...
      Selecting previously unselected package percona-server-common-5.7.
      (Reading database ... 35448 files and directories currently installed.)
      Preparing to unpack .../percona-server-common-5.7_5.7.26-29-1.buster_amd64.deb ...
      Unpacking percona-server-common-5.7 (5.7.26-29-1.buster) ...
      Selecting previously unselected package percona-server-client-5.7.
      Preparing to unpack .../percona-server-client-5.7_5.7.26-29-1.buster_amd64.deb ...
      Unpacking percona-server-client-5.7 (5.7.26-29-1.buster) ...
      Selecting previously unselected package libmecab2:amd64.
      Preparing to unpack .../libmecab2_0.996-6_amd64.deb ...
      Unpacking libmecab2:amd64 (0.996-6) ...
      Selecting previously unselected package psmisc.
      Preparing to unpack .../psmisc_23.2-1_amd64.deb ...
      Unpacking psmisc (23.2-1) ...
      Setting up percona-server-common-5.7 (5.7.26-29-1.buster) ...
      Selecting previously unselected package percona-server-server-5.7.
      (Reading database ... 35626 files and directories currently installed.)
      Preparing to unpack .../percona-server-server-5.7_5.7.26-29-1.buster_amd64.deb ...
      Unpacking percona-server-server-5.7 (5.7.26-29-1.buster) ...
      Selecting previously unselected package libfile-fcntllock-perl.
      Preparing to unpack .../libfile-fcntllock-perl_0.22-3+b5_amd64.deb ...
      Unpacking libfile-fcntllock-perl (0.22-3+b5) ...
      Setting up libmecab2:amd64 (0.996-6) ...
      Setting up percona-server-client-5.7 (5.7.26-29-1.buster) ...
      Setting up libfile-fcntllock-perl (0.22-3+b5) ...
      Setting up psmisc (23.2-1) ...
      Setting up percona-server-server-5.7 (5.7.26-29-1.buster) ...
      2019-07-16T08:53:28.051741Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see d
      ocumentation for more details).
      2019-07-16T08:53:28.189330Z 0 [Warning] InnoDB: New log files created, LSN=45790
      2019-07-16T08:53:28.221046Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
      2019-07-16T08:53:28.291297Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generatin
      g a new UUID: 2de5a649-a7a7-11e9-b05d-080027b517d6.
      2019-07-16T08:53:28.293381Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
      2019-07-16T08:53:28.526423Z 0 [Warning] CA certificate ca.pem is self signed.
      2019-07-16T08:53:28.597104Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
      ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
      2019-07-16T08:53:31.106812Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see d
      ocumentation for more details).
      2019-07-16T08:53:31.209928Z 0 [Warning] CA certificate ca.pem is self signed.
      
      Progress: [ 95%] [################################################################################################################################........]
      

      and it gets stuck there. Service logs show nothing and the service is not fully installed. I had to kill mysqld process to get this unstuck.

      /etc/mysql/my.cnf point to this:

      # The MariaDB configuration file
      #
      # The MariaDB/MySQL tools read configuration files in the following order:
      # 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
      # 2. "/etc/mysql/conf.d/*.cnf" to set global options.
      # 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
      # 4. "~/.my.cnf" to set user-specific options.
      #
      # If the same option is defined multiple times, the last one will apply.
      #
      # One can use all long options that the program supports.
      # Run program with --help to get a list of available options and with
      # --print-defaults to see which it would actually understand and use.
      
      #
      # This group is read both both by the client and the server
      # use it for options that affect everything
      #
      [client-server]
      
      # Import all .cnf files from configuration directory
      !includedir /etc/mysql/conf.d/
      !includedir /etc/mysql/mariadb.conf.d/
      

      so our config from percona-server.conf.d directory is not used, and mariadb one is basically empty.

      alternatives.log has this:

      update-alternatives 2019-07-15 09:30:43: link group c99 updated to point to /usr/bin/c99-gcc
      update-alternatives 2019-07-16 08:43:53: run with --install /etc/mysql/my.cnf my.cnf /etc/mysql/my.cnf.fallback 100
      update-alternatives 2019-07-16 08:43:53: link group my.cnf updated to point to /etc/mysql/my.cnf.fallback
      update-alternatives 2019-07-16 08:43:53: run with --install /etc/mysql/my.cnf my.cnf /etc/mysql/mariadb.cnf 200
      update-alternatives 2019-07-16 08:43:53: link group my.cnf updated to point to /etc/mysql/mariadb.cnf
      update-alternatives 2019-07-16 08:53:25: run with --install /etc/mysql/my.cnf my.cnf /etc/mysql/percona-server.cnf 200
      

      If we install PS 5.7.26 first it will install fine and it will select "mysql-common" for installation also and our config will be used.
      After that when we install Percona Toolkit it will also install "mariadb-common", but our config will be left working from what I see.

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  hrvoje.matijakovic Hrvoje Matijakovic
                  Reporter:
                  tomislav.plavcic@percona.com Tomislav Plavcic
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 1 day
                    1d