Comment 7 for bug 1612517

Revision history for this message
Cygnus (cygnusnsf) wrote : Re: [Bug 1612517] Re: Server fails to start after upgrade because of customized config and obsolete/renamed directives

Robie even

On Tue, 19 Nov 2019, 17:34 Neale Francis, <email address hidden> wrote:

> Thanks will do have a look cheers Robbie
>
> On Tue, 19 Nov 2019, 11:46 Robie Basak, <email address hidden>
> 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
>>
>