Bug #90120 cannot install mysql-apt-config
Submitted: 18 Mar 2018 15:51 Modified: 23 Mar 2018 10:04
Reporter: Karl Johansson Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Package Repos Severity:S2 (Serious)
Version: OS:Ubuntu (16.04)
Assigned to: CPU Architecture:Any

[18 Mar 2018 15:51] Karl Johansson
Description:
I'm having the same issue as https://bugs.mysql.com/bug.php?id=76149 which was closed three years ago, but with the latest version.

root@hostname:~# dpkg -i mysql-apt-config_0.8.9-1_all.deb
(Reading database ... 54955 files and directories currently installed.)
Preparing to unpack mysql-apt-config_0.8.9-1_all.deb ...
Unpacking mysql-apt-config (0.8.9-1) over (0.8.9-1) ...
Setting up mysql-apt-config (0.8.9-1) ...

<hangs forever>

How to repeat:
1. Install Ubuntu 16.04 from scratch. 

2. wget https://dev.mysql.com/get/mysql-apt-config_0.8.9-1_all.deb

3. dpkg -i mysql-apt-config_0.8.9-1_all.deb
[18 Mar 2018 16:01] Karl Johansson
This is on
Ubuntu 16.04.4 LTS (GNU/Linux 4.4.0-116-generic x86_64)

I have a VM with 16.04.1 where I just tried it and it worked as expected.
[18 Mar 2018 16:03] Karl Johansson
I just tried it on a second server with the exact same OS version (16.04.4) - same result. Hangs forever.
[19 Mar 2018 7:50] MySQL Verification Team
Hello Karl,

Thank you for the report.
I tried to confirm this issue on 16.04.2 and 16.04.4(to reproduce I've  upgraded from 16.04.3 - sudo apt update && sudo apt full-upgrade -y) but not seeing any issues as package installation goes smoothly.

### on 16.04.04 (Upgraded from 16.04.3)

ushastry@XenialXerus:~$ cat /etc/*release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=16.04
DISTRIB_CODENAME=xenial
DISTRIB_DESCRIPTION="Ubuntu 16.04.4 LTS"
NAME="Ubuntu"
VERSION="16.04.4 LTS (Xenial Xerus)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 16.04.4 LTS"
VERSION_ID="16.04"
HOME_URL="http://www.ubuntu.com/"
SUPPORT_URL="http://help.ubuntu.com/"
BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/"
VERSION_CODENAME=xenial
UBUNTU_CODENAME=xenial
ushastry@XenialXerus:~$ sudo dpkg -l |grep -i mysql
[sudo] password for ushastry: 
ushastry@XenialXerus:~$ 

-- Download .deb from https://dev.mysql.com/downloads/repo/apt/

ushastry@XenialXerus:~$ cd Downloads/
ushastry@XenialXerus:~/Downloads$ sudo dpkg -i mysql-apt-config_0.8.9-1_all.deb
Selecting previously unselected package mysql-apt-config.
(Reading database ... 248818 files and directories currently installed.)
Preparing to unpack mysql-apt-config_0.8.9-1_all.deb ...
Unpacking mysql-apt-config (0.8.9-1) ...
Setting up mysql-apt-config (0.8.9-1) ...
OK
ushastry@XenialXerus:~/Downloads$ sudo dpkg -l |grep -i mysql
ii  mysql-apt-config                           0.8.9-1                                      all          Auto configuration for MySQL APT Repo.
ushastry@XenialXerus:~/Downloads$ 

## On 16.04.2

root@ubuntu1604lts:/home/ushastry# dpkg -l|grep mysql
ii  libmysqlclient-dev                         5.7.21-1ubuntu16.04                                 amd64        MySQL development headers
ii  libmysqlclient20:amd64                     5.7.21-1ubuntu16.04                                 amd64        MySQL shared client libraries
ii  libmysqld-dev                              5.7.21-1ubuntu16.04                                 amd64        MySQL embedded server library
ii  mysql-apt-config                           0.8.7-1                                             all          Auto configuration for MySQL APT Repo.
ii  mysql-client                               5.7.21-1ubuntu16.04                                 amd64        MySQL Client meta package depending on latest version
ii  mysql-common                               5.7.21-1ubuntu16.04                                 amd64        MySQL Common
ii  mysql-community-client                     5.7.21-1ubuntu16.04                                 amd64        MySQL Client
ii  mysql-community-server                     5.7.21-1ubuntu16.04                                 amd64        MySQL Server
ii  mysql-connector-python                     2.1.6-1ubuntu16.04                                  all          MySQL database driver written in Python
ii  mysql-router                               2.1.3-1ubuntu16.04                                  amd64        MySQL Router
ii  mysql-server                               5.7.21-1ubuntu16.04                                 amd64        MySQL Server meta package depending on latest version
ii  mysql-shell:amd64                          1.0.9-1ubuntu16.04                                  amd64        MySQL Shell
ii  mysql-utilities                            1.6.5-1ubuntu16.04                                  all          Collection of scripts for managing MySQL servers
ii  mysql-workbench-community                  6.3.10-1ubuntu16.04                                 amd64        MySQL Workbench

root@ubuntu1604lts:/home/ushastry# cat /etc/*release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=16.04
DISTRIB_CODENAME=xenial
DISTRIB_DESCRIPTION="Ubuntu 16.04.2 LTS"
NAME="Ubuntu"
VERSION="16.04.2 LTS (Xenial Xerus)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 16.04.2 LTS"
VERSION_ID="16.04"
HOME_URL="http://www.ubuntu.com/"
SUPPORT_URL="http://help.ubuntu.com/"
BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/"
VERSION_CODENAME=xenial
UBUNTU_CODENAME=xenial

root@ubuntu1604lts:/home/ushastry/Downloads# dpkg -i mysql-apt-config_0.8.9-1_all.deb 
(Reading database ... 297349 files and directories currently installed.)
Preparing to unpack mysql-apt-config_0.8.9-1_all.deb ...
Unpacking mysql-apt-config (0.8.9-1) over (0.8.7-1) ...
Setting up mysql-apt-config (0.8.9-1) ...
OK
root@ubuntu1604lts:/home/ushastry/Downloads# dpkg -l|grep mysql
ii  libmysqlclient-dev                         5.7.21-1ubuntu16.04                                 amd64        MySQL development headers
ii  libmysqlclient20:amd64                     5.7.21-1ubuntu16.04                                 amd64        MySQL shared client libraries
ii  libmysqld-dev                              5.7.21-1ubuntu16.04                                 amd64        MySQL embedded server library
ii  mysql-apt-config                           0.8.9-1                                             all          Auto configuration for MySQL APT Repo.
ii  mysql-client                               5.7.21-1ubuntu16.04                                 amd64        MySQL Client meta package depending on latest version
ii  mysql-common                               5.7.21-1ubuntu16.04                                 amd64        MySQL Common
ii  mysql-community-client                     5.7.21-1ubuntu16.04                                 amd64        MySQL Client
ii  mysql-community-server                     5.7.21-1ubuntu16.04                                 amd64        MySQL Server
ii  mysql-connector-python                     2.1.6-1ubuntu16.04                                  all          MySQL database driver written in Python
ii  mysql-router                               2.1.3-1ubuntu16.04                                  amd64        MySQL Router
ii  mysql-server                               5.7.21-1ubuntu16.04                                 amd64        MySQL Server meta package depending on latest version
ii  mysql-shell:amd64                          1.0.9-1ubuntu16.04                                  amd64        MySQL Shell
ii  mysql-utilities                            1.6.5-1ubuntu16.04                                  all          Collection of scripts for managing MySQL servers
ii  mysql-workbench-community                  6.3.10-1ubuntu16.04                                 amd64        MySQL Workbench

Could you please confirm if this issue is just with mysql-apt-config or this is happening with any other .deb packages?

Thanks,
Umesh
[19 Mar 2018 8:34] MySQL Verification Team
I can't repeat even on freshly installed VM (Ubuntu 16.04.4 LTS iso used https://www.ubuntu.com/download/desktop).

ushastry@xenialxersus:~$ cd Downloads/
ushastry@xenialxersus:~/Downloads$ cat /etc/*release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=16.04
DISTRIB_CODENAME=xenial
DISTRIB_DESCRIPTION="Ubuntu 16.04.4 LTS"
NAME="Ubuntu"
VERSION="16.04.4 LTS (Xenial Xerus)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 16.04.4 LTS"
VERSION_ID="16.04"
HOME_URL="http://www.ubuntu.com/"
SUPPORT_URL="http://help.ubuntu.com/"
BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/"
VERSION_CODENAME=xenial
UBUNTU_CODENAME=xenial
ushastry@xenialxersus:~/Downloads$ sudo dpkg -i mysql-apt-config_0.8.9-1_all.deb 
Selecting previously unselected package mysql-apt-config.
(Reading database ... 176239 files and directories currently installed.)
Preparing to unpack mysql-apt-config_0.8.9-1_all.deb ...
Unpacking mysql-apt-config (0.8.9-1) ...
Setting up mysql-apt-config (0.8.9-1) ...
OK
ushastry@xenialxersus:~/Downloads$ dpkg -l|grep -i mysql
ii  mysql-apt-config                           0.8.9-1                                      all          Auto configuration for MySQL APT Repo.
ushastry@xenialxersus:~/Downloads$ 
ushastry@xenialxersus:~/Downloads$ sudo ls -l /var/log/installer/
total 724
-rw------- 1 root   root    963 Mar 19 03:59 casper.log
-rw------- 1 root   root   2942 Mar 19 04:01 debug
-rw-rw-r-- 1 root   root 470400 Mar 19 04:11 initial-status.gz
-rw-r--r-- 1 root   root     60 Mar 19 04:11 media-info
-rw------- 1 root   root  98408 Mar 19 04:00 partman
-rw------- 1 syslog adm  150430 Mar 19 04:11 syslog
-rw------- 1 root   root     19 Mar 19 03:59 version
[19 Mar 2018 9:01] Karl Johansson
That's really weird as I'm having this issue on two separate freshly installed servers.

Is there any sort of tracing I can enable to debug further? Regarding other dpkg packages, apt-get works as expected. Is there some dummy dpkg package I can try that doesn't risk me having to reinstall the server? These are physical machine, not VMs, so it's not as simple as taking a snapshot.
[19 Mar 2018 9:18] Karl Johansson
CPU usage is also high while it's hung - see screenshot

Attachment: Capture.PNG (image/png, text), 16.52 KiB.

[19 Mar 2018 9:51] MySQL Verification Team
I tried some 5-6 times on freshly installed VMs and on those upgraded VMs - installation goes through(my VMs are inside work network).  Till this issue is confirmed at our end,  I suggest you to adding and configuring the MySQL APT repository manually as explained in the manual:

https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/#repo-qg-apt-repo-manual-setup
[19 Mar 2018 9:53] Karl Johansson
I did that already and that method works fine, everything is up and running.

I'd gladly help debug this further if you can provide instructions about what to do.
[23 Mar 2018 8:33] MySQL Verification Team
Thank you for confirming that after adding manually it works. 
Today again I attempted on few boxes(within/outside network) and still no issues. Could you please confirm results from your environment?

sudo dpkg -l|grep mysql-apt
sudo dpkg --debug=help

-- try switching to debug and see if it points to any issues(I have used 1 for progress information but you can increase it for more verbose) 

sudo dpkg -i --debug=1 mysql-apt-config_0.8.9-1_all.deb 

Thanks,
Umesh
[23 Mar 2018 10:04] Karl Johansson
dpkg -P mysql-apt-config
dpkg -i --debug=100 mysql-apt-config_0.8.9-1_all.deb

--------------------

root@hostname:~# dpkg -P mysql-apt-config
(Reading database ... 55225 files and directories currently installed.)
Removing mysql-apt-config (0.8.9-1) ...
Purging configuration files for mysql-apt-config (0.8.9-1) ...

root@hostname:~# dpkg -i --debug=1 mysql-apt-config_0.8.9-1_all.deb
D000001: ensure_diversions: new, (re)loading
D000001: ensure_statoverrides: new, (re)loading
Selecting previously unselected package mysql-apt-config.
(Reading database ... 55220 files and directories currently installed.)
Preparing to unpack mysql-apt-config_0.8.9-1_all.deb ...
D000001: process_archive oldversionstatus=not installed
Unpacking mysql-apt-config (0.8.9-1) ...
D000001: process_archive updating info directory
D000001: generating infodb hashfile
D000001: process queue pkg mysql-apt-config:all queue.len 0 progress 1, try 1
Setting up mysql-apt-config (0.8.9-1) ...
D000001: deferred_configure updating conffiles

--------------------

root@hostname:~# dpkg -P mysql-apt-config
(Reading database ... 55225 files and directories currently installed.)
Removing mysql-apt-config (0.8.9-1) ...
Purging configuration files for mysql-apt-config (0.8.9-1) ...

root@hostname:~# dpkg -i --debug=2 mysql-apt-config_0.8.9-1_all.deb
Selecting previously unselected package mysql-apt-config.
(Reading database ... 55220 files and directories currently installed.)
Preparing to unpack mysql-apt-config_0.8.9-1_all.deb ...
D000002: maintscript_new nonexistent preinst '/var/lib/dpkg/tmp.ci/preinst'
Unpacking mysql-apt-config (0.8.9-1) ...
D000002: process_archive tmp.ci script/file '/var/lib/dpkg/tmp.ci/templates' installed as '/var/lib/dpkg/info/mysql-apt-config.templates'
D000002: process_archive tmp.ci script/file '/var/lib/dpkg/tmp.ci/postinst' installed as '/var/lib/dpkg/info/mysql-apt-config.postinst'
D000002: process_archive tmp.ci script/file '/var/lib/dpkg/tmp.ci/postrm' installed as '/var/lib/dpkg/info/mysql-apt-config.postrm'
D000002: process_archive tmp.ci script/file '.' contains dot
D000002: process_archive tmp.ci script/file '/var/lib/dpkg/tmp.ci/control' is control
D000002: process_archive tmp.ci script/file '/var/lib/dpkg/tmp.ci/config' installed as '/var/lib/dpkg/info/mysql-apt-config.config'
D000002: process_archive tmp.ci script/file '..' contains dot
Setting up mysql-apt-config (0.8.9-1) ...
D000002: fork/exec /var/lib/dpkg/info/mysql-apt-config.postinst ( configure  )

--------------------

root@hostname:~# dpkg -P mysql-apt-config
(Reading database ... 55225 files and directories currently installed.)
Removing mysql-apt-config (0.8.9-1) ...
Purging configuration files for mysql-apt-config (0.8.9-1) ...

root@hostname:~# dpkg -i --debug=10 mysql-apt-config_0.8.9-1_all.deb
D000010: path_remove_tree '/var/lib/dpkg/tmp.ci'
Selecting previously unselected package mysql-apt-config.
(Reading database ... 55220 files and directories currently installed.)
Preparing to unpack mysql-apt-config_0.8.9-1_all.deb ...
Unpacking mysql-apt-config (0.8.9-1) ...
D000010: tarobject ti->name='.' mode=40755 owner=0:0 type=53(d) ti->linkname='' namenode='/.' flags=2 instead='<none>'
D000010: tarobject ti->name='./usr' mode=40755 owner=0:0 type=53(d) ti->linkname='' namenode='/usr' flags=2 instead='<none>'
D000010: tarobject ti->name='./usr/share' mode=40755 owner=0:0 type=53(d) ti->linkname='' namenode='/usr/share' flags=2 instead='<none>'
D000010: tarobject ti->name='./usr/share/doc' mode=40755 owner=0:0 type=53(d) ti->linkname='' namenode='/usr/share/doc' flags=2 instead='<none>'
D000010: tarobject ti->name='./usr/share/doc/mysql-apt-config' mode=40755 owner=0:0 type=53(d) ti->linkname='' namenode='/usr/share/doc/mysql-apt-config' flags=2 instead='<none>'
D000010: path_remove_tree '/usr/share/doc/mysql-apt-config.dpkg-new'
D000010: path_remove_tree '/usr/share/doc/mysql-apt-config.dpkg-tmp'
D000010: tarobject ti->name='./usr/share/doc/mysql-apt-config/COPYING.gz' mode=100644 owner=0:0 type=48(-) ti->linkname=''
namenode='/usr/share/doc/mysql-apt-config/COPYING.gz' flags=2 instead='<none>'
D000010: path_remove_tree '/usr/share/doc/mysql-apt-config/COPYING.gz.dpkg-new'
D000010: path_remove_tree '/usr/share/doc/mysql-apt-config/COPYING.gz.dpkg-tmp'
D000010: tarobject ti->name='./usr/share/doc/mysql-apt-config/changelog.Debian.gz' mode=100644 owner=0:0 type=48(-) ti->linkname='' namenode='/usr/share/doc/mysql-apt-config/changelog.Debian.gz' flags=2 instead='<none>'
D000010: path_remove_tree '/usr/share/doc/mysql-apt-config/changelog.Debian.gz.dpkg-new'
D000010: path_remove_tree '/usr/share/doc/mysql-apt-config/changelog.Debian.gz.dpkg-tmp'
D000010: tarobject ti->name='./usr/share/doc/mysql-apt-config/README' mode=100644 owner=0:0 type=48(-) ti->linkname='' namenode='/usr/share/doc/mysql-apt-config/README' flags=2 instead='<none>'
D000010: path_remove_tree '/usr/share/doc/mysql-apt-config/README.dpkg-new'
D000010: path_remove_tree '/usr/share/doc/mysql-apt-config/README.dpkg-tmp'
D000010: tarobject ti->name='./usr/share/doc/mysql-apt-config/copyright' mode=100644 owner=0:0 type=48(-) ti->linkname='' namenode='/usr/share/doc/mysql-apt-config/copyright' flags=2 instead='<none>'
D000010: path_remove_tree '/usr/share/doc/mysql-apt-config/copyright.dpkg-new'
D000010: path_remove_tree '/usr/share/doc/mysql-apt-config/copyright.dpkg-tmp'
D000010: deferred extract of '/.'
D000010: deferred extract of '/usr'
D000010: deferred extract of '/usr/share'
D000010: deferred extract of '/usr/share/doc'
D000010: deferred extract of '/usr/share/doc/mysql-apt-config'
D000010: deferred extract of '/usr/share/doc/mysql-apt-config/COPYING.gz'
D000010: deferred extract of '/usr/share/doc/mysql-apt-config/changelog.Debian.gz'
D000010: deferred extract of '/usr/share/doc/mysql-apt-config/README'
D000010: deferred extract of '/usr/share/doc/mysql-apt-config/copyright'
D000010: process_archive looking for overwriting '/usr/share/doc/mysql-apt-config'
D000010: process_archive looking for overwriting '/usr/share/doc/mysql-apt-config/COPYING.gz'
D000010: process_archive looking for overwriting '/usr/share/doc/mysql-apt-config/changelog.Debian.gz'
D000010: process_archive looking for overwriting '/usr/share/doc/mysql-apt-config/README'
D000010: process_archive looking for overwriting '/usr/share/doc/mysql-apt-config/copyright'
D000010: path_remove_tree '/usr.dpkg-tmp'
D000010: path_remove_tree '/usr/share.dpkg-tmp'
D000010: path_remove_tree '/usr/share/doc.dpkg-tmp'
D000010: path_remove_tree '/usr/share/doc/mysql-apt-config.dpkg-tmp'
D000010: path_remove_tree '/usr/share/doc/mysql-apt-config/COPYING.gz.dpkg-tmp'
D000010: path_remove_tree '/usr/share/doc/mysql-apt-config/changelog.Debian.gz.dpkg-tmp'
D000010: path_remove_tree '/usr/share/doc/mysql-apt-config/README.dpkg-tmp'
D000010: path_remove_tree '/usr/share/doc/mysql-apt-config/copyright.dpkg-tmp'
D000010: path_remove_tree '/var/lib/dpkg/tmp.ci'
D000010: path_remove_tree running rm -rf '/var/lib/dpkg/tmp.ci'
D000010: path_remove_tree '/var/lib/dpkg/reassemble.deb'
Setting up mysql-apt-config (0.8.9-1) ...

-----------------