filesystem_engine.multiple_update test failure on OSX

Bug #621304 reported by Lee Bieber
8
This bug affects 1 person
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=filesystem_engine multiple_update
Logging: ./dtr --suite=filesystem_engine multiple_update
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_engine.multiple_update [ fail ]
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/lbieber/repos/trunk/tests/var/log/multiple_update.log

% bzr status
modified:
  plugin/filesystem_engine/tests/t/multiple_update.data

Related branches

Changed in drizzle:
status: New → Confirmed
Changed in drizzle:
assignee: nobody → ziminq (ziminq)
importance: Undecided → Medium
Revision history for this message
David Shrewsbury (dshrews) wrote :

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?

Revision history for this message
Lee Bieber (kalebral-deactivatedaccount) wrote :

I just confirmed this by changing the open files limit to 1024 on my Mac and the test now passes

Revision history for this message
Monty Taylor (mordred) wrote : Re: [Bug 621304] Re: filesystem_engine.multiple_update test failure on OSX

On 09/16/2010 11:51 AM, Lee Bieber wrote:
> I just confirmed this by changing the open files limit to 1024 on my Mac
> and the test now passes
>

Can we perhaps just have test-run.pl set open files limit if it's on a mac?

Revision history for this message
David Shrewsbury (dshrews) wrote :

Nope. That just hides the bug, which needs fixed.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers