[debian-mysql] Bug#415124: unattended-upgrade causes MySQL to stop

[Lonnie Olson]

I can confirm that this bug *is* a grave issue.  I had 3 servers stop
MySQL services during an unattended upgrade.

2008-11-22 06:46:03,870 INFO Initial blacklisted packages: 
2008-11-22 06:46:03,870 INFO Starting unattended upgrades script
2008-11-22 06:46:03,870 INFO Allowed origins are: ["['Ubuntu',
'hardy-security']"]
2008-11-22 06:46:14,226 WARNING pkg 'mysql-common' has conffile prompt
and needs to be upgraded manually
2008-11-22 06:46:15,321 INFO package 'mysql-common' not upgraded
2008-11-22 06:46:16,038 INFO package 'mysql-client-5.0' not upgraded
2008-11-22 06:46:16,752 INFO package 'libmysqlclient15off' not upgraded
2008-11-22 06:46:17,470 INFO package 'mysql-server-5.0' not upgraded
2008-11-22 06:46:18,182 INFO Packages that are upgraded: mysql-server
2008-11-22 06:46:18,182 INFO Writing dpkg log to
'/var/log/unattended-upgrades/unattended-upgrades-dpkg_2008-11-22_06:46:18.182579.log'
2008-11-22 06:46:22,840 INFO All upgrades installed

and the actual dpkg log

(Reading database ... 53756 files and directories currently installed.)
Preparing to replace mysql-server 5.0.51a-3ubuntu5.1 (using
.../mysql-server_5.0.51a-3ubuntu5.4_all.deb) ...
 * Stopping MySQL database server mysqld
   ...done.
Unpacking replacement mysql-server ...
Setting up mysql-server (5.0.51a-3ubuntu5.4) ...


Hence, since mysql-server-5.0 is held back due to conffile prompt, it
causes MySQL to stop.  Very grave indeed.

Solutions may include:
* Remove the preinst script from "mysql-server"
or 
* Add a postinst script to start mysql in "mysql-server"

--lonnie