MySQL Forums
Forum List  »  Source, Builds, Binaries

Problems starting / creating InnoDB
Posted by: michael
Date: November 09, 2006 09:27AM

Hello,

I have a problem: Some time ago I used MySQL 4.1.16 on an Intel ARM processor
with kernel 2.4.27 and all went well. Some time ago I upgraded to kernel 2.6.18,
but now the MySQL server doesn't start correctly. At the first time it prints:

InnoDB: The first specified data file /home/ibdata1 did not exist:
InnoDB: a new database to be created!
061109 15:12:05 InnoDB: Setting file /home/ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
061109 15:12:06 InnoDB: Log file /home/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /home/ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
061109 15:12:07 InnoDB: Log file /home/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /home/ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...

But after that nothing happens. The mysql.sock does not appear and any attempt
to connect to the server times out. With kernel 2.4.27 the above-mentioned
messages appears and direct afterwards the server also prints:

InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
061102 13:53:57 InnoDB: Started; log sequence number 0 0
/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.1.16' socket: '/tmp/mysql.sock' port: 3306 Source distribution

But this does not appear now. After a restart the server says:

InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html
061109 14:57:20 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.0.27' socket: '/tmp/mysql.sock' port: 3306 Source distribution

Now the server seems to run correctly !?! But it keeps printing the warnings
each time. Of course I checked the above-mentioned web page, but all the
proposals do not hold in my case.

Anyone a solution or observed something similar ? Any idea ?

Thanks,
Michael

Options: ReplyQuote


Subject
Views
Written By
Posted
Problems starting / creating InnoDB
2811
November 09, 2006 09:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.