Tomohito Nakayama (JIRA) wrote:
>I suspect there exists remaining previous thread concerning with that database
>, when
>
Yes, probably one connection shutdown the database intentionally , and
then another had trouble doing a rollback in Database.close(), that
exception is to be expected but we need to make sure the connection
closes properly.
>shutting down the database...
>Then ShutdownException is thrown from previous working thread , I wonder.
>
>
>
More details
SYMPTOM
- The test shuts down the database intentionally with shudown=true.
- When a database has been shutdown and connections terminate, an
exception may occur in Database.close() on rollback. It depends
on timing and is not a problem. The trouble is that if that an error
occurs on rollback we never close
the connection and clean up properly.
- Network Server prints exceptions that occur when closing the
connection to the console, because failing to
close the connection can cause a leak.
- Depending on timing you may or may not see the exception print to
the console.
POSSIBLE SOLUTION
Database.close() should only throw an exception if the connection
fails to close, not if the rollback fails.
i.e. catch the rollback exception and proceed with conn.close()
There is yet more detailed information in the Jira entry description of
the problem.
I hope this helps.
Kathey
>>The derbynet/dataSourcePermissions_net.java test fails intermittently
>>---------------------------------------------------------------------
>>
>> Key: DERBY-273
>> URL: http://issues.apache.org/jira/browse/DERBY-273
>> Project: Derby
>> Type: Bug
>> Environment: 1.4.2 JVM (both Sun and IBM)
>> Reporter: Jack Klebanoff
>> Assignee: Tomohito Nakayama
>>
>>
>
>
>
>>The test fails in the derbyall/derbynetclientmats/derbynetmats suite stack
>>with the following diff:
>>*** Start: dataSourcePermissions_net jdk1.4.2 DerbyNetClient
>>derbynetmats:derbynetmats 2005-05-11 04:24:11 ***
>>17a18,19
>>
>>
>>>org.apache.derby.iapi.services.context.ShutdownException:
>>>agentThread[DRDAConnThread_2,5,derby.daemons]
>>>
>>>
>>Test Failed.
>>
>>
>
>
>
