Hello all,

yesterday we seperated our app server and db server. We moved our 70GB of data 
from our app server to a new DB server. We installed MySQL 4.1.11 on the DB 
server. 

Now the following happened. On the DB server the ibdata1 and all the databases 
are the old ones (which were copied from the app server). But when Mysql was 
installed the ib_logfile0 ib_logfile1 and ib_logfile2 were created freshly on 
the DB serever. Each of these log files were created with 5M size. on the app 
server these files were 256M in size (innodb_log_file_size = 256M). On the DB 
server it is (innodb_log_file_size = 5M).

Today morning when I checked the error log, there seems to be a lot of error 
msg flowing in.

061211 11:41:47  InnoDB: Error: page 203046 log sequence number 87 3002891543
InnoDB: is in the future! Current system log sequence number 86 4025048037.
InnoDB: Your database may be corrupt.
061211 11:41:48  InnoDB: Error: page 90766 log sequence number 87 2007657570
InnoDB: is in the future! Current system log sequence number 86 4025048133.
InnoDB: Your database may be corrupt.
061211 11:41:48  InnoDB: Error: page 101643 log sequence number 87 1555755135
InnoDB: is in the future! Current system log sequence number 86 4025048213.
InnoDB: Your database may be corrupt.
061211 11:41:48  InnoDB: Error: page 126123 log sequence number 87 2434816015
InnoDB: is in the future! Current system log sequence number 86 4025048253.
InnoDB: Your database may be corrupt.
061211 11:41:48  InnoDB: Error: page 91391 log sequence number 87 3435504059
InnoDB: is in the future! Current system log sequence number 86 4025048310.
InnoDB: Your database may be corrupt.
061211 11:41:49  InnoDB: Error: page 7520 log sequence number 87 558983226
InnoDB: is in the future! Current system log sequence number 86 4025049185.
InnoDB: Your database may be corrupt.
061211 11:41:49  InnoDB: Error: page 70232 log sequence number 87 3176686221
InnoDB: is in the future! Current system log sequence number 86 4025049185.
InnoDB: Your database may be corrupt.
061211 11:41:49  InnoDB: Error: page 9339 log sequence number 87 3426386305
InnoDB: is in the future! Current system log sequence number 86 4025051173.
InnoDB: Your database may be corrupt.

Its not affecting the database as such till now.


1. What is the actual problem?
2. What is the possible work around?

Reply via email to