You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <de...@db.apache.org> on 2006/06/24 20:21:31 UTC
[jira] Created: (DERBY-1455) Intermittent failure in
derbynet/runtimeinfo.java
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
Assigned to: Knut Anders Hatlen
Priority: Minor
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
[jira] Updated: (DERBY-1455) Intermittent failure in
derbynet/runtimeinfo.java
Posted by "Knut Anders Hatlen (JIRA)" <de...@db.apache.org>.
[ 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
[jira] Closed: (DERBY-1455) Intermittent failure in
derbynet/runtimeinfo.java
Posted by "Knut Anders Hatlen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1455?page=all ]
Knut Anders Hatlen closed DERBY-1455:
-------------------------------------
Fix Version: 10.2.0.0
Resolution: Fixed
Committed revision 417131.
> 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
> Fix For: 10.2.0.0
> 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
[jira] Updated: (DERBY-1455) Intermittent failure in
derbynet/runtimeinfo.java
Posted by "Knut Anders Hatlen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1455?page=all ]
Knut Anders Hatlen updated DERBY-1455:
--------------------------------------
Derby Info: [Patch Available]
> 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