package mysql-server-5.7 5.7.26-0ubuntu0.16.04 failed to install/upgrade: subprocess insalled post-insallation script retourned error exi status 1
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-5.7 (Ubuntu) |
Expired
|
Undecided
|
Unassigned |
Bug Description
When upgrading from Ubuntu 14.0.5 LTS to 16 LTS, I got this error message that it is not possible to install Mysql-server-5.7 and Mysql-server.
I need a solution because I have several ubuntu serveru 14. LTS to upgrade to 18LTS.
ProblemType: Package
DistroRelease: Ubuntu 16.04
Package: mysql-server-5.7 5.7.26-
ProcVersionSign
Uname: Linux 3.2.0-32-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.18
Architecture: amd64
Date: Mon May 20 09:12:24 2019
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationDate: Installed on 2012-09-13 (2439 days ago)
InstallationMedia: Ubuntu-Server 12.04 LTS "Precise Pangolin" - Release amd64 (20120424.1)
Logs.var.
MySQLConf.
MySQLConf.
[mysqld_safe]
syslog
MySQLConf.
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
MySQLConf.
[mysqld_safe]
syslog
MySQLVarLibDirL
ProcCmdline: BOOT_IMAGE=
RelatedPackageV
dpkg 1.18.4ubuntu1.5
apt 1.2.31
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.26-
UpgradeStatus: Upgraded to xenial on 2019-05-20 (0 days ago)
tags: | removed: need-duplicate-check |
Hello, I noticed several problems in the logs:
First, it appears the filesystems may have problems:
[86759.038651] EXT4-fs (dm-0): error count: 13 start_sb: 327 start_sb: 327
[86759.038661] EXT4-fs (dm-0): initial error at 1504970654: ext4_journal_
[86759.038665] EXT4-fs (dm-0): last error at 1505132213: ext4_put_super:819
[173218.112237] EXT4-fs (dm-0): error count: 13
[173218.112241] EXT4-fs (dm-0): initial error at 1504970654: ext4_journal_
[173218.112244] EXT4-fs (dm-0): last error at 1505132213: ext4_put_super:819
Second, it appears that your mysql database has been moved and perhaps the AppArmor policy hasn't been updated to reflect the changed location.
Can you double-check your /etc/apparmor. d/local/ usr.sbin. mysqld file and make sure you've added appropriate policy lines for the new mysql data locations?
[252337.085739] type=1400 audit(155835793 9.928:45) : apparmor="DENIED" operation="open" parent=1558 profile= "/usr/sbin/ mysqld" name="/ proc/1559/ status" pid=1559 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0 9.928:46) : apparmor="DENIED" operation="open" parent=1558 profile= "/usr/sbin/ mysqld" name="/ sys/devices/ system/ node/" pid=1559 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0 9.928:47) : apparmor="DENIED" operation="open" parent=1558 profile= "/usr/sbin/ mysqld" name="/ proc/1559/ status" pid=1559 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0 9.988:48) : apparmor="DENIED" operation="mknod" parent=1558 profile= "/usr/sbin/ mysqld" name="/ data/mysql/ testflweb32. lower-test" pid=1559 comm="mysqld" requested_mask="c" denied_mask="c" fsuid=0 ouid=0 0.048:49) : apparmor="DENIED" operation="mknod" parent=1558 profile= "/usr/sbin/ mysqld" name="/ data/mysql/ testflweb32. lower-test" pid=1559 comm="mysqld" requested_mask="c" denied_mask="c" fsuid=0 ouid=0 0.048:50) : apparmor="DENIED" operation="mknod" parent=1558 profile= "/usr/sbin/ mysqld" name="/ data/mysql/ testflweb32. lower-test" pid=1559 comm="mysqld" requested_mask="c" denied_mask="c" fsuid=0 ouid=0 0.308:51) : apparmor="STATUS" operation= "profile_ replace" name="/ usr/sbin/ mysqld" pid=1573 comm="apparmor_ parser" 0.696:52) : apparmor="STATUS" operation= "profile_ replace" name="/ usr/sbin/ mysqld" pid=1624 comm="apparmor_ parser" 0.704:53) : apparmor="DENIED" operation="open" parent=1625 profile= "/usr/sbin/ mysqld" name="/ proc/1626/ status" pid=1626 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
[252337.085796] type=1400 audit(155835793
[252337.085859] type=1400 audit(155835793
[252337.147250] type=1400 audit(155835793
[252337.205848] type=1400 audit(155835794
[252337.205869] type=1400 audit(155835794
[252337.465182] type=1400 audit(155835794
[252337.854376] type=1400 audit(155835794
[252337.859040] type=1400 audit(155835794
Third, it appears your ntp daemon is being prevented from accessing the network:
[17901.858164] type=1400 audit(155812337 3.318:26) : apparmor="DENIED" operation="create" parent=1 profile= "/usr/sbin/ ntpd" pid=22481 comm="ntpd" family="unspec" sock_type="dgram" protocol=0 3.318:27) : apparmor="DENIED" operation="create" parent=1 profile= "/usr/sbin/ ntpd" pid=22481 comm="ntpd" family="unspec" sock_...
[17901.858205] type=1400 audit(155812337