Is the InnoDB: ERROR: the age of the last checkpoint error causing trouble? Find out the reason behind the error and how to resolve it. Our MySQL Support Service team is here to offer a hand with your queries and issues.

Resolved | InnoDB: ERROR: the age of the last checkpoint

Have you been coming across the following error?

InnoDB: ERROR: the age of the last checkpoint

If yes, our experts have a quick fix to help you out. Before we dive into the solution, let’s take a look at the reason behind the error.

According to our experts, this particular error message pops when we attempt to insert too much data into InnoDB too fast. This results in the InnoDB log filling up before the data is flushed into the main data files.

Our experts recommend trying out this solution if you have been getting this error:

1. First, make the following changes to the /etc/my.cnf file:

   [mysqld]
innodb_log_buffer_size = 32M
innodb_buffer_pool_size = 2G
innodb_log_file_size = 768M
2. Next, set the following variable to 0 to force InnoDB to purge all transactional changes in all InnoDB moving parts.

   SET GLOBAL innodb_fast_shutdown = 0

   This includes the transactional logs. So, we do not need to backup old transactional files

   mysql -uroot -p -e"SET GLOBAL innodb_fast_shutdown = 0;
3. Then, stop MySQL with the STOP command.
4. After that, delete the ib_logfiles with the following command:

   rm -f /var/lib/mysql/ib_logfile*
5. Finally, start MySQL again with the START command.

Let us know in the comments if this fix helped resolve your issue or if you need further help.

[Need assistance with a different issue? Our team is available 24/7.]

Conclusion

In conclusion, our Support Engineers demonstrated how to resolve InnoDB: ERROR: the age of the last checkpoint. We also learned about the root cause behind this error and how to fix it permanently.