Issue Details (XML | Word | Printable)

Key: DNET-910
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Jiri Cincura
Reporter: Christian Mayer
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
.NET Data provider

invalid transaction handle with aborted threads

Created: 22/Oct/19 01:49 PM   Updated: 22/Oct/19 01:51 PM
Component/s: ADO.NET Provider
Affects Version/s: 7.1.1.0
Fix Version/s: None

File Attachments: 1. Zip Archive FirebirdInvalidTransactionHandle.zip (608 kB)

Environment: Firebird 2.5.9, .net 4.5.2


 Description  « Hide
Hi,

we migrated our project from version 2.6.5.1 to 7.1.1.0.
After that 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.
A sample project is attached.
The remaining connection in the thread pool is unusable then.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Christian Mayer added a comment - 22/Oct/19 01:49 PM
Example project