Bug #48401 InnoDb module fails to run MySql as service

• Submitted: 29 Oct 2009 9:37
• Modified: 31 Oct 2009 14:56
• Reporter: Grigory Mazkevich
• Status: Closed
• Category: MySQL Server: Windows
• Severity: S2 (Serious)
• Version: 5.1.40
• OS: Windows (XP SP3)
• CPU Architecture: Any
• Tags: innodb, mysql service

[29 Oct 2009 9:37] Grigory Mazkevich

Description:
Hello,

during few months MySQL (5.1.xx - RC version) works fine as Windows service, but yesterday I found that it does not want to start.
I found that log files seems corrupted (size mismatch) and remove them. Then start MySQL again. It recreates the files, but not starts.
This time in .err file I found
091028 21:17:45  InnoDB: Error: unable to create temporary file; errno: 2
091028 21:17:45 [ERROR] Plugin 'InnoDB' init function returned error.
091028 21:17:45 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
091028 21:17:45 [ERROR] Unknown/unsupported table type: INNODB
091028 21:17:45 [ERROR] Aborting

So, I have uninstall that version. Then download and install latest stable v5.1.40. Unfortunately, it does not want to start as Windows service again.
When I start it in console it writes:
c:\Program Files\MySQL\MySQL Server 5.1\bin>mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server 5.1\my.ini" --verbose --console --standalone
091028 21:28:08 [Note] Plugin 'FEDERATED' is disabled.
091028 21:28:09  InnoDB: Started; log sequence number 0 44233
091028 21:28:09 [Note] Event Scheduler: Loaded 0 events
091028 21:28:09 [Note] mysqld: ready for connections.
Version: '5.1.40-community'  socket: ''  port: 3306  MySQL Community Server (GPL)

All MySQL installations configured as
 Developer Machine
 Multifunctional Database
 Multilanguage

How to repeat:
At current moment I don't know how to repeat it on clean PC because I don't know why it may happens.

[29 Oct 2009 9:44] Valeriy Kravchuk

So, it starts properly when mysqld ... command is used, but does not start as a service? Please, check service startup command line in the registry. Maybe it refers to some wrong my.ini location.

[29 Oct 2009 10:02] Grigory Mazkevich

Registry path is
"c:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --defaults-file="c:\Program Files\MySQL\MySQL Server 5.1\my.ini" MySQL

Command line from registry is almost the same as in console.

[29 Oct 2009 10:07] Valeriy Kravchuk

And what are the results of:

net start MySQL

then, without any other mysqld running? Send also the results of:

netstat -a

[29 Oct 2009 10:32] Valeriy Kravchuk

Please, upload also your my.ini file content.

[29 Oct 2009 10:35] Grigory Mazkevich

MySQL ini

Attachment: my.ini (application/octet-stream, text), 8.76 KiB.

[31 Oct 2009 14:56] Grigory Mazkevich

Hello guys,

I found the issue roots. It was %TEMP% == %TMP% == "C:\Temp" for the SYSTEM account.
I don't know which software has changed it, but this folder is not exists. I have fixed environment and MySQL is working again as a Windows service.