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:
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

[10 Oct 2003 7:32] john joseph
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.
[10 Oct 2003 7:47] MySQL Verification Team
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
[15 Oct 2003 21:22] MySQL Verification Team
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>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.