MySQL Forums
Forum List  »  InnoDB

Re: InnoDB error
Posted by: Heikki Tuuri
Date: April 25, 2005 07:21AM

Lieve,

does the customer have big BLOBs?

"
050315 17:31:37 InnoDB: ERROR: the age of the last checkpoint is 91581726,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
"

The above error is benign if mysqld does not crash.

This is the unexplained Windows bug:

"
050316 16:15:35 InnoDB: Operating system error number 995 in a file operation.
InnoDB: See http://dev.mysql.com/doc/mysql/en/InnoDB.html
InnoDB: for installation help.
"

This shows that the checkpoint problem was only temporary:

"
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 2 734799023
InnoDB: Doing recovery: scanned up to log sequence number 2 734847239
"

The port 3100 problem probably has nothing to do with InnoDB. It might be a Windows bug.

Best regards,

Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php

Options: ReplyQuote


Subject
Views
Written By
Posted
5121
January 24, 2005 08:48AM
3962
January 24, 2005 01:13PM
3200
January 27, 2005 07:33AM
3510
lg
March 04, 2005 02:52AM
3222
March 05, 2005 01:57AM
13073
lg
March 16, 2005 09:48AM
6432
April 19, 2005 02:22PM
Re: InnoDB error
5548
April 25, 2005 07:21AM


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.