Manager of pid file quit without updating file
Description: severals day ago, Cent OS is power off unexpectedly.
The following is from localhost./usr/local/mysql5/libexec/mysqld: Table 'plugin' is read only [ERROR]: Can't open the mysql.plugin table.
120502 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 120502 mysqld_safe mysqld from pid file /var/lib/mysql/tent.pid ended [email protected]:/var/lib/mysql$ ps aux | grep -i mysql root 1599 0.0 0.0 3712 1308 ?
The file in the mysql data folder is gone and mysql just wont behave without it.
The mysql.socket is no longer visible in /tmp eventhough mysql thinks it is.
111008 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.ended The only thing that helps is putting innodb_force_recovery=6 into Server starts, but all still unaccessible.
My SQL manager or server PID file could not be found! Manager of pid-file quit without updating [email protected]:~$ /sbin/service mysqld status ERROR!
Please use '--general_log'/'--general_log_file' instead. 111008 [Warning] Although a path was specified for the --log option, log tables are used. 111008 Inno DB: Assertion failure in thread 3086264000 in file os/os0file.c line 2291 Inno DB: We intentionally generate a memory trap. Inno DB: If you get repeated assertion failures or crashes, even Inno DB: immediately after the mysqld startup, there may be Inno DB: corruption in the Inno DB tablespace.