[Bug 1612517] Re: Server fails to start after upgrade because of customized config and obsolete/renamed directives

[Andreas Hasenack]

** Description changed:

  Separate from LP: #1571865 because this concerns options we don't try to
  automatically fix.
  
  When users upgrade from 5.5 (and especially if that was also an upgrade
  from earlier versions) and have custom configs, 5.7 may refuse to start
  because the config contains options that have been removed.
+ 
+ By "custom config", we actually mean two possibilities:
+ a) non-default config file (like /etc/mysql/my.cnf)
+ b) non-default config option (like NO_AUTO_CREATE_USER, which was dropped in 8)
  
  Options may have been removed due to becoming obsolete, or due to being
  renamed. Postinst will print the offending option to the terminal, but
  this might not be apparent in the text dump from a large upgrade
  operation.
  
  http://dev.mysql.com/doc/refman/5.7/en/mysqld-option-tables.html has a
  list of options that will be accepted for 5.7
  
  The advantage of the current solution (print option name and throw error) is that after fixing the config, apt-get -f install should complete the upgrade fully.
  The disadvantage is that it will abort the upgrade process, which might be a full distro upgrade.
  
  The alternative would be to print a warning, which might not be noticed,
  and complete the install without running mysql_upgrade or starting the
  service.

** Description changed:

  Separate from LP: #1571865 because this concerns options we don't try to
  automatically fix.
  
  When users upgrade from 5.5 (and especially if that was also an upgrade
  from earlier versions) and have custom configs, 5.7 may refuse to start
- because the config contains options that have been removed.
+ because the config contains options that have been removed. The same can
+ happen with any other upgrade, like from 5.7 to 8.0.
  
  By "custom config", we actually mean two possibilities:
  a) non-default config file (like /etc/mysql/my.cnf)
- b) non-default config option (like NO_AUTO_CREATE_USER, which was dropped in 8)
+ b) non-default config option (like NO_AUTO_CREATE_USER, which was dropped in 8, but was never part of the default config files shipped with the package)
  
  Options may have been removed due to becoming obsolete, or due to being
  renamed. Postinst will print the offending option to the terminal, but
  this might not be apparent in the text dump from a large upgrade
  operation.
  
  http://dev.mysql.com/doc/refman/5.7/en/mysqld-option-tables.html has a
  list of options that will be accepted for 5.7
  
  The advantage of the current solution (print option name and throw error) is that after fixing the config, apt-get -f install should complete the upgrade fully.
  The disadvantage is that it will abort the upgrade process, which might be a full distro upgrade.
  
  The alternative would be to print a warning, which might not be noticed,
  and complete the install without running mysql_upgrade or starting the
  service.

** Also affects: mysql-8.0 (Ubuntu)
   Importance: Undecided
       Status: New

** Changed in: mysql-8.0 (Ubuntu)
       Status: New => Confirmed

** Changed in: mysql-8.0 (Ubuntu)
   Importance: Undecided => Medium

-- 
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/1612517

Title:
  Server fails to start after upgrade because of customized config and
  obsolete/renamed directives

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