filesystem_engine.multiple_update test failure on OSX
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Medium
|
Unassigned | ||
7.0 |
Fix Released
|
Medium
|
Unassigned | ||
Dexter |
Won't Fix
|
Medium
|
Unassigned |
Bug Description
On my Mac I get this test failure with filesystem_engine multiple_update, but even more disturbing is that the test data is getting updated after I run the test. See below:
$ ./dtr --suite=
Logging: ./dtr --suite=
Drizzle Version 2010.08.1718
Using MTR_BUILD_THREAD = -69.4
Using MASTER_MYPORT = 9306
Using MASTER_MYPORT1 = 9307
Using SLAVE_MYPORT = 9308
Using SLAVE_MYPORT1 = 9309
Using SLAVE_MYPORT2 = 9310
Using MC_PORT = 9316
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
=======
DEFAULT STORAGE ENGINE: innodb
TEST RESULT TIME (ms)
-------
filesystem_
drizzletest: At line 248: query 'UPDATE t1 SET a=555 WHERE a=666' failed: 1030: Got error 24 from storage engine
The result from queries just before the failure was:
< snip >
UPDATE t1 SET a=666 WHERE a=555;
UPDATE t1 SET a=555 WHERE a=666;
UPDATE t1 SET a=666 WHERE a=555;
UPDATE t1 SET a=555 WHERE a=666;
UPDATE t1 SET a=666 WHERE a=555;
UPDATE t1 SET a=555 WHERE a=666;
UPDATE t1 SET a=666 WHERE a=555;
UPDATE t1 SET a=555 WHERE a=666;
UPDATE t1 SET a=666 WHERE a=555;
UPDATE t1 SET a=555 WHERE a=666;
UPDATE t1 SET a=666 WHERE a=555;
UPDATE t1 SET a=555 WHERE a=666;
UPDATE t1 SET a=666 WHERE a=555;
UPDATE t1 SET a=555 WHERE a=666;
UPDATE t1 SET a=666 WHERE a=555;
UPDATE t1 SET a=555 WHERE a=666;
UPDATE t1 SET a=666 WHERE a=555;
UPDATE t1 SET a=555 WHERE a=666;
UPDATE t1 SET a=666 WHERE a=555;
UPDATE t1 SET a=555 WHERE a=666;
More results from queries before failure can be found in /Users/
% bzr status
modified:
plugin/
Related branches
- Monty Taylor: Approve
-
Diff: 68 lines (+17/-11)1 file modifiedplugin/filesystem_engine/filesystem_engine.cc (+17/-11)
Changed in drizzle: | |
status: | New → Confirmed |
Changed in drizzle: | |
assignee: | nobody → ziminq (ziminq) |
importance: | Undecided → Medium |
CURRENT_TEST: filesystem_ engine. multiple_ update
drizzletest: At line 248: query 'UPDATE t1 SET a=555 WHERE a=666' failed: 1030: Got error 24 from storage engine
Davids-iMac:~ david$ perror 24
OS error code 24: Too many open files
Default Mac OS X limit of open files = 256
Default Linux limit of open files = 1024
It seems, from a quick inspection of the test, that for each UPDATE, a new file handle is acquired and never closed. Bug in the engine?