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 "Kathey Marsden (JIRA)" <de...@db.apache.org> on 2005/05/22 22:57:52 UTC

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

     [ http://issues.apache.org/jira/browse/DERBY-273?page=comments#action_65997 ]
     
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: SQLCODE: -1, SQLSTATE: 08006, SQLERRMC: wombat08006.DDatabase 'wombat' shutdown.(server log:D:\dev\src\JarResults.2005-05-19\jdk142_derbyall\derbyall\derbynetclientmats\DerbyNetClient\derbynetmats\derbynetmats\dataSourcePermissions_net\derby.log




> 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