-
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
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.