MySQL Forums
Forum List  »  InnoDB

Re: InnoDB error
Posted by: lg
Date: March 04, 2005 02:52AM

Hi,

I encountered this problem on the production machine for a customer yesterday evening.

Extract from the log:
-------
050303 23:01:30 InnoDB: ERROR: the age of the last checkpoint is 99820658,
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.
050303 23:01:46 InnoDB: ERROR: the age of the last checkpoint is 105403507,
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.

050303 23:03:58 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.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'Windows aio'.
InnoDB: Cannot continue operation.
--------

The problem was triggered by a database cleanup script that deletes all rows in some 10 tables
older than 7 days ( that probably triggers the innodb error also ).

Restarting MySql in these case didn't help, I had to restart the whole machine to get it up and
running again.

Does somebody already have an idea how this issue can be solved?

thx,

Lieven.

Options: ReplyQuote


Subject
Views
Written By
Posted
5047
January 24, 2005 08:48AM
3918
January 24, 2005 01:13PM
3152
January 27, 2005 07:33AM
Re: InnoDB error
3468
lg
March 04, 2005 02:52AM
3178
March 05, 2005 01:57AM
13013
lg
March 16, 2005 09:48AM
6388
April 19, 2005 02:22PM
5496
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.