Posts Tagged ‘[ERROR] Plugin ‘InnoDB’ init function returned error.’

Not able to start Mysql after enabling innodb

June 3rd, 2011

I upgraded Mysql 5.0 to Mysql 5.5.8 and start mysql. It was working fine but when i enable innodb and try to start Mysql i was not able to start it.

I checked the Mysql error logs, saw below errors

[root@manoj mysql]# tail /var/log/mysqld.log
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 1073741824 bytes!
110603  7:34:15 [ERROR] Plugin ‘InnoDB’ init function returned error.
110603  7:34:15 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
110603  7:34:15 [ERROR] Unknown/unsupported storage engine: InnoDB
110603  7:34:15 [ERROR] Aborting

10603  7:34:15 [Note] /usr/sbin/mysqld: Shutdown complete

I moved the ib_logfile0 and ib_logfile01 to bak and start Mysql again. Now this time, it is working fine

[root@Manoj mysql]# mv ib_logfile0 ib_logfile0-bak
[root@Manoj mysql]# mv ib_logfile1 ib_logfile1-bak

Thanks
Manoj

View Comments »

Posted in Mysql

Tags:

MySql: Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed

October 15th, 2010

I have setup the mysql with STORAGE ENGINE InnoDB but when i created table it shows me STORAGE ENGINE MyISAM, i have fixed this issue by doing the following things

1. I checked the mysql error log file and find the below error message for Plugin ‘InnoDB’

101014 10:25:11 [ERROR] Plugin ‘InnoDB’ init function returned error.
101014 10:25:11 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.

2. I have stopped the mysql on Master as well as in Slave and delete “ib_logfile0″ and “ib_logfile1″ from both.

3. Started Mysql on both and started the Slave also.

It will resolve the error and start you MySql.
Why: According to my search: Open the my.ini file and check the InnoDB variables’s size. When above file exides the mentioned size it will prompt this(“Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.”) error.

Then i have Alter the table using below command and it is working for me.

mysql> ALTER TABLE example_timestamp ENGINE=INNODB;
Query OK, 1 row affected (0.10 sec)
Records: 1  Duplicates: 0  Warnings: 0

Thanks
Manoj Chuahan

View Comments »

Posted in Mysql

Tags: