MySQL not starting, page size not supported

edwardmp asked:

After a MySQL restart, MySQL won’t start anymore.

130608 21:35:02 mysqld_safe mysqld from pid file /var/lib/mysql/server.pid ended
130608 21:35:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130608 21:35:08 [Note] Plugin 'FEDERATED' is disabled.
130608 21:35:08 InnoDB: The InnoDB memory heap is disabled
130608 21:35:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130608 21:35:08 InnoDB: Compressed tables use zlib 1.2.3
130608 21:35:08 InnoDB: Using Linux native AIO
130608 21:35:08 InnoDB: Initializing buffer pool, size = 1.0G
130608 21:35:08 InnoDB: Completed initialization of buffer pool
130608 21:35:08 InnoDB: Error: data file /var/lib/mysql/ibdata2 uses page size 8192,
130608 21:35:08 InnoDB: but the only supported page size in this release is=16384
130608 21:35:08 InnoDB: Could not open or create data files.
130608 21:35:08 InnoDB: If you tried to add new data files, and it failed here,
130608 21:35:08 InnoDB: you should now edit innodb_data_file_path in my.cnf back
130608 21:35:08 InnoDB: to what it was, and remove the new ibdata files InnoDB created
130608 21:35:08 InnoDB: in this failed attempt. InnoDB only wrote those files full of
130608 21:35:08 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
130608 21:35:08 InnoDB: remove old data files which contain your precious data!
130608 21:35:08 [ERROR] Plugin 'InnoDB' init function returned error.
130608 21:35:08 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130608 21:35:08 [ERROR] Unknown/unsupported storage engine: InnoDB
130608 21:35:08 [ERROR] Aborting

Version MySQL 5.5.20. Please hep.


I answered:

This is a bug in MySQL 5.5.20. Update to 5.5.22 or later, in which it was fixed.


View the full question and answer on Server Fault.

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.