Submitted by: Pascal D. (pd_87)

Relate to DNET668

We use the Firebird driver to communicate with the Firebird database and our web service. Sometimes there is an error that can only be corrected by restarting the process. The following exception is thrown here:

{
"ClassName": "FirebirdSql.Data.FirebirdClient.FbException",
"Message": "Error reading data from the connection.",
"Data": null,
"InnerException": {
"ClassName": "FirebirdSql.Data.Common.IscException",
"Message": "Unable to write data to the transport connection: The socket has been shut down.",
"Data": null,
"InnerException": {
"ClassName": "System.IO.IOException",
"Message": "Unable to write data to the transport connection: The socket has been shut down.",
"Data": null,
"InnerException": {
"NativeErrorCode": 10058,
"ClassName": "System.Net.Sockets.SocketException",
"Message": "The socket has been shut down",
"Data": null,
"InnerException": null,
"HelpURL": null,
"StackTraceString": " at System.Net.Sockets.Socket.Send (System.Byte[] buffer, System.Int32 offset, System.Int32 size, System.Net.Sockets.SocketFlags socketFlags) [0x00016] in <d2c057d9d34d4e029e580897bd60340c>:0 \n at System.Net.Sockets.NetworkStream.Write (System.Byte[] buffer, System.Int32 offset, System.Int32 size) [0x0009b] in <d2c057d9d34d4e029e580897bd60340c>:0 ",
"RemoteStackTraceString": null,
"RemoteStackIndex": 0,
"ExceptionMethod": null,
"HResult": -2147467259,
"Source": "System"
},
"HelpURL": null,
"StackTraceString": " at System.Net.Sockets.NetworkStream.Write (System.Byte[] buffer, System.Int32 offset, System.Int32 size) [0x000e2] in <d2c057d9d34d4e029e580897bd60340c>:0 \n at FirebirdSql.Data.Client.Managed.XdrStream.Flush () [0x000d3] in <5e7529d7713a478ca878b28774fda053>:0 \n at FirebirdSql.Data.Client.Managed.Version10.GdsTransaction.BeginTransaction (FirebirdSql.Data.Common.TransactionParameterBuffer tpb) [0x00085] in <5e7529d7713a478ca878b28774fda053>:0 ",
"RemoteStackTraceString": null,
"RemoteStackIndex": 0,
"ExceptionMethod": null,
"HResult": -2146232800,
"Source": "System"
},
"HelpURL": null,
"StackTraceString": " at FirebirdSql.Data.Client.Managed.Version10.GdsTransaction.BeginTransaction (FirebirdSql.Data.Common.TransactionParameterBuffer tpb) [0x000dd] in <5e7529d7713a478ca878b28774fda053>:0 \n at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.BeginTransaction (FirebirdSql.Data.Common.TransactionParameterBuffer tpb) [0x00006] in <5e7529d7713a478ca878b28774fda053>:0 \n at FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction () [0x00023] in <5e7529d7713a478ca878b28774fda053>:0 ",
"RemoteStackTraceString": null,
"RemoteStackIndex": 0,
"ExceptionMethod": null,
"HResult": -2146233088,
"Source": "FirebirdSql.Data.FirebirdClient",
"errors": [{
"Message": null,
"ErrorCode": 335544726,
"StrParam": "",
"Type": 1,
"IsArgument": false,
"IsWarning": false
}, {
"Message": "Error reading data from the connection.",
"ErrorCode": 335544726,
"StrParam": "",
"Type": 0,
"IsArgument": false,
"IsWarning": false
}],
"errorCode": 335544726
},
"HelpURL": null,
"StackTraceString": " at FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction () [0x0003c] in <5e7529d7713a478ca878b28774fda053>:0 \n at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbTransaction:BeginTransaction ()\n at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare (System.Boolean returnsSet) [0x00058] in <5e7529d7713a478ca878b28774fda053>:0 \n at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand (System.Data.CommandBehavior behavior, System.Boolean returnsSet) [0x00000] in <5e7529d7713a478ca878b28774fda053>:0 \n at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00037] in <5e7529d7713a478ca878b28774fda053>:0 \n at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader () [0x00000] in <5e7529d7713a478ca878b28774fda053>:0 \n at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbCommand:ExecuteReader ()\n at FirebirdTest.Program.Select (FirebirdSql.Data.FirebirdClient.FbConnection
"RemoteStackTraceString": null,
"RemoteStackIndex": 0,
"ExceptionMethod": null,
"HResult": -2147467259,
"Source": "FirebirdSql.Data.FirebirdClient",
"errors": [{
"Class": 0,
"LineNumber": 0,
"Message": null,
"Number": 335544726
}, {
"Class": 0,
"LineNumber": 0,
"Message": "Error reading data from the connection.",
"Number": 335544726
}]
}

Couldn't the driver automatically delete the connection from the pool?