[ 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