Bug #43845 MySQL 5.1 installation fails at 'Start Service'
Submitted: 24 Mar 2009 23:01 Modified: 25 Mar 2009 6:45
Reporter: Kalyan Yalamanchili Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:5.1.32 OS:Windows (Vista Business 32-bit)
Assigned to: CPU Architecture:Any

[24 Mar 2009 23:01] Kalyan Yalamanchili
Description:
I am trying to install MySQL on Vista Business 32-bit and it fails at start service. I have searched the forums and found out using this command and obtained the this below log.

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqld -nt --defaults-file="C:\Progr
am Files\MySQL\MySQL Server 5.1\my.ini" --standalone --console
090324 15:44:47  InnoDB: Error: unable to create temporary file; errno: 2
090324 15:44:47 [ERROR] Plugin 'InnoDB' init function returned error.
090324 15:44:47 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

090324 15:44:47 [ERROR] Unknown/unsupported table type: INNODB
090324 15:44:47 [ERROR] Aborting

090324 15:44:47 [Warning] Forcing shutdown of 1 plugins
090324 15:44:47 [Note] mysqld: Shutdown complete

Right from start it didn't pass through this problem. I had tried various times like uninstalling (clean up registry and all its directories) and re-installing. No success.

How to repeat:

MySQL Server Instance Configuration Wizard 1.0.15.0 go through all the process till hitting execute
[24 Mar 2009 23:30] MySQL Verification Team
Thank you for the bug report. Please see in your my.ini file the path for the datadir directory, i.e:

datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data/"

Then open a command prompt and go to that folder and doing a dir command see if the below InnoDB files have the same size of my.ini file:

c:\>cd "C:/ProgramData/MySQL/MySQL Server 5.1/Data/"

C:\ProgramData\MySQL\MySQL Server 5.1\data>dir ib*
 O volume na unidade C não tem nome.
 O Número de Série do Volume é F4C1-E357

 Pasta de C:\ProgramData\MySQL\MySQL Server 5.1\data

24/03/2009  16:57        10.485.760 ibdata1
24/03/2009  16:59        25.165.824 ib_logfile0
24/03/2009  09:18        25.165.824 ib_logfile1
               3 arquivo(s)     60.817.408 bytes
               0 pasta(s)   55.030.525.952 bytes disponíveis

C:\ProgramData\MySQL\MySQL Server 5.1\data>

If ibdata1 = 10M then it is the default one.
ib_logfile0 and ib_logfile1 according my.ini i.e:

innodb_log_file_size=24M

If you did a fresh install (you don't have data to preserve) then delete the above files and try to start the service again. If the service fails please print here the message error printed in the computer_name.err file which exists in the datadir folder. Thanks in advance.
[25 Mar 2009 1:35] Kalyan Yalamanchili
I do have the files u have mentioned 

C:\ProgramData\MySQL\MySQL Server 5.1\data>

If ibdata1 = 10M then it is the default one.
ib_logfile0 and ib_logfile1 according my.ini i.e:

innodb_log_file_size=24M

I have deleted those files as the installation is a fresh one and have tried the 'MySQL Server Installation Configuration' wizard and went through all the process until clicking execute... 

This time it says : "The service could not be started."

Log is as follows:

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqld -nt -defaults-file="C:\Progrm
 Files\MySQL\MySQL Server 5.1\my.ini" --standalone --console
090324 18:27:28  InnoDB: Error: unable to create temporary file; errno: 2
090324 18:27:28 [ERROR] Plugin 'InnoDB' init function returned error.
090324 18:27:28 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

090324 18:27:28 [ERROR] Unknown/unsupported table type: INNODB
090324 18:27:28 [ERROR] Aborting

090324 18:27:28 [Warning] Forcing shutdown of 1 plugins
090324 18:27:28 [Note] mysqld: Shutdown complete

Thanks for your concern into this issue.
[25 Mar 2009 6:45] Sveta Smirnova
Thank you for the feedback.

Server can not start, because temporary directory is not writable. 

This is duplicate of bug #40757. More details and workaround in bug #40768.

Please wait next release.