About 10 or 20 times a day, usually under load the application has been throwing an error claiming that the entity connection is either broken or closed. This is a known issue involved with sharing DataConext among business objects. When you look in the application log for a corresponding event the event below is always seen with the error.
The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor.
After many days of searching I think we have found a solution to this problem. Although the error mentions the session being in single-user mode, this appears to be a dead end of inquiry as the database as reported by us and many others is in fact not in single-user mode.
After finally looking on the SQL Server forums we found the suggestion to disable connection pooling. This seems to be working. So you will now see in the web.config that comes with MvcCms the setting Pooling=False in the entity connection string.
Hope this helps.
Jon
The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor.
After many days of searching I think we have found a solution to this problem. Although the error mentions the session being in single-user mode, this appears to be a dead end of inquiry as the database as reported by us and many others is in fact not in single-user mode.
After finally looking on the SQL Server forums we found the suggestion to disable connection pooling. This seems to be working. So you will now see in the web.config that comes with MvcCms the setting Pooling=False in the entity connection string.
Hope this helps.
Jon
2 years 3 months 17 days
ago by
jon
