Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL Connection getting dropped Expand / Collapse
Author
Message
Posted Sunday, July 31, 2011 4:51 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 20, 2013 4:10 PM
Points: 241, 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

Post #1151564
Posted Monday, August 1, 2011 5:17 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 4:15 AM
Points: 20,581, Visits: 9,619
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?
Post #1151702
Posted Monday, August 1, 2011 7:35 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 20, 2013 4:10 PM
Points: 241, 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

Post #1151796
Posted Monday, August 1, 2011 7:38 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 4:15 AM
Points: 20,581, Visits: 9,619
I've never seen anything else that could explain this... will hang around just in case.
Post #1151800
Posted Monday, August 1, 2011 7:52 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 20, 2013 4:10 PM
Points: 241, 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

Post #1151806
Posted Monday, August 1, 2011 7:54 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 4:15 AM
Points: 20,581, Visits: 9,619
Are you using nolock hints or read uncommitted?

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
Post #1151810
Posted Monday, August 1, 2011 7:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 20, 2013 4:10 PM
Points: 241, 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

Post #1151811
Posted Monday, August 1, 2011 7:58 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 4:15 AM
Points: 20,581, Visits: 9,619
Ninja's_RGR'us (8/1/2011)
I've never seen anything else that could explain this... will hang around just in case.


Post #1151812
Posted Monday, August 1, 2011 8:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 20, 2013 4:10 PM
Points: 241, 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

Post #1151816
Posted Monday, August 1, 2011 8:04 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 8:09 AM
Points: 6,735, Visits: 8,495
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


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

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


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1151817
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse