List:General Discussion« Previous MessageNext Message »
From:Ady Wicaksono Date:August 26 2005 7:15pm
Subject:InnoDB: Error: tablespace size stored in header is 640000 pages,
but the sum of data file sizes is 1056000 pages
View as plain text  
|Dear All,

As subject, Actually i've been ever meet this case

when i see :

InnoDB: Error: tablespace size stored in header is 877184 pages, but
InnoDB: the sum of data file sizes is 953856 pages

And Mr. Heikki tell me to do these steps:

(953856 - 877184) / 64 = 1198 MB

1) Stop the mysqld server.
2) Add a new 1198M ibdata file at the end of  innodb_data_file_path.
3) When  you start mysqld, InnoDB will write that new ibdata file full of
zeros, and increment the tablespace size stored in  the tablespace header by
1198M.
4) Then stop the mysqld server, remove the extra 1198M ibdata file from
innodb_data_file_path and delete that extra ibdata file.
5) Start mysqld again.
6) Voila! Now the tablespace size stored in the tablespace header agrees
with the combined size of the files in innodb_data_file_path!

BUT
With my case (1056000-640000) / 64 = 6500 Mbyte
It's bigger than a single file in my Linux (2 Gbyte).

My InnoDB data path is:
------------------------
innodb_data_file_path = 
/rsv1/ibdata1:2000M;/rsv1/ibdata2:2000M;/rsv1/ibdata3:2000M;/rsv1/ibdata4:2000M;/rsv1/ibdata5:500M;/r
sv3/ibdata6:2000M;/rsv3/ibdata7:2000M;/rsv3/ibdata8:2000M;/rsv3/ibdata9:2000M;

Any solutions?

|

|-- 
Regards,
Ady Wicaksono
HP: +628562208680
|


Thread
InnoDB: Error: tablespace size stored in header is 640000 pages,but the sum of data file sizes is 1056000 pagesAdy Wicaksono26 Aug
  • Re: InnoDB: Error: tablespace size stored in header is 640000 pages,but the sum of data file sizes is 1056000 pagesAdy Wicaksono26 Aug