My Oracle Support Banner

InnoDB: ERROR: the age of the last checkpoint is %u which exceeds the log group capacity %u (Doc ID 1536120.1)

Last updated on JUNE 12, 2017

Applies to:

MySQL Server - Version 4.0 and later
Information in this document applies to any platform.

Symptoms

The MySQL error log prints the following message about the checkpoint age:

InnoDB: ERROR: the age of the last checkpoint is 9433817,
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.

Changes

This issue may occur at any time, however it is more likely to occur if the server starts processing a larger volume of data or if you start inserting very large rows particualrly with BLOB columns.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.