Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Wed, 28 Sep 2005 16:35:27 +0200
From: Oyvind.Bakksjo@Sun.COM
Subject: Re: [jira] Updated: (DERBY-579) Query timeout set for one statement
 may affect other statements with the same SQL string
In-reply-to: <4334A6D4.2080901@Sourcery.Org>
To: Derby Development <derby-dev@db.apache.org>
Message-id: <433AAA2F.1010809@sun.com>
Organization: Sun Microsystems
MIME-version: 1.0
Content-type: text/plain; charset=us-ascii; format=flowed
Content-transfer-encoding: 7BIT
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7) Gecko/20040618
References: <1216783041.1127225428457.JavaMail.jira@ajax.apache.org>
 <4333FF25.5080908@sun.com> <4334A6D4.2080901@Sourcery.Org>

Satheesh Bandaram wrote:
> I am not exactly objecting  :-) , but it would be nice to add a test
> case to show the problem the fix is attempting to fix. I suspect the
> original issue is easy to introduce, but hard to catch.
> 
> While we are on this topic, I noticed SetQueryTimeoutTest test takes
> around 30-40 minutes on my laptop. On one of our build machines, it
> actually runs for longer than 2 hours when the test harness actually
> kills the test. (causing the test to fail everytime) Though this is more
> of our test machine problem (it is really sloooow), taking 30-40 minutes
> for one functional test seems too long. Is there anyway the test can be
> made to run faster?

You realize that you are making conflicting requests, don't you? ;-) 
More tests in less time!

I ran the test in 15 minutes, which is less than what you are 
experiencing, but I still think it is too much. I'll look into making 
the test run faster. The problem is that it's hard to tune the size of 
the tables so you're "guaranteed" that the fetching of some rows will 
take longer than the timeout value.

I'll also look at adding a testcase for the bug that this patch addresses.

-- 
Oyvind Bakksjo
Sun Microsystems, Database Technology Group
Trondheim, Norway
http://weblogs.java.net/blog/bakksjo/