[jira] Commented: (DERBY-273) The derbynet/dataSourcePermissions_net.java test fails intermittently

     [ 
http://issues.apache.org/jira/browse/DERBY-273?page=comments#action_65999 ]
     
Kathey Marsden commented on DERBY-273:
--------------------------------------

When network server closes a session, it tries to perform a rollback on the 
connection before closing the connection. If it encounters an exception during 
rollback it treats the exception as an unexpected exception and prints the 
error to the console. 

However, in this case, the database has been intentionally shut down and the 
error on rollback is expected. Network Server should treat an error on 
rollback, when closing a session, as an expected exception if the database has 
been intentionally shut down. 

The intermittent nature of this diff seems to be related to when the session 
for the disconnected client that shutdown the database gets cleaned up. 

When the test fails, this is the trace in the tmp file: 

org.apache.derby.iapi.services.context.ShutdownException: 
at 
org.apache.derby.iapi.services.context.ContextManager.checkInterrupt(ContextManager.java:374)
 
at 
org.apache.derby.iapi.services.context.ContextManager.popContext(ContextManager.java:152)
 
at 
org.apache.derby.iapi.services.context.ContextImpl.popMe(ContextImpl.java:80) 
at 
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.resetSavepoints(GenericLanguageConnectionContext.java:1309)
 
at 
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.doRollback(GenericLanguageConnectionContext.java:1288)
 
at 
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.userRollback(GenericLanguageConnectionContext.java:1199)
 
at 
org.apache.derby.impl.jdbc.TransactionResourceImpl.rollback(TransactionResourceImpl.java:244)
 
agentThread[DRDAConnThread_3,5,derby.daemons] 
at 
org.apache.derby.impl.jdbc.EmbedConnection.rollback(EmbedConnection.java:894) 
at org.apache.derby.impl.drda.Database.close(Database.java:352) 
at org.apache.derby.impl.drda.Session.close(Session.java:110) 
at 
org.apache.derby.impl.drda.DRDAConnThread.closeSession(DRDAConnThread.java:6803)
 
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:241) 
EXPECTED SHUTDOWN DERBY SQL error: SQLCODEWhen network server closes a session, 
it tries to perform a rollback on the connection before closing the connection. 
If it encounters an exception during rollback it treats the exception as an 
unexpected exception and prints the error to the console. 

However, in this case, the database has been intentionally shut down and the 
error on rollback is expected. Network Server should treat an error on 
rollback, when closing a session, as an expected exception if the database has 
been intentionally shut down. 

The intermittent nature of this diff seems to be related to when the session 
for the disconnected client that shutdown the database gets cleaned up. 

When the test fails, this is the trace in the tmp file: 

org.apache.derby.iapi.services.context.ShutdownException: 
at 
org.apache.derby.iapi.services.context.ContextManager.checkInterrupt(ContextManager.java:374)
 
at 
org.apache.derby.iapi.services.context.ContextManager.popContext(ContextManager.java:152)
 
at 
org.apache.derby.iapi.services.context.ContextImpl.popMe(ContextImpl.java:80) 
at 
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.resetSavepoints(GenericLanguageConnectionContext.java:1309)
 
at 
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.doRollback(GenericLanguageConnectionContext.java:1288)
 
at 
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.userRollback(GenericLanguageConnectionContext.java:1199)
 
at 
org.apache.derby.impl.jdbc.TransactionResourceImpl.rollback(TransactionResourceImpl.java:244)
 
agentThread[DRDAConnThread_3,5,derby.daemons] 
at 
org.apache.derby.impl.jdbc.EmbedConnection.rollback(EmbedConnection.java:894) 
at org.apache.derby.impl.drda.Database.close(Database.java:352) 
at org.apache.derby.impl.drda.Session.close(Session.java:110) 
at 
org.apache.derby.impl.drda.DRDAConnThread.closeSession(DRDAConnThread.java:6803)
 
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:241) 
EXPECTED SHUTDOWN DERBY SQL error: SQLCODE: -1, SQLSTATE: 08006 ...

> 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

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

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