Bug #17141 Partitions: crash if 500 hash partitions
Submitted: 5 Feb 2006 19:15 Modified: 28 Feb 2006 21:55
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:5.1.7-beta-debug OS:Linux (SUSE 10.0)
Assigned to: Sergei Glukhov CPU Architecture:Any

[5 Feb 2006 19:15] Peter Gulutzan
Description:
I create a table with 500 hash partitions.
I try to select from information_schema.
Crash.

Perhaps the underlying cause is the same as in bug#17129,
but it's a much different symptom, so I report it as a different bug.

How to repeat:
mysql> select count(*) from information_schema.partitions;
+----------+
| count(*) |
+----------+
|       43 |
+----------+
1 row in set (0.03 sec)

mysql> create table txt (s1 int) partition by hash (s1) partitions 500;
Query OK, 0 rows affected (0.28 sec)

mysql> select count(*) from information_schema.partitions;
ERROR 2013 (HY000): Lost connection to MySQL server during query
[6 Feb 2006 0:50] MySQL Verification Team
Thank you for the bug report.

mysql> select count(*) from information_schema.partitions;
ERROR 2013 (HY000): Lost connection to MySQL server during query
[28 Feb 2006 21:55] Jon Stephens
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Documented fix in 5.1.7 changelog. Closed.

(Changed category to Server:Partitioning.)