解决MySQL InnoDB Error: Data File ibdata2 Uses Page Size … But the Only Supported Page Size In This Release Ss=16384

适用于:

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

Comment

*

沪ICP备14014813号

沪公网安备 31010802001379号