Status: On Hold
Affects Version/s: None
Fix Version/s: None
**Reported in Launchpad by chrisjob1021 last update 29-03-2016 15:40:42
Server shut down normally without error. Upon restart, I encountered this error--
2015-03-04 05:49:13 2b054eea2cf0 InnoDB: Error: tablespace size stored in header is 147013632 pages, but
2015-03-04 05:49:13 2b054eea2cf0 InnoDB: the sum of data file sizes is only 147003840 pages
I did not modify 'innodb_data_file_path' in any way. Data files were in tact and no known corruption. Checked XFS file system and found nothing. Was planning on restoring from backup when I decided to mess with 'innodb_data_file_path'--
innodb_data_file_path = /ssd/data/ibdata1:806578M;/mysql3/inno_db/data/ibdata2:390354M;/mysql4/inno_db/data/ibdata3:729522M;/mysql5/inno_db/data/ibdata4:50M:autoextend
Made a typo and got the server online with this statement:
innodb_data_file_path = /ssd/data/ibdata1:806578M;/mysql3/inno_db/data/ibdata2:390354M;/mysql4/inno_db/data/ibdata3:729522M;/mysql5/inno_db/data/ibdata4:370481M;/mysql5/inno_db/data/ibdata4:153M:autoextend
Works consistently, although fallout is unclear. Tables all seem to be in tact without corruption. I'm envisioning problems will crop up eventually.
I cannot modify that line really in any way, though. For example, adding additional files results in the error returning.