Databases
StackOverflow2013
Postsdbo
POConcurrent access to a database with Entity Framework == EntityException
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POConcurrent access to a database with Entity Framework == EntityException
    text
    copied!<p>I've a MS SQL 2008 database which is accessed through LINQ for data update/retrival.</p> <p>My linq is accessed by WCF services in a PerCall instantiation mode for an heavy application. This application has several thread which makes calls to the service, and several application are running in the sametime.</p> <p>I've often some EntityException happening:</p> <blockquote> <p>System.Data.EntityException was caught Message=An error occurred while starting a transaction on the provider connection. See the inner exception for details. Source=System.Data.Entity StackTrace: at System.Data.EntityClient.EntityConnection.BeginDbTransaction(IsolationLevel isolationLevel) at System.Data.EntityClient.EntityConnection.BeginTransaction() at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at Infoteam.GfK.TOMServer.DataServer.DataServer.SaveChanges() in D:\Workspace\XYZWASDF\DataServer\DataServer.cs:line 123 InnerException: System.Data.SqlClient.SqlException Message=Une nouvelle transaction n'est pas autorisée parce que d'autres threads sont en cours d'exécution dans la session. Source=.Net SqlClient Data Provider ErrorCode=-2146232060 Class=16 LineNumber=1 Number=3988 Procedure="" Server=ift-srv114 State=1 StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest) at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest) at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest) at System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName) at System.Data.SqlClient.SqlInternalConnection.BeginTransaction(IsolationLevel iso) at System.Data.SqlClient.SqlConnection.BeginDbTransaction(IsolationLevel isolationLevel) at System.Data.Common.DbConnection.BeginTransaction(IsolationLevel isolationLevel) at System.Data.EntityClient.EntityConnection.BeginDbTransaction(IsolationLevel isolationLevel) InnerException: </p> </blockquote> <p>(Sorry it's not very readable). (The message of the internal exception mean "A new transaction is not allowed because there are other threads running in the session."</p> <p>I've check, I'm not in a loop, it's purely random when it makes this exception, and I've no idea about how to avoid this.</p> <p>any help will be really appreciated :)</p> <p>Thank you!</p> <p>EDIT: Here is an example of where I got this exception SOMETIMES</p> <pre><code> //My DataServer method, which is a singleton [MethodImpl(MethodImplOptions.Synchronized)] public void SaveChanges() { lock (_lockObject) { try { _context.SaveChanges(SaveOptions.AcceptAllChangesAfterSave); _changeListener.ManageIDAfterInsert(); } catch (Exception ex) { Logger.Instance.Error("[DataServer:SaveChanges] Got an error when trying to save an object", ex); //HERE I've this error } } } //One example where I can have exception sometimes, this is called through a WCF service, so I have a method which attach the object and then save it private OrderStatus AddOrderStatus(OrderStatus orderStatus) { DataServer.DataServer.Instance.InsertOrUpdateDetachedObject(orderStatus); return orderStatus; } </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload