MySQL Forums :: InnoDB :: Plugin 'InnoDB' init function returned error.


Advanced Search

Re: Plugin 'InnoDB' init function returned error. (fixed)
Posted by: YUEN-YI LIN ()
Date: January 06, 2009 03:22AM

I got same problem, there is the error log:

===
InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytes
InnoDB: than specified in the .cnf file 0 33554432 bytes!
090105 9:17:08 [ERROR] Plugin 'InnoDB' init function returned error.
090105 9:17:08 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090105 9:17:08 [ERROR] Unknown/unsupported table type: INNODB
090105 9:17:08 [ERROR] Aborting

090105 9:17:08 [Note] D:\PROGRAM\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete
===

so, what should I do? delete the .log files?

=== (Edit) ===

well, after I try to delete the old logfiles, it auto recovery and fixed.

just try to find your database "data folder", and delete ib_logfile(s).
(oops, remember backup your old files before delete!)

and the new err log looks like this:

===
090106 17:33:39 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 32 MB
InnoDB: Database physically writes the file full: wait...
090106 17:33:40 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 32 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090106 17:33:41 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...
090106 17:33:41 InnoDB: Started; log sequence number 0 1686420492
090106 17:33:42 [Note] Event Scheduler: Loaded 0 events
090106 17:33:42 [Note] D:\PROGRAM\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.28-rc-community' socket: '' port: 3309 MySQL Community Server (GPL)
===

I guess that will be happened when the "log file size" change ...

wish this information could help.



Edited 2 time(s). Last edit at 01/06/2009 03:42AM by YUEN-YI LIN.

Options: ReplyQuote


Subject Views Written By Posted
Plugin 'InnoDB' init function returned error. 95734 liewjoee 03/16/2007 06:31AM
Re: Plugin 'InnoDB' init function returned error. 52254 Marko Mäkelä 03/21/2007 05:19AM
Re: Plugin 'InnoDB' init function returned error. 48112 JC Loro 06/03/2008 02:29PM
Re: Plugin 'InnoDB' init function returned error. (fixed) 82784 YUEN-YI LIN 01/06/2009 03:22AM
Re: Plugin 'InnoDB' init function returned error. (fixed) 37960 Devlin Ford 01/07/2009 08:20AM
Re: Plugin 'InnoDB' init function returned error. (fixed) 33341 Parames Kalidas 02/10/2009 01:26AM
Re: Plugin 'InnoDB' init function returned error. (fixed) 44269 keerthi ramalingam 02/25/2009 02:38AM
Re: Plugin 'InnoDB' init function returned error. 61255 Richard Lee 02/27/2009 10:21AM
Re: Plugin 'InnoDB' init function returned error. 18386 Christian Flury 02/28/2009 07:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.