[debian-mysql] Bug#843959: Bug#843959: can't upgrade if not running all the time

[Lars Tangvald]

Hi, thanks for the report.

We're aware of the general issue (installation fails if service is disabled). It's also tracked here: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1592669
The most likely solution for this is:
If service is disabled but server isn't running: Start it in a more manual way, without networking, to run mysql_upgrade.
If service is disabled but server _is_ running (meaning we can't start the new one); Print a warning asking the user to run mysql_upgrade after restarting.

--
Lars


----- jidanni at jidanni.org wrote:

> Package: mysql-server
> Version: 5.7.16-1
> 
> Some of us don't see the point of having mysql running all the time.
> 
> So we disable it.
> 
> This causes:
> Setting up mysql-server-5.7 (5.7.16-1) ...
> insserv: warning: current start runlevel(s) (empty) of script `mysql'
> overrides LSB defaults (2 3 4 5).
> insserv: warning: current stop runlevel(s) (0 1 2 3 4 5 6) of script
> `mysql' overrides LSB defaults (0 1 6).
> mysql_upgrade: Got error: 2002: Can't connect to local MySQL server
> through socket '/var/run/mysqld/mysqld.sock' (2) while connecting to
> the MySQL server
> Upgrade process encountered error and will not continue.
> mysql_upgrade failed with exit status 11
> dpkg: error processing package mysql-server-5.7 (--configure):
>  subprocess installed post-installation script returned error exit
> status 1
> dpkg: dependency problems prevent configuration of mysql-server:
>  mysql-server depends on mysql-server-5.7; however:
>   Package mysql-server-5.7 is not configured yet.
> 
> dpkg: error processing package mysql-server (--configure):
>  dependency problems - leaving unconfigured
> Errors were encountered while processing:
>  mysql-server-5.7
>  mysql-server
> 
> upon every upgrade.
> 
> Well why don't you start the server in this case,
> or have a configuration item:
> if $user_approves_is_set
> then
>         start mysql
>         do upgrade
>         stop mysql
> fi
> 
> _______________________________________________
> pkg-mysql-maint mailing list
> pkg-mysql-maint at lists.alioth.debian.org
> http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mysql-maint