List:General Discussion« Previous MessageNext Message »
From:Andrew Simpson Date:April 12 2007 12:12pm
Subject:InnoDB data log files
View as plain text  
Hello all,

I am looking after the installation of web-based software built using 
MySQL with mostly InnoDB tables. The software is currently installed in 
over 10 locations and has been running continually for several months in 
some of these. These installations vary from several thousand to several 
hundred thousand lines in the database, with 100 tables.

Backups are made roughly daily from within the application, which uses 
the php 'exec' function to directly call mysqldump.

One server had a problem while creating a backup last week. The routine 
normally takes about 30 seconds, but in this case went on for over 30 
minutes. During this, the application was responding correctly to other 
users. After a reboot, InnoDB has been disabled, which left the data 
inaccessible. The database was restored using the most recent backup, 
but all tables are now using the MyISAM engine.

The server is running Windows Server 2003 and MySQL version 
5.0.24a-community-nt installed using the xampp package.

The relevant sections of the MySQL log file are below, after which it 
went into a near endless cycle of 'Incorrect information in file:' errors.

The errors are due to InnoDB being disabled. As far as I can tell, this 
has happened as the InnoDB log file ib_logfile0 is the wrong size. This 
took me to the description for adding and removing log files at: 
http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html

However, something has happened in this case to expand the file 
id_logfile0 and instructions are not given on how to clean it out and 
start again.

Any help on how to sort this out without a reinstall or, more 
importantly, to understand why this may have happened, would be greatly 
appreciated.

Best regards,

Andrew Simpson



070403 16:33:53 [Note] C:\www\xampp\mysql\bin\mysqld-nt.exe: Normal shutdown

070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing 
close of thread 6135  user: 'wasp'

070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing 
close of thread 6134  user: 'wasp'

070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing 
close of thread 6133  user: 'wasp'

070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing 
close of thread 6131  user: 'wasp'

070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing 
close of thread 6130  user: 'wasp'

070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing 
close of thread 6129  user: 'wasp'

070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing 
close of thread 6128  user: 'wasp'

070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing 
close of thread 6127  user: 'wasp'

070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing 
close of thread 6099  user: 'wasp'

070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing 
close of thread 6015  user: 'wasp'

070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing 
close of thread 5929  user: 'wasp'

070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing 
close of thread 5928  user: 'wasp'

070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing 
close of thread 5865  user: 'wasp'

070403 16:33:55 [Warning] C:\www\xampp\mysql\bin\mysqld-nt.exe: Forcing 
close of thread 5861  user: 'wasp'

070403 16:33:55  InnoDB: Starting shutdown...
070403 16:33:57  InnoDB: Shutdown completed; log sequence number 0 81792952
070403 16:33:57 [Note] C:\www\xampp\mysql\bin\mysqld-nt.exe: Shutdown 
complete

InnoDB: Error: log file C:\www\xampp\mysql\data\ib_logfile0 is of 
different size 0 134217728 bytes
InnoDB: than specified in the .cnf file 0 67108864 bytes!
070403 16:35:01 [Note] C:\www\xampp\mysql\bin\mysqld-nt.exe: ready for 
connections.
Version: '5.0.24a-community-nt'  socket: ''  port: 3306  MySQL Community 
Edition (GPL)
070403 16:40:45 [ERROR] C:\www\xampp\mysql\bin\mysqld-nt.exe: Incorrect 
information in file: '.\wasp_ke\wasp_settings.frm'
070403 16:40:45 [ERROR] C:\www\xampp\mysql\bin\mysqld-nt.exe: Incorrect 
information in file: '.\wasp_ke\wasp_settings.frm'
070403 16:40:45 [ERROR] C:\www\xampp\mysql\bin\mysqld-nt.exe: Incorrect 
information in file: '.\wasp_ke\bugs.frm'



-----------------------------------------------------------------------------
This message has been scanned for viruses and
dangerous content by the http://www.orbital.net
MailScanner, and is believed to be clean.
-----------------------------------------------------------------------------

Thread
InnoDB data log filesAndrew Simpson12 Apr
  • Re: InnoDB data log filesDan Nelson12 Apr
    • Re: InnoDB data log filesAndrew Simpson25 Apr