Error while installation

[Pavel Ivanov]

OS:
Ubuntu 16.04

Command:
sudo apt-get install mysql-server pinba-engine-mysql

---

Result:
An error occurred while installing the database:

mysql said: ERROR 1126 (HY000) at line 1: Can't open shared library '/usr/lib/mysql/plugin/libpinba_engine.so' (errno: 2 /usr/lib/mysql/plugin/libpinba_engine.so: undefined symbol: mysql_malloc_service)

---

Full command output:
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
  apparmor dbconfig-common libapparmor-perl libcgi-fast-perl libcgi-pm-perl libencode-locale-perl libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl
  libhttp-message-perl libio-html-perl libjemalloc1 libjudydebian1 liblwp-mediatypes-perl libtimedate-perl liburi-perl mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server-5.7
  mysql-server-core-5.7 pinba-engine-mysql-5.7 psmisc
Suggested packages:
  apparmor-profiles apparmor-profiles-extra apparmor-docs apparmor-utils dbconfig-mysql | dbconfig-pgsql | dbconfig-sqlite | dbconfig-sqlite3 | dbconfig-no-thanks libdata-dump-perl
  libipc-sharedcache-perl libwww-perl mailx tinyca
The following NEW packages will be installed:
  apparmor dbconfig-common libapparmor-perl libcgi-fast-perl libcgi-pm-perl libencode-locale-perl libfcgi-perl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl
  libhttp-message-perl libio-html-perl libjemalloc1 libjudydebian1 liblwp-mediatypes-perl libtimedate-perl liburi-perl mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server mysql-server-5.7
  mysql-server-core-5.7 pinba-engine-mysql pinba-engine-mysql-5.7 psmisc
0 upgraded, 27 newly installed, 0 to remove and 0 not upgraded.
Need to get 19.9 MB of archives.
After this operation, 167 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://mirror.hetzner.de/ubuntu/packages xenial-updates/main amd64 mysql-common all 5.7.12-0ubuntu1 [17.0 kB]
Get:2 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 libapparmor-perl amd64 2.10.95-0ubuntu2 [31.6 kB]
Get:3 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 apparmor amd64 2.10.95-0ubuntu2 [445 kB]
Get:4 http://mirror.hetzner.de/ubuntu/packages xenial-updates/main amd64 mysql-client-core-5.7 amd64 5.7.12-0ubuntu1 [6,122 kB]
Get:5 http://mirror.hetzner.de/ubuntu/packages xenial-updates/main amd64 mysql-client-5.7 amd64 5.7.12-0ubuntu1 [1,693 kB]
Get:6 http://mirror.hetzner.de/ubuntu/packages xenial-updates/main amd64 mysql-server-core-5.7 amd64 5.7.12-0ubuntu1 [7,503 kB]
Get:7 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 psmisc amd64 22.21-2.1build1 [48.0 kB]
Get:8 http://mirror.hetzner.de/ubuntu/packages xenial-updates/main amd64 mysql-server-5.7 amd64 5.7.12-0ubuntu1 [2,584 kB]
Get:9 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 dbconfig-common all 2.0.4ubuntu1 [582 kB]
Get:10 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 libhtml-tagset-perl all 3.20-2 [13.5 kB]
Get:11 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 liburi-perl all 1.71-1 [76.9 kB]
Get:12 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 libhtml-parser-perl amd64 3.72-1 [86.1 kB]
Get:13 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 libcgi-pm-perl all 4.26-1 [185 kB]
Get:14 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 libfcgi-perl amd64 0.77-1build1 [32.3 kB]
Get:15 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 libcgi-fast-perl all 1:2.10-1 [10.2 kB]
Get:16 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 libencode-locale-perl all 1.05-1 [12.3 kB]
Get:17 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 libhtml-template-perl all 2.95-2 [60.4 kB]
Get:18 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 libtimedate-perl all 2.3000-2 [37.5 kB]
Get:19 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 libhttp-date-perl all 6.02-1 [10.4 kB]
Get:20 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 libio-html-perl all 1.001-1 [14.9 kB]
Get:21 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 liblwp-mediatypes-perl all 6.02-1 [21.7 kB]
Get:22 http://mirror.hetzner.de/ubuntu/packages xenial/main amd64 libhttp-message-perl all 6.11-1 [74.3 kB]
Get:23 http://mirror.hetzner.de/ubuntu/packages xenial/universe amd64 libjudydebian1 amd64 1.0.5-5 [94.6 kB]
Get:24 http://mirror.hetzner.de/ubuntu/packages xenial-updates/main amd64 mysql-server all 5.7.12-0ubuntu1 [10.1 kB]
Get:25 http://mirror.hetzner.de/ubuntu/packages xenial/universe amd64 libjemalloc1 amd64 3.6.0-9ubuntu1 [78.9 kB]
Get:26 http://mirror.hetzner.de/ubuntu/packages xenial-updates/universe amd64 pinba-engine-mysql-5.7 amd64 1.1.0-1ubuntu1.1 [92.7 kB]
Get:27 http://mirror.hetzner.de/ubuntu/packages xenial-updates/universe amd64 pinba-engine-mysql all 1.1.0-1ubuntu1.1 [7,894 B]
Fetched 19.9 MB in 0s (21.8 MB/s)
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 54256 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.7.12-0ubuntu1_all.deb ...
Unpacking mysql-common (5.7.12-0ubuntu1) ...
Selecting previously unselected package libapparmor-perl.
Preparing to unpack .../libapparmor-perl_2.10.95-0ubuntu2_amd64.deb ...
Unpacking libapparmor-perl (2.10.95-0ubuntu2) ...
Selecting previously unselected package apparmor.
Preparing to unpack .../apparmor_2.10.95-0ubuntu2_amd64.deb ...
Unpacking apparmor (2.10.95-0ubuntu2) ...
Selecting previously unselected package mysql-client-core-5.7.
Preparing to unpack .../mysql-client-core-5.7_5.7.12-0ubuntu1_amd64.deb ...
Unpacking mysql-client-core-5.7 (5.7.12-0ubuntu1) ...
Selecting previously unselected package mysql-client-5.7.
Preparing to unpack .../mysql-client-5.7_5.7.12-0ubuntu1_amd64.deb ...
Unpacking mysql-client-5.7 (5.7.12-0ubuntu1) ...
Selecting previously unselected package mysql-server-core-5.7.
Preparing to unpack .../mysql-server-core-5.7_5.7.12-0ubuntu1_amd64.deb ...
Unpacking mysql-server-core-5.7 (5.7.12-0ubuntu1) ...
Selecting previously unselected package psmisc.
Preparing to unpack .../psmisc_22.21-2.1build1_amd64.deb ...
Unpacking psmisc (22.21-2.1build1) ...
Processing triggers for systemd (229-4ubuntu6) ...
Processing triggers for ureadahead (0.100.0-19) ...
Processing triggers for man-db (2.7.5-1) ...
Setting up mysql-common (5.7.12-0ubuntu1) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Selecting previously unselected package mysql-server-5.7.
(Reading database ... 54577 files and directories currently installed.)
Preparing to unpack .../mysql-server-5.7_5.7.12-0ubuntu1_amd64.deb ...
Unpacking mysql-server-5.7 (5.7.12-0ubuntu1) ...
Selecting previously unselected package dbconfig-common.
Preparing to unpack .../dbconfig-common_2.0.4ubuntu1_all.deb ...
Unpacking dbconfig-common (2.0.4ubuntu1) ...
Selecting previously unselected package libhtml-tagset-perl.
Preparing to unpack .../libhtml-tagset-perl_3.20-2_all.deb ...
Unpacking libhtml-tagset-perl (3.20-2) ...
Selecting previously unselected package liburi-perl.
Preparing to unpack .../liburi-perl_1.71-1_all.deb ...
Unpacking liburi-perl (1.71-1) ...
Selecting previously unselected package libhtml-parser-perl.
Preparing to unpack .../libhtml-parser-perl_3.72-1_amd64.deb ...
Unpacking libhtml-parser-perl (3.72-1) ...
Selecting previously unselected package libcgi-pm-perl.
Preparing to unpack .../libcgi-pm-perl_4.26-1_all.deb ...
Unpacking libcgi-pm-perl (4.26-1) ...
Selecting previously unselected package libfcgi-perl.
Preparing to unpack .../libfcgi-perl_0.77-1build1_amd64.deb ...
Unpacking libfcgi-perl (0.77-1build1) ...
Selecting previously unselected package libcgi-fast-perl.
Preparing to unpack .../libcgi-fast-perl_1%3a2.10-1_all.deb ...
Unpacking libcgi-fast-perl (1:2.10-1) ...
Selecting previously unselected package libencode-locale-perl.
Preparing to unpack .../libencode-locale-perl_1.05-1_all.deb ...
Unpacking libencode-locale-perl (1.05-1) ...
Selecting previously unselected package libhtml-template-perl.
Preparing to unpack .../libhtml-template-perl_2.95-2_all.deb ...
Unpacking libhtml-template-perl (2.95-2) ...
Selecting previously unselected package libtimedate-perl.
Preparing to unpack .../libtimedate-perl_2.3000-2_all.deb ...
Unpacking libtimedate-perl (2.3000-2) ...
Selecting previously unselected package libhttp-date-perl.
Preparing to unpack .../libhttp-date-perl_6.02-1_all.deb ...
Unpacking libhttp-date-perl (6.02-1) ...
Selecting previously unselected package libio-html-perl.
Preparing to unpack .../libio-html-perl_1.001-1_all.deb ...
Unpacking libio-html-perl (1.001-1) ...
Selecting previously unselected package liblwp-mediatypes-perl.
Preparing to unpack .../liblwp-mediatypes-perl_6.02-1_all.deb ...
Unpacking liblwp-mediatypes-perl (6.02-1) ...
Selecting previously unselected package libhttp-message-perl.
Preparing to unpack .../libhttp-message-perl_6.11-1_all.deb ...
Unpacking libhttp-message-perl (6.11-1) ...
Selecting previously unselected package libjudydebian1.
Preparing to unpack .../libjudydebian1_1.0.5-5_amd64.deb ...
Unpacking libjudydebian1 (1.0.5-5) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../mysql-server_5.7.12-0ubuntu1_all.deb ...
Unpacking mysql-server (5.7.12-0ubuntu1) ...
Selecting previously unselected package libjemalloc1.
Preparing to unpack .../libjemalloc1_3.6.0-9ubuntu1_amd64.deb ...
Unpacking libjemalloc1 (3.6.0-9ubuntu1) ...
Selecting previously unselected package pinba-engine-mysql-5.7.
Preparing to unpack .../pinba-engine-mysql-5.7_1.1.0-1ubuntu1.1_amd64.deb ...
Unpacking pinba-engine-mysql-5.7 (1.1.0-1ubuntu1.1) ...
Selecting previously unselected package pinba-engine-mysql.
Preparing to unpack .../pinba-engine-mysql_1.1.0-1ubuntu1.1_all.deb ...
Unpacking pinba-engine-mysql (1.1.0-1ubuntu1.1) ...
Processing triggers for systemd (229-4ubuntu6) ...
Processing triggers for ureadahead (0.100.0-19) ...
Processing triggers for man-db (2.7.5-1) ...
Processing triggers for libc-bin (2.23-0ubuntu3) ...
Setting up libapparmor-perl (2.10.95-0ubuntu2) ...
Setting up apparmor (2.10.95-0ubuntu2) ...
update-rc.d: warning: start and stop actions are no longer supported; falling back to defaults
Setting up mysql-client-core-5.7 (5.7.12-0ubuntu1) ...
Setting up mysql-client-5.7 (5.7.12-0ubuntu1) ...
Setting up mysql-server-core-5.7 (5.7.12-0ubuntu1) ...
Setting up psmisc (22.21-2.1build1) ...
Setting up mysql-server-5.7 (5.7.12-0ubuntu1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Setting up dbconfig-common (2.0.4ubuntu1) ...

Creating config file /etc/dbconfig-common/config with new version
Setting up libhtml-tagset-perl (3.20-2) ...
Setting up liburi-perl (1.71-1) ...
Setting up libhtml-parser-perl (3.72-1) ...
Setting up libcgi-pm-perl (4.26-1) ...
Setting up libfcgi-perl (0.77-1build1) ...
Setting up libcgi-fast-perl (1:2.10-1) ...
Setting up libencode-locale-perl (1.05-1) ...
Setting up libhtml-template-perl (2.95-2) ...
Setting up libtimedate-perl (2.3000-2) ...
Setting up libhttp-date-perl (6.02-1) ...
Setting up libio-html-perl (1.001-1) ...
Setting up liblwp-mediatypes-perl (6.02-1) ...
Setting up libhttp-message-perl (6.11-1) ...
Setting up libjudydebian1 (1.0.5-5) ...
Setting up mysql-server (5.7.12-0ubuntu1) ...
Setting up libjemalloc1 (3.6.0-9ubuntu1) ...
Setting up pinba-engine-mysql-5.7 (1.1.0-1ubuntu1.1) ...
Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
dbconfig-common: writing config to /etc/dbconfig-common/pinba-engine-mysql-5.7.conf

Creating config file /etc/dbconfig-common/pinba-engine-mysql-5.7.conf with new version
granting access to database pinba for pinba-engine-mys@localhost: success.
verifying access for pinba-engine-mys@localhost: success.
creating database pinba: success.
verifying database pinba exists: success.
populating database via administrative sql... error encountered populating database with administrative sql:
mysql said: mysql: [Warning] mysql: Empty value for 'port' specified. Will throw an error in future versions ERROR 1126 (HY000) at line 1: Can't open shared library '/usr/lib/mysql/plugin/libpinba_engine.so' (errno: 2 /usr/lib/mysql/plugin/libpinba_engine.so: undefined symbol: mysql_malloc_service)
dbconfig-common: pinba-engine-mysql-5.7 configure: trying again.
Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
dbconfig-common: writing config to /etc/dbconfig-common/pinba-engine-mysql-5.7.conf
Replacing config file /etc/dbconfig-common/pinba-engine-mysql-5.7.conf with new version
granting access to database pinba for pinba@localhost: success.
verifying access for pinba@localhost: success.
creating database pinba: already exists.
populating database via administrative sql... error encountered populating database with administrative sql:
mysql said: mysql: [Warning] mysql: Empty value for 'port' specified. Will throw an error in future versions ERROR 1126 (HY000) at line 1: Can't open shared library '/usr/lib/mysql/plugin/libpinba_engine.so' (errno: 2 /usr/lib/mysql/plugin/libpinba_engine.so: undefined symbol: mysql_malloc_service)
dbconfig-common: pinba-engine-mysql-5.7 configure: trying again.
Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
dbconfig-common: writing config to /etc/dbconfig-common/pinba-engine-mysql-5.7.conf
Replacing config file /etc/dbconfig-common/pinba-engine-mysql-5.7.conf with new version
granting access to database pinba for pinba@localhost: already exists.
creating database pinba: already exists.
populating database via administrative sql... error encountered populating database with administrative sql:
mysql said: ERROR 1126 (HY000) at line 1: Can't open shared library '/usr/lib/mysql/plugin/libpinba_engine.so' (errno: 2 /usr/lib/mysql/plugin/libpinba_engine.so: undefined symbol: mysql_malloc_service)
dbconfig-common: pinba-engine-mysql-5.7 configure: ignoring errors from here forwards
done.
populating database via sql... done.
dbconfig-common: flushing administrative password
dbconfig-common: pinba-engine-mysql-5.7 configure: ignoring errors from here forwards
dbconfig-common: pinba-engine-mysql-5.7 configure: ignoring errors from here forwards
Setting up pinba-engine-mysql (1.1.0-1ubuntu1.1) ...
Processing triggers for systemd (229-4ubuntu6) ...
Processing triggers for ureadahead (0.100.0-19) ...
Processing triggers for libc-bin (2.23-0ubuntu3) ...

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Nikola Petkanski (nikola.petkanski)]

The problem is present on 16.04.2.

[TomaszChmielewski (mangoo-wpkg)]

The problem (/usr/lib/mysql/plugin/libpinba_engine.so: undefined symbol: mysql_malloc_service) is still present in Ubuntu 16.04.3.