[debian-mysql] Bug#773223: (no subject)

Jean Weisbuch jean at phpnet.org
Mon Dec 15 21:30:05 UTC 2014


Which version of the packages were previously installed?

The "mysql_upgrade" script that does upgrade the "mysql" database 
structure if required after an upgrade is ran at each start/restart by 
the init script by running "/etc/mysql/debian-start" which itself run 
the "upgrade_system_tables_if_necessary" function from 
"/etc/mysql/debian-start.inc.sh" once the server is running and 
accepting requests but it only tries to connect for 30 seconds (if 
"MYSQLD_STARTUP_TIMEOUT" has not been modified) after "mysqld_safe" has 
been ran which means that if your server takes more than 30 seconds to 
accept connections (if it had to do a crash recovery start for example), 
the mysql_upgrade script wont be ran.

It means that even if the package upgrade is successful, "mysql_upgrade" 
will only be ran after the server has been started and accepting 
connection, did you still had the errors after restarting again MariaDB?

Another possibe reason why it hasnt been ran could be that the 
credentials user by mysql_upgrade located on "/etc/mysql/debian.cnf" are 
not correct, you can try to run mysql_upgrade manually with 
"mysql_upgrade --defaults-extra-file=/etc/mysql/debian.cnf", if it 
already has been ran it should output :
     This installation of MySQL is already upgraded to 10.0.15-MariaDB, 
use --force if you still need to run mysql_upgrade

If you got this message while still having the error when starting 
MariaDB you should try to force mysql_upgrade to re-run with 
"mysql_upgrade --defaults-extra-file=/etc/mysql/debian.cnf --force" then 
report the result here.
If you dont have this message but see it running it means that it hasnt 
been ran since you upgraded to 10.0.15 which shouldnt happen.



More information about the pkg-mysql-maint mailing list