King0770-Notes-InnoDB is in the future: Difference between revisions
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
{{BC|Community Sandbox}} | |||
__FORCETOC__ | |||
<div class="col-md-12 ibox-content"> | |||
=King Notes InnoDB is in the future= | |||
{{KB|{{Unsupported}}|{{ZCS 7.0}}|{{ZCS 6.0}}|}} | |||
{{WIP}} | {{WIP}} | ||
Line 41: | Line 46: | ||
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 | 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 | ||
{{Article Footer|Zimbra Collaboration 7.0, 6.0|04/16/2014}} | |||
[[Category:MySQL]] | [[Category:MySQL]] |
Latest revision as of 09:58, 12 July 2015
King Notes InnoDB is in the future
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