Page 1 of 1

ibdata1 can't be opened in read-write mode

Posted: Tue May 10, 2016 11:17 am
by alan.m
Hello All,

Today I have received one cPanel alert for MySQL service down. When I try to restart the MySQL service through command line and through WHM, it got failed again. Below are the error log entry from MySQL error log. Any one can help to sort this issue?

2016-05-10 11:12:38 7254 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode
2016-05-10 11:12:38 7254 [ERROR] InnoDB: The system tablespace must be writable!
2016-05-10 11:12:38 7254 [ERROR] Plugin 'InnoDB' init function returned error.
2016-05-10 11:12:38 7254 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-05-10 11:12:38 7254 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-05-10 11:12:38 7254 [ERROR] Aborting

2016-05-10 11:12:38 7254 [Note] Binlog end