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

[Greg Raven]

Trying to do an upgrade of my 14 system using sudo apt-get dist-upgrade

ProblemType: Package
DistroRelease: Ubuntu 16.04
Package: mysql-server-5.7 5.7.31-0ubuntu0.16.04.1
ProcVersionSignature: Ubuntu 3.13.0-182.233-generic 3.13.11-ckt39
Uname: Linux 3.13.0-182-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.25
Architecture: amd64
Date: Sun Oct 25 10:13:26 2020
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationDate: Installed on 2014-04-18 (2381 days ago)
InstallationMedia:

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.mysqld_slow_log.cnf:
 [mysqld]
 log_slow_queries = /var/log/mysql/mysql-slow.log
 long_query_time = 0.1
 #log-queries-not-using-indexes
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: ['debian-5.5.flag', 'ib_logfile1', 'ib_logfile0', 'performance_schema', 'ibdata1', 'mysql_upgrade_info', 'mysql', 'hporg@002dwp@002dfy8TDPyv']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-3.13.0-182-generic root=UUID=050e1e34-39e6-4072-a03e-ae0bf90ba13a ro
RelatedPackageVersions:
 dpkg 1.18.4ubuntu1.6
 apt 1.2.32ubuntu0.1
SourcePackage: mysql-5.7
Title: package mysql-server-5.7 5.7.31-0ubuntu0.16.04.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: Upgraded to xenial on 2020-10-25 (0 days ago)

[Christian Ehrhardt  (paelzer)]

From your log:

ERROR: Unable to start MySQL server:
2020-10-25T14:13:25.927849Z 0 [ERROR] unknown variable 'log_slow_queries=/var/log/mysql/mysql-slow.log'
2020-10-25T14:13:25.932353Z 0 [ERROR] Aborting
Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips on fixing common upgrade issues.

This is a confirugation error that the newer version doesn't support anymore.
Answered plenty of times on the internet like (my first find) https://stackoverflow.com/questions/20136926/why-does-log-slow-queries-break-my-cnf

[Christian Ehrhardt  (paelzer)]

Thank you for your report.

This looks like a local configuration problem, rather than a bug in Ubuntu.

You can find pointers to get help for this sort of problem here: http://www.ubuntu.com/support/community

Since we use this bug tracker to track bugs in Ubuntu, rather than configuration problems, I'm marking this bug as Invalid. This helps us to focus on fixing bugs in Ubuntu.

If you believe that this is really a bug, then you may find it helpful to read "How to report bugs effectively" http://www.chiark.greenend.org.uk/~sgtatham/bugs.html. We'd be grateful if you would then provide a more complete description of the problem, explain why you believe this is a bug in Ubuntu rather than a problem specific to your system, and then change the bug status back to New.

[Launchpad Janitor (janitor)]

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