MySQL Bugs: #10899: mysqld fails to start on windows and doesnt create an err file

Bug #10899	mysqld fails to start on windows and doesnt create an err file
Submitted:	27 May 2005 1:56	Modified:	2 Oct 2008 0:15
Reporter:	Jorge del Conde	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.4	OS:	Windows (Windows)
Assigned to:	Reggie Burnett	CPU Architecture:	Any

Description:
mysqld fails to start on windows and doesn't create an error file.

How to repeat:
I installed mysql in "c:\my\mysql" and did the following sequence:

cd c:\my\mysql\bin
mysqld --install
net start mysql

the following was sent to screen:

C:\my\mysql\data>net start mysql
The MySQL service is starting.
The MySQL service could not be started.

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.

Since I don't have a my.cnf in this machine, the original .err file only contained information regarding ibdata, etc.  No error message was logged.

I deleted the err file (that contained no information why the service failed to start), and attempted to start the service again with "net start mysql".  This time, the same error message appeared, but no err file was created.

This happens because the service expects to load its error messages from "C:\mysql\share\english\errmsg.sys".

We need to hook things up to log to the event log during startup so messages that explain failures like this can be reported to the user.

This is WL#838, currently assigned to Reggie, where it is marked as being in Code-Review.