Bug #44446 InnoDB cannot start after new install, because log file size
Submitted: 23 Apr 2009 20:18 Modified: 23 Apr 2009 20:38
Reporter: bryan costanich Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:5.1.34, 5.0.77 OS:Windows (XP SP3)
Assigned to: CPU Architecture:Any
Tags: innodb

[23 Apr 2009 20:18] bryan costanich
Description:
When i do a fresh install of mysql, with all the defaults, and then do the instance configuration (with all defaults, "test" as password), the service fails to start.

event log errors are:

Product: MySQL Server 5.1 -- Installation operation completed successfully. 
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. 

-- 
Plugin 'InnoDB' init function returned error. 
For more information, see Help and Support Center at http://www.mysql.com. 

-- 
Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 
For more information, see Help and Support Center at http://www.mysql.com. 

-- 
Unknown/unsupported table type: INNODB 
For more information, see Help and Support Center at http://www.mysql.com. 

-- 
Aborting 
For more information, see Help and Support Center at http://www.mysql.com. 

-- 
Forcing shutdown of 1 plugins 
For more information, see Help and Support Center at http://www.mysql.com. 

-- 
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete 
For more information, see Help and Support Center at http://www.mysql.com.

How to repeat:
install  mysql with all default options, then run instance config, with all default options.

it fails on starting the service

Suggested fix:
the workaround is to delete the log file and start the service. that works, but is not an easy option when you are automating the install. 

suggested fix would be to do a filesize check or something.
[23 Apr 2009 20:38] MySQL Verification Team
Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=43374.