> Can you give me more information: > * From which version did you upgrade or was it a fresh install
I don't know exactly. I just did a fresh install about 3/4 months ago and daily I run "aptitude update; aptitute upgrade". I remembered that one or two times the package was upgraded to new release. I had the same problem in another machine. I solved removing the package and all under /var/lib/mysql and after I reinstalled the package. > * Can you send me everything from "grep mysql /var/log/syslog > /var/log/auth.log" /var/log/syslog:Feb 19 16:56:44 localhost mysqld_safe[4310]: started /var/log/syslog:Feb 19 16:56:45 localhost mysqld[4313]: 070219 16:56:45 InnoDB: Database was not shut down normally! /var/log/syslog:Feb 19 16:56:45 localhost mysqld[4313]: InnoDB: Starting crash recovery. /var/log/syslog:Feb 19 16:56:45 localhost mysqld[4313]: InnoDB: Reading tablespace information from the .ibd files... /var/log/syslog:Feb 19 16:56:45 localhost mysqld[4313]: InnoDB: Restoring possible half-written data pages from the doublewrite /var/log/syslog:Feb 19 16:56:45 localhost mysqld[4313]: InnoDB: buffer... /var/log/syslog:Feb 19 16:56:45 localhost mysqld[4313]: 070219 16:56:45 InnoDB: Starting log scan based on checkpoint at /var/log/syslog:Feb 19 16:56:45 localhost mysqld[4313]: InnoDB: log sequence number 0 107874. /var/log/syslog:Feb 19 16:56:45 localhost mysqld[4313]: InnoDB: Doing recovery: scanned up to log sequence number 0 107874 /var/log/syslog:Feb 19 16:56:45 localhost mysqld[4313]: InnoDB: Last MySQL binlog file position 0 39010, file name /var/log/mysql/mysql-bin.000008 /var/log/syslog:Feb 19 16:56:45 localhost mysqld[4313]: 070219 16:56:45 InnoDB: Started; log sequence number 0 107874 /var/log/syslog:Feb 19 16:56:45 localhost mysqld[4313]: 070219 16:56:45 [Note] Recovering after a crash using /var/log/mysql/mysql-bin /var/log/syslog:Feb 19 16:56:45 localhost mysqld[4313]: 070219 16:56:45 [Note] Starting crash recovery... /var/log/syslog:Feb 19 16:56:45 localhost mysqld[4313]: 070219 16:56:45 [Note] Crash recovery finished. /var/log/syslog:Feb 19 16:56:46 localhost mysqld[4313]: 070219 16:56:46 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'host' /var/log/syslog:Feb 19 16:56:46 localhost mysqld_safe[4333]: ended /var/log/syslog:Feb 19 16:56:59 localhost /etc/init.d/mysql[4459]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in /var/log/syslog:Feb 19 16:56:59 localhost /etc/init.d/mysql[4459]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed /var/log/syslog:Feb 19 16:56:59 localhost /etc/init.d/mysql[4459]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' /var/log/syslog:Feb 19 16:56:59 localhost /etc/init.d/mysql[4459]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! /var/log/syslog:Feb 19 16:56:59 localhost /etc/init.d/mysql[4459]: /var/log/syslog:Feb 19 21:35:49 localhost mysqld_safe[4305]: started /var/log/syslog:Feb 19 21:35:49 localhost mysqld[4308]: 070219 21:35:49 InnoDB: Database was not shut down normally! /var/log/syslog:Feb 19 21:35:49 localhost mysqld[4308]: InnoDB: Starting crash recovery. /var/log/syslog:Feb 19 21:35:49 localhost mysqld[4308]: InnoDB: Reading tablespace information from the .ibd files... /var/log/syslog:Feb 19 21:35:50 localhost mysqld[4308]: InnoDB: Restoring possible half-written data pages from the doublewrite /var/log/syslog:Feb 19 21:35:50 localhost mysqld[4308]: InnoDB: buffer... /var/log/syslog:Feb 19 21:35:50 localhost mysqld[4308]: 070219 21:35:50 InnoDB: Starting log scan based on checkpoint at /var/log/syslog:Feb 19 21:35:50 localhost mysqld[4308]: InnoDB: log sequence number 0 107874. /var/log/syslog:Feb 19 21:35:50 localhost mysqld[4308]: InnoDB: Doing recovery: scanned up to log sequence number 0 107874 /var/log/syslog:Feb 19 21:35:50 localhost mysqld[4308]: InnoDB: Last MySQL binlog file position 0 39010, file name /var/log/mysql/mysql-bin.000008 /var/log/syslog:Feb 19 21:35:50 localhost mysqld[4308]: 070219 21:35:50 InnoDB: Started; log sequence number 0 107874 /var/log/syslog:Feb 19 21:35:50 localhost mysqld[4308]: 070219 21:35:50 [Note] Recovering after a crash using /var/log/mysql/mysql-bin /var/log/syslog:Feb 19 21:35:50 localhost mysqld[4308]: 070219 21:35:50 [Note] Starting crash recovery... /var/log/syslog:Feb 19 21:35:50 localhost mysqld[4308]: 070219 21:35:50 [Note] Crash recovery finished. /var/log/syslog:Feb 19 21:35:50 localhost mysqld[4308]: 070219 21:35:50 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'host' /var/log/syslog:Feb 19 21:35:50 localhost mysqld_safe[4328]: ended /var/log/syslog:Feb 19 21:36:03 localhost /etc/init.d/mysql[4454]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in /var/log/syslog:Feb 19 21:36:03 localhost /etc/init.d/mysql[4454]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed /var/log/syslog:Feb 19 21:36:03 localhost /etc/init.d/mysql[4454]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' /var/log/syslog:Feb 19 21:36:03 localhost /etc/init.d/mysql[4454]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! /var/log/syslog:Feb 19 21:36:03 localhost /etc/init.d/mysql[4454]: /var/log/syslog:Feb 20 11:02:51 localhost mysqld_safe[4306]: started /var/log/syslog:Feb 20 11:02:52 localhost mysqld[4309]: 070220 11:02:52 InnoDB: Database was not shut down normally! /var/log/syslog:Feb 20 11:02:52 localhost mysqld[4309]: InnoDB: Starting crash recovery. /var/log/syslog:Feb 20 11:02:52 localhost mysqld[4309]: InnoDB: Reading tablespace information from the .ibd files... /var/log/syslog:Feb 20 11:02:52 localhost mysqld[4309]: InnoDB: Restoring possible half-written data pages from the doublewrite /var/log/syslog:Feb 20 11:02:52 localhost mysqld[4309]: InnoDB: buffer... /var/log/syslog:Feb 20 11:02:52 localhost mysqld[4309]: 070220 11:02:52 InnoDB: Starting log scan based on checkpoint at /var/log/syslog:Feb 20 11:02:52 localhost mysqld[4309]: InnoDB: log sequence number 0 107874. /var/log/syslog:Feb 20 11:02:52 localhost mysqld[4309]: InnoDB: Doing recovery: scanned up to log sequence number 0 107874 /var/log/syslog:Feb 20 11:02:52 localhost mysqld[4309]: InnoDB: Last MySQL binlog file position 0 39010, file name /var/log/mysql/mysql-bin.000008 /var/log/syslog:Feb 20 11:02:52 localhost mysqld[4309]: 070220 11:02:52 InnoDB: Started; log sequence number 0 107874 /var/log/syslog:Feb 20 11:02:52 localhost mysqld[4309]: 070220 11:02:52 [Note] Recovering after a crash using /var/log/mysql/mysql-bin /var/log/syslog:Feb 20 11:02:52 localhost mysqld[4309]: 070220 11:02:52 [Note] Starting crash recovery... /var/log/syslog:Feb 20 11:02:52 localhost mysqld[4309]: 070220 11:02:52 [Note] Crash recovery finished. /var/log/syslog:Feb 20 11:02:52 localhost mysqld[4309]: 070220 11:02:52 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'host' /var/log/syslog:Feb 20 11:02:52 localhost mysqld_safe[4329]: ended /var/log/syslog:Feb 20 11:03:05 localhost /etc/init.d/mysql[4455]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in /var/log/syslog:Feb 20 11:03:05 localhost /etc/init.d/mysql[4455]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed /var/log/syslog:Feb 20 11:03:05 localhost /etc/init.d/mysql[4455]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' /var/log/syslog:Feb 20 11:03:05 localhost /etc/init.d/mysql[4455]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! /var/log/syslog:Feb 20 11:03:05 localhost /etc/init.d/mysql[4455]: /var/log/syslog:Feb 20 11:04:43 localhost mysqld_safe[5421]: started /var/log/syslog:Feb 20 11:04:43 localhost mysqld[5424]: 070220 11:04:43 InnoDB: Database was not shut down normally! /var/log/syslog:Feb 20 11:04:43 localhost mysqld[5424]: InnoDB: Starting crash recovery. /var/log/syslog:Feb 20 11:04:43 localhost mysqld[5424]: InnoDB: Reading tablespace information from the .ibd files... /var/log/syslog:Feb 20 11:04:43 localhost mysqld[5424]: InnoDB: Restoring possible half-written data pages from the doublewrite /var/log/syslog:Feb 20 11:04:43 localhost mysqld[5424]: InnoDB: buffer... /var/log/syslog:Feb 20 11:04:43 localhost mysqld[5424]: 070220 11:04:43 InnoDB: Starting log scan based on checkpoint at /var/log/syslog:Feb 20 11:04:43 localhost mysqld[5424]: InnoDB: log sequence number 0 107874. /var/log/syslog:Feb 20 11:04:43 localhost mysqld[5424]: InnoDB: Doing recovery: scanned up to log sequence number 0 107874 /var/log/syslog:Feb 20 11:04:44 localhost mysqld[5424]: InnoDB: Last MySQL binlog file position 0 39010, file name /var/log/mysql/mysql-bin.000008 /var/log/syslog:Feb 20 11:04:44 localhost mysqld[5424]: 070220 11:04:44 InnoDB: Started; log sequence number 0 107874 /var/log/syslog:Feb 20 11:04:44 localhost mysqld[5424]: 070220 11:04:44 [Note] Recovering after a crash using /var/log/mysql/mysql-bin /var/log/syslog:Feb 20 11:04:44 localhost mysqld[5424]: 070220 11:04:44 [Note] Starting crash recovery... /var/log/syslog:Feb 20 11:04:44 localhost mysqld[5424]: 070220 11:04:44 [Note] Crash recovery finished. /var/log/syslog:Feb 20 11:04:44 localhost mysqld[5424]: 070220 11:04:44 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'host' /var/log/syslog:Feb 20 11:04:44 localhost mysqld_safe[5435]: ended /var/log/syslog:Feb 20 11:04:59 localhost /etc/init.d/mysql[5597]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in /var/log/syslog:Feb 20 11:04:59 localhost /etc/init.d/mysql[5597]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed /var/log/syslog:Feb 20 11:04:59 localhost /etc/init.d/mysql[5597]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' /var/log/syslog:Feb 20 11:04:59 localhost /etc/init.d/mysql[5597]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! /var/log/syslog:Feb 20 11:04:59 localhost /etc/init.d/mysql[5597]: /var/log/syslog:Feb 20 14:54:47 localhost mysqld_safe[9048]: started /var/log/syslog:Feb 20 14:54:47 localhost mysqld[9051]: 070220 14:54:47 InnoDB: Database was not shut down normally! /var/log/syslog:Feb 20 14:54:47 localhost mysqld[9051]: InnoDB: Starting crash recovery. /var/log/syslog:Feb 20 14:54:47 localhost mysqld[9051]: InnoDB: Reading tablespace information from the .ibd files... /var/log/syslog:Feb 20 14:54:47 localhost mysqld[9051]: InnoDB: Restoring possible half-written data pages from the doublewrite /var/log/syslog:Feb 20 14:54:47 localhost mysqld[9051]: InnoDB: buffer... /var/log/syslog:Feb 20 14:54:47 localhost mysqld[9051]: 070220 14:54:47 InnoDB: Starting log scan based on checkpoint at /var/log/syslog:Feb 20 14:54:47 localhost mysqld[9051]: InnoDB: log sequence number 0 107874. /var/log/syslog:Feb 20 14:54:47 localhost mysqld[9051]: InnoDB: Doing recovery: scanned up to log sequence number 0 107874 /var/log/syslog:Feb 20 14:54:47 localhost mysqld[9051]: InnoDB: Last MySQL binlog file position 0 39010, file name /var/log/mysql/mysql-bin.000008 /var/log/syslog:Feb 20 14:54:47 localhost mysqld[9051]: 070220 14:54:47 InnoDB: Started; log sequence number 0 107874 /var/log/syslog:Feb 20 14:54:47 localhost mysqld[9051]: 070220 14:54:47 [Note] Recovering after a crash using /var/log/mysql/mysql-bin /var/log/syslog:Feb 20 14:54:47 localhost mysqld[9051]: 070220 14:54:47 [Note] Starting crash recovery... /var/log/syslog:Feb 20 14:54:47 localhost mysqld[9051]: 070220 14:54:47 [Note] Crash recovery finished. /var/log/syslog:Feb 20 14:54:47 localhost mysqld[9051]: 070220 14:54:47 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'host' /var/log/syslog:Feb 20 14:54:47 localhost mysqld_safe[9062]: ended /var/log/syslog:Feb 20 14:55:02 localhost /etc/init.d/mysql[9198]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in /var/log/syslog:Feb 20 14:55:02 localhost /etc/init.d/mysql[9198]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed /var/log/syslog:Feb 20 14:55:02 localhost /etc/init.d/mysql[9198]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' /var/log/syslog:Feb 20 14:55:02 localhost /etc/init.d/mysql[9198]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! /var/log/syslog:Feb 20 14:55:02 localhost /etc/init.d/mysql[9198]: > * The output of "ls -al /var/lib/mysql/mysql/" total 656 drwxr-xr-x 2 mysql mysql 4096 2007-02-13 12:36 . drwxr-xr-x 16 mysql mysql 4096 2007-02-20 14:54 .. -rw-rw---- 1 mysql mysql 8820 2007-02-13 12:36 columns_priv.frm -rw-rw---- 1 mysql mysql 0 2007-02-13 12:36 columns_priv.MYD -rw-rw---- 1 mysql mysql 1024 2007-02-13 12:36 columns_priv.MYI -rw-rw---- 1 mysql mysql 9494 2007-02-13 12:36 db.frm -rw-rw---- 1 mysql mysql 0 2007-02-13 12:36 db.MYD -rw-rw---- 1 mysql mysql 1024 2007-02-13 12:36 db.MYI -rw-rw---- 1 mysql mysql 8665 2007-02-13 12:36 func.frm -rw-rw---- 1 mysql mysql 0 2007-02-13 12:36 func.MYD -rw-rw---- 1 mysql mysql 1024 2007-02-13 12:36 func.MYI -rw-rw---- 1 mysql mysql 8700 2006-11-11 18:03 help_category.frm -rw-rw---- 1 mysql mysql 20916 2007-02-03 22:04 help_category.MYD -rw-rw---- 1 mysql mysql 3072 2007-02-03 22:04 help_category.MYI -rw-rw---- 1 mysql mysql 8612 2006-11-11 18:03 help_keyword.frm -rw-rw---- 1 mysql mysql 75254 2007-02-03 22:04 help_keyword.MYD -rw-rw---- 1 mysql mysql 15360 2007-02-03 22:04 help_keyword.MYI -rw-rw---- 1 mysql mysql 8630 2006-11-11 18:03 help_relation.frm -rw-rw---- 1 mysql mysql 6624 2007-02-03 22:04 help_relation.MYD -rw-rw---- 1 mysql mysql 13312 2007-02-03 22:04 help_relation.MYI -rw-rw---- 1 mysql mysql 8770 2006-11-11 18:03 help_topic.frm -rw-rw---- 1 mysql mysql 269424 2007-02-03 22:04 help_topic.MYD -rw-rw---- 1 mysql mysql 17408 2007-02-03 22:04 help_topic.MYI -rw-rw---- 1 mysql mysql 9416 2007-02-13 12:36 host.frm -rw-rw---- 1 mysql mysql 0 2007-02-13 12:36 host.MYD -rw-rw---- 1 mysql mysql 1024 2007-02-13 12:36 host.MYI -rw-rw---- 1 mysql mysql 9691 2007-02-13 12:36 proc.frm -rw-rw---- 1 mysql mysql 0 2007-02-13 12:36 proc.MYD -rw-rw---- 1 mysql mysql 1024 2007-02-13 12:36 proc.MYI -rw-rw---- 1 mysql mysql 8875 2007-02-13 12:36 procs_priv.frm -rw-rw---- 1 mysql mysql 0 2007-02-13 12:36 procs_priv.MYD -rw-rw---- 1 mysql mysql 1024 2007-02-13 12:36 procs_priv.MYI -rw-rw---- 1 mysql mysql 8947 2007-02-13 12:36 tables_priv.frm -rw-rw---- 1 mysql mysql 0 2007-02-13 12:36 tables_priv.MYD -rw-rw---- 1 mysql mysql 1024 2007-02-13 12:36 tables_priv.MYI -rw-rw---- 1 mysql mysql 8636 2007-02-13 12:36 time_zone.frm -rw-rw---- 1 mysql mysql 8624 2006-11-11 18:03 time_zone_leap_second.frm -rw-rw---- 1 mysql mysql 0 2006-11-11 18:03 time_zone_leap_second.MYD -rw-rw---- 1 mysql mysql 1024 2006-11-11 18:03 time_zone_leap_second.MYI -rw-rw---- 1 mysql mysql 0 2007-02-13 12:36 time_zone.MYD -rw-rw---- 1 mysql mysql 1024 2007-02-13 12:36 time_zone.MYI -rw-rw---- 1 mysql mysql 8606 2006-11-11 18:03 time_zone_name.frm -rw-rw---- 1 mysql mysql 0 2006-11-11 18:03 time_zone_name.MYD -rw-rw---- 1 mysql mysql 1024 2006-11-11 18:03 time_zone_name.MYI -rw-rw---- 1 mysql mysql 8686 2006-11-11 18:03 time_zone_transition.frm -rw-rw---- 1 mysql mysql 0 2006-11-11 18:03 time_zone_transition.MYD -rw-rw---- 1 mysql mysql 1024 2006-11-11 18:03 time_zone_transition.MYI -rw-rw---- 1 mysql mysql 8748 2006-11-11 18:03 time_zone_transition_type.frm -rw-rw---- 1 mysql mysql 0 2006-11-11 18:03 time_zone_transition_type.MYD -rw-rw---- 1 mysql mysql 1024 2006-11-11 18:03 time_zone_transition_type.MYI -rw-rw---- 1 mysql mysql 10330 2007-02-13 12:36 user.frm -rw-rw---- 1 mysql mysql 308 2007-02-13 12:36 user.MYD -rw-rw---- 1 mysql mysql 2048 2007-02-13 12:36 user.MYI -- Atenciosamente, Wanderson Santiago dos Reis Técnico em Tecnologia da Informação CEFET-BAMBUÍ
