Thanks will do have a look cheers Robbie On Tue, 19 Nov 2019, 11:46 Robie Basak, <1612...@bugs.launchpad.net> wrote:
> We're getting some additional duplicates of this bug against MySQL 8.0. > It might be an idea to look through the recent dupes and try to identify > a list of common failures that we could automatically attempt to fix in > postinst. > > -- > You received this bug notification because you are subscribed to a > duplicate bug report (1852758). > https://bugs.launchpad.net/bugs/1612517 > > Title: > Server fails to start after upgrade because of customized config and > obsolete/renamed directives > > Status in mysql-5.7 package in Ubuntu: > Confirmed > Status in mysql-8.0 package in Ubuntu: > Confirmed > > Bug description: > 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. > 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, 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. > > To manage notifications about this bug go to: > > https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1612517/+subscriptions > -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. 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-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs