Error occurred while reading the input stream from the network

Hi,

I am facing this error in SQL server error logs on my active\passive Cluster set around 10-20 times per day, can anyone guide me according to the versions and service pack that is been used

Edition : SQLserver2008R2 Enterprise edition

SQL SP: SP1

Windows : 2008R2 Enterprise windows

  2012-07-30 04:44:15.560 A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 10054, output error: 0).

August 2nd, 2012 1:34pm

You may want to look at this article: http://www.sqlcoffee.com/Troubleshooting004.htm

Typically, this problem occurs when the network adapter uses the Broadcom 5708 chipset. For example, the following network adapters use the Broadcom 5708 chipset:

  • Broadcom NetXtreme II
  • Hewlett-Packard NC373i Multifunction Gigabit Server Adapter

http://support.microsoft.com/kb/942861

Free Windows Admin Tool Kit Click here and download it now
August 2nd, 2012 2:28pm

Thanks for this, but the links mentioned directs to windows 2003 and SQL2005, is this an generic issue unmindful of version as we use 2008R2 Ent on both db/serverlevel.
August 2nd, 2012 2:32pm

If you are using this network card, then yes, this is a driver issue with the network card.  It is independent of the OS and SQL Server version.

Free Windows Admin Tool Kit Click here and download it now
August 2nd, 2012 3:29pm

PS. I have seen this issue with other network cards also.   I have had to use the workaround of turning off TCP Chimney.

August 2nd, 2012 3:32pm

Thanks Tom, but this is ENT Windows 2008 R2 and this option for workaround on turning off the TCP chimney is not present in reg-edit, we can find only one enable clause which is 'EnableICMPRedirect'.

Attached image has the Adaptor type.

Free Windows Admin Tool Kit Click here and download it now
August 3rd, 2012 12:54pm

can find this link on enabling\disabling

http://technet.microsoft.com/en-us/library/gg162682%28v=ws.10%29.aspx

but how to find if its actually enabled in my server ..

August 3rd, 2012 1:13pm

As said before this error is general for those network adapter.

To check the status of TCP Chimney use this:

netsh int tcp show global


Free Windows Admin Tool Kit Click here and download it now
August 4th, 2012 11:09pm

As said before this error is general for those network adapter.

To check the status of TCP Chimney use this:

netsh int tcp show global


August 4th, 2012 11:09pm

In Windows 2008 this is the document:

http://support.microsoft.com/kb/951037

  • To determine the current status of TCP Chimney Offload, follow these steps:
    1. Use administrative credentials to open a command prompt.
    2. At the command prompt, type the following command, and then press ENTER: netsh int tcp show global
Free Windows Admin Tool Kit Click here and download it now
August 6th, 2012 4:17pm

In Windows 2008 this is the document:

http://support.microsoft.com/kb/951037

  • To determine the current status of TCP Chimney Offload, follow these steps:
    1. Use administrative credentials to open a command prompt.
    2. At the command prompt, type the following command, and then press ENTER: netsh int tcp show global
August 6th, 2012 4:17pm

we have experienced this error  a week ago. our network team, security team and database team search every thing. At the end of the researching we have detected the error resource.
It is the IPS device. Ask your security team is there any signature on IPS device.
Free Windows Admin Tool Kit Click here and download it now
November 5th, 2014 9:26am

I encountered this same error in sqlserver errorlog

: 4014: 20: 13
A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 64, output error: 0).      

                                                                                   

May 8th, 2015 12:42am

We are running SQL 2012 and I just started seeing these errors but in this case I found that they are related to error 8061.  A stored procedure is being called from C#, passing a table parameter that does not match the definition in the stored procedure.

The data for table-valued parameter "%.*ls" doesn't conform to the table type of the parameter.

Free Windows Admin Tool Kit Click here and download it now
July 17th, 2015 3:03pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics