Bug #69363 I want to ADD partition in table but got "ERROR 1499 (HY000): Too many partitio"

• Submitted: 31 May 2013 10:55
• Modified: 31 May 2013 11:36
• Reporter: sourabh parashar
• Status: Not a Bug
• Category: MySQL Server: Partitions
• Severity: S2 (Serious)
• Version: 5.1.55
• OS: Linux
• CPU Architecture: Any
• Tags: ERROR 1499 (HY000), partition error

[31 May 2013 10:55] sourabh parashar

Description:
when we execute following query on partitioned table of live mysql database server,
we got this error -
------
mysql>ALTER TABLE abc_xyz ADD PARTITION ( PARTITION p1025 VALUES LESS THAN(735488));
ERROR 1499 (HY000): Too many partitions (including subpartitions) were defined

How to repeat:
We got this first time, previously when we extend partition, we did not get any error from server.

[31 May 2013 11:36] Miguel Solorzano

Thank you for the bug report.

http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations.html#partitioning-limitati...

"Maximum number of partitions.  The maximum possible number of partitions for a given table (that does not use the NDB storage engine) is 1024. This number includes subpartitions. ......."