db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1455) Intermittent failure in derbynet/runtimeinfo.java
Date Sat, 24 Jun 2006 18:44:32 GMT
     [ 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


Mime
View raw message