1

I keep running into this error message while debugging a .Net application:

"A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)" It is not branch-specific, and I encounter it whether I am pointing to the development database or production database. My IIS settings, network settings are identical to the other developers. We have tried replacing the network card, turned off wifi on my computer, and validated that I do not have any packet loss or unusual latency.

I encounter this while using my local sites hosted with IIS. I can interact with the website for five to ten minutes without encountering the error, or I can interact with it for one minute and it pops up. After the error shows, it then shows almost every time I try to interact with the site.

I have tried disabling/reenabling IIS, upgrading to Windows 10, updating SSMS

This is unique because the other developers are not experiencing this issue even with the same development branch. I have tried recycling the app pool and it does nothing.

Any ideas on how to solve this? Thanks

Philip Weiser
  • 63
  • 1
  • 11
  • The error means SQL Server closed the connection while .NET's connection pool thinks the associated connection is still usable. make sure to close, dispose, and whatever not your connections. – CodeCaster Jul 31 '17 at 13:55
  • Closing my reader would explain the error if the other developers were getting the error, but they are not, even when using the same exact development branch. – Philip Weiser Jul 31 '17 at 13:57
  • Does https://github.com/aspnet/EntityFramework/issues/7800 or https://stackoverflow.com/questions/22714569/cannot-get-rid-of-physical-connection-is-not-usable-exception or https://blogs.msdn.microsoft.com/spike/2009/04/16/a-transport-level-error-has-occurred-when-sending-the-request-to-the-server-provider-tcp-provider-error-0-an-existing-connection-was-forcibly-closed-by-the-remote-host/ help? – mjwills Jul 31 '17 at 14:18
  • Have any of your team tried on your PC / laptop & have you tried a a PC / laptop that is known to work for someone else? – Scrobi Jul 31 '17 at 14:31
  • @mjwills this error does not show for other developers, using the exact same dev branch. I am thinking this is an IIS or local configuration issue – Philip Weiser Jul 31 '17 at 14:44
  • 1
    Possible duplicate of [A transport-level error has occurred when receiving results from the server](https://stackoverflow.com/questions/2962927/a-transport-level-error-has-occurred-when-receiving-results-from-the-server) – Igor Jul 31 '17 at 18:42
  • @PhilipWeiser The thing I would caution you against is jumping to a conclusion too early. – mjwills Jul 31 '17 at 21:51

0 Answers0