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.