Bug #12203 Can't find file after execting a very long query

• Submitted: 27 Jul 2005 10:39
• Modified: 27 Sep 2005 15:42
• Reporter: Steve Hassan
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1, 5.0
• OS: Linux (Linux)
• CPU Architecture: Any

[27 Jul 2005 10:39] Steve Hassan

Description:
After executing a very long query (the query is 2.64Mb on disk) i get the following error message both in my application log and in the mysql error log:

050727  9:58:31 [ERROR] C:\Nesstar-Server\mysql\bin\mysqld-nt: Can't find file: '.\steve\studyejb.frm' (errno: 24)

The query however succeeds.

How to repeat:
See attachment.

[27 Jul 2005 10:43] Steve Hassan

Example of how to repeat the problem (plain text in zip format)

Attachment: Document.zip (application/zip, text), 38.80 KiB.

[27 Jul 2005 11:47] Aleksey Kishkin

we need some repeatable testcase for bug processing.  Could you please attach here a query and table definitions?

[27 Jul 2005 11:50] Steve Hassan

Yes done, the query was too long to include in the comment,  please see file attachment Document.zip.

[27 Jul 2005 20:37] MySQL Verification Team

Is possible for you to provide instead a file dump which you can create
using the mysqldump tool. For to run the query we need data too.

Thanks in advance.

[28 Jul 2005 9:21] Steve Hassan

i have provided a file dump you can download at this location

http://www.nesstar.org/server/debug/bug12203.dump.zip

[28 Jul 2005 11:31] Aleksey Kishkin

well. got the similar error on win xp on mysql 4.1.13:

E:\my41\bin>mysql.exe -u root test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.13-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> source e:\bug/12203/qry.sql
ERROR 1017 (HY000): Can't find file: '.\test\categorystatisticejb.frm' (errno: 24)
mysql>

and this error message appears even if tables are empty.

[5 Aug 2005 22:17] Aleksey Kishkin

tested on linux, got the same error as well. 

walrus@hnt02951:~/bin> mysql test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.10-beta-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> source sql.sql
ERROR 1017 (HY000): Can't find file: './test/CategoryStatisticEJB.frm' (errno: 24)

error 24 means "too many open files", so i'll try tomorrow this test with increased number of availabled file descriptors.

[27 Sep 2005 15:42] Aleksey Kishkin

I don't think it's a bug. Actually mysql requires more open files for performing this quiery than os can provide. Mysql shows appropriate error.

[27 Sep 2005 15:42] Aleksey Kishkin

test case I used to investigate this bug report

Attachment: TESTCASE.ZIP (application/binary, text), 34.57 KiB.