Bug #65032 | Misleading error shown while trying to ALTER TABLE | ||
---|---|---|---|
Submitted: | 19 Apr 2012 8:40 | Modified: | 5 Jan 2013 5:57 |
Reporter: | Damien Roche | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S3 (Non-critical) |
Version: | 7.2.5 | OS: | Linux (2.6.32) |
Assigned to: | CPU Architecture: | Any | |
Tags: | IndexMemory, MaxNoOfOrderedIndexes |
[19 Apr 2012 8:40]
Damien Roche
[5 Jan 2013 5:57]
MySQL Verification Team
Hello Damien, Thank you for the report. Verified as described. Thanks, Umesh
[5 Jan 2013 6:00]
MySQL Verification Team
## Workaround Use "show warnings" after the failed attempt to get meaningful error mysql> alter table City4 engine=ndbcluster; ERROR 1005 (HY000): Can't create table 'defect.#sql-2c82_3' (errno: 136) mysql> show warnings; +---------+------+-----------------------------------------------------------------------------------+ | Level | Code | Message | +---------+------+-----------------------------------------------------------------------------------+ | Warning | 1296 | Got error 904 'Out of fragment records (increase MaxNoOfOrderedIndexes)' from NDB | | Error | 1005 | Can't create table 'defect.#sql-2c82_3' (errno: 136) | +---------+------+-----------------------------------------------------------------------------------+ 2 rows in set (0.00 sec)