MySQL Forums
Forum List  »  InnoDB

InnoDB: Database was not shut down normally!
Posted by: Debasis Bhadra
Date: November 05, 2013 12:39AM

Xampp is installed in the m/c.Mysql is shutdown unexpectedly again and again after some time.It is showing in the log that it was not shutdown normally.I am giving the log information here.Please give some solutions to fix the issue.

130508 9:05:55 [Note] Plugin 'FEDERATED' is disabled.
130508 9:05:55 InnoDB: The InnoDB memory heap is disabled
130508 9:05:55 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130508 9:05:55 InnoDB: Compressed tables use zlib 1.2.3
130508 9:05:55 InnoDB: Initializing buffer pool, size = 16.0M
130508 9:05:55 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
130508 9:05:55 InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130508 9:05:55 InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130508 9:05:55 InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130508 9:05:56 InnoDB: Waiting for the background threads to start
130508 9:05:57 InnoDB: 1.1.8 started; log sequence number 0
130508 9:05:57 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130508 9:05:57 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130508 9:05:57 [Note] Server socket created on IP: '0.0.0.0'.
130508 9:05:57 [Note] Event Scheduler: Loaded 0 events
130508 9:05:57 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
130508 9:07:19 [Note] Plugin 'FEDERATED' is disabled.
130508 9:07:19 InnoDB: The InnoDB memory heap is disabled
130508 9:07:19 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130508 9:07:19 InnoDB: Compressed tables use zlib 1.2.3
130508 9:07:19 InnoDB: Initializing buffer pool, size = 16.0M
130508 9:07:19 InnoDB: Completed initialization of buffer pool
130508 9:07:19 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!
130508 9:07:19 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...
130508 9:07:19 InnoDB: Waiting for the background threads to start
130508 9:07:20 InnoDB: 1.1.8 started; log sequence number 1595675
130508 9:07:20 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130508 9:07:20 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130508 9:07:20 [Note] Server socket created on IP: '0.0.0.0'.
130508 9:07:20 [Note] Event Scheduler: Loaded 0 events
130508 9:07:20 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
130508 9:09:35 [Note] Plugin 'FEDERATED' is disabled.
130508 9:09:35 InnoDB: The InnoDB memory heap is disabled
130508 9:09:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130508 9:09:35 InnoDB: Compressed tables use zlib 1.2.3
130508 9:09:35 InnoDB: Initializing buffer pool, size = 16.0M
130508 9:09:35 InnoDB: Completed initialization of buffer pool
130508 9:09:35 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!
130508 9:09:35 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...
130508 9:09:35 InnoDB: Waiting for the background threads to start
130508 9:09:36 InnoDB: 1.1.8 started; log sequence number 1595675
130508 9:09:37 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130508 9:09:37 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130508 9:09:37 [Note] Server socket created on IP: '0.0.0.0'.
130508 9:09:37 [Note] Event Scheduler: Loaded 0 events
130508 9:09:37 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
130514 7:01:38 [Note] Plugin 'FEDERATED' is disabled.
130514 7:01:38 InnoDB: The InnoDB memory heap is disabled
130514 7:01:38 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130514 7:01:38 InnoDB: Compressed tables use zlib 1.2.3
130514 7:01:38 InnoDB: Initializing buffer pool, size = 16.0M
130514 7:01:38 InnoDB: Completed initialization of buffer pool
130514 7:01:38 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!
130514 7:01:38 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...
130514 7:01:39 InnoDB: Waiting for the background threads to start
130514 7:01:40 InnoDB: 1.1.8 started; log sequence number 1595675
130514 7:01:40 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130514 7:01:40 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130514 7:01:40 [Note] Server socket created on IP: '0.0.0.0'.
130514 7:01:40 [Note] Event Scheduler: Loaded 0 events
130514 7:01:40 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
130514 7:23:41 [Note] Plugin 'FEDERATED' is disabled.
130514 7:23:41 InnoDB: The InnoDB memory heap is disabled
130514 7:23:41 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130514 7:23:41 InnoDB: Compressed tables use zlib 1.2.3
130514 7:23:41 InnoDB: Initializing buffer pool, size = 16.0M
130514 7:23:41 InnoDB: Completed initialization of buffer pool
130514 7:23:41 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!
130514 7:23:41 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...
130514 7:23:41 InnoDB: Waiting for the background threads to start
130514 7:23:42 InnoDB: 1.1.8 started; log sequence number 1595675
130514 7:23:42 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130514 7:23:42 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130514 7:23:42 [Note] Server socket created on IP: '0.0.0.0'.
130514 7:23:42 [Note] Event Scheduler: Loaded 0 events
130514 7:23:42 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
130515 6:28:03 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

130515 6:28:03 [Note] Event Scheduler: Purging the queue. 0 events
130515 6:28:03 InnoDB: Starting shutdown...
130515 6:28:03 InnoDB: Shutdown completed; log sequence number 1595675
130515 6:28:03 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

130515 6:32:52 [Note] Plugin 'FEDERATED' is disabled.
130515 6:32:52 InnoDB: The InnoDB memory heap is disabled
130515 6:32:52 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130515 6:32:52 InnoDB: Compressed tables use zlib 1.2.3
130515 6:32:52 InnoDB: Initializing buffer pool, size = 16.0M
130515 6:32:52 InnoDB: Completed initialization of buffer pool
130515 6:32:52 InnoDB: highest supported file format is Barracuda.
130515 6:32:53 InnoDB: Waiting for the background threads to start
130515 6:32:54 InnoDB: 1.1.8 started; log sequence number 1595675
130515 6:32:54 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130515 6:32:54 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130515 6:32:54 [Note] Server socket created on IP: '0.0.0.0'.
130515 6:32:55 [Note] Event Scheduler: Loaded 0 events
130515 6:32:55 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
130517 13:56:45 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

130517 13:56:45 [Note] Event Scheduler: Purging the queue. 0 events
130517 13:56:45 InnoDB: Starting shutdown...
130517 13:56:46 InnoDB: Shutdown completed; log sequence number 1679033
130517 13:56:46 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

130517 14:01:34 [Note] Plugin 'FEDERATED' is disabled.
130517 14:01:34 InnoDB: The InnoDB memory heap is disabled
130517 14:01:34 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130517 14:01:34 InnoDB: Compressed tables use zlib 1.2.3
130517 14:01:34 InnoDB: Initializing buffer pool, size = 16.0M
130517 14:01:34 InnoDB: Completed initialization of buffer pool
130517 14:01:34 InnoDB: highest supported file format is Barracuda.
130517 14:01:34 InnoDB: Waiting for the background threads to start
130517 14:01:35 InnoDB: 1.1.8 started; log sequence number 1679033
130517 14:01:35 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130517 14:01:35 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130517 14:01:35 [Note] Server socket created on IP: '0.0.0.0'.
130517 14:01:36 [Note] Event Scheduler: Loaded 0 events
130517 14:01:36 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
130517 14:09:20 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

130517 14:09:20 [Note] Event Scheduler: Purging the queue. 0 events
130517 14:09:20 InnoDB: Starting shutdown...
130517 14:09:20 InnoDB: Shutdown completed; log sequence number 1679033
130517 14:09:20 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB: Database was not shut down normally!
9070
November 05, 2013 12:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.