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

Bug #1829753 reported by crp laval
8
This bug affects 1 person
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-0ubuntu0.16.04.1
ProcVersionSignature: Ubuntu 3.2.0-32.51-generic 3.2.30
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.log.daemon.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
MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: ['typo3_com_schema_dev', 'schema_60173115612198658', 'ib_logfile1', 'mysql', 'schema_60173115612198658_dev', 'typo3_com_schema', 'debian-5.5.flag', 'performance_schema', 'typo3_dev', 'schema_42787631542922841', 'ibdata1', 'schema_56666248816403611_dev', 'typo3_i2', 'ib_logfile0', 'debian-5.7.flag', 'schema_89614666756947876', 'schema_56666248816403611', 'ftsr_350', 'schema_89614666756947876_dev', 'schema_34172755111414497', 'typo3', 'mysql_upgrade_info', 'typo3_i3']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-3.2.0-32-generic root=UUID=4e685a63-09ba-47d2-887f-cde6dbd8e5e8 ro
RelatedPackageVersions:
 dpkg 1.18.4ubuntu1.5
 apt 1.2.31
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.26-0ubuntu0.16.04.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: Upgraded to xenial on 2019-05-20 (0 days ago)

Revision history for this message
crp laval (crplaval) wrote :
tags: removed: need-duplicate-check
Revision history for this message
Seth Arnold (seth-arnold) wrote :
Download full text (3.8 KiB)

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
[86759.038661] EXT4-fs (dm-0): initial error at 1504970654: ext4_journal_start_sb:327
[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_start_sb:327
[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(1558357939.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
[252337.085796] type=1400 audit(1558357939.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
[252337.085859] type=1400 audit(1558357939.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
[252337.147250] type=1400 audit(1558357939.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
[252337.205848] type=1400 audit(1558357940.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
[252337.205869] type=1400 audit(1558357940.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
[252337.465182] type=1400 audit(1558357940.308:51): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=1573 comm="apparmor_parser"
[252337.854376] type=1400 audit(1558357940.696:52): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=1624 comm="apparmor_parser"
[252337.859040] type=1400 audit(1558357940.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

Third, it appears your ntp daemon is being prevented from accessing the network:

[17901.858164] type=1400 audit(1558123373.318:26): apparmor="DENIED" operation="create" parent=1 profile="/usr/sbin/ntpd" pid=22481 comm="ntpd" family="unspec" sock_type="dgram" protocol=0
[17901.858205] type=1400 audit(1558123373.318:27): apparmor="DENIED" operation="create" parent=1 profile="/usr/sbin/ntpd" pid=22481 comm="ntpd" family="unspec" sock_...

Read more...

Revision history for this message
Andreas Hasenack (ahasenack) wrote :

Thanks for triaging this, Seth. I'll mark the bug as incomplete until more data is provided.

Changed in mysql-5.7 (Ubuntu):
status: New → Incomplete
Revision history for this message
crp laval (crplaval) wrote : Re: [Bug 1829753] Re: 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
Download full text (6.7 KiB)

Thank you for your answer, could you tell me a little about MYSQL and
also what modul to install for typo3?
MYSQL 5.6 and PHP7.0
Thanks again.

Le lun. 20 mai 2019 à 19:10, Seth Arnold <email address hidden> a
écrit :

> 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
> [86759.038661] EXT4-fs (dm-0): initial error at 1504970654:
> ext4_journal_start_sb:327
> [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_start_sb:327
> [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(1558357939.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
> [252337.085796] type=1400 audit(1558357939.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
> [252337.085859] type=1400 audit(1558357939.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
> [252337.147250] type=1400 audit(1558357939.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
> [252337.205848] type=1400 audit(1558357940.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
> [252337.205869] type=1400 audit(1558357940.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
> [252337.465182] type=1400 audit(1558357940.308:51): apparmor="STATUS"
> operation="profile_replace" name="/usr/sbin/mysqld" pid=1573
> comm="apparmor_parser"
> [252337.854376] type=1400 audit(1558357940.696:52): apparmor="STATUS"
> operation="profile_replace" name="/usr/sbin/mysqld" pid=1624
> comm="apparmor_parser"
> [252337.859040] type=1400 audit(1558357940.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
>
> Third, it appears your ntp daemon is being prevented from accessing the
> network:
>
> [17901.858164] ...

Read more...

Revision history for this message
crp laval (crplaval) wrote :

Thank you for your answer, could you tell me a little about MYSQL and
also what modul to install for typo3?
MYSQL 5.6 and PHP7.0
Thanks again.

Le mar. 21 mai 2019 à 15:40, Andreas Hasenack <email address hidden> a
écrit :

> Thanks for triaging this, Seth. I'll mark the bug as incomplete until
> more data is provided.
>
> ** Changed in: mysql-5.7 (Ubuntu)
> Status: New => Incomplete
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1829753
>
> Title:
> 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
>
> Status in mysql-5.7 package in Ubuntu:
> Incomplete
>
> 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-0ubuntu0.16.04.1
> ProcVersionSignature: Ubuntu 3.2.0-32.51-generic 3.2.30
> 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.log.daemon.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
> MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf:
> [mysqld_safe]
> syslog
> MySQLVarLibDirListing: ['typo3_com_schema_dev',
> 'schema_60173115612198658', 'ib_logfile1', 'mysql',
> 'schema_60173115612198658_dev', 'typo3_com_schema', 'debian-5.5.flag',
> 'performance_schema', 'typo3_dev', 'schema_42787631542922841', 'ibdata1',
> 'schema_56666248816403611_dev', 'typo3_i2', 'ib_logfile0',
> 'debian-5.7.flag', 'schema_89614666756947876', 'schema_56666248816403611',
> 'ftsr_350', 'schema_89614666756947876_dev', 'schema_34172755111414497',
> 'typo3', 'mysql_upgrade_info', 'typo3_i3']
> ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-3.2.0-32-generic
> root=UUID=4e685a63-09ba-47d2-887f-cde6dbd8e5e8 ro
> RelatedPackageVersions:
> dpkg 1.18.4ubuntu1.5
> apt 1.2.31
> SourcePackage: mysql-5.7
> Title: package mysql-server-5.7 5.7.26-0ubuntu0.16.04.1 failed to
> install/upgrade: subprocess installed post-installation script returned
> error exit status 1
> UpgradeStatus: Upgraded to xenial on 2019-05-20 (0 days ago)
>
> To manage notifications about this bug go to:
>
> https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1829753/+subscriptions
>

Revision history for this message
Launchpad Janitor (janitor) wrote :

[Expired for mysql-5.7 (Ubuntu) because there has been no activity for 60 days.]

Changed in mysql-5.7 (Ubuntu):
status: Incomplete → Expired
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.