I recently switched from an older provider version (2.x something) to the current 5.0.5.0 build and use it in an embedded scenario. In that process I also switched from FB 2.5 to 3.0
I have stability problems when the system gets under heavy load with concurrent transactions/connections. I receive 335544332 errors (invalid transaction handle) from random locations. Any pointers at what to look? Typical stacks look like FirebirdSql.Data.Common.IscException: invalid transaction handle (expecting explicit transaction start) at FirebirdSql.Data.Client.Native.FesDatabase.ProcessStatusVector(IntPtr[] statusVector) at FirebirdSql.Data.Client.Native.FesStatement.Prepare(String commandText) at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteScalar() or FirebirdSql.Data.Common.IscException: invalid transaction handle (expecting explicit transaction start) at FirebirdSql.Data.Client.Native.FesDatabase.ProcessStatusVector(IntPtr[] statusVector) at FirebirdSql.Data.Client.Native.FesTransaction.Commit() at FirebirdSql.Data.FirebirdClient.FbTransaction.Commit() or FirebirdSql.Data.Common.IscException: invalid transaction handle (expecting explicit transaction start) at FirebirdSql.Data.Client.Native.FesDatabase.ProcessStatusVector(IntPtr[] statusVector) at FirebirdSql.Data.Client.Native.FesStatement.Prepare(String commandText) at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteScalar()
------------------------------------------------------------------------------
_______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider