Manager of pid file quit without updating file
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 ?S Apr30 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysql 1666 0.0 0.9 130000 19356 ? 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. This is from log: 111008 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 111008 [Warning] The syntax '--log' is deprecated and will be removed in My SQL 7.0.It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured.
Please use ''--general_log'/'--general_log_file'' instead. Inno DB: The error means mysqld does not have the access rights to Inno DB: the directory.
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.
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.