King0770-Notes-InnoDB is in the future

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

King Notes InnoDB is in the future

   KB 5738        Last updated on 2015-07-12  




0.00
(0 votes)


If you look in the /opt/zimbra/log/mysql_error.log, and you see the following that looks like:


110224  4:38:44  InnoDB: Error: page 1 log sequence number 252 1880879917
InnoDB: is in the future! Current system log sequence number 250 376589009.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
InnoDB: for more information.
110224  4:38:44  InnoDB: Error: page 439 log sequence number 252 1829571000
InnoDB: is in the future! Current system log sequence number 250 376589009.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
InnoDB: for more information.

You may need to increment the ib_logfiles. Basically, you need to find a large mboxgroupXX directory in ~/db/data that is equal, or greater in size to the sizes of both ib_logfile0 and ib_logfile1 files. Once you have found a mboxgroup, you can create a temporary database, populate it with data from mail_item dump, then drop the table and database.


Example
-------

1) source ~/bin/zmshutil; zmsetvars

2) ~/mysql/bin/mysqldump mboxgroup10 -S $mysql_socket -u root --password=$mysql_root_password >> /tmp/mboxgroup10.sql

3) mysql -e "create database temp"

4) mysql temp < /tmp/mboxgroup10.sql

5) mysql -e "drop database temp"

I am not 100% this will work, but that suggestion came from a mysql post. http://forums.mysql.com/read.php?22,130164,131915#msg-131915

Verified Against: Zimbra Collaboration 7.0, 6.0 Date Created: 04/16/2014
Article ID: https://wiki.zimbra.com/index.php?title=King0770-Notes-InnoDB_is_in_the_future Date Modified: 2015-07-12



Try Zimbra

Try Zimbra Collaboration with a 60-day free trial.
Get it now »

Want to get involved?

You can contribute in the Community, Wiki, Code, or development of Zimlets.
Find out more. »

Looking for a Video?

Visit our YouTube channel to get the latest webinars, technology news, product overviews, and so much more.
Go to the YouTube channel »

Jump to: navigation, search