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

[Henry Ivey]

This happen while installing MythTV ver. 32

ProblemType: Package
DistroRelease: Ubuntu 16.04
Package: mysql-server-5.7 5.7.33-0ubuntu0.16.04.1
ProcVersionSignature: Ubuntu 4.15.0-142.146~16.04.1-generic 4.15.18
Uname: Linux 4.15.0-142-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.30
Architecture: amd64
Date: Mon Oct 24 20:42:39 2022
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationDate: Installed on 2022-10-21 (3 days ago)
InstallationMedia: Mythbuntu 16.04.6 LTS "Xenial Xerus" - Release amd64 (20190226)
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.conf.d.mythtv.cnf:
 [mysqld]
 #bind-address=::
 max_connections=100
MySQLConf.etc.mysql.conf.d.mythtv.cnf.save:
 [mysqld]
 bind-address=127.0.0.1
MySQLConf.etc.mysql.conf.d.mythtv.cnf.save.1:
 127.0.0.1[mysqld]
 bind-address=0.0.0.0
MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf:
 [mysqld_safe]
 syslog
MySQLConf.etc.mysql.mysql.conf.d.mythtv.cnf:
 [mysqld]
 #bind-address=::
 max_connections=100
MySQLVarLibDirListing: ['client-key.pem', 'ib_buffer_pool', 'mysql', 'ibdata1', 'mythconverg', 'debian-5.7.flag', 'private_key.pem', 'server-key.pem', 'client-cert.pem', 'auto.cnf', 'ca.pem', 'ib_logfile0', 'server-cert.pem', 'mysql_upgrade_info', 'ib_logfile1', 'sys', 'public_key.pem', 'ca-key.pem', 'performance_schema']
ProcCmdline: BOOT_IMAGE=/vmlinuz-4.15.0-142-generic root=/dev/mapper/mythbuntu--vg-root ro quiet splash
RelatedPackageVersions:
 dpkg 1.18.4ubuntu1.7
 apt 1.2.35
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.33-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)

[Sergio Durigan Junior (sergiodj)]

Hello,

Thank you for taking the time to file a bug and make Ubuntu better.

I see that you're using Xenial, whose standard support has ended back in 2021. For this reason, I am closing this bug as Won't Fix.

On top of that, I have quickly checked the DpkgTerminalLog.txt file attached to this bug and noticed the following snippet:

update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
ERROR: Unable to start MySQL server:
2022-10-25T01:42:39.450425Z 0 [ERROR] unknown variable 'table_cache=128'
2022-10-25T01:42:39.453029Z 0 [ERROR] Aborting

I believe this tells you what's wrong, and it seems to be a local configuration issue. I would suggest reaching out to the MySQL/Mythbuntu communities.

Thank you.