** 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 -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
