db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepa Remesh (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1219) jdbcapi/checkDataSource.java and jdbcapi/checkDataSource30.java hang intermittently with client
Date Wed, 10 May 2006 17:33:10 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1219?page=comments#action_12378954 ] 

Deepa Remesh commented on DERBY-1219:
-------------------------------------

Posting my observation with the patch 'no-sessions-for-closed-threads.diff': I think this
patch solves the problem of "poisoned" threads partially. It makes sure that a thread which
has been marked closed does not get a session to work on. However, the session which came
in is still hanging because there are no new threads which can pick it up. When the session
came in, server had queued it so that a free thread picks it up. But the thread which picked
it up was a "poisoned" (closed) thread. So the session is still waiting for another thread.


To test that the hang will go away when a new thread gets created, I opened another connection
using ij. This made the hang go away and the repro ran to the end. When the connection from
ij came in, the newly created thread was able to work on the waiting session and resolve the
hang.

Bryan, I am looking at your trial patch "interrupt.diff" which looks like a good solution
to me too. This patch made the hang go away on my machine. But you had said that it did not
resolve all hangs for you. Can you please post your observations with this patch?

> jdbcapi/checkDataSource.java and jdbcapi/checkDataSource30.java hang intermittently with
client
> -----------------------------------------------------------------------------------------------
>
>          Key: DERBY-1219
>          URL: http://issues.apache.org/jira/browse/DERBY-1219
>      Project: Derby
>         Type: Test

>   Components: Network Server, Network Client
>     Versions: 10.2.0.0
>  Environment: More often on jdk 1.5 or jdk 1.6 but hangs on jdk 1.4.2 as well
>     Reporter: Kathey Marsden
>     Assignee: Bryan Pendleton
>     Priority: Minor
>  Attachments: client_stack_trace_050306.txt, drda_traces_050206.zip, interrupt.diff,
no-sessions-for-closed-threads.diff, server_stack_trace_050306.txt, skipThreads.diff, testfiles_afterhang.zip,
traces_on_hang.txt
>
> The tests checkDataSource.java and checkDataSource30.java 
> hang intermittently especially with jdk 1.5.
> Attached is the test run output and traces when the server is started separately.
> 1) Enable checkDataSource30.java by taking it out of functionTests/suites/DerbyNetClient.exclude.
> 2) Run the test with client.
> java -Dij.exceptionTrace=true -Dkeepfiles=true -Dframework=DerbyNetClient org.apache.derbyTesting.functionTests.harness.RunTest
jdbcapi/checkDataSource30.java
> Attachements:
>  testfiles_after_hang.zip - Test directory.
>  traces_on_hang.txt  - Server side traces obtained by starting the server separately
before running the test.
> I wish I had time to work on this right now as I would really like to see this valuable
test in the suite, but hopefully someone else will pick it up.

-- 
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