package mysql-server-5.7 5.7.23-0ubuntu0.16.04.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1

[Bhargav Anadkat]

Error came while updating custom mysql cnf file.

etc/mysql/mysql.cnf
/etc/apparmor.d/usr.sbin.mysqld

ProblemType: Package
DistroRelease: Ubuntu 16.04
Package: mysql-server-5.7 5.7.23-0ubuntu0.16.04.1
ProcVersionSignature: Ubuntu 4.15.0-32.35~16.04.1-generic 4.15.18
Uname: Linux 4.15.0-32-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.18
Architecture: amd64
Date: Sat Aug 25 10:10:38 2018
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationDate: Installed on 2018-04-07 (139 days ago)
InstallationMedia: Ubuntu 16.04.4 LTS "Xenial Xerus" - Release amd64 (20180228)
Logs.var.log.daemon.log:

MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
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: ['ib_logfile0', 'ib_logfile1', 'test_wp14', 'ib_buffer_pool', 'test_dincdailylogs', 'mysql', 'ibdata1', 'dincdailylogs2018', 'test_wp12', 'phpmyadmin', 'performance_schema', 'debian-5.7.flag', 'test_wp11', 'test_wp1', 'test_wp15', 'auto.cnf', 'sys', 'test_wp2']
ProcCmdline: BOOT_IMAGE=/vmlinuz-4.15.0-32-generic root=UUID=235dd206-4cbd-43c6-a91c-53a639dbe6f7 ro quiet splash vt.handoff=7
RelatedPackageVersions:
 dpkg 1.18.4ubuntu1.4
 apt 1.2.27
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.23-0ubuntu0.16.04.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)
modified.conffile..etc.apparmor.d.usr.sbin.mysqld: [modified]
modified.conffile..etc.mysql.mysql.cnf: [modified]
mtime.conffile..etc.apparmor.d.usr.sbin.mysqld: 2018-04-14T17:39:53.849809
mtime.conffile..etc.mysql.mysql.cnf: 2018-04-14T17:46:59.236779
upstart.mysql.override: manual

[Andreas Hasenack (ahasenack)]

Thanks for filing this bug in Ubuntu.

No idea what happened:
2018-08-25T04:40:38.044455Z 4 [ERROR] InnoDB: Operating system error number 17 in a file operation.
2018-08-25T04:40:38.044493Z 4 [ERROR] InnoDB: Error number 17 means 'File exists'
2018-08-25T04:40:38.044505Z 4 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2018-08-25T04:40:38.044515Z 4 [ERROR] InnoDB: Cannot create file './mysql/innodb_table_stats.ibd'
2018-08-25T04:40:38.044525Z 4 [ERROR] InnoDB: The file './mysql/innodb_table_stats.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. Have you moved InnoDB .ibd files around without using the SQL commands DISCARD TABLESPACE and IMPORT TABLESPACE, or did mysqld crash in the middle of CREATE TABLE? You can resolve the problem by removing the file './mysql/innodb_table_stats.ibd' under the 'datadir' of MySQL.
2018-08-25T04:41:14.564124Z 6 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
2018-08-25T04:41:14.564157Z 6 [ERROR] InnoDB: Fetch of persistent statistics requested for table `badincdailylogs2018`.`important_info` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2018-08-25T04:46:12.616491Z 61 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
2018-08-25T04:46:12.616538Z 61 [ERROR] InnoDB: Fetch of persistent statistics requested for table `blueclub-insight`.`tbl_admin_user` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2018-08-25T04:46:12.631123Z 61 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
2018-08-25T04:46:12.631159Z 61 [ERROR] InnoDB: Fetch of persistent statistics requested for table `blueclub-insight`.`tbl_log_admin` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

Maybe different directories were specified, and that broke the mysql upgrade script?

[Launchpad Janitor (janitor)]

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