Bug #34039 | Can't open FRM file after creating table with > 576 partitions | ||
---|---|---|---|
Submitted: | 24 Jan 2008 17:58 | Modified: | 24 Jan 2008 18:18 |
Reporter: | Norman Elton | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Partitions | Severity: | S2 (Serious) |
Version: | 5.1.22-rc-community | OS: | Linux (x86_64) |
Assigned to: | CPU Architecture: | Any |
[24 Jan 2008 17:58]
Norman Elton
[24 Jan 2008 18:00]
Norman Elton
If I only use four partitions, I can get up to 144 subpartitions, but it breaks at 145. It appears that there is bug limiting a table to 576 partitions.
[24 Jan 2008 18:18]
Norman Elton
Resolved issue by increasing file_limit_size.
[30 Apr 2009 16:39]
Gatis Rumbens
I have the same problem. What do you mean with increase file_limit_size? In OS kernel parameters increase max_open_files or similar?