SQL 2008 Error: 4014, Severity: 20, State: 11

  • Fraggle257

    Say Hey Kid

    Points: 712

    Hi

    I have had a problem with our SQL server which has resulted in the error message below. I have searched Microsoft but they don't have any further information on the error. I wondered if anyone else has come across it. It is causing a problem because it caused our ISA to crash as it was unable to write to the database for more than 30 seconds!

    Any ideas much appreciated!

    Many thanks!

    Fraggle

    Log Name: Application

    Source: MSSQL$CORPORATE

    Date: 24/02/2010 12:20:53

    Event ID: 4014

    Task Category: Server

    Level: Error

    Keywords: Classic

    User: N/A

    Computer: W8-SQL3A.XXX

    Description:

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

  • Nicholas Cain

    SSC-Dedicated

    Points: 33009

    It looks like a network error. I would check your network connectivity, see if you are dropping packets. Netmon or wireshark [/url] would both be a help in packet investigation, plus you can use perfmon to look at your network stats.

    Also, have a look at http://support.microsoft.com/kb/942861 as regards network issues with certain NIC's and TCP Chimney Offloading.



    Shamless self promotion - read my blog http://sirsql.net

  • Fraggle257

    Say Hey Kid

    Points: 712

    Thank you so much for the reply, I will look into this and let you know how I get on!

  • Nicholas Cain

    SSC-Dedicated

    Points: 33009

    Oh, and don't forget to check out both ends of the communication chain. I spent a good while troubleshooting something in the past just to find out it was the front end actually causing the problem.



    Shamless self promotion - read my blog http://sirsql.net

  • george sibbald

    SSC Guru

    Points: 104200

    Fraggle, did you resolve this?

    ---------------------------------------------------------------------

  • Fraggle257

    Say Hey Kid

    Points: 712

    I wish I could offer some good advice to help resolve this however it just seemed to go away on its own! I think it could perhaps have been dropping some packets of data due to heavy network traffic whilst performing database backups across the network to our tape jukebox however, I was never certain!

  • george sibbald

    SSC Guru

    Points: 104200

    ok, thanks for replying. We also see these on a new super-spec server at times of load.

    ---------------------------------------------------------------------

  • Fraggle257

    Say Hey Kid

    Points: 712

    Interestingly, our server was also virtually brand new and very high spec also which is why my thoughts turned to the point of packet loss being the cross network traffic.

  • aravindkumar.h23

    SSC Enthusiast

    Points: 192

    Hello All,

    I guess the reason for this error is given in the below link. Have a look once.

    Its due to TCP Chimney offloading data to Network Adapter.

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/9fcefe31-e525-46c0-8e62-e6a7e1178feb/error-occurred-while-reading-the-input-stream-from-the-network

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply