Bug #938 mysqladmin shutdown fails on Win2k/XP
Submitted: 28 Jul 2003 12:48 Modified: 28 Jul 2003 15:01
Reporter: Van Sederburg Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: Command-line Clients Severity:S2 (Serious)
Version:4.1.0-alpha OS:Microsoft Windows (Win2k, XP)
Assigned to: CPU Architecture:Any

[28 Jul 2003 12:48] Van Sederburg
Executing the command "mysqladmin -u root shutdown" has no effect on Win2K and XP-Pro (the only OS's I have to try it on) to stop mysqld. This used to work in 4.0.1. Now you have to go to the Task Manager to kill the process.  

When installed as a service (I tried mysqld-opt and mysqld) it also fails to shutdown with NET STOP mysql, and also fails via the Windows control panel/services.

However, after you run "shutdown", if you try to run something like mysqladmin ping, it will fail as unable to connect. 

The mysql.err log will also show entries that indicate the shutdown was successful, even though it wasn't.

So it's gone, but not gone... :-)

How to repeat:

1. Go to command prompt 
2. Run mysqld-opt
3. Start a second command prompt
4. Run mysqladmin -u root shutdown
   The error log shows:
    030728 14:39:56  mysqld-opt: Normal shutdown
    030728 14:39:57  mysqld-opt: Shutdown Complete
5. Return to first command prompt -- nothing has changed
6. Bring up windows Task Manager -- mysqld-opt task is still there
7. Return to second command prompt and try mysqladmin ping and it will fail.
8. Return to Task manager and kill the task.
9. Return to the first command prompt and the process has officially ended.

Suggested fix:

No idea, but it works fine with 4.0.1. :)
[28 Jul 2003 12:50] Van Sederburg
Forgot to mention -- I tested this both with a new 4.1.0 install, and with an upgraded 4.0.1 install, with the same results.

[28 Jul 2003 15:01] MySQL Verification Team
Please follow up the bug #296 for further information.