King0770-Notes-InnoDB is in the future

Revision as of 09:58, 12 July 2015 by Jorge de la Cruz (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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