Correction PB (ERROR 1577) sur Mysql

Suite à une coupure de courant, mon PC qui me sert de serveur n’a pas pû remonter correctement son filesystem et ce dernier est passé en lecture seule…
Après un fsck du sdb1 endommagé, j’ai eu l’erreur suivante sur le démarrage de Mysql :

/root@arcadia:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
root@arcadia:~# ERROR 1577 (HY000) at line 1: Cannot proceed because system tabl es used by Event Scheduler were found damaged at server start
ERROR 1547 (HY000) at line 1: Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted

Une rapide recherche sur Internet m’a donné la solution et la possibilité de mettre un nouvel article sur ce site vide 🙂

root@arcadia:~# mysql_upgrade -u root -h localhost -p –verbose –force
Enter password:
Looking for ‘mysql’ as: mysql
Looking for ‘mysqlcheck’ as: mysqlcheck
Running ‘mysqlcheck’ with connection arguments: ‘–port=3306’ ‘–socket=/var/run /mysqld/mysqld.sock’ ‘–host=localhost’
Running ‘mysqlcheck’ with connection arguments: ‘–port=3306’ ‘–socket=/var/run /mysqld/mysqld.sock’ ‘–host=localhost’
castreswireless.spip_articles OK

mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log
Error : You can’t use locks with log tables.
status : OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.servers OK
mysql.slow_log
Error : You can’t use locks with log tables.
status : OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK

Running ‘mysql_fix_privilege_tables’…
OK

root@arcadia:~#

Après avoir croisé les doigts, tout est redevenu en ordre…

root@arcadia:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
root@arcadia:~#

Laisser un commentaire

Votre adresse de messagerie ne sera pas publiée. Les champs obligatoires sont indiqués avec *