Bug #62883 MySQL Normal Shutdown !

• Submitted: 22 Oct 2011 21:21
• Modified: 7 Nov 2011 21:02
• Reporter: Gabriel Dias
• Status: Can't repeat
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.5.16
• OS: Any
• CPU Architecture: Any
• Tags: normal shutdown

[22 Oct 2011 21:21] Gabriel Dias

Description:
The MySQL Service ends alone!

111022 18:40:13 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown

111022 18:40:13 [Note] Event Scheduler: Purging the queue. 0 events
111022 18:40:15 [Warning] c:\xampp\mysql\bin\mysqld.exe: Forcing close of thread 6  user: 'root'

111022 18:40:15  InnoDB: Starting shutdown...
111022 18:40:16  InnoDB: Shutdown completed; log sequence number 135348634
111022 18:40:16 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

111022 18:41:35 [Note] Plugin 'FEDERATED' is disabled.
111022 18:41:35 InnoDB: The InnoDB memory heap is disabled
111022 18:41:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111022 18:41:35 InnoDB: Compressed tables use zlib 1.2.3
111022 18:41:35 InnoDB: Initializing buffer pool, size = 16.0M
111022 18:41:35 InnoDB: Completed initialization of buffer pool
111022 18:41:35 InnoDB: highest supported file format is Barracuda.
111022 18:41:37  InnoDB: Waiting for the background threads to start
111022 18:41:38 InnoDB: 1.1.8 started; log sequence number 135348634
111022 18:41:38 [Note] Event Scheduler: Loaded 0 events
111022 18:41:38 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16'  socket: ''  port: 3306  MySQL Community Server (GPL)
111022 18:41:40 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown

111022 18:41:40 [Note] Event Scheduler: Purging the queue. 0 events
111022 18:41:40  InnoDB: Starting shutdown...
111022 18:41:40  InnoDB: Shutdown completed; log sequence number 135348634
111022 18:41:40 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

111022 18:41:41 [Note] Plugin 'FEDERATED' is disabled.
111022 18:41:41 InnoDB: The InnoDB memory heap is disabled
111022 18:41:41 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111022 18:41:41 InnoDB: Compressed tables use zlib 1.2.3
111022 18:41:41 InnoDB: Initializing buffer pool, size = 16.0M
111022 18:41:41 InnoDB: Completed initialization of buffer pool
111022 18:41:41 InnoDB: highest supported file format is Barracuda.
111022 18:41:43  InnoDB: Waiting for the background threads to start
111022 18:41:44 InnoDB: 1.1.8 started; log sequence number 135348634
111022 18:41:44 [Note] Event Scheduler: Loaded 0 events
111022 18:41:44 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.

How to repeat:
I just set up the service, and after some hours this error happen. I have a Diablo II server.

[23 Oct 2011 10:02] Valeriy Kravchuk

Probably somebody (or some software) just initiated shutdown. Please, check Event Viewer for possible related messages.

[23 Oct 2011 14:38] Gabriel Dias

Have some MySQL events on event viwer.

* c:\xampp\mysql\bin\mysqld.exe: Normal shutdown.
* Event Scheduler: Purging the queue. 0 events
* c:\xampp\mysql\bin\mysqld.exe: Forcing close of thread 6  user: 'root'
* c:\xampp\mysql\bin\mysqld.exe: Shutdown complete.
* Plugin 'FEDERATED' is disabled.
* Event Scheduler: Loaded 0 events
* c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16'  socket: ''  port: 3306  MySQL Community Server (GPL)
* c:\xampp\mysql\bin\mysqld.exe: Normal shutdown
 
And repeat the same logs again and again. ALl these erros have event id 100.

[23 Oct 2011 14:43] Gabriel Dias

When I try to access the database, this error occurs.

* db said: 'Can't connect to MySQL server on '127.0.0.1' (10061)'

[7 Nov 2011 21:02] MySQL Verification Team

Please follow Valeriy's advices (look for software or somebody initiated the shutdown process). Thanks.