MySQL 5.1 on Windows won't start.
Posted by: Seungho Nam Nam
Date: February 25, 2014 12:54AM

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

Options: ReplyQuote


Subject
Written By
Posted
MySQL 5.1 on Windows won't start.
February 25, 2014 12:54AM


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.