MySQL 5.1 on Windows won't start.
Dear list,
My MySQL won't start with 2 windows event logs:
<Event xmlns="
http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Application Error" />
<EventID Qualifiers="0">1000</EventID>
<Level>2</Level>
<Task>100</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2014-02-25T05:52:10.000000000Z" />
<EventRecordID>19255</EventRecordID>
<Channel>Application</Channel>
<Security />
</System>
<EventData>
<Data>mysqld.exe</Data>
<Data>0.0.0.0</Data>
<Data>519389ce</Data>
<Data>mysqld.exe</Data>
<Data>0.0.0.0</Data>
<Data>519389ce</Data>
<Data>c0000005</Data>
<Data>0000000000287c29</Data>
<Data>18b0</Data>
<Data>01cf31edb805d9ab</Data>
<Data>C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld.exe</Data>
<Data>C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld.exe</Data>
<Data>f703b144-9de0-11e3-babf-90b11c953fb3</Data>
</EventData>
</Event>
<Event xmlns="
http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MySQL" />
<EventID Qualifiers="49152">100</EventID>
<Level>3</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2014-02-25T05:52:08.000000000Z" />
<EventRecordID>19253</EventRecordID>
<Channel>Application</Channel>
<Computer>DELL-28-PC</Computer>
<Security />
</System>
<EventData>
<Data>Changed limits: max_open_files: 2048 max_connections: 200 table_cache: 919
</Data>
</EventData>
</Event>
and these are the messages in .err file:
140225 14:44:50 [Note] Plugin 'FEDERATED' is disabled.
140225 14:44:51 InnoDB: Initializing buffer pool, size = 2.0G
140225 14:44:51 InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 32 228213376
140225 14:44:51 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 32 228218202
140225 14:44:52 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 140225 14:44:53 InnoDB: Assertion failure in thread 4304 in file .\btr\btr0pcur.c line 395
InnoDB: Failing assertion: btr_page_get_prev(next_page, mtr) == buf_frame_get_page_no(page)
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to
http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB:
http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
InnoDB: Thread 7128 stopped in file .\os\os0sync.c line 391
Can anyone help me find the root causes and solutions to troubleshoot this problems, please?
Thank you in advance.
Best regards,
Seungho