MySQL Forums
Forum List  »  InnoDB

InnoDB: ERROR: the age of the last checkpoint
Posted by: alan langridge
Date: August 21, 2006 09:09AM

Hi

We have just started getting this error:

060819 16:57:44 InnoDB: ERROR: the age of the last checkpoint is 188740240,
InnoDB: which exceeds the log group capacity 188739994.
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.

I have looked thru the forum for previous reports of this issue, which basically say to look to http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html which I have done.

This page says to do these things:

1. Make the ibdata file auto extend - mine is
2. Increase the ib_log file size

What makes me confused is that the message says to increase the log file size, and my log file is 100M and the longest blob I have is 25378 bytes - well within the limits of the message above.

Can anyone please offer some advice?

Thanks in advance.
Alan Langridge

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB: ERROR: the age of the last checkpoint
7268
August 21, 2006 09:09AM


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.