John Maxim - Wed, 2011/03/30 - 20:06

I faced something like these after modifying my.cnf:

110330 18:00:44 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 262144000 bytes!
110330 18:00:45 [ERROR] Plugin 'InnoDB' init function returned error.
110330 18:00:45 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110330 18:00:45 [Note] Event Scheduler: Loaded 0 events
110330 18:00:45 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.8'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)

Can someone help me to solve this?

Forum: 
Support
Tags: 
mysql
tomcat
Jeremy Davis's picture

Jeremy Davis - Thu, 2011/03/31 - 00:24

But have a look at this thread. It actually relates to the previous (v2009.x) TKL release but may still be relevant. Have a try and see if it works. Be great if you could report back, especially if you get it sorted.

John Maxim - Thu, 2011/03/31 - 03:58

Yes, apparently corrupted log file of some sort. Followed the scripts to remove the log file as shown in the link by the original poster and after that I re-created my database, and all the tables, populated them again, and well the innodb plugin is on. Except there were still some erros:

 

110331  1:50:05 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
110331  1:50:06  InnoDB: highest supported file format is Barracuda.
110331  1:50:06 InnoDB Plugin 1.0.5 started; log sequence number 347127
110331  1:50:06 [Note] Event Scheduler: Loaded 0 events
110331  1:50:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.8'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)


Jeremy Davis's picture

Jeremy Davis - Thu, 2011/03/31 - 11:10

They don't seem to be errors, notes/info. But if you would to try getting rid of them have a look at the MySQL config file. You should find it at /etc/mysql/my.cnf

Add new comment