| Bug #58480 | large_tests.lock_tables_big is failing | ||
|---|---|---|---|
| Submitted: | 25 Nov 2010 6:01 | Modified: | 6 Apr 2011 17:34 |
| Reporter: | Anitha Gopi | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Locking | Severity: | S3 (Non-critical) |
| Version: | 5.5 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[25 Nov 2010 8:54]
Valeriy Kravchuk
Verified with mysql-5.5 tree on Ubuntu:
openxs@ubuntu:/home2/openxs/bzr2/mysql-5.5/mysql-test$ ./mtr large_tests.lock_tables_big.test
Logging: ./mtr large_tests.lock_tables_big.test
101125 10:52:15 [Note] Plugin 'FEDERATED' is disabled.
MySQL Version 5.5.7
Checking supported features...
- skipping ndbcluster
- SSL connections supported
- binaries are debug compiled
Collecting tests...
vardir: /home2/openxs/bzr2/mysql-5.5/mysql-test/var
Removing old var directory...
Creating var directory '/home2/openxs/bzr2/mysql-5.5/mysql-test/var'...
Installing system database...
Using server port 37366
==============================================================================
TEST RESULT TIME (ms)
------------------------------------------------------------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
large_tests.lock_tables_big [ fail ]
Test ended at 2010-11-25 10:52:59
CURRENT_TEST: large_tests.lock_tables_big
mysqltest: At line 25: query 'LOCK TABLES $table_list' failed: 1016: Can't open file: './many_tables/t2497.frm' (errno: 24)
...
[1 Dec 2010 8:29]
Anitha Gopi
It could be a server bug too. I am not sure.
[28 Jan 2011 13:14]
Joerg Bruehe
I do not think this is a server bug - I completely miss any analysis.
This is what I would do:
First, check what the problem really is:
joerg@trift-6core:/V51/work-5.1$ fgrep 24 /usr/include/asm-generic/errno-base.h
#define EMFILE 24 /* Too many open files */
What does "EMFILE" mean? According to "man 2 open":
EMFILE The process already has the maximum number of files open.
Now, please check that limit on your machine.
If it is Linux, "ulimit -n" should tell you the value.
Now, that part of your message becomes interesting:
'./many_tables/t2497.frm' (errno: 24)
The combination of "many tables" and EMFILE does shed a light,
and maybe your machine is just configured too small.
If you think your limits are sufficient, check how many tables the test tries to open simultaneously.
All in all, I suppose "Not a bug".
[6 Apr 2011 17:34]
Paul DuBois
Test suite changes. No changelog entry needed. CHANGESET - http://lists.mysql.com/commits/132184
Description: This test is under large_tests suite and is currently not run anywhere. Fix the test if important otherwise retire it worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 large_tests.lock_tables_big [ fail ] Test ended at 2010-11-25 10:52:55 CURRENT_TEST: large_tests.lock_tables_big mysqltest: At line 25: query 'LOCK TABLES $table_list' failed: 1016: Can't open file: './many_tables/t2497.frm' (errno: 24) How to repeat: ./mtr large_tests.lock_tables_big.test