Bug #40523 Got error 22 from storage engine in windows but in linux get the error:errno: 2
Submitted: 5 Nov 2008 10:31 Modified: 21 Dec 2008 9:39
Reporter: sfh sfh Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:mysql server/client 5.1.28 OS:Linux (and windows)
Assigned to: CPU Architecture:Any
Tags: partition error

[5 Nov 2008 10:31] sfh sfh
Description:
i have three tables :
one : i have a partition by range(20) and then 10 HASH subpartition by every partition
two : i have a partition by range(50) and then 10 HASH subpartition by every partition
three : i have a partition by range(50) and then 10 HASH subpartition by every partition

so in the database i have 1200 partition!
i can create the partitions success,but when i desc the table or insert into values i got the error:
in linux:
mysql> desc traffic_log;
ERROR 1016 (HY000): Can't open file: './stone_syslog/traffic_log.frm' (errno: 24)
mysql> desc web_log;
ERROR 1016 (HY000): Can't open file: './stone_syslog/web_log.frm' (errno: 24)
in windows:
mysql> desc web_log;
ERROR 1030 (HY000): Got error 22 from storage engine

How to repeat:
in linux:
mysql> desc traffic_log;
ERROR 1016 (HY000): Can't open file: './stone_syslog/traffic_log.frm' (errno: 24)
mysql> desc web_log;
ERROR 1016 (HY000): Can't open file: './stone_syslog/web_log.frm' (errno: 24)
in windows:
mysql> desc web_log;
ERROR 1030 (HY000): Got error 22 from storage engine
[6 Nov 2008 5:17] Valeriy Kravchuk
Thank you for a problem report. Please, send the results of:

show global variables like 'open_%';

from both environments.
[6 Nov 2008 6:40] sfh sfh
i do the action:
windows : open_files_limit 2048;
linux : open_files_limit 1024;

but i have been set the number to 6144.in my.ini file and then restart mysql.
windows:
# Size of the buffer used for doing full table scans of MyISAM tables.
# Allocated per thread, if a full scan is needed.
read_buffer_size=64K
read_rnd_buffer_size=256K

# This buffer is allocated when MySQL needs to rebuild the index in
# REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE
# into an empty table. It is allocated per thread so be careful with
# large settings.
sort_buffer_size=256K
open_files_limit=6144

for linux /etc/my.ini:
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[mysqldump
[6 Nov 2008 12:50] sfh sfh
now i hava 3 tables
table1:8389797
table2:765393
table3:7796602

when i do the query:select count(*) from table1 where ... it will 16 sconds
but our aim is less than 2 seconds when the counts is 40000000.table2,table3 is 100000000

mysql can do that?
show processlist,this is something wrong?
mysql> show full processlist;
+----+---------------+-----------------+--------------+---------+------+-------+-----------------------+
| Id | User          | Host            | db           | Command | Time | State | Info                  |
+----+---------------+-----------------+--------------+---------+------+-------+-----------------------+
|  5 | stoneviewuser | localhost       | stone_syslog | Sleep   |  509 |       | NULL                  |
|  6 | stoneviewuser | localhost       | stone_syslog | Sleep   |  409 |       | NULL                  |
|  7 | stoneviewuser | localhost       | stone_syslog | Query   |    0 | NULL  | show full processlist |
|  8 | stoneviewuser | localhost       | stone_syslog | Sleep   |  149 |       | NULL                  |
|  9 | stoneviewuser | localhost       | stone_syslog | Sleep   |  270 |       | NULL                  |
| 10 | stoneviewuser | localhost       | stone_syslog | Sleep   |  264 |       | NULL                  |
| 11 | stoneviewuser | localhost:45810 | stoneview_db | Sleep   |   64 |       | NULL                  |
| 12 | stoneviewuser | localhost       | stone_syslog | Sleep   |  231 |       | NULL                  |
| 13 | stoneviewuser | localhost       | stone_syslog | Sleep   |  137 |       | NULL                  |
+----+---------------+-----------------+--------------+---------+------+-------+-----------------------+
[10 Nov 2008 2:33] sfh sfh
hava somebody help me ?
[21 Nov 2008 9:39] Sveta Smirnova
Thank you for the feedback.

do you have same error after increasing open_files_limit to 6144? Do you have same error if issue FLUSH TABLES; then DESC?
[22 Dec 2008 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".