Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
Fraggle257
Fraggle257
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 3098
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
Nicholas Cain
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2084 Visits: 6200
It looks like a network error. I would check your network connectivity, see if you are dropping packets. Netmon or wireshark 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
Fraggle257
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 3098
Thank you so much for the reply, I will look into this and let you know how I get on!
Nicholas Cain
Nicholas Cain
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2084 Visits: 6200
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
george sibbald
SSCertifiable
SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)

Group: General Forum Members
Points: 6364 Visits: 13687
Fraggle, did you resolve this?

---------------------------------------------------------------------
Fraggle257
Fraggle257
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 3098
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
george sibbald
SSCertifiable
SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)

Group: General Forum Members
Points: 6364 Visits: 13687
ok, thanks for replying. We also see these on a new super-spec server at times of load.

---------------------------------------------------------------------
Fraggle257
Fraggle257
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 3098
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
aravindkumar.h23
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 98
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search