适用于:
MySQL服务器版本5.5到5.5 [发行版5.5]
本文信息适用于所有平台。
症状
当重新启动MySQL5.5.20或5.5.21时,MySQL无法启动,并且在错误日志中出现以下错误:
121215 11:25:25 InnoDB: Error: data file /mysql_data/mysql_databases/ibdata2 uses page size 1024, 12121 5 11:25:25 InnoDB: but the only supported page size in this release is=16384 121215 11:25:25 InnoDB: Could not open or create data files.
报告的ibdata2页大小可以有除了1024的其他尺寸。
更改
这个问题通常在使用ALTER TABLE语句改变一个InnoDB表的KEY_BLOCK_SIZE属性时发生,例如从一个未压缩表切换到压缩表时。
原因
这是由于防止从MySQL5.6降级的更改而造成的复原,其支持除16k以外的页大小。
参见 Bug 13698765 64160: PAGE SIZE 1024 BUT THE ONLY SUPPORTED PAGE SIZE IN THIS RELEASE IS=16384.
解决方案
解决的办法是升级到MySQL5.5.22或更高版本。
建议升级到最新的补丁版本,以获得所有最新的补丁。
参见:
How to Download MySQL Server 5.6, 5.5, 5.1 or 5.0; Standard Edition, Enterprise Edition; Advanced, Pro, Classic, Patch
How to Upgrade your Existing MySQL Server to MySQL 5.6 Version (this also applies to MySQL 5.5)
参考
BUG:13698765 64160:
PAGE SIZE 1024 BUT THE ONLY SUPPORTED PAGE SIZE IN THIS RELEASE
IS=16384
NOTE:1300654.1 How to Download MySQL Server 5.6, 5.5, 5.1 or 5.0; Standard Edition, Enterprise Edition; Advanced, Pro, Classic, Patch
NOTE:1319877.1 How to Upgrade your Existing MySQL Server to MySQL 5.6 Version
NOTE:1589556.1 How does Patching Work in MySQL?; How to Apply All the Latest Patches?; How to Find the Latest Patches
Didn’t find what you are looking for?
Keywords
DATA FILE; MYSQL; PATCH; REGRESSION; TABLESPACE; INNODB STORAGE ENGINE
Leave a Reply