[Firebird-net-provider] [FB-Tracker] Created: (DNET-910) invalid transaction handle with aborted threads

[Christian M. (JIRA) <tr...@fi...>]

invalid transaction handle with aborted threads
-----------------------------------------------

                 Key: DNET-910
                 URL: http://tracker.firebirdsql.org/browse/DNET-910
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 7.1.1.0
         Environment: Firebird 2.5.9, .net 4.5.2
            Reporter: Christian Mayer
            Assignee: Jiri Cincura
         Attachments: FirebirdInvalidTransactionHandle.zip

We get this exception in a multithreaded environment with the use of thread abortion.

FirebirdSql.Data.FirebirdClient.FbException (0x80004005): invalid transaction handle (expecting explicit transaction start) ---> invalid transaction handle (expecting explicit transaction start)
   bei FirebirdSql.Data.FirebirdClient.FbTransaction.Dispose(Boolean disposing)
   bei System.Data.Common.DbTransaction.Dispose()
   bei FirebirdSql.Data.FirebirdClient.FbCommand.RollbackImplicitTransaction()
   bei FirebirdSql.Data.FirebirdClient.FbCommand.CommitImplicitTransaction()
   bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteScalar()

It seems that the unfinished implicit transaction is carried to the next connection through connection pooling.
The remaining connection in the thread pool is unusable then.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira