Issue Details (XML | Word | Printable)

Key: DNET-938
Type: Bug Bug
Status: Closed Closed
Resolution: Cannot Reproduce
Priority: Major Major
Assignee: Jiri Cincura
Reporter: Krosaci
Votes: 0
Watchers: 0

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


Created: 01/Apr/20 09:27 AM   Updated: 26/Jul/20 05:14 PM
Component/s: ADO.NET Provider
Affects Version/s:
Fix Version/s: None

Environment:  Firebird net provider 6.4.0 and Firebird server 2.5.4.

 Description  « Hide
Hello, I ran on specific problem on Firebird net provider (ver. 6.4.0) . Sometimes (once or two times a month) on some machines provider throws after calling Begin Transaction ArgumentOutOfRangeException. Look at callstack:

System.ArgumentOutOfRangeException: operation=159
Parameter name: operation
   at FirebirdSql.Data.Client.Managed.GdsConnection.ProcessOperation(Int32 operation, XdrStream xdr)
   at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadSingleResponse()
   at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse()
   at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse()
   at FirebirdSql.Data.Client.Managed.Version10.GdsTransaction.BeginTransaction(TransactionParameterBuffer tpb)
   at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.BeginTransaction(TransactionParameterBuffer tpb)
   at FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction(FbTransactionOptions options)
   at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.BeginTransaction(FbTransactionOptions options, String transactionName)
   at FirebirdSql.Data.FirebirdClient.FbConnection.BeginTransaction(FbTransactionOptions options)

Or sometimes it throws similar exception but with parameter operation =-16777216.
We are using Firebird server 2.5.4.

Thanks for any advice to resolve this issue.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Jiri Cincura added a comment - 01/Apr/20 09:30 AM
First try to replicate it with latest version, 6.4.0 is quite old.

Christian Mayer added a comment - 15/Jun/20 01:16 PM - edited
Hi, we have the same issue with Verion

System.ArgumentOutOfRangeException: operation=509011189
Parametername: operation
   bei FirebirdSql.Data.Client.Managed.GdsConnection.ProcessOperation(Int32 operation, IXdrReader xdr)
   bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadSingleResponse(Int32 operation)
   bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse[TResponse]()
   bei FirebirdSql.Data.Client.Managed.Version10.GdsTransaction.BeginTransaction(TransactionParameterBuffer tpb)
   bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.BeginTransaction(TransactionParameterBuffer tpb)
   bei FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction()
   bei FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
   bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
   bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
   bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior behavior)
   bei System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)

The operation number varies.
Once this error appears, it seems to happen every time BeginTransaction is called, until we restart our application.


Jiri Cincura added a comment - 15/Jun/20 01:50 PM
Can you replicate it?

Christian Mayer added a comment - 24/Jul/20 08:21 AM
We tried to replicate it on our dev machines without success.
After running sfc /scannow - which found something to fix - the exception doesnt occur anymore.

Jiri Cincura added a comment - 26/Jul/20 05:14 PM
That's unfortunate. :( Thanks for the effort.

I'll close it for now and I'll reopen when somebody has the same problem and can provide more clues.