Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <21854799.1151174672550.JavaMail.jira@brutus>
Date: Sat, 24 Jun 2006 18:44:32 +0000 (GMT+00:00)
From: "Knut Anders Hatlen (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-1455) Intermittent failure in
 derbynet/runtimeinfo.java
In-Reply-To: <1484410.1151173291758.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

     [ http://issues.apache.org/jira/browse/DERBY-1455?page=all ]

Knut Anders Hatlen updated DERBY-1455:
--------------------------------------

    Attachment: derby-1455.diff
                derby-1455.stat

Attached a patch which seems to fix the problem. I ran the test 421 times with the jar files from the 10.2.0.3 snapshot, and it failed 337 times (80% of the time). With the patch applied, I ran the test 814 times without any failures.

The problem occurs when the test has opened four connections, closes three of them and runs getRuntimeInfo() on the server. The test expects that there is one active session on the server, but in some cases, the network server has not had enough time to clean up after the closed connections, and more sessions are listed as active.

The patch solves this timing issue by invoking Thread.sleep(1000) before calling getRuntimeInfo().

> Intermittent failure in derbynet/runtimeinfo.java
> -------------------------------------------------
>
>          Key: DERBY-1455
>          URL: http://issues.apache.org/jira/browse/DERBY-1455
>      Project: Derby
>         Type: Bug

>   Components: Test
>     Versions: 10.2.0.0
>     Reporter: Knut Anders Hatlen
>     Assignee: Knut Anders Hatlen
>     Priority: Minor
>  Attachments: derby-1455.diff, derby-1455.stat
>
> I often see failures of this type in derbynet/runtimeinfo.java:
> ********* Diff file derbyall/derbynetclientmats/DerbyNetClient/derbynetmats/derbynetmats/runtimeinfo.diff
> *** Start: runtimeinfo jdk1.5.0_04 DerbyNetClient derbynetmats:derbynetmats 2006-01-20 23:19:43 ***
> 57a58,66
> > Session # :4
> > Database :wombat;create=true
> > User :APP
> > # Statements:2
> > Prepared Statement Information: 
> > 	Stmt ID		SQLText
> > 	-------------	-----------
> > 	SYSLH0002	VALUES(2)
> > 	SYSLH0001	SELECT count(*) from sys.systables
> 61 del
> < # Active Sessions : 1
> 61a70
> > # Active Sessions : 2
> Test Failed.
> *** End:   runtimeinfo jdk1.5.0_04 DerbyNetClient derbynetmats:derbynetmats 2006-01-20 23:19:51 ***
> It doesn't seem to happen very frequently in Ole's nightly testing, but it has occurred there too:
> http://www.multinet.no/~solberg/public/Apache/TinderBox_Derby/testlog/SunOS-5.10_i86pc-i386/386483-derbyall_diff.txt
> http://www.multinet.no/~solberg/public/Apache/Derby/testlog/Linux-2.6.14-1.1644_FC4_i686-i686/354827-derbyall_diff.txt
> http://www.multinet.no/~solberg/public/Apache/Derby/testlog/Linux-2.6.14-1.1644_FC4_i686-i686/355169-derbynetmats_diff.txt
> http://www.multinet.no/~solberg/public/Apache/Derby/testlog/SunOS-5.10_i86pc-i386/321161-derbynetclientmats_diff.txt
> http://www.multinet.no/~solberg/public/Apache/Derby/testlog/SunOS-5.10_i86pc-i386/370878-derbyall_diff.txt

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira