Solved

ConnectionRead (WrapperRead()) Error

Posted on 2004-09-03
11
1,702 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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
 
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

856 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