MySQL Bugs: #48047: Can't do normal shutdown

Bug #48047	Can't do normal shutdown
Submitted:	14 Oct 2009 16:31	Modified:	12 Nov 2009 18:49
Reporter:	Miguel Solorzano	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	mysql-next-mr	OS:	Windows (Vista 64-bit)
Assigned to:	Vladislav Vaintroub	CPU Architecture:	Any

Description:
I compiled mysql-next-mr with VS2005 64-bit and I couldn't shutdown with the normal procedure with mysqladmin or even with CTRL+C, only killing the process.

c:\dbs>c:\dbs\5.5\bin\mysqld --defaults-file=c:\dbs\5.5\my.ini  --standalone --console
091014 13:23:53 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions.
091014 13:23:54  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
091014 13:23:54  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
091014 13:23:54 InnoDB Plugin 1.0.4 started; log sequence number 44264
091014 13:23:56 [Note] Event Scheduler: Loaded 0 events
091014 13:23:56 [Note] c:\dbs\5.5\bin\mysqld: ready for connections.
Version: '5.5.0-beta-Win X64'  socket: ''  port: 3540  Source distribution

Microsoft Windows [Version 6.0.6002]
Copyright (c) 2006 Microsoft Corporation.  All rights reserved.

c:\dbs>55s

c:\dbs>c:\dbs\5.5\bin\mysqladmin -uroot --port=3540 shutdown

How to repeat:
See description

Suggested fix:
---

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/86894

2900 Vladislav Vaintroub	2009-10-15
      Bug #48047 Can't do normal shutdown  
      
      Fix a regression that crept in when downporting Windows improvements.
      Instead of a shutdown thread, another thread that  handledsocket connection was created.

Pushed into 6.0.14-alpha (revid:alik@sun.com-20091031081410-qkxmjsdzjmj840aq) (version source revid:serg@mysql.com-20091019190146-2g2j9i8aqhnd4a1u) (merge vers: 6.0.14-alpha) (pib:13)

Noted in 6.0.14 changelog.

Server shutdown failed on Windows.

Setting report to NDI pending push to 5.5.x.

Pushed into 5.5.0-beta (revid:alik@sun.com-20091110093229-0bh5hix780cyeicl) (version source revid:mikael@mysql.com-20091102100915-a2nbfxaqprpgptfw) (merge vers: 5.5.0-beta) (pib:13)

Noted in 5.5.0 changelog.