Skip navigation links

MySQL Forums :: InnoDB :: InnoDB: ERROR: the age of the last checkpoint


Advanced Search

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 6416 alan langridge 08/21/2006 09:09AM
Re: InnoDB: ERROR: the age of the last checkpoint 3623 Heikki Tuuri 08/23/2006 08:03AM
Re: InnoDB: ERROR: the age of the last checkpoint 10396 alan langridge 08/23/2006 09:31AM
Re: InnoDB: ERROR: the age of the last checkpoint 5589 Heikki Tuuri 08/23/2006 12:33PM
Re: InnoDB: ERROR: the age of the last checkpoint 4540 alan langridge 08/24/2006 02:34AM


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.