1

Closed

Net40 CI build fails occasionally attempting to promote to distributed transaction

description

Details of the failure are below. Note that it is not acceptable to enable DTC on the machine since we rely on the tests to let us know if we accidentally introduce a change that requires transaction promotion.
TemplateTests.Read_and_write_using_MonsterModel_created_from_T4_template  

System.Data.Entity.Core.EntityException : The underlying provider failed on Open.
 ---- System.Data.SqlClient.SqlException : MSDTC on server 'UNICORNS410\SQLEXPRESS' is unavailable.

 Server stack trace: 
    at System.Data.Entity.Core.EntityClient.EntityConnection.Open() in d:\BuildAgent\work\master\src\EntityFramework\Core\EntityClient\EntityConnection.cs:line 573
    at System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection() in d:\BuildAgent\work\master\src\EntityFramework\Core\Objects\ObjectContext.cs:line 1452
    at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) in d:\BuildAgent\work\master\src\EntityFramework\Core\Objects\ObjectQuery`.cs:line 676
    at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0() in d:\BuildAgent\work\master\src\EntityFramework\Core\Objects\ObjectQuery`.cs:line 522
    at System.Lazy`1.CreateValue()

 Exception rethrown at [0]: 
    at System.Data.Entity.Core.EntityClient.EntityConnection.Open() in d:\BuildAgent\work\master\src\EntityFramework\Core\EntityClient\EntityConnection.cs:line 573
    at System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection() in d:\BuildAgent\work\master\src\EntityFramework\Core\Objects\ObjectContext.cs:line 1452
    at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) in d:\BuildAgent\work\master\src\EntityFramework\Core\Objects\ObjectQuery`.cs:line 676
    at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0() in d:\BuildAgent\work\master\src\EntityFramework\Core\Objects\ObjectQuery`.cs:line 522
    at System.Lazy`1.CreateValue()
    at System.Lazy`1.LazyInitValue()
    at System.Lazy`1.get_Value()
    at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() in d:\BuildAgent\work\master\src\EntityFramework\Internal\LazyEnumerator`.cs:line 38
    at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
    at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__3[TResult](IEnumerable`1 sequence) in d:\BuildAgent\work\master\src\EntityFramework\Core\Objects\ELinq\ObjectQueryProvider.cs:line 238
    at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot) in d:\BuildAgent\work\master\src\EntityFramework\Core\Objects\ELinq\ObjectQueryProvider.cs:line 214
    at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[TResult](Expression expression) in d:\BuildAgent\work\master\src\EntityFramework\Core\Objects\ELinq\ObjectQueryProvider.cs:line 127
    at System.Data.Entity.Internal.Linq.DbQueryProvider.Execute[TResult](Expression expression) in d:\BuildAgent\work\master\src\EntityFramework\Internal\Linq\DbQueryProvider.cs:line 91
    at System.Linq.Queryable.Single[TSource](IQueryable`1 source, Expression`1 predicate)
    at ProductivityApiTests.TemplateTests.Read_and_write_using_MonsterModel_created_from_T4_template() in d:\BuildAgent\work\master\test\EntityFramework\FunctionalTests\ProductivityApi\TemplateTests.cs:line 126
 ----- Inner Stack Trace -----
   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.SqlDataReader.ConsumeMetaData()
    at System.Data.SqlClient.SqlDataReader.get_MetaData()
    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.TdsParser.GetDTCAddress(Int32 timeout, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlInternalConnectionTds.GetDTCAddress()
    at System.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx)
    at System.Data.SqlClient.SqlInternalConnection.Enlist(Transaction tx)
    at System.Data.SqlClient.SqlInternalConnectionTds.Activate(Transaction transaction)
    at System.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction)
    at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
    at System.Data.SqlClient.SqlConnection.Open()
    at System.Data.Entity.Core.EntityClient.EntityConnection.Open() in d:\BuildAgent\work\master\src\EntityFramework\Core\EntityClient\EntityConnection.cs:line 561 
Closed Sep 19, 2013 at 10:08 PM by RoMiller
We aren't seeing this issue any more.

comments