| LinHES Forums http://forum.linhes.org/ |
|
| Mysql Will Not start! http://forum.linhes.org/viewtopic.php?f=6&t=18907 |
Page 1 of 1 |
| Author: | snake3061 [ Tue Sep 02, 2008 6:38 am ] |
| Post subject: | Mysql Will Not start! |
After upgrading to 5.5 and running now for a few weeks. Everything seems to be running fine. Last night the sytem locked up and not mysql will not start back up. Disk space is fine. syslog part for the mysql is: Sep 2 07:14:27 MBE mysqld_safe[3202]: started Sep 2 07:14:27 MBE mysqld[3205]: 080902 7:14:27 InnoDB: Database was not shut down normally! Sep 2 07:14:27 MBE mysqld[3205]: InnoDB: Starting crash recovery. Sep 2 07:14:27 MBE mysqld[3205]: InnoDB: Reading tablespace information from the .ibd files... Sep 2 07:14:27 MBE mysqld[3205]: InnoDB: Restoring possible half-written data pages from the doublewrite Sep 2 07:14:27 MBE mysqld[3205]: InnoDB: buffer... Sep 2 07:14:27 MBE mysqld[3205]: 080902 7:14:27 InnoDB: Starting log scan based on checkpoint at Sep 2 07:14:27 MBE mysqld[3205]: InnoDB: log sequence number 0 113826. Sep 2 07:14:27 MBE mysqld[3205]: InnoDB: Doing recovery: scanned up to log sequence number 0 113826 Sep 2 07:14:27 MBE mysqld[3205]: 080902 7:14:27 InnoDB: Started; log sequence number 0 113826 Sep 2 07:14:27 MBE mysqld[3205]: 080902 7:14:27 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/host.frm' Sep 2 07:14:27 MBE mysqld[3205]: 080902 7:14:27 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/host.frm' Sep 2 07:14:27 MBE mysqld[3205]: 080902 7:14:27 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect information in file: './mysql/host.frm' Sep 2 07:14:27 MBE mysqld_safe[3216]: ended Sep 2 07:14:28 MBE ntpdate[2903]: step time server 128.10.19.24 offset -0.476778 sec Sep 2 07:14:41 MBE /etc/init.d/mysql[3351]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Sep 2 07:14:41 MBE /etc/init.d/mysql[3351]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Sep 2 07:14:41 MBE /etc/init.d/mysql[3351]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Sep 2 07:14:41 MBE /etc/init.d/mysql[3351]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Sep 2 07:14:41 MBE /etc/init.d/mysql[3351]: Any help would be great! |
|
| Author: | snake3061 [ Tue Sep 02, 2008 8:24 am ] |
| Post subject: | |
I see this is happened to several people.. I have done all the check and repaired the errors but I still can't start mysql. |
|
| Author: | manicmike [ Tue Sep 02, 2008 3:44 pm ] |
| Post subject: | |
Code: Fatal error: Can't open and lock privilege tables: Incorrect information in file: './mysql/host.frm' is obviously the key.
A five second google led me to http://forums.mysql.com/read.php?10,172399,172572#msg-172572 |
|
| Author: | snake3061 [ Thu Sep 04, 2008 3:42 am ] |
| Post subject: | |
Yea, I just reinstalled. All that DB stuff is way over my head unless it written step by step.. |
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|