Forum archive
Appliance Tomcat Stand Alone: How to change to MySQL Engine type INNODB by default
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?
Replies (3)
I'm not sure
Reply 1Thanks Jeremy - The link helps.
Reply 2Yes, 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)
Check the setup in the MySQL config file
Reply 3They 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
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.