[Bug 1795332] Re: 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

[Andreas Hasenack]

Thanks for filing this bug in Ubuntu.

This is the error:
Installing new version of config file /etc/mysql/debian-start ...
Renaming removed key_buffer and myisam-recover options (if present)
ERROR: Unable to start MySQL server:
2018-10-01T07:00:11.667268Z 0 [ERROR] unknown variable 'myisam_recover=BACKUP'
2018-10-01T07:00:11.674546Z 0 [ERROR] Aborting
Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips on fixing common upgrade issues.
Once the problem is resolved, run apt-get --fix-broken install to retry.
dpkg: error processing package mysql-server-5.7 (--configure):
 subprocess installed post-installation script returned error exit status 1

The myisam-recover option was renamed a long time ago. From the mysql 5.5 documentation:
"""
This option was renamed in MySQL 5.5.3 to --myisam-recover-options. See the description of that option for more information.
"""


Looks like the postinst script attempted to rename it:
"""
Renaming removed key_buffer and myisam-recover options (if present)
"""

Your attached /etc/mysql/mysql.conf.d/mysqld.cnf file shows it renamed:
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options  = BACKUP

But you still have it in /etc/mysql/my.cnf:
myisam_recover                          = BACKUP

I see that this file has a header that indicates it was generated by another tool:
# DO NOT CHANGE THIS FILE!
# This config is generated by SALTSTACK
# and all change will be overrided on next salt call

So I believe you need to update your "SALTSTACK" templates/scripts, and
this is not an error in the mysql packaging. I'll therefore mark this
bug as invalid.

If my analysis is incorrect, please reopen the bug stating your
reasoning.

Thanks!

** Changed in: mysql-5.7 (Ubuntu)
       Status: New => Invalid

-- 
You received this bug notification because you are a member of Ubuntu
Server, which is subscribed to mysql-5.7 in Ubuntu.
Matching subscriptions: main
https://bugs.launchpad.net/bugs/1795332

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

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1795332/+subscriptions