Solved

ConnectionRead (WrapperRead()) Error

Posted on 2004-09-03
11
1,694 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
ID: 11974929
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
ID: 11974951
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
ID: 11975004
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
ID: 11975199
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
ID: 11975238
"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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 34

Expert Comment

by:arbert
ID: 11975267
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
ID: 11975392
will do
0
 
LVL 2

Author Comment

by:poliguin
ID: 11975441
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
ID: 12051437
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
ID: 12068597
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
ID: 12068667
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

863 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

22 Experts available now in Live!

Get 1:1 Help Now