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.but we don't want to start it every time like that..is the solution?I have installed the following packages from I am using Cent OS 5.: My SQL-community-debuginfo-5.1.50-1.rhel5.x86_64My SQL-client-community-5.1.50-1.rhel5.x86_64My SQL-server-5.1.50-1.glibc23.x86_64My SQL-devel-5.1.50-1.glibc23.x86_64Is there anything missing?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.
To enable logging to files use the --log-output option. Please refer to Inno DB: DB: about forcing recovery.
Inno DB: File name ./ibdata1 Inno DB: File operation call: 'open'. 130319 mysqld_safe mysqld from pid file /var/lib/mysql/ip-10-144-82-28ended Then, Uninstall RPM (Only when it is fresh installation, and you do not have any mysql data.
If it is not fresh installation, do a rpm -Uvh instead) Remove all contents of /var/lib/mysql/ directory Re-install RPM check if /var/lib/mysql/mysql/is created after installing RPM Then give a service mysql start and watch logs.
Inform us if you still get same error after removing pid file.
Please remove pid file manually, then start mysqld.
We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail.