Exception: The socket has been shut down.
-----------------------------------------

                 Key: DNET-807
                 URL: http://tracker.firebirdsql.org/browse/DNET-807
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.5.0.0
         Environment: Ubuntu 16.04 lts
Mono 5.2.0.215
Pooling active (default )
            Reporter: Pascal D.
            Assignee: Jiri Cincura


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? 

-- 
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

       

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to