Cannot get rid of "physical connection is not usable" exception

sql-server asp.net-mvc entity-framework unity-container ioc-container
fenix2222 picture fenix2222 · Mar 28, 2014 · Viewed 59.6k times · Source

I am about to shoot myself. Spent few weeks now trying to solve this issue. We have an ASP.NET MVC 4 web app that uses SQL Server 2012 and Entity Framework as ORM and Unity for IoC. Web app is hosted on Amazon EC2. I started getting "Physical connection is not usable" exception. It happens few times a day. I searched many articles and forums and tried all the possible suggestions:

  • Tried removing pooling from connection string "Polling=False"
  • Tried limiting pool size and connection lifetime
  • Tried changing LifetimeManager of Unity to HierarchicalLifetimeManager, PerRequestLifetimeManager. Also made sure entities context is disposed after the end of request
  • Removed all TransactionScope references

When exception happens, the only way to restore application is to restart server, which is very bad!!!

This is full exception:

A transport-level error has occurred when sending the request to the server. (provider: Session Provider, error: 19 - Physical connection is not usable)

Answer

fenix2222 picture fenix2222 · Apr 7, 2014

I confirm now, by changing connection string on the server to use "." for data source instead of domain name, exception seem to have disappeared. Very weird as domain name used to work before. Must be some sort of update on SQL Server

Related questions

How do I programmatically set the connection string for Entity-Framework Code-First?

I'm trying to write some code that allows me to switch between SQLCE (locally on my dev machine) and full SQL (on AppHarbor). With SQL CE, the connection string is all handled for me, but I have to construct it …

Read More
How to resolve Azure "Windows logins are not supported in this version of SQL Server"?

I get the following error message, when I try to connect to SQL Azure. Windows logins are not supported in this version of SQL Server I'm using an Azure connection string. On development I'm running against SQL Server Express. This …

Read More
The number of primary key values passed must match number of primary key values defined on the entity

I've created a view in SQL Server that contains the most important columns from different tables. Printing the content of the table to the ASP.NET MVC view works fine, but when I want to get the details of a …

Read More