InnoDB: Error: tablespace size stored in header

[Shakeel Sorathia]

Hi, we're using Innodb here and I just upped the number of datafiles that innodb was using. When I did a show table status I noticed that I didn't get all the space that I had added. When I looked at the error log, I got recieved the following error.

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


Can anyone help me out here? BTW, we recompiled innodb to use 64kb pages rather then the default of 16kb. Here is the my.cnf we are using...

Thanks!

--shak

innodb_data_file_path = ibdata1:4000M;ibdata2:4000M;ibdata3:4000M;ibdata4:4000M;ibdata5:4000M;ibdata6:4000M;ibdata7:4000M;ibdata8:4000M;ibdata9:4000M;ibdata10:4000M;ibdata11:4000M;ibdata12:4000M;ibdata13:4000M;ibdata14:4000M;ibdata15:4000M;ibdata16:4000M;ibdata17:4000M;ibdata18:4000M
innodb_flush_log_at_trx_commit=0
set-variable = innodb_buffer_pool_size=2048M
innodb_data_home_dir = /opt/mysql/data/
innodb_log_group_home_dir = /opt/mysql/data/
innodb_log_arch_dir = /opt/mysql/data/
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=128M
set-variable = innodb_log_buffer_size=192M
innodb_log_archive=0
innodb_fast_shutdown=1
innodb_flush_method=nosync
set-variable = innodb_additional_mem_pool_size=128M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
set-variable = innodb_thread_concurrency=12


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php