Re: [vhffs] mysqlcheck

[Laurent Stella <olaulau@xxxxxxxxx>]

ok, ce patch est sorti y'a longtemps ? il est dans les paquets actuels ?

# cat /var/log/syslog | grep mysql
Feb 28 16:12:36 ks203417 mysqld: 120228 16:12:36 [Note] /usr/sbin/mysqld: Normal shutdown
Feb 28 16:12:36 ks203417 mysqld:
Feb 28 16:12:36 ks203417 mysqld: 120228 16:12:36  InnoDB: Starting shutdown...
Feb 28 16:12:39 ks203417 mysqld: 120228 16:12:39  InnoDB: Shutdown completed; log sequence number 0 89682988
Feb 28 16:12:39 ks203417 mysqld: 120228 16:12:39 [Note] /usr/sbin/mysqld: Shutdown complete
Feb 28 16:12:39 ks203417 mysqld:
Feb 28 16:12:39 ks203417 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Feb 28 16:12:40 ks203417 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Feb 28 16:12:40 ks203417 mysqld: 120228 16:12:40 [Note] Plugin 'FEDERATED' is disabled.
Feb 28 16:12:40 ks203417 mysqld: 120228 16:12:40  InnoDB: Started; log sequence number 0 89682988
Feb 28 16:12:40 ks203417 mysqld: 120228 16:12:40 [ERROR] Incorrect definition of table mysql.db: expected column 'User' at position 2 to have type char(16), found type char(32).
Feb 28 16:12:40 ks203417 mysqld: 120228 16:12:40 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
Feb 28 16:12:40 ks203417 mysqld: 120228 16:12:40 [Note] /usr/sbin/mysqld: ready for connections.
Feb 28 16:12:40 ks203417 mysqld: Version: '5.1.49-3'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)
Feb 28 16:12:40 ks203417 /etc/mysql/debian-start[4417]: Upgrading MySQL tables if necessary.
Feb 28 16:12:40 ks203417 /etc/mysql/debian-start[4420]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Feb 28 16:12:40 ks203417 /etc/mysql/debian-start[4420]: Looking for 'mysql' as: /usr/bin/mysql
Feb 28 16:12:40 ks203417 /etc/mysql/debian-start[4420]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Feb 28 16:12:40 ks203417 /etc/mysql/debian-start[4420]: This installation of MySQL is already upgraded to 5.1.49, use --force if you still need to run mysql_upgrade
Feb 28 16:12:40 ks203417 /etc/mysql/debian-start[4427]: Checking for insecure root accounts.
Feb 28 16:12:40 ks203417 /etc/mysql/debian-start[4431]: Triggering myisam-recover for all MyISAM tables
j'imagine que ce sera corrigé avec le patch aussi.

pour moi cette erreur est récente, mais je ne redémarre jamais mysql en temps normal.

2012/2/28 Sylvain Rochet <gradator@xxxxxxxxxxxx>

Salut Laurent,

On Tue, Feb 28, 2012 at 04:14:00PM +0100, Laurent Stella wrote:
> oh oui, j'ai dû faire un mysql_upgrade aussi pour "corriger" le pb, qui du
> coup apparait encore :

Ah bah voila! tout s'explique, là je comprends beaucoup mieux.

Oui mysql_upgrade change la table mysql à grand coup de tronçonneuse
pour l'adapter à la version courante de mysql, ce n'est nécessaire que
lors d'un changement de version mineure (pas de révision) de MySQL..

Dans le dernier patch, on modifie aussi mysql_upgrade, pour qu'il ne
fasse pas de mal à la table mysql, ou plutôt pour qu'il applique aussi
nos modifications ;-)

>  * Checking for corrupt, not cleanly closed and upgrade needing tables.
> # ERROR 1577 (HY000) at line 1: Cannot proceed because system tables used
> by Event Scheduler were found damaged at server start

Ya quoi dans le syslog ?


Sylvain