SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Connection getting dropped


SQL Connection getting dropped

Author
Message
BeerBeerBeer
BeerBeerBeer
Mr or Mrs. 500
Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)

Group: General Forum Members
Points: 523 Visits: 74
I have a situation with one of our clients where one of our utility applications is losing it's SQL connection after it has successfully retrieved data.

For instance, the customer can log into the application, load a list of members, but on trying to view an individual members details we'll get the following exception

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

The Connection String uses an IP address to get to the server - don't know if this makes behaviour any different - I would doubt it though.

Have tried it with pooling=false but no difference.

Have elongated the server time out setting to no avail.

We have multiple clients connection to the DB server in this fashion but only some of them are experiencing this behaviour.

At this point, at a loss as to where to look next - hopefully someone has some fresh ideas about what might be happening - or can ask some questions that might open up those ideas

TIA
Steve


Regards,

Steve

Life without beer is no life at all

All beer is good, some beers are just better than others

Ninja's_RGR'us
Ninja's_RGR'us
SSC-Dedicated
SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)

Group: General Forum Members
Points: 37151 Visits: 9671
Are those users connected on a db with log-shipping?

Do you kill connection to resolve blocking?

Do you reboot the server (or service) on a regular basis?
BeerBeerBeer
BeerBeerBeer
Mr or Mrs. 500
Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)

Group: General Forum Members
Points: 523 Visits: 74
Ninja's_RGR'us (8/1/2011)
Are those users connected on a db with log-shipping?

No

Do you kill connection to resolve blocking?

No

Do you reboot the server (or service) on a regular basis?

No

If I can work my way down this list

There is no log shipping - effectively there is no real DBA in control. You'd have to live outside a large country to understand the small systems we work with (actually, they're large to us ... ) ;-)

The connection is getting killed during processing of a query - no need for us to kill it. No, the application does not kill the connection (though I will review this)

If you have to reboot your server, you're doing it wrong in the first place. But the direct answer is No.

Appreciate your questions, hope my answers lead to more

Regards
Steve


Regards,

Steve

Life without beer is no life at all

All beer is good, some beers are just better than others

Ninja's_RGR'us
Ninja's_RGR'us
SSC-Dedicated
SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)

Group: General Forum Members
Points: 37151 Visits: 9671
I've never seen anything else that could explain this... will hang around just in case.
BeerBeerBeer
BeerBeerBeer
Mr or Mrs. 500
Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)

Group: General Forum Members
Points: 523 Visits: 74
I agree.

Very weird

The fact that the connection happens and data is retrieved, THEN the connection is lost ???

We have other environments where this utility is running without any issue whatsoever.

One last piece of information (which shouldn't make any difference) is that the DB is sitting behind a Terminal Server environment for the actual application. We are connecting direct to the SQL Server instance with our connection string for this utility app, ignoring the TS setup.

Don't know if that makes a difference - again suspect not.

Again, thanks for questions, suggestions, ideas.

Steve


Regards,

Steve

Life without beer is no life at all

All beer is good, some beers are just better than others

Ninja's_RGR'us
Ninja's_RGR'us
SSC-Dedicated
SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)

Group: General Forum Members
Points: 37151 Visits: 9671
Are you using nolock hints or read uncommitted?

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
BeerBeerBeer
BeerBeerBeer
Mr or Mrs. 500
Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)

Group: General Forum Members
Points: 523 Visits: 74
There are no hints in the DB queries and we do not suggest how the lock should be - basically we trust SQL Server


Regards,

Steve

Life without beer is no life at all

All beer is good, some beers are just better than others

Ninja's_RGR'us
Ninja's_RGR'us
SSC-Dedicated
SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)

Group: General Forum Members
Points: 37151 Visits: 9671
Ninja's_RGR'us (8/1/2011)
I've never seen anything else that could explain this... will hang around just in case.


Ermm
BeerBeerBeer
BeerBeerBeer
Mr or Mrs. 500
Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)

Group: General Forum Members
Points: 523 Visits: 74
I do believe that is a similar face to mine once I was told this was happening ...


Regards,

Steve

Life without beer is no life at all

All beer is good, some beers are just better than others

ALZDBA
ALZDBA
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15782 Visits: 8971
is there a query exception recorded in e.g. errorlog ( deadlock / error with Severity levels from 20 through 25 are considered fatal. If a fatal severity level is encountered, the client connection is terminated after receiving the message, and the error is logged in the error and application logs.)

Johan


Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


press F1 for solution, press shift+F1 for urgent solution :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
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