MySQL Will Not Start - InnoDB: Database was not shut down no

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

MySQL Will Not Start - InnoDB: Database was not shut down no

Postby dwayned » 11. December 2012 12:01

I am having some problems with MySQL - the service has stopped and will not restart.

I have an XAMPP stack running MediaWiki which is what uses the MySQL database. The server itself is a VM running Windows 2003 SP2 with 512MB RAM.

Below is an extract from the mysql_error.log

Code: Select all
120807 11:18:19 [Note] Plugin 'FEDERATED' is disabled.
120807 11:18:19 InnoDB: The InnoDB memory heap is disabled
120807 11:18:19 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120807 11:18:19 InnoDB: Compressed tables use zlib 1.2.3
120807 11:18:19 InnoDB: Initializing buffer pool, size = 16.0M
120807 11:18:19 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file \xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
120807 11:18:19  InnoDB: Setting file \xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
120807 11:18:19  InnoDB: Log file \xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file \xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
120807 11:18:19  InnoDB: Log file \xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file \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
120807 11:18:20  InnoDB: Waiting for the background threads to start
120807 11:18:21 InnoDB: 1.1.8 started; log sequence number 0
120807 11:18:21 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120807 11:18:21 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120807 11:18:21 [Note] Server socket created on IP: '0.0.0.0'.
120807 11:18:21 [Note] Event Scheduler: Loaded 0 events
120807 11:18:21 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)
120921 17:15:35 [Note] Plugin 'FEDERATED' is disabled.
120921 17:15:35 InnoDB: The InnoDB memory heap is disabled
120921 17:15:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120921 17:15:35 InnoDB: Compressed tables use zlib 1.2.3
120921 17:15:35 InnoDB: Initializing buffer pool, size = 16.0M
120921 17:15:35 InnoDB: Completed initialization of buffer pool
120921 17:15:36 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!
120921 17:15:36  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...
120921 17:15:36  InnoDB: Waiting for the background threads to start
120921 17:15:37 InnoDB: 1.1.8 started; log sequence number 1595675
120921 17:15:37 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120921 17:15:37 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120921 17:15:37 [Note] Server socket created on IP: '0.0.0.0'.
120921 17:15:37 [Note] Event Scheduler: Loaded 0 events
120921 17:15:37 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)
121004 10:24:09 [Note] Plugin 'FEDERATED' is disabled.
121004 10:24:09 InnoDB: The InnoDB memory heap is disabled
121004 10:24:09 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121004 10:24:09 InnoDB: Compressed tables use zlib 1.2.3
121004 10:24:09 InnoDB: Initializing buffer pool, size = 16.0M
121004 10:24:09 InnoDB: Completed initialization of buffer pool
121004 10:24:09 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!
121004 10:24:09  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...
121004 10:24:10  InnoDB: Waiting for the background threads to start
121004 10:24:11 InnoDB: 1.1.8 started; log sequence number 4934573
121004 10:24:11 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121004 10:24:11 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
121004 10:24:11 [Note] Server socket created on IP: '0.0.0.0'.
121004 10:24:12 [Note] Event Scheduler: Loaded 0 events
121004 10:24:12 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)
121112 16:16:30 [Note] Plugin 'FEDERATED' is disabled.
121112 16:16:31 InnoDB: The InnoDB memory heap is disabled
121112 16:16:31 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121112 16:16:31 InnoDB: Compressed tables use zlib 1.2.3
121112 16:16:31 InnoDB: Initializing buffer pool, size = 16.0M
121112 16:16:31 InnoDB: Completed initialization of buffer pool
121112 16:16:31 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!
121112 16:16:31  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...
121112 16:16:31  InnoDB: Waiting for the background threads to start
121112 16:16:32 InnoDB: 1.1.8 started; log sequence number 21311383
121112 16:16:32 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121112 16:16:32 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
121112 16:16:32 [Note] Server socket created on IP: '0.0.0.0'.
121112 16:16:33 [Note] Event Scheduler: Loaded 0 events
121112 16:16:33 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)
121112 16:28:15 [Note] Plugin 'FEDERATED' is disabled.
121112 16:28:15 InnoDB: The InnoDB memory heap is disabled
121112 16:28:15 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121112 16:28:15 InnoDB: Compressed tables use zlib 1.2.3
121112 16:28:15 InnoDB: Initializing buffer pool, size = 16.0M
121112 16:28:15 InnoDB: Completed initialization of buffer pool
121112 16:28:15 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!
121112 16:28:15  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...
121112 16:28:16  InnoDB: Waiting for the background threads to start
121112 16:28:17 InnoDB: 1.1.8 started; log sequence number 21315159
121112 16:28:17 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121112 16:28:17 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
121112 16:28:17 [Note] Server socket created on IP: '0.0.0.0'.
121112 16:28:17 [Note] Event Scheduler: Loaded 0 events
121112 16:28:17 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)
121120 16:10:10 [Note] Plugin 'FEDERATED' is disabled.
121120 16:10:10 InnoDB: The InnoDB memory heap is disabled
121120 16:10:10 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121120 16:10:10 InnoDB: Compressed tables use zlib 1.2.3
121120 16:10:10 InnoDB: Initializing buffer pool, size = 16.0M
121120 16:10:10 InnoDB: Completed initialization of buffer pool
121120 16:10:10 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!
121120 16:10:10  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...
121120 16:10:11  InnoDB: Waiting for the background threads to start
121120 16:10:12 InnoDB: 1.1.8 started; log sequence number 28818026
121120 16:10:12 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121120 16:10:12 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
121120 16:10:12 [Note] Server socket created on IP: '0.0.0.0'.
121120 16:10:12 [Note] Event Scheduler: Loaded 0 events
121120 16:10:12 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)
121120 16:11:46 [Note] Plugin 'FEDERATED' is disabled.
121120 16:11:46 InnoDB: The InnoDB memory heap is disabled
121120 16:11:46 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121120 16:11:46 InnoDB: Compressed tables use zlib 1.2.3
121120 16:11:46 InnoDB: Initializing buffer pool, size = 16.0M
121120 16:11:46 InnoDB: Completed initialization of buffer pool
121120 16:11:46 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 28821623
121120 16:11:47  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...
InnoDB: Doing recovery: scanned up to log sequence number 28825154
121120 16:11:47  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
121120 16:11:48  InnoDB: Waiting for the background threads to start
121120 16:11:49 InnoDB: 1.1.8 started; log sequence number 28825154
121120 16:11:49 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121120 16:11:49 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
121120 16:11:49 [Note] Server socket created on IP: '0.0.0.0'.
121120 16:11:49 [Note] Event Scheduler: Loaded 0 events
121120 16:11:49 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)
121120 16:16:41 [Note] Plugin 'FEDERATED' is disabled.
121120 16:16:41 InnoDB: The InnoDB memory heap is disabled
121120 16:16:41 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121120 16:16:41 InnoDB: Compressed tables use zlib 1.2.3
121120 16:16:41 InnoDB: Initializing buffer pool, size = 16.0M
121120 16:16:41 InnoDB: Completed initialization of buffer pool
121120 16:16: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!
121120 16:16: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...
121120 16:16:42  InnoDB: Waiting for the background threads to start
121120 16:16:43 InnoDB: 1.1.8 started; log sequence number 28841927
121120 16:16:43 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121120 16:16:43 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
121120 16:16:43 [Note] Server socket created on IP: '0.0.0.0'.
121120 16:16:43 [Note] Event Scheduler: Loaded 0 events
121120 16:16:43 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)


Fixes Attempted:

Tried starting from services - error 1067 - "The Process Terminated unexpectedly"
Tried restarting the server itself - no good
Tried moving the ib_logfile0 and ib_logfile1 files from directory and restarting server no good
Tried killing the PID of MySQL from command prompt in case it was still running but it was not running.

If anybody could point me in the right direction it would be much appreciated.

NB> I have also increased the RAM on the box but it didn't work.

thanks
Dwayne
dwayned
 
Posts: 1
Joined: 11. December 2012 11:35
Operating System: Windows Server 2003

Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 1 guest