[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