MySQL Bugs: #1518: Stopping mysql

Bug #1518	Stopping mysql
Submitted:	10 Oct 2003 7:32	Modified:	15 Oct 2003 21:22
Reporter:	john joseph	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	4.1.0a	OS:	Windows (Windows 2000/Winows XP)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
After installing mysql as a service (mysqld --install) 
you can start the server using the command line:
net start mysql.

however stopping the server using net stop mysql causes an indefinite hang.
Using the winmysqladmin the 'starte light' of the server is turned to 'yellow'
the server cannot be started and keeps using resources.

How to repeat:
Install as service use net start mysql, net stop mysql

Suggested fix:
not known? This used to work in all versions.

For the release version 4.1.0-alpha there is a bug in the shutdown
process (the server don't complete the shutdown). For this reason
the WinMySQLAdmin shows the "yellow light".
The work around is: go to the SCM and change the start from automatic
to manual and reboot the machine (for to avoid the service remains in
bad state).
Then remove the service: mysqld --remove

and install the service using mysqld-nt or mysqld-max-nt servers.

In another words don't use: mysqld.exe, mysqld-opt.exe and mysqld-max.exe
servers.

Thank you for the bug report it is already fixed in the latest 4.1 BK tree
and therefor in the next 4.1.1-alpha release:

C:\mysql\bin>mysqld --standalone --console
031016  1:07:52  InnoDB: Started; log sequence number 0 28141073
TODO: make sure MySQL sets field->query_id right in prepare/execute
mysqld: ready for connections.
Version: '4.1.1-alpha-max-debug'  socket: ''  port: 3306
031016  1:08:44  mysqld: Normal shutdown

031016  1:08:44  InnoDB: Starting shutdown...
031016  1:08:44  InnoDB: Shutdown completed; log sequence number 0 28141073
031016  1:08:44  mysqld: Shutdown Complete

C:\mysql\bin>

C:\mysql\bin>mysqld --install
Service successfully installed.

C:\mysql\bin>net start mysql
O serviço de MySql está sendo iniciado.
O serviço de MySql foi iniciado com êxito.

C:\mysql\bin>net stop mysql
O serviço de MySql está sendo finalizado .
O serviço de MySql foi finalizado com êxito.