When I upgraded my ubuntu server to a more recent mysql version, the mysql server didn't come up anymore.
The error.log said:
InnoDB: Log scan progressed past the checkpoint lsn 0 726937418 110103 23:55:57 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Error: tried to read 65536 bytes at offset 0 4220416. InnoDB: Was only able to read 23040. InnoDB: Fatal error: cannot read from file. OS error number 17. 110103 23:55:57 InnoDB: Assertion failure in thread 140594203866912 in file ../../../storage/innobase/os/os0file.c line 2291 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html InnoDB: about forcing recovery.
The deamon.log only stated:
Jan 3 23:55:57 myhostname init: mysql post-start process (28722) terminated with status 1
On the web I found the hint to add skip-innodb, which didn't help, because I needed innodb for this project.
The solution was (thanks
# mv /var/lib/mysql/ib* /root/
This moved the inno db index files and after that I restarted mysql and everything was fine again.
# restart mysql