Public bug reported:
The upgrade fails on postinst:
root 22338 0.0 0.0 4508 1492 ? Ss 03:18 0:00 /bin/sh
/usr/lib/apt/apt.systemd.daily
root 22682 0.4 2.0 165144 82812 ? S 03:18 1:06 \_
/usr/bin/python3 /usr/bin/unattended-upgrade
root 22717 0.1 1.7 165108 69636 ? S 03:19 0:18 \_
/usr/bin/python3 /usr/bin/unattended-upgrade
root 23944 0.0 0.1 20792 4936 pts/0 Ss+ 03:22 0:00 \_
/usr/bin/dpkg --status-fd 10 --configure mysql-client-core-5.7:amd64
mysql-client-5.7:amd64 mysql-server-core-5.7:amd64 mysql-server-5.7:amd64
libxslt1.1:amd64 mysql-client:all mysql-server:all
root 23945 0.0 0.3 61668 16052 pts/0 S+ 03:22 0:00
\_ /usr/bin/perl -w /usr/share/debconf/frontend
/var/lib/dpkg/info/mysql-server-5.7.postinst configure 5.7.17-0ubuntu0.16.04.1
root 23950 0.0 0.0 21144 3484 pts/0 S+ 03:22 0:00
\_ /bin/bash /var/lib/dpkg/info/mysql-server-5.7.postinst configure
5.7.17-0ubuntu0.16.04.1
mysql 24429 6.7 38.8 7299644 1569968 pts/0 Sl+ 03:22 17:48
\_ mysqld --user=mysql --init-file=/var/lib/mysql-files/tmp.jF2oDV8fe4
--socket=/tmp/tmp.C5IS1jXXbG/mysqld.sock
--pid-file=/tmp/tmp.C5IS1jXXbG/mysqld.pid
The init file /var/lib/mysql-files/tmp.jF2oDV8fe4 contains:
USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH 'auth_socket';
UPDATE user SET password_expired='N', account_locked='N' WHERE user='root';
FLUSH PRIVILEGES;
SHUTDOWN;
I've manually run all statements and fails on the second, don't know if this
can cause hang, tough:
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH 'auth_socket';
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'
mysql> UPDATE user SET password_expired='N', account_locked='N' WHERE
user='root';
Query OK, 0 rows affected (0,00 sec)
Rows matched: 4 Changed: 0 Warnings: 0
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0,01 sec)
After manually running SHUTDOWN the upgrade process finished correctly.
ProblemType: Bug
DistroRelease: Ubuntu 16.04
Package: mysql-server 5.7.18-0ubuntu0.16.04.1
ProcVersionSignature: Ubuntu 4.4.0-67.88-generic 4.4.49
Uname: Linux 4.4.0-67-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.5
Architecture: amd64
Date: Fri Apr 28 07:47:44 2017
InstallationDate: Installed on 2013-02-15 (1532 days ago)
InstallationMedia: Ubuntu-Server 12.04 LTS "Precise Pangolin" - Release amd64
(20120424.1)
Logs.var.log.daemon.log:
Logs.var.log.mysql.error.log:
MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
MySQLConf.etc.mysql.conf.d.mysqld_safe_syslog.cnf:
[mysqld_safe]
syslog
MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
[mysqldump]
quick
quote-names
#max_allowed_packet = 16M
max_allowed_packet = 20M
MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf:
[mysqld_safe]
syslog
MySQLVarLibDirListing: ['debian-5.7.flag', 'mysql', 'debian-5.5.flag']
PackageArchitecture: all
ProcEnviron:
TERM=xterm-256color
PATH=(custom, no user)
XDG_RUNTIME_DIR=<set>
LANG=it_IT.UTF-8
SHELL=/bin/bash
SourcePackage: mysql-5.7
UpgradeStatus: Upgraded to xenial on 2016-09-21 (218 days ago)
modified.conffile..etc.apparmor.d.usr.sbin.mysqld: [modified]
modified.conffile..etc.mysql.mysql.conf.d.mysqld.cnf: [modified]
mtime.conffile..etc.apparmor.d.usr.sbin.mysqld: 2016-12-02T09:05:19.542731
mtime.conffile..etc.mysql.mysql.conf.d.mysqld.cnf: 2017-04-03T09:29:47.752449
** Affects: mysql-5.7 (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug xenial
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1686894
Title:
mysql-server hangs on postinst script
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1686894/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
