MySQL Forums
Forum List  »  InnoDB

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
Re: Plugin 'InnoDB' init function returned error. (fixed)
96751
January 06, 2009 03:22AM


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.