Solved

ConnectionRead (WrapperRead()) Error

Posted on 2004-09-03
11
1,688 Views
Last Modified: 2010-08-05
O/S Win2k Advanced Server
Running SQL Server sp3

Using
MDAC 2,80,1022,3
ADO 2.8
VB 6

For a while now our SQL server has been returning this error:
[DBNETLIB][ConnectionRead (WrapperRead()).]General network error. Check your network documentation

It seems that many people have run into this problem but not much in solutions has really been posted (well, at least not one that works for me)

It gets very troublesome since it seems that the database gets locked when this error is generated.  To provide a temporary remedy I have to clear all connections to the database, sometimes more than once.  I have been searching the web for a while and have been trying to find a remedy for this and trying any solution I have found that may provide a solution to this problem.  Turnging connection pooling off (in reference to kb article http://support.microsoft.com/default.aspx?scid=kb;en-us;Q229564).

This problem isn't happening on all databases either, which makes this even more troublesome.

Everything at the database level seems to be checking out (I've run DBCC checks with no errors being generated in reference to http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21076842.html).  I've tried running performance traces to see if there is a TCP reset that is happening but haven't seen one yet.  It seems that a TCP reset is probably causing the error but I can't seem to find it.  In looking at KB I found the following article: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q154/6/28.asp&NoWebContent=1 and applied this fix hoping that this was the problem causing TCP resets.  The problem was not fixed by this.  The named pipes and TCP settings in the client network utility are fine and the web server recognizes by IP and Name.

Any help would be greatly appreciated.
0
Comment
Question by:poliguin
  • 4
  • 4
  • 3
11 Comments
 
LVL 18

Assisted Solution

by:ShogunWade
ShogunWade earned 200 total points
Comment Utility
Might be the completely wrong in your case,  but I had a similar error some time ago on a heavily stressed server.   It turned out that the raid controller card was intermittently flaking out and coming back.   Replaced the controller and its been ok since.
0
 
LVL 2

Author Comment

by:poliguin
Comment Utility
That's worth a shot.  I don't get to control such decisions, etc but I'll see if that works.
0
 
LVL 18

Expert Comment

by:ShogunWade
Comment Utility
check in your system event log and application log for any disk errors.  or if you have something like a PERC controller (which we have) there were a series on events in the raid diagnostic software.

0
 
LVL 34

Accepted Solution

by:
arbert earned 300 total points
Comment Utility
Agree with ShogunWade....I've found that when most of these errors have happened it's because of overly HIGH IO on the server....

I really hate this error 'cause it really isn't indicative of what the problem might actually be!
0
 
LVL 18

Expert Comment

by:ShogunWade
Comment Utility
"I really hate this error 'cause it really isn't indicative of what the problem might actually be!"

Me too,  unfortunately I didnt discover what it was in my case untill the controller died completely ;(
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 34

Expert Comment

by:arbert
Comment Utility
Ouch!  

I don't want to hijack the question, but shogun, why don't you drop me an email sometime--my addy is in my profile....

Brett
0
 
LVL 18

Expert Comment

by:ShogunWade
Comment Utility
will do
0
 
LVL 2

Author Comment

by:poliguin
Comment Utility
highjack away.  I'm going to have someone look into the Raid controller and see if that's the problem.  If it isn't then I'll try and get the thread back, ha.
0
 
LVL 2

Author Comment

by:poliguin
Comment Utility
after doing more research and it seems to be pointing to the client connection reseting the connection.  i've come to this conclusion after finally finding a query that i've found to cause the problem from several different locations and have found that when i do it remotely that i end up getting this error back.

it also helped when i finally got enterprise manager to return the error [microsoft][odbc SQL Server Driver]Communication Link Failure.  it's kind of funny that i should be getting a connection timeout error since the offending query i've been running exceeds the connection timeout but instead decides it wants to return this error instead and lock the database up (the connections are getting properly closed within the error handling).

finding where this tcp reset is the part that i have no idea about.  i've been asking the network guy to run checks on the router, switch, etc for the past week or so but he seems to insist that it is highly unlikely anything would ever go wong with them.  being this the case, how do i go about finding out where this reset is coming from?
0
 
LVL 2

Author Comment

by:poliguin
Comment Utility
it wasn't really the raid controller but rather high io that was causing the server to conk out on an intermittant basis.  it tended to be more intensive querries that were causing this problem most of the time.
0
 
LVL 34

Expert Comment

by:arbert
Comment Utility
Nice--glad someone else has verified this same problem :)  Just doesn't make sense to me why things are so quick to timeout in these scenarios...
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now