Public feed #893836

Mine

public text v1 · immutable
Raw Edit
·published 2008-02-06 14:32 UTC
rendered paste body
InnoDB: Error: data file /var/db/mysql/ibdata1 is of a different size
InnoDB: 305792 pages (rounded down to MB)
InnoDB: than specified in the .cnf file 128000 pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
---------------------------
080207 00:29:52  mysqld started
080207  0:29:55  InnoDB: Data file /var/db/mysql/ibdata2 did not exist: new to be created
080207  0:29:55  InnoDB: Setting file /var/db/mysql/ibdata2 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080207  0:29:55  InnoDB: Log file /var/db/mysql/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /var/db/mysql/ib_logfile0 size to 512 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500
080207  0:30:02  InnoDB: Log file /var/db/mysql/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /var/db/mysql/ib_logfile1 size to 512 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
080207  0:30:07  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
080207  0:30:08  InnoDB: Started; log sequence number 1 4193662988
080207  0:30:08 [Note] /usr/local/libexec/mysqld: ready for connections.