[ 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

Reply via email to