efcore icon indicating copy to clipboard operation
efcore copied to clipboard

Distributed transactions failures when running EF Core tests on main

Open ajcvickers opened this issue 2 years ago • 3 comments

✘ Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorCreateTablesTest.Creates_schema_in_existing_database_test(async: True, ambientTransaction: True)

Distributed transaction started\r\nExpected: False\r\nActual:   True
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorCreateTablesTest.Creates_schema_in_existing_database_test(Boolean async, Boolean ambientTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 484

✘ Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_schema_in_existing_database(async: True, ambientTransaction: True)

Distributed transaction started\r\nExpected: False\r\nActual:   True
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_physical_database_and_schema_test(ValueTuple`4 options) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 263

✘ Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_with_string_FK_and_GUID_PK

System.InvalidOperationException : The operation is not valid for the current state of the enlistment.
   at System.Transactions.EnlistmentState.Aborted(InternalEnlistment enlistment, Exception e)
   at System.Transactions.SinglePhaseEnlistment.Aborted()
   at Microsoft.Data.SqlClient.SqlDelegatedTransaction.Rollback(SinglePhaseEnlistment enlistment)
   at System.Transactions.TransactionStateDelegatedAborting.EnterState(InternalTransaction tx)
   at System.Transactions.Transaction.Rollback()
   at System.Transactions.TransactionScope.InternalDispose()
   at System.Transactions.TransactionScope.Dispose()
   at Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_with_string_FK_and_GUID_PK() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\Update\MismatchedKeyTypesSqlServerTest.cs:line 236
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)

ajcvickers avatar Sep 12 '22 11:09 ajcvickers

/cc @roji

ajcvickers avatar Sep 12 '22 11:09 ajcvickers

FYI, I have run many local builds over the last few days and have not seen this again.

ajcvickers avatar Sep 16 '22 11:09 ajcvickers

OK, let's wait a bit more. We haven't seen this in CI either, right?

roji avatar Sep 16 '22 12:09 roji

@roji Had another run with failures.

 Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorCreateTablesTest.Creates_schema_in_existing_database_test(async: True, ambientTransaction: True)
Distributed transaction started\r\nExpected: False\r\nActual:   True
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorCreateTablesTest.Creates_schema_in_existing_database_test(Boolean async, Boolean ambientTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 484
--- End of stack trace from previous location ---
73.4075678s✘ Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorDeleteTest.Deletes_database(async: True, ambientTransaction: True)
Distributed transaction started\r\nExpected: False\r\nActual:   True
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorDeleteTest.Deletes_database(Boolean async, Boolean ambientTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 425
--- End of stack trace from previous location ---
163.5213315s✘ Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Deletes_database(async: True, open: True, ambientTransaction: True)
Distributed transaction started\r\nExpected: False\r\nActual:   True
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.<>c__DisplayClass2_0.<<Delete_database_test>b__0>d.MoveNext() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 144
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c.<<ExecuteAsync>b__3_0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategyExtensions.cs:line 111
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.<>c__DisplayClass30_0`2.<<ExecuteAsync>b__0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 311
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 334
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 358
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 310
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Delete_database_test(Boolean async, Boolean open, Boolean ambientTransaction, Boolean file) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 141
--- End of stack trace from previous location ---
60.3333264s✘ Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_true_when_database_exists(async: False, ambientTransaction: True, useCanConnect: False)
Distributed transaction started\r\nExpected: False\r\nActual:   True
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.<>c__DisplayClass5_0.<<Returns_true_when_database_exists_test>b__0>d.MoveNext() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 91
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c.<<ExecuteAsync>b__3_0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategyExtensions.cs:line 111
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.<>c__DisplayClass30_0`2.<<ExecuteAsync>b__0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 311
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 334
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 358
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 310
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_true_when_database_exists_test(Boolean async, Boolean ambientTransaction, Boolean useCanConnect, Boolean file) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 88
--- End of stack trace from previous location ---
56.9324682s✘ Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorHasTablesTest.Returns_true_when_database_exists_and_has_any_tables(async: True, ambientTransaction: True)
Distributed transaction started\r\nExpected: False\r\nActual:   True
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorHasTablesTest.<>c__DisplayClass2_0.<<Returns_true_when_database_exists_and_has_any_tables>b__1>d.MoveNext() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 402
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c.<<ExecuteAsync>b__3_0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategyExtensions.cs:line 111
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.<>c__DisplayClass30_0`2.<<ExecuteAsync>b__0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 311
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 334
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 358
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 310
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorHasTablesTest.Returns_true_when_database_exists_and_has_any_tables(Boolean async, Boolean ambientTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 399
--- End of stack trace from previous location ---
0.5349851s✘ Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_with_tinyint_FK_and_smallint_PK
System.InvalidOperationException : The operation is not valid for the current state of the enlistment.
   at System.Transactions.EnlistmentState.Aborted(InternalEnlistment enlistment, Exception e)
   at System.Transactions.SinglePhaseEnlistment.Aborted()
   at Microsoft.Data.SqlClient.SqlDelegatedTransaction.Rollback(SinglePhaseEnlistment enlistment)
   at System.Transactions.TransactionStateDelegatedAborting.EnterState(InternalTransaction tx)
   at System.Transactions.Transaction.Rollback()
   at System.Transactions.TransactionScope.InternalDispose()
   at System.Transactions.TransactionScope.Dispose()
   at Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_with_tinyint_FK_and_smallint_PK() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\Update\MismatchedKeyTypesSqlServerTest.cs:line 163
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)

ajcvickers avatar Sep 22 '22 12:09 ajcvickers

I looked into this. We have two failures here.

Problem 1

In SqlServerDatabaseCreatorExistsTest (which isn't run in CI), we hook up an event listener to TransactionManager.DistributedTransactionStarted to throw if a distributed transaction is started. Adding an event listener even after a transaction will started will fire for previously-started transactions, so the exception is indicating that some previous test caused a transaction to be started - but we can't know which one. It's probably just MismatchedKeyTypesSqlServerTest, which is causing the other failure.

If we want to make sure that no distributed transactions are ever started in our test suite, we can just use a module initializer to register a listener globally; that would give us a clear stack trace showing which tests causes the escalation (and would also clean up SqlServerDatabaseCreatorExistsTest a bit). If we ever do want to add tests exercising distributed transactions, we can run them disabling parallelization, and unregistering the listener.

Problem 2

Tests in MismatchedKeyTypesSqlServerTest somehow get into an escalated into a distributed transaction. What's more, they're in some sort of weird invalid state where rolling back the transaction (at the end of the test) throws. Right now I can't explain how this is possible; but if we do the proposed changes above, then we should get an exception the moment an escalation, which should hopefully help us understand what's going on.

roji avatar Sep 28 '22 16:09 roji

@roji Just got this running tests on main:

 Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_with_tinyint_FK_and_smallint_PK
System.InvalidOperationException : The operation is not valid for the current state of the enlistment.
   at System.Transactions.EnlistmentState.Aborted(InternalEnlistment enlistment, Exception e)
   at System.Transactions.SinglePhaseEnlistment.Aborted()
   at Microsoft.Data.SqlClient.SqlDelegatedTransaction.Rollback(SinglePhaseEnlistment enlistment)
   at System.Transactions.TransactionStateDelegatedAborting.EnterState(InternalTransaction tx)
   at System.Transactions.Transaction.Rollback()
   at System.Transactions.TransactionScope.InternalDispose()
   at System.Transactions.TransactionScope.Dispose()
   at Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_with_tinyint_FK_and_smallint_PK() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\Update\MismatchedKeyTypesSqlServerTest.cs:line 163
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)

ajcvickers avatar Oct 07 '22 08:10 ajcvickers

Yeah, this is the same as before.

I need to prepare that branch/PR which would allow us to catch this when it's promoted.

roji avatar Oct 07 '22 09:10 roji

OK, while preparing a branch which throws, I suddenly got the exact exception above simply by throwing from TransactionManager.DistributedTransactionStarted; System.Transactions doesn't handle that well (the same happens on netfx).

In other words, the exception isn't a bad state left over from another test which initially caused the promotion or anything like that - it is that specific test causing the escalation for some reason. Will continue my investigation.

roji avatar Oct 07 '22 14:10 roji

@roji

Test run
Test run for C:\github\efcore\artifacts\bin\EFCore.SqlServer.FunctionalTests\Debug\net7.0\Microsoft.EntityFrameworkCore.SqlServer.FunctionalTests.dll (.NETCoreApp,Version=v7.0)
Microsoft (R) Test Execution Command Line Tool Version 17.4.0-preview-20220813-01 (x64)
Copyright (c) Microsoft Corporation.  All rights reserved.

Starting test execution, please wait...
A total of 1 test files matched the specified pattern.
[xUnit.net 00:00:08.02] Microsoft.EntityFrameworkCore.SqlServer.FunctionalTests: Skipping test case with duplicate ID '73729475a75ae7b01a4de4e8c4902343dea25028' ('Microsoft.EntityFrameworkCore.TwoDatabasesSqlServerTest.Can_set_connection_string_in_interceptor(withConnectionString: True, withNullConnectionString: False)' and 'Microsoft.EntityFrameworkCore.TwoDatabasesSqlServerTest.Can_set_connection_string_in_interceptor(withConnectionString: True, withNullConnectionString: False)')
[xUnit.net 00:00:08.02] Microsoft.EntityFrameworkCore.SqlServer.FunctionalTests: Skipping test case with duplicate ID '8bf62411b13851dcef2d5e867566136a1296f2e4' ('Microsoft.EntityFrameworkCore.Update.StoreValueGenerationIdentitySqlServerTest.Delete_Add_with_same_entity_types(async: False)' and 'Microsoft.EntityFrameworkCore.Update.StoreValueGenerationIdentitySqlServerTest.Delete_Add_with_same_entity_types(async: False)')
[xUnit.net 00:00:08.02] Microsoft.EntityFrameworkCore.SqlServer.FunctionalTests: Skipping test case with duplicate ID '73ce55abf48b36d4d0503c8d948bcc97b324b33c' ('Microsoft.EntityFrameworkCore.Update.StoreValueGenerationIdentitySqlServerTest.Delete_Add_with_same_entity_types(async: True)' and 'Microsoft.EntityFrameworkCore.Update.StoreValueGenerationIdentitySqlServerTest.Delete_Add_with_same_entity_types(async: True)')
[xUnit.net 00:00:08.02] Microsoft.EntityFrameworkCore.SqlServer.FunctionalTests: Skipping test case with duplicate ID '3f76d9b573d580ae54f8d87f2b55feacfe367e86' ('Microsoft.EntityFrameworkCore.Query.NorthwindKeylessEntitiesQuerySqlServerTest.KeylessEntity_with_included_navs_multi_level(async: False)' and 'Microsoft.EntityFrameworkCore.Query.NorthwindKeylessEntitiesQuerySqlServerTest.KeylessEntity_with_included_navs_multi_level(async: False)')
[xUnit.net 00:00:08.02] Microsoft.EntityFrameworkCore.SqlServer.FunctionalTests: Skipping test case with duplicate ID '1aa3a081268e4489f72d579e3be3a2b4095f2e9e' ('Microsoft.EntityFrameworkCore.Query.NorthwindKeylessEntitiesQuerySqlServerTest.KeylessEntity_with_included_navs_multi_level(async: True)' and 'Microsoft.EntityFrameworkCore.Query.NorthwindKeylessEntitiesQuerySqlServerTest.KeylessEntity_with_included_navs_multi_level(async: True)')
[xUnit.net 00:00:08.02] Microsoft.EntityFrameworkCore.SqlServer.FunctionalTests: Skipping test case with duplicate ID '34f35f97acd55f560dde2c12e9d061e2ddc85595' ('Microsoft.EntityFrameworkCore.Query.NorthwindKeylessEntitiesQuerySqlServerTest.KeylessEntity_with_defining_query_and_correlated_collection(async: False)' and 'Microsoft.EntityFrameworkCore.Query.NorthwindKeylessEntitiesQuerySqlServerTest.KeylessEntity_with_defining_query_and_correlated_collection(async: False)')
[xUnit.net 00:00:08.02] Microsoft.EntityFrameworkCore.SqlServer.FunctionalTests: Skipping test case with duplicate ID '375f4df234e8be3160cc141d327646677dbca4ea' ('Microsoft.EntityFrameworkCore.Query.NorthwindKeylessEntitiesQuerySqlServerTest.KeylessEntity_with_defining_query_and_correlated_collection(async: True)' and 'Microsoft.EntityFrameworkCore.Query.NorthwindKeylessEntitiesQuerySqlServerTest.KeylessEntity_with_defining_query_and_correlated_collection(async: True)')
[xUnit.net 00:00:08.49]     Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureConnectionTest.Connect_with_encryption(encryptionEnabled: True) [SKIP]
[xUnit.net 00:00:08.49]     Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureConnectionTest.Connect_with_encryption(encryptionEnabled: False) [SKIP]
  Skipped Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureConnectionTest.Connect_with_encryption(encryptionEnabled: True) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureConnectionTest.Connect_with_encryption(encryptionEnabled: False) [1 ms]
[xUnit.net 00:00:15.85]     Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureBatchingTest.AddWithBatchSize(batchSize: 1000) [SKIP]
[xUnit.net 00:00:15.85]     Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureBatchingTest.AddWithBatchSize(batchSize: 1) [SKIP]
[xUnit.net 00:00:15.85]     Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureBatchingTest.AddWithBatchSize(batchSize: 10) [SKIP]
[xUnit.net 00:00:15.85]     Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureBatchingTest.AddWithBatchSize(batchSize: 100) [SKIP]
  Skipped Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureBatchingTest.AddWithBatchSize(batchSize: 1000) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureBatchingTest.AddWithBatchSize(batchSize: 1) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureBatchingTest.AddWithBatchSize(batchSize: 10) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureBatchingTest.AddWithBatchSize(batchSize: 100) [1 ms]
[xUnit.net 00:00:16.38]     Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureFundamentalsTest.CanUpdate [SKIP]
[xUnit.net 00:00:16.38]     Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureFundamentalsTest.CanAdd [SKIP]
[xUnit.net 00:00:16.38]     Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureFundamentalsTest.CanExecuteQuery [SKIP]
[xUnit.net 00:00:16.40]     Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureFundamentalsTest.IncludeQuery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureFundamentalsTest.CanUpdate [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureFundamentalsTest.CanAdd [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureFundamentalsTest.CanExecuteQuery [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureFundamentalsTest.IncludeQuery [1 ms]
[xUnit.net 00:00:26.20]     Microsoft.EntityFrameworkCore.BulkUpdates.TPTInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First_2 [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.TPTInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First_2 [1 ms]
[xUnit.net 00:00:38.85]     Microsoft.EntityFrameworkCore.Query.QueryNoClientEvalSqlServerTest.Throws_when_group_by [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.QueryNoClientEvalSqlServerTest.Throws_when_group_by [1 ms]
[xUnit.net 00:00:43.01]     Microsoft.EntityFrameworkCore.TPTTableSplittingSqlServerTest.Can_insert_dependent_with_just_one_parent [SKIP]
  Skipped Microsoft.EntityFrameworkCore.TPTTableSplittingSqlServerTest.Can_insert_dependent_with_just_one_parent [1 ms]
[xUnit.net 00:00:55.00]     Microsoft.EntityFrameworkCore.Query.UdfDbFunctionSqlServerTests.QF_Select_Direct_In_Anonymous_distinct [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.UdfDbFunctionSqlServerTests.QF_Select_Direct_In_Anonymous_distinct [1 ms]
[xUnit.net 00:00:56.18]     Microsoft.EntityFrameworkCore.BulkUpdates.FiltersInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First_2 [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.FiltersInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First_2 [1 ms]
[xUnit.net 00:00:56.32]     Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureDatabaseCreationTest.Creates_database_in_elastic_pool [SKIP]
[xUnit.net 00:00:56.32]     Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureDatabaseCreationTest.Creates_basic_database [SKIP]
  Skipped Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureDatabaseCreationTest.Creates_database_in_elastic_pool [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureDatabaseCreationTest.Creates_basic_database [1 ms]
[xUnit.net 00:00:56.32]     Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureDatabaseCreationTest.Creates_business_critical_database [SKIP]
  Skipped Microsoft.EntityFrameworkCore.SqlAzure.SqlAzureDatabaseCreationTest.Creates_business_critical_database [1 ms]
[xUnit.net 00:00:56.62]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Split_entity_owning_a_split_reference_without_table_sharing [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Split_entity_owning_a_split_reference_without_table_sharing [1 ms]
[xUnit.net 00:01:07.61]     Microsoft.EntityFrameworkCore.BulkUpdates.TPTFiltersInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.TPTFiltersInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First [1 ms]
[xUnit.net 00:01:07.87]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_physical_database_with_filename_and_schema(async: False, ambientTransaction: False) [SKIP]
[xUnit.net 00:01:07.87]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_physical_database_with_filename_and_schema(async: True, ambientTransaction: True) [SKIP]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_physical_database_with_filename_and_schema(async: False, ambientTransaction: False) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_physical_database_with_filename_and_schema(async: True, ambientTransaction: True) [1 ms]
[xUnit.net 00:01:07.87]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_schema_in_existing_database_with_filename(async: True, ambientTransaction: False) [SKIP]
[xUnit.net 00:01:07.87]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_schema_in_existing_database_with_filename(async: False, ambientTransaction: True) [SKIP]
[xUnit.net 00:01:07.87]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Noop_when_database_with_filename_exists_and_has_schema(async: False) [SKIP]
[xUnit.net 00:01:07.87]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Noop_when_database_with_filename_exists_and_has_schema(async: True) [SKIP]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_schema_in_existing_database_with_filename(async: True, ambientTransaction: False) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_schema_in_existing_database_with_filename(async: False, ambientTransaction: True) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Noop_when_database_with_filename_exists_and_has_schema(async: False) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Noop_when_database_with_filename_exists_and_has_schema(async: True) [1 ms]
[xUnit.net 00:01:07.87]     Microsoft.EntityFrameworkCore.Query.SqlExecutorSqlServerTest.Throws_on_concurrent_command [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.SqlExecutorSqlServerTest.Throws_on_concurrent_command [1 ms]
[xUnit.net 00:01:08.21]     Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_composite_keys_mismatched_in_store [FAIL]
  Failed Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_composite_keys_mismatched_in_store [2 s]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.FireDistributedTransactionStarted(Transaction transaction)
   at System.Transactions.TransactionStateDelegatedBase.EnterState(InternalTransaction tx)
   at System.Transactions.EnlistableStates.Promote(InternalTransaction tx)
   at System.Transactions.Transaction.Promote()
   at System.Transactions.TransactionInterop.ConvertToOletxTransaction(Transaction transaction)
   at System.Transactions.TransactionInterop.GetExportCookie(Transaction transaction, Byte[] whereabouts)
   at Microsoft.Data.SqlClient.SqlInternalConnection.GetTransactionCookie(Transaction transaction, Byte[] whereAbouts)
   at Microsoft.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction)
   at Microsoft.Data.ProviderBase.DbConnectionPool.PrepareConnection(DbConnection owningObject, DbConnectionInternal obj, Transaction transaction)
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.OpenDbConnection(Boolean errorsExpected) in C:\github\efcore\src\EFCore.SqlServer\Storage\Internal\SqlServerConnection.cs:line 49
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected) in C:\github\efcore\src\EFCore.Relational\Storage\RelationalConnection.cs:line 719
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) in C:\github\efcore\src\EFCore.Relational\Storage\RelationalConnection.cs:line 633
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) in C:\github\efcore\src\EFCore.Relational\Storage\RelationalCommand.cs:line 513
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator) in C:\github\efcore\src\EFCore.Relational\Query\Internal\SingleQueryingEnumerable.cs:line 240
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.<>c.<MoveNext>b__21_0(DbContext _, Enumerator enumerator) in C:\github\efcore\src\EFCore.Relational\Query\Internal\SingleQueryingEnumerable.cs:line 168
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) in C:\github\efcore\src\EFCore.SqlServer\Storage\Internal\SqlServerExecutionStrategy.cs:line 57
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() in C:\github\efcore\src\EFCore.Relational\Query\Internal\SingleQueryingEnumerable.cs:line 167
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_composite_keys_mismatched_in_store() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\Update\MismatchedKeyTypesSqlServerTest.cs:line 278
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
[xUnit.net 00:01:11.57]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_schema_in_existing_database(async: True, ambientTransaction: True) [FAIL]
  Failed Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_schema_in_existing_database(async: True, ambientTransaction: True) [2 s]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_physical_database_and_schema_test(ValueTuple`4 options) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 263
--- End of stack trace from previous location ---
[xUnit.net 00:01:11.98]     Microsoft.EntityFrameworkCore.BulkUpdates.TPCInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.TPCInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First [1 ms]
[xUnit.net 00:01:23.15]     Microsoft.EntityFrameworkCore.BulkUpdates.TPCInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First_2 [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.TPCInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First_2 [1 ms]
[xUnit.net 00:01:23.28]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tpt_entity_owning_a_split_collection_on_leaf [SKIP]
[xUnit.net 00:01:23.28]     Microsoft.EntityFrameworkCore.BulkUpdates.TPTInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First [SKIP]
[xUnit.net 00:01:23.28]     Microsoft.EntityFrameworkCore.BulkUpdates.TPTInheritanceBulkUpdatesSqlServerTest.Update_where_hierarchy_subquery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tpt_entity_owning_a_split_collection_on_leaf [1 ms]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.TPTInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First [1 ms]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.TPTInheritanceBulkUpdatesSqlServerTest.Update_where_hierarchy_subquery [1 ms]
[xUnit.net 00:01:23.28]     Microsoft.EntityFrameworkCore.BulkUpdates.TPTInheritanceBulkUpdatesSqlServerTest.Delete_where_using_hierarchy_derived [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.TPTInheritanceBulkUpdatesSqlServerTest.Delete_where_using_hierarchy_derived [1 ms]
[xUnit.net 00:01:23.31]     Microsoft.EntityFrameworkCore.BulkUpdates.TPTInheritanceBulkUpdatesSqlServerTest.Delete_where_using_hierarchy [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.TPTInheritanceBulkUpdatesSqlServerTest.Delete_where_using_hierarchy [1 ms]
[xUnit.net 00:01:26.49]     Microsoft.EntityFrameworkCore.TableSplittingSqlServerTest.Can_insert_dependent_with_just_one_parent [SKIP]
  Skipped Microsoft.EntityFrameworkCore.TableSplittingSqlServerTest.Can_insert_dependent_with_just_one_parent [1 ms]
[xUnit.net 00:01:31.41]     Microsoft.EntityFrameworkCore.OptimisticConcurrencyULongSqlServerTest.Concurrency_issue_where_a_complex_type_nested_member_is_the_concurrency_token_can_be_handled [SKIP]
  Skipped Microsoft.EntityFrameworkCore.OptimisticConcurrencyULongSqlServerTest.Concurrency_issue_where_a_complex_type_nested_member_is_the_concurrency_token_can_be_handled [1 ms]
[xUnit.net 00:01:34.13]     Microsoft.EntityFrameworkCore.Query.SqlExecutorSqlServerTest.Throws_on_concurrent_command_async [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.SqlExecutorSqlServerTest.Throws_on_concurrent_command_async [1 ms]
[xUnit.net 00:01:37.81]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tpt_entity_owning_a_split_collection_on_middle [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tpt_entity_owning_a_split_collection_on_middle [1 ms]
[xUnit.net 00:01:40.39]     Microsoft.EntityFrameworkCore.BulkUpdates.TPTFiltersInheritanceBulkUpdatesSqlServerTest.Update_where_hierarchy_subquery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.TPTFiltersInheritanceBulkUpdatesSqlServerTest.Update_where_hierarchy_subquery [1 ms]
[xUnit.net 00:01:40.48]     Microsoft.EntityFrameworkCore.BulkUpdates.TPTFiltersInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First_2 [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.TPTFiltersInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First_2 [1 ms]
[xUnit.net 00:01:44.40]     Microsoft.EntityFrameworkCore.BulkUpdates.TPCFiltersInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.TPCFiltersInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First [1 ms]
[xUnit.net 00:01:44.45]     Microsoft.EntityFrameworkCore.BulkUpdates.TPCFiltersInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First_2 [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.TPCFiltersInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First_2 [1 ms]
[xUnit.net 00:01:44.54]     Microsoft.EntityFrameworkCore.BulkUpdates.FiltersInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.FiltersInheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First [1 ms]
[xUnit.net 00:01:51.65]     Microsoft.EntityFrameworkCore.BulkUpdates.InheritanceBulkUpdatesSqlServerTest.Update_where_hierarchy_subquery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.InheritanceBulkUpdatesSqlServerTest.Update_where_hierarchy_subquery [1 ms]
[xUnit.net 00:01:51.65]     Microsoft.EntityFrameworkCore.BulkUpdates.TPCInheritanceBulkUpdatesSqlServerTest.Update_where_hierarchy_subquery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.TPCInheritanceBulkUpdatesSqlServerTest.Update_where_hierarchy_subquery [1 ms]
[xUnit.net 00:01:51.73]     Microsoft.EntityFrameworkCore.BulkUpdates.TPCFiltersInheritanceBulkUpdatesSqlServerTest.Update_where_hierarchy_subquery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.TPCFiltersInheritanceBulkUpdatesSqlServerTest.Update_where_hierarchy_subquery [1 ms]
[xUnit.net 00:02:03.31]     Microsoft.EntityFrameworkCore.BulkUpdates.InheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.InheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First [1 ms]
[xUnit.net 00:02:03.35]     Microsoft.EntityFrameworkCore.BulkUpdates.InheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First_2 [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.InheritanceBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_First_2 [1 ms]
[xUnit.net 00:02:03.40]     Microsoft.EntityFrameworkCore.BulkUpdates.FiltersInheritanceBulkUpdatesSqlServerTest.Update_where_hierarchy_subquery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.FiltersInheritanceBulkUpdatesSqlServerTest.Update_where_hierarchy_subquery [1 ms]
[xUnit.net 00:02:03.87]     Microsoft.EntityFrameworkCore.Query.ManyToManyNoTrackingQuerySqlServerTest.Throws_when_different_filtered_then_include_via_different_paths [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.ManyToManyNoTrackingQuerySqlServerTest.Throws_when_different_filtered_then_include_via_different_paths [1 ms]
[xUnit.net 00:02:12.35]     Microsoft.EntityFrameworkCore.Query.IncompleteMappingInheritanceQuerySqlServerTest.OfType_Union_subquery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.IncompleteMappingInheritanceQuerySqlServerTest.OfType_Union_subquery [1 ms]
[xUnit.net 00:02:13.41]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorHasTablesTest.Returns_false_when_database_exists_but_has_no_tables(async: False, ambientTransaction: True) [FAIL]
  Failed Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorHasTablesTest.Returns_false_when_database_exists_but_has_no_tables(async: False, ambientTransaction: True) [1 m 1 s]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorHasTablesTest.<>c__DisplayClass1_0.<<Returns_false_when_database_exists_but_has_no_tables>b__0>d.MoveNext() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 383
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c.<<ExecuteAsync>b__3_0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategyExtensions.cs:line 111
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.<>c__DisplayClass30_0`2.<<ExecuteAsync>b__0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 311
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 334
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 358
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 310
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorHasTablesTest.Returns_false_when_database_exists_but_has_no_tables(Boolean async, Boolean ambientTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 380
--- End of stack trace from previous location ---
[xUnit.net 00:02:14.86]     Microsoft.EntityFrameworkCore.Query.JsonQuerySqlServerTest.Project_json_entity_FirstOrDefault_subquery_with_entity_comparison_on_top [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.JsonQuerySqlServerTest.Project_json_entity_FirstOrDefault_subquery_with_entity_comparison_on_top [1 ms]
[xUnit.net 00:02:15.78]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_true_when_database_exists(async: False, ambientTransaction: True, useCanConnect: True) [FAIL]
  Failed Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_true_when_database_exists(async: False, ambientTransaction: True, useCanConnect: True) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.<>c__DisplayClass5_0.<<Returns_true_when_database_exists_test>b__0>d.MoveNext() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 91
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c.<<ExecuteAsync>b__3_0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategyExtensions.cs:line 111
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.<>c__DisplayClass30_0`2.<<ExecuteAsync>b__0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 311
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 334
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 358
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 310
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_true_when_database_exists_test(Boolean async, Boolean ambientTransaction, Boolean useCanConnect, Boolean file) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 88
--- End of stack trace from previous location ---
[xUnit.net 00:02:17.64]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorCreateTablesTest.Creates_schema_in_existing_database_test(async: True, ambientTransaction: True) [FAIL]
  Failed Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorCreateTablesTest.Creates_schema_in_existing_database_test(async: True, ambientTransaction: True) [1 m 1 s]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorCreateTablesTest.Creates_schema_in_existing_database_test(Boolean async, Boolean ambientTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 484
--- End of stack trace from previous location ---
[xUnit.net 00:02:18.52]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Normal_entity_owning_a_split_reference_with_main_fragment_not_sharing_custom_projection [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Normal_entity_owning_a_split_reference_with_main_fragment_not_sharing_custom_projection [1 ms]
[xUnit.net 00:02:20.65]     Microsoft.EntityFrameworkCore.BulkUpdates.NorthwindBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.NorthwindBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select [1 ms]
[xUnit.net 00:02:21.54]     Microsoft.EntityFrameworkCore.OptimisticConcurrencySqlServerTest.Concurrency_issue_where_a_complex_type_nested_member_is_the_concurrency_token_can_be_handled [SKIP]
  Skipped Microsoft.EntityFrameworkCore.OptimisticConcurrencySqlServerTest.Concurrency_issue_where_a_complex_type_nested_member_is_the_concurrency_token_can_be_handled [1 ms]
[xUnit.net 00:02:22.39]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_physical_database_and_schema(async: False, ambientTransaction: True) [FAIL]
  Failed Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_physical_database_and_schema(async: False, ambientTransaction: True) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureCreatedTest.Creates_physical_database_and_schema_test(ValueTuple`4 options) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 263
--- End of stack trace from previous location ---
[xUnit.net 00:02:22.65]     Microsoft.EntityFrameworkCore.Query.TPTInheritanceQuerySqlServerTest.Union_siblings_with_duplicate_property_in_subquery [SKIP]
[xUnit.net 00:02:22.65]     Microsoft.EntityFrameworkCore.Query.TPTInheritanceQuerySqlServerTest.OfType_Union_subquery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPTInheritanceQuerySqlServerTest.Union_siblings_with_duplicate_property_in_subquery [1 ms]
  Skipped Microsoft.EntityFrameworkCore.Query.TPTInheritanceQuerySqlServerTest.OfType_Union_subquery [1 ms]
[xUnit.net 00:02:25.03]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorCreateTest.Creates_physical_database_but_not_tables(async: False, ambientTransaction: True) [FAIL]
  Failed Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorCreateTest.Creates_physical_database_but_not_tables(async: False, ambientTransaction: True) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorCreateTest.<>c__DisplayClass0_0.<<Creates_physical_database_but_not_tables>b__0>d.MoveNext() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 612
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c.<<ExecuteAsync>b__3_0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategyExtensions.cs:line 111
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.<>c__DisplayClass30_0`2.<<ExecuteAsync>b__0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 311
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 334
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 358
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 310
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorCreateTest.Creates_physical_database_but_not_tables(Boolean async, Boolean ambientTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 609
--- End of stack trace from previous location ---
[xUnit.net 00:02:25.15]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Deletes_database(async: False, open: False, ambientTransaction: True) [FAIL]
  Failed Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Deletes_database(async: False, open: False, ambientTransaction: True) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.<>c__DisplayClass2_0.<<Delete_database_test>b__0>d.MoveNext() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 144
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c.<<ExecuteAsync>b__3_0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategyExtensions.cs:line 111
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.<>c__DisplayClass30_0`2.<<ExecuteAsync>b__0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 311
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 334
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 358
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 310
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Delete_database_test(Boolean async, Boolean open, Boolean ambientTransaction, Boolean file) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 141
--- End of stack trace from previous location ---
[xUnit.net 00:02:26.33]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tph_entity_owning_a_split_reference_on_leaf_without_table_sharing [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tph_entity_owning_a_split_reference_on_leaf_without_table_sharing [1 ms]
[xUnit.net 00:02:26.33]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tph_entity_owning_a_split_collection_on_middle [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tph_entity_owning_a_split_collection_on_middle [1 ms]
[xUnit.net 00:02:27.83]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Noop_when_database_with_filename_does_not_exist(async: False) [SKIP]
[xUnit.net 00:02:27.83]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Noop_when_database_with_filename_does_not_exist(async: True) [SKIP]
[xUnit.net 00:02:27.83]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Deletes_database_with_filename(async: True, open: True, ambientTransaction: False) [SKIP]
[xUnit.net 00:02:27.83]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Deletes_database_with_filename(async: False, open: True, ambientTransaction: True) [SKIP]
[xUnit.net 00:02:27.83]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Deletes_database_with_filename(async: True, open: False, ambientTransaction: True) [SKIP]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Noop_when_database_with_filename_does_not_exist(async: False) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Noop_when_database_with_filename_does_not_exist(async: True) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Deletes_database_with_filename(async: True, open: True, ambientTransaction: False) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Deletes_database_with_filename(async: False, open: True, ambientTransaction: True) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Deletes_database_with_filename(async: True, open: False, ambientTransaction: True) [1 ms]
[xUnit.net 00:02:27.83]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Deletes_database_with_filename(async: False, open: False, ambientTransaction: False) [SKIP]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorEnsureDeletedTest.Deletes_database_with_filename(async: False, open: False, ambientTransaction: False) [1 ms]
[xUnit.net 00:02:30.54]     Microsoft.EntityFrameworkCore.Query.TPCInheritanceQuerySqlServerTest.OfType_Union_OfType [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPCInheritanceQuerySqlServerTest.OfType_Union_OfType [1 ms]
[xUnit.net 00:02:31.49]     Microsoft.EntityFrameworkCore.Query.TPCInheritanceQuerySqlServerTest.OfType_Union_subquery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPCInheritanceQuerySqlServerTest.OfType_Union_subquery [1 ms]
[xUnit.net 00:02:32.65]     Microsoft.EntityFrameworkCore.Query.TPCInheritanceQuerySqlServerTest.Union_siblings_with_duplicate_property_in_subquery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPCInheritanceQuerySqlServerTest.Union_siblings_with_duplicate_property_in_subquery [1 ms]
[xUnit.net 00:02:34.60]     Microsoft.EntityFrameworkCore.Query.TPCInheritanceQueryHiLoSqlServerTest.OfType_Union_OfType [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPCInheritanceQueryHiLoSqlServerTest.OfType_Union_OfType [1 ms]
[xUnit.net 00:02:36.83]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tph_entity_owning_a_split_collection_on_leaf [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tph_entity_owning_a_split_collection_on_leaf [1 ms]
[xUnit.net 00:02:38.73]     Microsoft.EntityFrameworkCore.Query.ManyToManyNoTrackingQuerySqlServerTest.Includes_accessed_via_different_path_are_merged_unidirectional [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.ManyToManyNoTrackingQuerySqlServerTest.Includes_accessed_via_different_path_are_merged_unidirectional [1 ms]
[xUnit.net 00:02:39.78]     Microsoft.EntityFrameworkCore.Query.TPCInheritanceQueryHiLoSqlServerTest.Union_siblings_with_duplicate_property_in_subquery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPCInheritanceQueryHiLoSqlServerTest.Union_siblings_with_duplicate_property_in_subquery [1 ms]
[xUnit.net 00:02:39.90]     Microsoft.EntityFrameworkCore.Query.InheritanceQuerySqlServerTest.Union_siblings_with_duplicate_property_in_subquery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.InheritanceQuerySqlServerTest.Union_siblings_with_duplicate_property_in_subquery [1 ms]
[xUnit.net 00:02:39.91]     Microsoft.EntityFrameworkCore.Query.InheritanceQuerySqlServerTest.OfType_Union_OfType [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.InheritanceQuerySqlServerTest.OfType_Union_OfType [1 ms]
[xUnit.net 00:02:41.22]     Microsoft.EntityFrameworkCore.Query.IncompleteMappingInheritanceQuerySqlServerTest.Union_siblings_with_duplicate_property_in_subquery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.IncompleteMappingInheritanceQuerySqlServerTest.Union_siblings_with_duplicate_property_in_subquery [1 ms]
[xUnit.net 00:02:41.49]     Microsoft.EntityFrameworkCore.Query.TPCInheritanceQuerySqlServerTest.Union_entity_equality [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPCInheritanceQuerySqlServerTest.Union_entity_equality [1 ms]
[xUnit.net 00:02:41.68]     Microsoft.EntityFrameworkCore.Query.TPCInheritanceQueryHiLoSqlServerTest.OfType_Union_subquery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPCInheritanceQueryHiLoSqlServerTest.OfType_Union_subquery [1 ms]
[xUnit.net 00:02:45.00]     Microsoft.EntityFrameworkCore.Query.TPTInheritanceQuerySqlServerTest.Union_entity_equality [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPTInheritanceQuerySqlServerTest.Union_entity_equality [1 ms]
[xUnit.net 00:02:45.95]     Microsoft.EntityFrameworkCore.Query.TPTInheritanceQuerySqlServerTest.OfType_Union_OfType [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPTInheritanceQuerySqlServerTest.OfType_Union_OfType [1 ms]
[xUnit.net 00:02:46.22]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tpc_entity_owning_a_split_collection_on_leaf [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tpc_entity_owning_a_split_collection_on_leaf [1 ms]
[xUnit.net 00:02:46.62]     Microsoft.EntityFrameworkCore.Query.IncompleteMappingInheritanceQuerySqlServerTest.Union_entity_equality [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.IncompleteMappingInheritanceQuerySqlServerTest.Union_entity_equality [1 ms]
[xUnit.net 00:02:46.87]     Microsoft.EntityFrameworkCore.Query.TPCInheritanceQueryHiLoSqlServerTest.Union_entity_equality [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPCInheritanceQueryHiLoSqlServerTest.Union_entity_equality [1 ms]
[xUnit.net 00:02:47.66]     Microsoft.EntityFrameworkCore.Query.TPTManyToManyQuerySqlServerTest.Includes_accessed_via_different_path_are_merged_unidirectional [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPTManyToManyQuerySqlServerTest.Includes_accessed_via_different_path_are_merged_unidirectional [1 ms]
[xUnit.net 00:02:48.16]     Microsoft.EntityFrameworkCore.Query.JsonQuerySqlServerTest.Json_subquery_reference_pushdown_reference_pushdown_anonymous_projection [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.JsonQuerySqlServerTest.Json_subquery_reference_pushdown_reference_pushdown_anonymous_projection [1 ms]
[xUnit.net 00:02:48.55]     Microsoft.EntityFrameworkCore.Query.InheritanceQuerySqlServerTest.OfType_Union_subquery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.InheritanceQuerySqlServerTest.OfType_Union_subquery [1 ms]
[xUnit.net 00:02:50.25]     Microsoft.EntityFrameworkCore.Query.IncompleteMappingInheritanceQuerySqlServerTest.OfType_Union_OfType [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.IncompleteMappingInheritanceQuerySqlServerTest.OfType_Union_OfType [1 ms]
[xUnit.net 00:02:51.39]     Microsoft.EntityFrameworkCore.Query.InheritanceQuerySqlServerTest.Union_entity_equality [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.InheritanceQuerySqlServerTest.Union_entity_equality [1 ms]
[xUnit.net 00:02:51.75]     Microsoft.EntityFrameworkCore.Query.NullSemanticsQuerySqlServerTest.Null_comparison_in_join_key_with_relational_nulls [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.NullSemanticsQuerySqlServerTest.Null_comparison_in_join_key_with_relational_nulls [1 ms]
[xUnit.net 00:02:52.32]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction_with_connectionString(async: False, autoTransactionBehavior: Always) [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction_with_connectionString(async: False, autoTransactionBehavior: Always) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.SaveChanges_uses_ambient_transaction_with_connectionString(Boolean async, AutoTransactionBehavior autoTransactionBehavior) in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 431
--- End of stack trace from previous location ---
[xUnit.net 00:02:55.75]     Microsoft.EntityFrameworkCore.Query.JsonQuerySqlServerTest.Json_entity_backtracking [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.JsonQuerySqlServerTest.Json_entity_backtracking [1 ms]
[xUnit.net 00:02:56.14]     Microsoft.EntityFrameworkCore.Query.ManyToManyQuerySqlServerTest.Filtered_includes_accessed_via_different_path_are_merged [SKIP]
[xUnit.net 00:02:56.14]     Microsoft.EntityFrameworkCore.Query.ManyToManyQuerySqlServerTest.Includes_accessed_via_different_path_are_merged_unidirectional [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.ManyToManyQuerySqlServerTest.Filtered_includes_accessed_via_different_path_are_merged [1 ms]
  Skipped Microsoft.EntityFrameworkCore.Query.ManyToManyQuerySqlServerTest.Includes_accessed_via_different_path_are_merged_unidirectional [1 ms]
[xUnit.net 00:02:56.43]     Microsoft.EntityFrameworkCore.Query.JsonQuerySqlServerTest.Json_collection_element_access_in_predicate [SKIP]
[xUnit.net 00:02:56.43]     Microsoft.EntityFrameworkCore.Query.JsonQuerySqlServerTest.Json_subquery_reference_pushdown_reference_anonymous_projection [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.JsonQuerySqlServerTest.Json_collection_element_access_in_predicate [1 ms]
  Skipped Microsoft.EntityFrameworkCore.Query.JsonQuerySqlServerTest.Json_subquery_reference_pushdown_reference_anonymous_projection [1 ms]
[xUnit.net 00:02:56.43]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tpc_entity_owning_a_split_reference_on_leaf_without_table_sharing [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tpc_entity_owning_a_split_reference_on_leaf_without_table_sharing [1 ms]
[xUnit.net 00:03:02.58]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tpt_entity_owning_a_split_collection_on_base [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tpt_entity_owning_a_split_collection_on_base [1 ms]
[xUnit.net 00:03:04.58]     Microsoft.EntityFrameworkCore.Query.JsonQuerySqlServerTest.Group_by_json_scalar_Orderby_json_scalar_FirstOrDefault [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.JsonQuerySqlServerTest.Group_by_json_scalar_Orderby_json_scalar_FirstOrDefault [1 ms]
[xUnit.net 00:03:07.60]     Microsoft.EntityFrameworkCore.Query.NorthwindGroupByQuerySqlServerTest.GroupBy_with_group_key_being_navigation_with_complex_projection [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.NorthwindGroupByQuerySqlServerTest.GroupBy_with_group_key_being_navigation_with_complex_projection [1 ms]
[xUnit.net 00:03:12.96]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Normal_entity_owning_a_split_reference_with_main_fragment_not_sharing [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Normal_entity_owning_a_split_reference_with_main_fragment_not_sharing [1 ms]
[xUnit.net 00:03:15.89]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_true_when_database_exists(async: False, ambientTransaction: True, useCanConnect: False) [FAIL]
[xUnit.net 00:03:15.91]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_false_when_database_with_filename_does_not_exist(async: False, ambientTransaction: True, useCanConnect: True) [SKIP]
[xUnit.net 00:03:15.91]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_false_when_database_with_filename_does_not_exist(async: True, ambientTransaction: False, useCanConnect: True) [SKIP]
[xUnit.net 00:03:15.91]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_false_when_database_with_filename_does_not_exist(async: False, ambientTransaction: True, useCanConnect: False) [SKIP]
[xUnit.net 00:03:15.91]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_false_when_database_with_filename_does_not_exist(async: True, ambientTransaction: False, useCanConnect: False) [SKIP]
[xUnit.net 00:03:15.91]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_true_when_database_with_filename_exists(async: True, ambientTransaction: True, useCanConnect: True) [SKIP]
[xUnit.net 00:03:15.91]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_true_when_database_with_filename_exists(async: True, ambientTransaction: True, useCanConnect: False) [SKIP]
[xUnit.net 00:03:15.91]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_true_when_database_with_filename_exists(async: False, ambientTransaction: False, useCanConnect: True) [SKIP]
[xUnit.net 00:03:15.91]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_true_when_database_with_filename_exists(async: False, ambientTransaction: False, useCanConnect: False) [SKIP]
  Failed Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_true_when_database_exists(async: False, ambientTransaction: True, useCanConnect: False) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.<>c__DisplayClass5_0.<<Returns_true_when_database_exists_test>b__0>d.MoveNext() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 91
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c.<<ExecuteAsync>b__3_0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategyExtensions.cs:line 111
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.<>c__DisplayClass30_0`2.<<ExecuteAsync>b__0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 311
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 334
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 358
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 310
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_true_when_database_exists_test(Boolean async, Boolean ambientTransaction, Boolean useCanConnect, Boolean file) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 88
--- End of stack trace from previous location ---
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_false_when_database_with_filename_does_not_exist(async: False, ambientTransaction: True, useCanConnect: True) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_false_when_database_with_filename_does_not_exist(async: True, ambientTransaction: False, useCanConnect: True) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_false_when_database_with_filename_does_not_exist(async: False, ambientTransaction: True, useCanConnect: False) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_false_when_database_with_filename_does_not_exist(async: True, ambientTransaction: False, useCanConnect: False) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_true_when_database_with_filename_exists(async: True, ambientTransaction: True, useCanConnect: True) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_true_when_database_with_filename_exists(async: True, ambientTransaction: True, useCanConnect: False) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_true_when_database_with_filename_exists(async: False, ambientTransaction: False, useCanConnect: True) [1 ms]
  Skipped Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_true_when_database_with_filename_exists(async: False, ambientTransaction: False, useCanConnect: False) [1 ms]
[xUnit.net 00:03:16.38]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorHasTablesTest.Returns_true_when_database_exists_and_has_any_tables(async: True, ambientTransaction: True) [FAIL]
  Failed Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorHasTablesTest.Returns_true_when_database_exists_and_has_any_tables(async: True, ambientTransaction: True) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorHasTablesTest.<>c__DisplayClass2_0.<<Returns_true_when_database_exists_and_has_any_tables>b__1>d.MoveNext() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 402
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c.<<ExecuteAsync>b__3_0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategyExtensions.cs:line 111
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.<>c__DisplayClass30_0`2.<<ExecuteAsync>b__0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 311
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 334
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 358
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 310
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorHasTablesTest.Returns_true_when_database_exists_and_has_any_tables(Boolean async, Boolean ambientTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 399
--- End of stack trace from previous location ---
[xUnit.net 00:03:22.39]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Split_entity_owning_a_split_collection [SKIP]
[xUnit.net 00:03:22.39]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tph_entity_owning_a_split_reference_on_base_without_table_sharing [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Split_entity_owning_a_split_collection [1 ms]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tph_entity_owning_a_split_reference_on_base_without_table_sharing [1 ms]
[xUnit.net 00:03:35.78]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Normal_entity_owning_a_split_collection [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Normal_entity_owning_a_split_collection [1 ms]
[xUnit.net 00:03:39.85]     Microsoft.EntityFrameworkCore.Query.TPCManyToManyQuerySqlServerTest.Filtered_includes_accessed_via_different_path_are_merged [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPCManyToManyQuerySqlServerTest.Filtered_includes_accessed_via_different_path_are_merged [1 ms]
[xUnit.net 00:03:43.81]     Microsoft.EntityFrameworkCore.Query.ManyToManyNoTrackingQuerySqlServerTest.Filtered_includes_accessed_via_different_path_are_merged [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.ManyToManyNoTrackingQuerySqlServerTest.Filtered_includes_accessed_via_different_path_are_merged [1 ms]
[xUnit.net 00:03:44.18]     Microsoft.EntityFrameworkCore.Query.TPTManyToManyNoTrackingQuerySqlServerTest.Includes_accessed_via_different_path_are_merged_unidirectional [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPTManyToManyNoTrackingQuerySqlServerTest.Includes_accessed_via_different_path_are_merged_unidirectional [1 ms]
[xUnit.net 00:03:50.07]     Microsoft.EntityFrameworkCore.BulkUpdates.NorthwindBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_2 [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.NorthwindBulkUpdatesSqlServerTest.Delete_GroupBy_Where_Select_2 [1 ms]
[xUnit.net 00:03:52.33]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction_with_connectionString(async: False, autoTransactionBehavior: Never) [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction_with_connectionString(async: False, autoTransactionBehavior: Never) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.SaveChanges_uses_ambient_transaction_with_connectionString(Boolean async, AutoTransactionBehavior autoTransactionBehavior) in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 431
--- End of stack trace from previous location ---
[xUnit.net 00:03:53.16]     Microsoft.EntityFrameworkCore.BulkUpdates.NorthwindBulkUpdatesSqlServerTest.Update_Where_GroupBy_First_set_constant_2 [SKIP]
  Skipped Microsoft.EntityFrameworkCore.BulkUpdates.NorthwindBulkUpdatesSqlServerTest.Update_Where_GroupBy_First_set_constant_2 [1 ms]
[xUnit.net 00:03:53.39]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tph_entity_owning_a_split_reference_on_middle_without_table_sharing [SKIP]
[xUnit.net 00:03:53.39]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tpt_entity_owning_a_split_reference_on_base_without_table_sharing [SKIP]
[xUnit.net 00:03:53.39]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tpt_entity_owning_a_split_reference_on_leaf_without_table_sharing [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tph_entity_owning_a_split_reference_on_middle_without_table_sharing [1 ms]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tpt_entity_owning_a_split_reference_on_base_without_table_sharing [1 ms]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tpt_entity_owning_a_split_reference_on_leaf_without_table_sharing [1 ms]
[xUnit.net 00:03:57.68]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tph_entity_owning_a_split_collection_on_base [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tph_entity_owning_a_split_collection_on_base [1 ms]
[xUnit.net 00:03:57.80]     Microsoft.EntityFrameworkCore.Query.TemporalManyToManyQuerySqlServerTest.Includes_accessed_via_different_path_are_merged_unidirectional [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TemporalManyToManyQuerySqlServerTest.Includes_accessed_via_different_path_are_merged_unidirectional [1 ms]
[xUnit.net 00:04:04.83]     Microsoft.EntityFrameworkCore.Query.TPCManyToManyNoTrackingQuerySqlServerTest.Filtered_includes_accessed_via_different_path_are_merged [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPCManyToManyNoTrackingQuerySqlServerTest.Filtered_includes_accessed_via_different_path_are_merged [1 ms]
[xUnit.net 00:04:05.58]     Microsoft.EntityFrameworkCore.Query.ManyToManyNoTrackingQuerySqlServerTest.Includes_accessed_via_different_path_are_merged [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.ManyToManyNoTrackingQuerySqlServerTest.Includes_accessed_via_different_path_are_merged [1 ms]
[xUnit.net 00:04:06.71]     Microsoft.EntityFrameworkCore.Query.NullSemanticsQuerySqlServerTest.Negated_order_comparison_on_nullable_arguments_doesnt_get_optimized [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.NullSemanticsQuerySqlServerTest.Negated_order_comparison_on_nullable_arguments_doesnt_get_optimized [1 ms]
[xUnit.net 00:04:09.49]     Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tpt_entity_owning_a_split_reference_on_middle_without_table_sharing [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.EntitySplittingQuerySqlServerTest.Tpt_entity_owning_a_split_reference_on_middle_without_table_sharing [1 ms]
[xUnit.net 00:04:10.09]     Microsoft.EntityFrameworkCore.Query.ManyToManyQuerySqlServerTest.Includes_accessed_via_different_path_are_merged [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.ManyToManyQuerySqlServerTest.Includes_accessed_via_different_path_are_merged [1 ms]
[xUnit.net 00:04:10.98]     Microsoft.EntityFrameworkCore.Query.TPTManyToManyNoTrackingQuerySqlServerTest.Filtered_includes_accessed_via_different_path_are_merged [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPTManyToManyNoTrackingQuerySqlServerTest.Filtered_includes_accessed_via_different_path_are_merged [1 ms]
[xUnit.net 00:04:12.08]     Microsoft.EntityFrameworkCore.Query.ManyToManyQuerySqlServerTest.Throws_when_different_filtered_then_include_via_different_paths [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.ManyToManyQuerySqlServerTest.Throws_when_different_filtered_then_include_via_different_paths [1 ms]
[xUnit.net 00:04:15.33]     Microsoft.EntityFrameworkCore.Query.TemporalComplexNavigationsCollectionsSharedTypeQuerySqlServerTest.Complex_query_with_let_collection_projection_FirstOrDefault_with_ToList_on_inner_and_outer [SKIP]
[xUnit.net 00:04:15.33]     Microsoft.EntityFrameworkCore.Query.TemporalComplexNavigationsCollectionsSharedTypeQuerySqlServerTest.Filtered_include_include_parameter_used_inside_filter_throws [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TemporalComplexNavigationsCollectionsSharedTypeQuerySqlServerTest.Complex_query_with_let_collection_projection_FirstOrDefault_with_ToList_on_inner_and_outer [1 ms]
  Skipped Microsoft.EntityFrameworkCore.Query.TemporalComplexNavigationsCollectionsSharedTypeQuerySqlServerTest.Filtered_include_include_parameter_used_inside_filter_throws [1 ms]
[xUnit.net 00:04:16.07]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_false_when_database_does_not_exist(async: True, ambientTransaction: True, useCanConnect: False) [FAIL]
  Failed Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_false_when_database_does_not_exist(async: True, ambientTransaction: True, useCanConnect: False) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.<>c__DisplayClass2_0.<<Returns_false_when_database_does_not_exist_test>b__0>d.MoveNext() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 47
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c.<<ExecuteAsync>b__3_0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategyExtensions.cs:line 111
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.<>c__DisplayClass30_0`2.<<ExecuteAsync>b__0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 311
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 334
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 358
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 310
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_false_when_database_does_not_exist_test(Boolean async, Boolean ambientTransaction, Boolean useCanConnect, Boolean file) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 44
--- End of stack trace from previous location ---
[xUnit.net 00:04:19.84]     Microsoft.EntityFrameworkCore.Query.TemporalManyToManyQuerySqlServerTest.Filtered_includes_accessed_via_different_path_are_merged [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TemporalManyToManyQuerySqlServerTest.Filtered_includes_accessed_via_different_path_are_merged [1 ms]
[xUnit.net 00:04:20.32]     Microsoft.EntityFrameworkCore.Query.TPCManyToManyNoTrackingQuerySqlServerTest.Includes_accessed_via_different_path_are_merged_unidirectional [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPCManyToManyNoTrackingQuerySqlServerTest.Includes_accessed_via_different_path_are_merged_unidirectional [1 ms]
[xUnit.net 00:04:20.58]     Microsoft.EntityFrameworkCore.Query.TPCManyToManyQuerySqlServerTest.Includes_accessed_via_different_path_are_merged_unidirectional [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPCManyToManyQuerySqlServerTest.Includes_accessed_via_different_path_are_merged_unidirectional [1 ms]
[xUnit.net 00:04:25.94]     Microsoft.EntityFrameworkCore.Query.TemporalManyToManyQuerySqlServerTest.Includes_accessed_via_different_path_are_merged [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TemporalManyToManyQuerySqlServerTest.Includes_accessed_via_different_path_are_merged [1 ms]
[xUnit.net 00:04:27.16]     Microsoft.EntityFrameworkCore.Query.TemporalManyToManyQuerySqlServerTest.Throws_when_different_filtered_then_include_via_different_paths [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TemporalManyToManyQuerySqlServerTest.Throws_when_different_filtered_then_include_via_different_paths [1 ms]
[xUnit.net 00:04:27.30]     Microsoft.EntityFrameworkCore.Query.TPTManyToManyNoTrackingQuerySqlServerTest.Throws_when_different_filtered_then_include_via_different_paths [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPTManyToManyNoTrackingQuerySqlServerTest.Throws_when_different_filtered_then_include_via_different_paths [1 ms]
[xUnit.net 00:04:27.33]     Microsoft.EntityFrameworkCore.Query.TPTManyToManyQuerySqlServerTest.Includes_accessed_via_different_path_are_merged [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPTManyToManyQuerySqlServerTest.Includes_accessed_via_different_path_are_merged [1 ms]
[xUnit.net 00:04:28.07]     Microsoft.EntityFrameworkCore.Query.TPCManyToManyNoTrackingQuerySqlServerTest.Includes_accessed_via_different_path_are_merged [SKIP]
[xUnit.net 00:04:28.08]     Microsoft.EntityFrameworkCore.Query.TPCManyToManyNoTrackingQuerySqlServerTest.Throws_when_different_filtered_then_include_via_different_paths [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPCManyToManyNoTrackingQuerySqlServerTest.Includes_accessed_via_different_path_are_merged [1 ms]
  Skipped Microsoft.EntityFrameworkCore.Query.TPCManyToManyNoTrackingQuerySqlServerTest.Throws_when_different_filtered_then_include_via_different_paths [1 ms]
[xUnit.net 00:04:28.13]     Microsoft.EntityFrameworkCore.Query.TPTManyToManyNoTrackingQuerySqlServerTest.Includes_accessed_via_different_path_are_merged [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPTManyToManyNoTrackingQuerySqlServerTest.Includes_accessed_via_different_path_are_merged [1 ms]
[xUnit.net 00:04:28.65]     Microsoft.EntityFrameworkCore.Query.TPCManyToManyQuerySqlServerTest.Throws_when_different_filtered_then_include_via_different_paths [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPCManyToManyQuerySqlServerTest.Throws_when_different_filtered_then_include_via_different_paths [1 ms]
[xUnit.net 00:04:30.78]     Microsoft.EntityFrameworkCore.Query.TemporalComplexNavigationsCollectionsSharedTypeQuerySqlServerTest.Filtered_include_outer_parameter_used_inside_filter [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TemporalComplexNavigationsCollectionsSharedTypeQuerySqlServerTest.Filtered_include_outer_parameter_used_inside_filter [1 ms]
[xUnit.net 00:04:31.30]     Microsoft.EntityFrameworkCore.Query.TPTManyToManyQuerySqlServerTest.Throws_when_different_filtered_then_include_via_different_paths [SKIP]
[xUnit.net 00:04:31.30]     Microsoft.EntityFrameworkCore.Query.TPTManyToManyQuerySqlServerTest.Filtered_includes_accessed_via_different_path_are_merged [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPTManyToManyQuerySqlServerTest.Throws_when_different_filtered_then_include_via_different_paths [1 ms]
  Skipped Microsoft.EntityFrameworkCore.Query.TPTManyToManyQuerySqlServerTest.Filtered_includes_accessed_via_different_path_are_merged [1 ms]
[xUnit.net 00:04:32.22]     Microsoft.EntityFrameworkCore.Query.TPCManyToManyQuerySqlServerTest.Includes_accessed_via_different_path_are_merged [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TPCManyToManyQuerySqlServerTest.Includes_accessed_via_different_path_are_merged [1 ms]
[xUnit.net 00:04:39.26]     Microsoft.EntityFrameworkCore.Query.NullSemanticsQuerySqlServerTest.Where_IndexOf_empty [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.NullSemanticsQuerySqlServerTest.Where_IndexOf_empty [1 ms]
[xUnit.net 00:04:44.55]     Microsoft.EntityFrameworkCore.Query.TemporalComplexNavigationsCollectionsSharedTypeQuerySqlServerTest.Include_inside_subquery [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.TemporalComplexNavigationsCollectionsSharedTypeQuerySqlServerTest.Include_inside_subquery [1 ms]
[xUnit.net 00:04:52.37]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction_with_connectionString(async: True, autoTransactionBehavior: Always) [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction_with_connectionString(async: True, autoTransactionBehavior: Always) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.SaveChanges_uses_ambient_transaction_with_connectionString(Boolean async, AutoTransactionBehavior autoTransactionBehavior) in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 431
--- End of stack trace from previous location ---
[xUnit.net 00:05:05.92]     Microsoft.EntityFrameworkCore.Query.NorthwindGroupByQuerySqlServerTest.GroupBy_aggregate_left_join_GroupBy_aggregate_left_join [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.NorthwindGroupByQuerySqlServerTest.GroupBy_aggregate_left_join_GroupBy_aggregate_left_join [1 ms]
[xUnit.net 00:05:16.28]     Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_false_when_database_does_not_exist(async: True, ambientTransaction: True, useCanConnect: True) [FAIL]
  Failed Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_false_when_database_does_not_exist(async: True, ambientTransaction: True, useCanConnect: True) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorTest.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 666
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.<>c__DisplayClass2_0.<<Returns_false_when_database_does_not_exist_test>b__0>d.MoveNext() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 47
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c.<<ExecuteAsync>b__3_0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategyExtensions.cs:line 111
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.<>c__DisplayClass30_0`2.<<ExecuteAsync>b__0>d.MoveNext() in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 311
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 334
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 358
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken) in C:\github\efcore\src\EFCore\Storage\ExecutionStrategy.cs:line 310
   at Microsoft.EntityFrameworkCore.SqlServerDatabaseCreatorExistsTest.Returns_false_when_database_does_not_exist_test(Boolean async, Boolean ambientTransaction, Boolean useCanConnect, Boolean file) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\SqlServerDatabaseCreatorTest.cs:line 44
--- End of stack trace from previous location ---
[xUnit.net 00:05:19.57]     Microsoft.EntityFrameworkCore.Query.NorthwindGroupByQuerySqlServerTest.GroupBy_aggregate_from_multiple_query_in_same_projection_3 [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.NorthwindGroupByQuerySqlServerTest.GroupBy_aggregate_from_multiple_query_in_same_projection_3 [1 ms]
[xUnit.net 00:05:23.40]     Microsoft.EntityFrameworkCore.Migrations.MigrationsSqlServerTest.Create_index_unique_with_include_and_filter_online [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Migrations.MigrationsSqlServerTest.Create_index_unique_with_include_and_filter_online [1 ms]
[xUnit.net 00:05:29.41]     Microsoft.EntityFrameworkCore.Migrations.MigrationsSqlServerTest.Create_index_unique_with_include_filter_online_and_fillfactor [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Migrations.MigrationsSqlServerTest.Create_index_unique_with_include_filter_online_and_fillfactor [1 ms]
[xUnit.net 00:05:52.38]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction_with_connectionString(async: True, autoTransactionBehavior: Never) [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction_with_connectionString(async: True, autoTransactionBehavior: Never) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.SaveChanges_uses_ambient_transaction_with_connectionString(Boolean async, AutoTransactionBehavior autoTransactionBehavior) in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 431
--- End of stack trace from previous location ---
[xUnit.net 00:05:59.50]     Microsoft.EntityFrameworkCore.Query.ComplexNavigationsSharedTypeQuerySqlServerTest.GroupBy_aggregate_where_required_relationship_2 [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.ComplexNavigationsSharedTypeQuerySqlServerTest.GroupBy_aggregate_where_required_relationship_2 [1 ms]
[xUnit.net 00:06:15.78]     Microsoft.EntityFrameworkCore.Query.ComplexNavigationsSharedTypeQuerySqlServerTest.GroupBy_aggregate_where_required_relationship [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.ComplexNavigationsSharedTypeQuerySqlServerTest.GroupBy_aggregate_where_required_relationship [1 ms]
[xUnit.net 00:06:52.39]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction_with_connectionString(async: True, autoTransactionBehavior: WhenNeeded) [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction_with_connectionString(async: True, autoTransactionBehavior: WhenNeeded) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.SaveChanges_uses_ambient_transaction_with_connectionString(Boolean async, AutoTransactionBehavior autoTransactionBehavior) in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 431
--- End of stack trace from previous location ---
[xUnit.net 00:06:54.51]     Microsoft.EntityFrameworkCore.Query.NorthwindGroupByQuerySqlServerTest.GroupBy_aggregate_from_multiple_query_in_same_projection [SKIP]
  Skipped Microsoft.EntityFrameworkCore.Query.NorthwindGroupByQuerySqlServerTest.GroupBy_aggregate_from_multiple_query_in_same_projection [1 ms]
[xUnit.net 00:07:52.41]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction_with_connectionString(async: False, autoTransactionBehavior: WhenNeeded) [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction_with_connectionString(async: False, autoTransactionBehavior: WhenNeeded) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.SaveChanges_uses_ambient_transaction_with_connectionString(Boolean async, AutoTransactionBehavior autoTransactionBehavior) in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 431
--- End of stack trace from previous location ---
[xUnit.net 00:08:52.42]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.EnlistTransaction_throws_if_ambient_transaction_started [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.EnlistTransaction_throws_if_ambient_transaction_started [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.EnlistTransaction_throws_if_ambient_transaction_started() in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 1290
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
[xUnit.net 00:09:52.47]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.UseTransaction_throws_if_ambient_transaction_started [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.UseTransaction_throws_if_ambient_transaction_started [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.UseTransaction_throws_if_ambient_transaction_started() in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 1104
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
[xUnit.net 00:10:53.30]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_throws_for_suppressed_ambient_transactions(connectionString: False) [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_throws_for_suppressed_ambient_transactions(connectionString: False) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.SaveChanges_throws_for_suppressed_ambient_transactions(Boolean connectionString) in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 475
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
[xUnit.net 00:11:53.32]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_throws_for_suppressed_ambient_transactions(connectionString: True) [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_throws_for_suppressed_ambient_transactions(connectionString: True) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.SaveChanges_throws_for_suppressed_ambient_transactions(Boolean connectionString) in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 475
   at InvokeStub_TransactionTestBase`1.SaveChanges_throws_for_suppressed_ambient_transactions(Object, Object, IntPtr*)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
[xUnit.net 00:12:53.35]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction(async: False, autoTransactionBehavior: WhenNeeded) [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction(async: False, autoTransactionBehavior: WhenNeeded) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.SaveChanges_uses_ambient_transaction(Boolean async, AutoTransactionBehavior autoTransactionBehavior) in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 359
--- End of stack trace from previous location ---
[xUnit.net 00:13:53.37]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction(async: False, autoTransactionBehavior: Always) [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction(async: False, autoTransactionBehavior: Always) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.SaveChanges_uses_ambient_transaction(Boolean async, AutoTransactionBehavior autoTransactionBehavior) in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 359
--- End of stack trace from previous location ---
[xUnit.net 00:14:53.38]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction(async: True, autoTransactionBehavior: WhenNeeded) [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction(async: True, autoTransactionBehavior: WhenNeeded) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.SaveChanges_uses_ambient_transaction(Boolean async, AutoTransactionBehavior autoTransactionBehavior) in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 359
--- End of stack trace from previous location ---
[xUnit.net 00:15:53.39]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction(async: True, autoTransactionBehavior: Always) [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction(async: True, autoTransactionBehavior: Always) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.SaveChanges_uses_ambient_transaction(Boolean async, AutoTransactionBehavior autoTransactionBehavior) in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 359
--- End of stack trace from previous location ---
[xUnit.net 00:16:53.40]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction(async: False, autoTransactionBehavior: Never) [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction(async: False, autoTransactionBehavior: Never) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.SaveChanges_uses_ambient_transaction(Boolean async, AutoTransactionBehavior autoTransactionBehavior) in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 359
--- End of stack trace from previous location ---
[xUnit.net 00:17:53.40]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction(async: True, autoTransactionBehavior: Never) [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_ambient_transaction(async: True, autoTransactionBehavior: Never) [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.SaveChanges_uses_ambient_transaction(Boolean async, AutoTransactionBehavior autoTransactionBehavior) in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 359
--- End of stack trace from previous location ---
[xUnit.net 00:18:53.45]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_enlisted_transaction_after_ambient_transaction [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.SaveChanges_uses_enlisted_transaction_after_ambient_transaction [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.SaveChanges_uses_enlisted_transaction_after_ambient_transaction() in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 601
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
[xUnit.net 00:19:53.52]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.BeginTransaction_can_be_used_after_ambient_transaction_ended [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.BeginTransaction_can_be_used_after_ambient_transaction_ended [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.BeginTransaction_can_be_used_after_ambient_transaction_ended() in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 1196
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
[xUnit.net 00:20:53.66]     Microsoft.EntityFrameworkCore.TransactionSqlServerTest.BeginTransaction_throws_if_ambient_transaction_started [FAIL]
  Failed Microsoft.EntityFrameworkCore.TransactionSqlServerTest.BeginTransaction_throws_if_ambient_transaction_started [1 m]
  Error Message:
   Distributed transaction started
Expected: False
Actual:   True
  Stack Trace:
     at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener.DistributedTransactionStarted(Object sender, TransactionEventArgs e) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 129
   at System.Transactions.TransactionManager.ProcessExistingTransactions(TransactionStartedEventHandler eventHandler)
   at System.Transactions.TransactionManager.add_DistributedTransactionStarted(TransactionStartedEventHandler value)
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.DistributedTransactionListener..ctor() in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 125
   at Microsoft.EntityFrameworkCore.TestUtilities.TestStore.CreateTransactionScope(Boolean useTransaction) in C:\github\efcore\test\EFCore.Specification.Tests\TestUtilities\TestStore.cs:line 108
   at Microsoft.EntityFrameworkCore.TransactionTestBase`1.BeginTransaction_throws_if_ambient_transaction_started() in C:\github\efcore\test\EFCore.Relational.Specification.Tests\TransactionTestBase.cs:line 1155
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)

Failed!  - Failed:    31, Passed: 39289, Skipped:   152, Total: 39472, Duration: 20 m 45 s - Microsoft.EntityFrameworkCore.SqlServer.FunctionalTests.dll (net7.0)
False
PS C:\github\efcore\test\EFCore.SqlServer.FunctionalTests>

ajcvickers avatar Oct 09 '22 15:10 ajcvickers

See https://github.com/dotnet/SqlClient/issues/1675#issuecomment-1317580525 where promotion unexpectedly happens on .NET 6.0 in a parallel SqlClient scenario. It could conceivably be the same issue.

roji avatar Nov 17 '22 12:11 roji

@roji: Today on main:

Failed tests
2.9756072s✘ Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_with_string_FK_and_GUID_PK
System.NotSupportedException : Implicit distributed transactions have not been enabled. If you're intentionally starting a distributed transaction, set TransactionManager.ImplicitDistributedTransactions to true.
   at System.Transactions.DtcProxyShim.DtcProxyShimFactory.ConnectToProxy(String nodeName, Guid resourceManagerIdentifier, Object managedIdentifier, Boolean& nodeNameMatches, Byte[]& whereabouts, ResourceManagerShim& resourceManagerShim)
   at System.Transactions.Oletx.DtcTransactionManager.Initialize()
   at System.Transactions.Oletx.DtcTransactionManager.get_ProxyShimFactory()
   at System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropagationToken(Byte[] propagationToken)
   at System.Transactions.TransactionStatePSPEOperation.PSPEPromote(InternalTransaction tx)
   at System.Transactions.TransactionStateDelegatedBase.EnterState(InternalTransaction tx)
   at System.Transactions.EnlistableStates.Promote(InternalTransaction tx)
   at System.Transactions.Transaction.Promote()
   at System.Transactions.TransactionInterop.ConvertToOletxTransaction(Transaction transaction)
   at System.Transactions.TransactionInterop.GetExportCookie(Transaction transaction, Byte[] whereabouts)
   at Microsoft.Data.SqlClient.SqlInternalConnection.GetTransactionCookie(Transaction transaction, Byte[] whereAbouts)
   at Microsoft.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction)
   at Microsoft.Data.ProviderBase.DbConnectionPool.PrepareConnection(DbConnection owningObject, DbConnectionInternal obj, Transaction transaction)
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.OpenDbConnection(Boolean errorsExpected) in C:\github\efcore\src\EFCore.SqlServer\Storage\Internal\SqlServerConnection.cs:line 49
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected) in C:\github\efcore\src\EFCore.Relational\Storage\RelationalConnection.cs:line 719
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) in C:\github\efcore\src\EFCore.Relational\Storage\RelationalConnection.cs:line 633
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) in C:\github\efcore\src\EFCore.Relational\Storage\RelationalCommand.cs:line 513
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator) in C:\github\efcore\src\EFCore.Relational\Query\Internal\SingleQueryingEnumerable.cs:line 240
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.<>c.<MoveNext>b__21_0(DbContext _, Enumerator enumerator) in C:\github\efcore\src\EFCore.Relational\Query\Internal\SingleQueryingEnumerable.cs:line 168
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) in C:\github\efcore\src\EFCore.SqlServer\Storage\Internal\SqlServerExecutionStrategy.cs:line 57
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() in C:\github\efcore\src\EFCore.Relational\Query\Internal\SingleQueryingEnumerable.cs:line 167
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_with_string_FK_and_GUID_PK() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\Update\MismatchedKeyTypesSqlServerTest.cs:line 202
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
0.3496499s✘ Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_with_tinyint_FK_and_smallint_PK
System.NotSupportedException : Implicit distributed transactions have not been enabled. If you're intentionally starting a distributed transaction, set TransactionManager.ImplicitDistributedTransactions to true.
   at System.Transactions.DtcProxyShim.DtcProxyShimFactory.ConnectToProxy(String nodeName, Guid resourceManagerIdentifier, Object managedIdentifier, Boolean& nodeNameMatches, Byte[]& whereabouts, ResourceManagerShim& resourceManagerShim)
   at System.Transactions.Oletx.DtcTransactionManager.Initialize()
   at System.Transactions.Oletx.DtcTransactionManager.get_ProxyShimFactory()
   at System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropagationToken(Byte[] propagationToken)
   at System.Transactions.TransactionStatePSPEOperation.PSPEPromote(InternalTransaction tx)
   at System.Transactions.TransactionStateDelegatedBase.EnterState(InternalTransaction tx)
   at System.Transactions.EnlistableStates.Promote(InternalTransaction tx)
   at System.Transactions.Transaction.Promote()
   at System.Transactions.TransactionInterop.ConvertToOletxTransaction(Transaction transaction)
   at System.Transactions.TransactionInterop.GetExportCookie(Transaction transaction, Byte[] whereabouts)
   at Microsoft.Data.SqlClient.SqlInternalConnection.GetTransactionCookie(Transaction transaction, Byte[] whereAbouts)
   at Microsoft.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction)
   at Microsoft.Data.ProviderBase.DbConnectionPool.PrepareConnection(DbConnection owningObject, DbConnectionInternal obj, Transaction transaction)
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.OpenDbConnection(Boolean errorsExpected) in C:\github\efcore\src\EFCore.SqlServer\Storage\Internal\SqlServerConnection.cs:line 49
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected) in C:\github\efcore\src\EFCore.Relational\Storage\RelationalConnection.cs:line 719
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) in C:\github\efcore\src\EFCore.Relational\Storage\RelationalConnection.cs:line 633
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) in C:\github\efcore\src\EFCore.Relational\Storage\RelationalCommand.cs:line 513
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator) in C:\github\efcore\src\EFCore.Relational\Query\Internal\SingleQueryingEnumerable.cs:line 240
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.<>c.<MoveNext>b__21_0(DbContext _, Enumerator enumerator) in C:\github\efcore\src\EFCore.Relational\Query\Internal\SingleQueryingEnumerable.cs:line 168
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) in C:\github\efcore\src\EFCore.SqlServer\Storage\Internal\SqlServerExecutionStrategy.cs:line 57
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() in C:\github\efcore\src\EFCore.Relational\Query\Internal\SingleQueryingEnumerable.cs:line 167
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_with_tinyint_FK_and_smallint_PK() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\Update\MismatchedKeyTypesSqlServerTest.cs:line 127
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)

ajcvickers avatar Nov 20 '22 13:11 ajcvickers

@ajcvickers thanks, I think this is the first time we see this in CI (as opposed to on your machine)...

I'll look into https://github.com/dotnet/SqlClient/issues/1675#issuecomment-1317580525, which seems like a good place to investigate - it's not yet clear whether this is a SqlClient or Sys.Tx bug.

roji avatar Nov 21 '22 09:11 roji

@roji This was my machine.

ajcvickers avatar Nov 21 '22 09:11 ajcvickers

Oh oops, OK...

roji avatar Nov 21 '22 09:11 roji

CI failure: https://dev.azure.com/dnceng-public/public/_build/results?buildId=107446&view=ms.vss-test-web.build-test-results-tab&runId=2294248&resultId=112915&paneView=debug

Note that the failure occured on Ubuntu (hence PlatformNotSupportedException). I highly suspect a SqlClient-side issue rather than a Sys.Tx one (e.g. see https://github.com/dotnet/SqlClient/issues/1675#issuecomment-1328104310); if so, this should be reproducible with a new SqlClient on an older runtime (e.g. .NET 6.0).

System.PlatformNotSupportedException : This platform does not support distributed transactions.
   at System.Transactions.Oletx.OletxTransactionManager.GetOletxTransactionFromTransmitterPropagationToken(Byte[] propagationToken)
   at System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropagationToken(Byte[] propagationToken)
   at System.Transactions.TransactionStatePSPEOperation.PSPEPromote(InternalTransaction tx)
   at System.Transactions.TransactionStateDelegatedBase.EnterState(InternalTransaction tx)
   at System.Transactions.EnlistableStates.Promote(InternalTransaction tx)
   at System.Transactions.Transaction.Promote()
   at System.Transactions.TransactionInterop.ConvertToOletxTransaction(Transaction transaction)
   at System.Transactions.TransactionInterop.GetExportCookie(Transaction transaction, Byte[] whereabouts)
   at Microsoft.Data.SqlClient.SqlInternalConnection.GetTransactionCookie(Transaction transaction, Byte[] whereAbouts)
   at Microsoft.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction)
   at Microsoft.Data.ProviderBase.DbConnectionPool.PrepareConnection(DbConnection owningObject, DbConnectionInternal obj, Transaction transaction)
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected) in D:\a\_work\1\s\src\EFCore.Relational\Storage\RelationalConnection.cs:line 733
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) in D:\a\_work\1\s\src\EFCore.Relational\Storage\RelationalConnection.cs:line 641
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) in D:\a\_work\1\s\src\EFCore.Relational\Storage\RelationalCommand.cs:line 610
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator) in D:\a\_work\1\s\src\EFCore.Relational\Query\Internal\SingleQueryingEnumerable.cs:line 255
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) in D:\a\_work\1\s\src\EFCore.SqlServer\Storage\Internal\SqlServerExecutionStrategy.cs:line 61
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() in D:\a\_work\1\s\src\EFCore.Relational\Query\Internal\SingleQueryingEnumerable.cs:line 229
   at System.Linq.Enumerable.TryGetSingle[TSource](IEnumerable`1 source, Boolean& found)
   at lambda_method140988(Closure, QueryContext)
   at Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.<Can_update_and_delete_with_bigint_FK_and_int_PK>g__LoadAndValidatePopulated|4_1(Int32 expected, <>c__DisplayClass4_0&) in D:\a\_work\1\s\test\EFCore.SqlServer.FunctionalTests\Update\MismatchedKeyTypesSqlServerTest.cs:line 74

roji avatar Dec 11 '22 15:12 roji

@ajcvickers reminder that we still need to do this at some point

roji avatar Jan 27 '23 23:01 roji

Haven't see this fail in a while, but did see this last week. Note this is with SqlClient 5.1.

Microsoft.EntityFrameworkCore.SqlServer.FunctionalTests.dll
Summary
Tests run: 42576 — Failures: 2, Skipped: 134, Run time: 604.742s, Finished: 01/31/2023 14:18:23

Failed tests
3.7203172s✘ Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_with_string_FK_and_GUID_PK
System.NotSupportedException : Implicit distributed transactions have not been enabled. If you're intentionally starting a distributed transaction, set TransactionManager.ImplicitDistributedTransactions to true.
   at System.Transactions.DtcProxyShim.DtcProxyShimFactory.ConnectToProxy(String nodeName, Guid resourceManagerIdentifier, Object managedIdentifier, Boolean& nodeNameMatches, Byte[]& whereabouts, ResourceManagerShim& resourceManagerShim)
   at System.Transactions.Oletx.DtcTransactionManager.Initialize()
   at System.Transactions.Oletx.DtcTransactionManager.get_ProxyShimFactory()
   at System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropagationToken(Byte[] propagationToken)
   at System.Transactions.TransactionStatePSPEOperation.PSPEPromote(InternalTransaction tx)
   at System.Transactions.TransactionStateDelegatedBase.EnterState(InternalTransaction tx)
   at System.Transactions.EnlistableStates.Promote(InternalTransaction tx)
   at System.Transactions.Transaction.Promote()
   at System.Transactions.TransactionInterop.ConvertToOletxTransaction(Transaction transaction)
   at System.Transactions.TransactionInterop.GetExportCookie(Transaction transaction, Byte[] whereabouts)
   at Microsoft.Data.SqlClient.SqlInternalConnection.GetTransactionCookie(Transaction transaction, Byte[] whereAbouts)
   at Microsoft.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction)
   at Microsoft.Data.ProviderBase.DbConnectionPool.PrepareConnection(DbConnection owningObject, DbConnectionInternal obj, Transaction transaction)
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.OpenDbConnection(Boolean errorsExpected) in C:\github\efcore\src\EFCore.SqlServer\Storage\Internal\SqlServerConnection.cs:line 49
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected) in C:\github\efcore\src\EFCore.Relational\Storage\RelationalConnection.cs:line 725
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) in C:\github\efcore\src\EFCore.Relational\Storage\RelationalConnection.cs:line 639
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) in C:\github\efcore\src\EFCore.Relational\Storage\RelationalCommand.cs:line 513
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(Enumerator enumerator) in C:\github\efcore\src\EFCore.Relational\Query\Internal\SingleQueryingEnumerable.cs:line 240
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.<>c.<MoveNext>b__21_0(DbContext _, Enumerator enumerator) in C:\github\efcore\src\EFCore.Relational\Query\Internal\SingleQueryingEnumerable.cs:line 168
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) in C:\github\efcore\src\EFCore.SqlServer\Storage\Internal\SqlServerExecutionStrategy.cs:line 57
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext() in C:\github\efcore\src\EFCore.Relational\Query\Internal\SingleQueryingEnumerable.cs:line 167
   at System.Linq.Enumerable.TryGetSingle[TSource](IEnumerable`1 source, Boolean& found)
   at lambda_method127430(Closure, QueryContext)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.Execute[TResult](Expression query) in C:\github\efcore\src\EFCore\Query\Internal\QueryCompiler.cs:line 68
   at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.Execute[TResult](Expression expression) in C:\github\efcore\src\EFCore\Query\Internal\EntityQueryProvider.cs:line 63
   at Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.<Can_update_and_delete_with_string_FK_and_GUID_PK>g__LoadAndValidateEmpty|6_0(<>c__DisplayClass6_0&) in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\Update\MismatchedKeyTypesSqlServerTest.cs:line 208
   at Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_with_string_FK_and_GUID_PK() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\Update\MismatchedKeyTypesSqlServerTest.cs:line 194
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)
1.7464014s✘ Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_with_tinyint_FK_and_smallint_PK
System.NotSupportedException : Implicit distributed transactions have not been enabled. If you're intentionally starting a distributed transaction, set TransactionManager.ImplicitDistributedTransactions to true.
   at System.Transactions.DtcProxyShim.DtcProxyShimFactory.ConnectToProxy(String nodeName, Guid resourceManagerIdentifier, Object managedIdentifier, Boolean& nodeNameMatches, Byte[]& whereabouts, ResourceManagerShim& resourceManagerShim)
   at System.Transactions.Oletx.DtcTransactionManager.Initialize()
   at System.Transactions.Oletx.DtcTransactionManager.get_ProxyShimFactory()
   at System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropagationToken(Byte[] propagationToken)
   at System.Transactions.TransactionStatePSPEOperation.PSPEPromote(InternalTransaction tx)
   at System.Transactions.TransactionStateDelegatedBase.EnterState(InternalTransaction tx)
   at System.Transactions.EnlistableStates.Promote(InternalTransaction tx)
   at System.Transactions.Transaction.Promote()
   at System.Transactions.TransactionInterop.ConvertToOletxTransaction(Transaction transaction)
   at System.Transactions.TransactionInterop.GetExportCookie(Transaction transaction, Byte[] whereabouts)
   at Microsoft.Data.SqlClient.SqlInternalConnection.GetTransactionCookie(Transaction transaction, Byte[] whereAbouts)
   at Microsoft.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction)
   at Microsoft.Data.ProviderBase.DbConnectionPool.PrepareConnection(DbConnection owningObject, DbConnectionInternal obj, Transaction transaction)
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.OpenDbConnection(Boolean errorsExpected) in C:\github\efcore\src\EFCore.SqlServer\Storage\Internal\SqlServerConnection.cs:line 49
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected) in C:\github\efcore\src\EFCore.Relational\Storage\RelationalConnection.cs:line 725
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) in C:\github\efcore\src\EFCore.Relational\Storage\RelationalConnection.cs:line 639
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection) in C:\github\efcore\src\EFCore.Relational\Update\Internal\BatchExecutor.cs:line 83
   at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IList`1 entries) in C:\github\efcore\src\EFCore.Relational\Storage\RelationalDatabase.cs:line 58
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave) in C:\github\efcore\src\EFCore\ChangeTracking\Internal\StateManager.cs:line 1323
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(StateManager stateManager, Boolean acceptAllChangesOnSuccess) in C:\github\efcore\src\EFCore\ChangeTracking\Internal\StateManager.cs:line 1386
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<>c.<SaveChanges>b__117_0(DbContext _, ValueTuple`2 t) in C:\github\efcore\src\EFCore\ChangeTracking\Internal\StateManager.cs:line 1367
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) in C:\github\efcore\src\EFCore.SqlServer\Storage\Internal\SqlServerExecutionStrategy.cs:line 57
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess) in C:\github\efcore\src\EFCore\ChangeTracking\Internal\StateManager.cs:line 1363
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess) in C:\github\efcore\src\EFCore\DbContext.cs:line 628
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges() in C:\github\efcore\src\EFCore\DbContext.cs:line 579
   at Microsoft.EntityFrameworkCore.Update.MismatchedKeyTypesSqlServerTest.Can_update_and_delete_with_tinyint_FK_and_smallint_PK() in C:\github\efcore\test\EFCore.SqlServer.FunctionalTests\Update\MismatchedKeyTypesSqlServerTest.cs:line 115
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)

ajcvickers avatar Feb 07 '23 12:02 ajcvickers

@roji Just FYI, I now see this maybe 50% of the time when running the tests on my machine.

ajcvickers avatar Jan 10 '24 15:01 ajcvickers

I saw it too recently... At least in principle it may make it easier to debug :) But I don't see myself getting around to diving into this any time soon, unless you think it's important etc.

roji avatar Jan 10 '24 15:01 roji

I don't think it is a priority. But I may look at it again just because I like our tests to be green across the board. :-)

ajcvickers avatar Jan 10 '24 16:01 ajcvickers

Absolutely. Let me know what you find, I may be able to help with some ideas... I still think the most likely culprit is something within SqlClient itself (there have been quite a few Transaction-related bugs there), but it would definitely be good to know for sure.

roji avatar Jan 10 '24 17:01 roji

Is it this fix in 5.1.4? https://github.com/dotnet/SqlClient/blob/main/release-notes/5.1/5.1.4.md

ErikEJ avatar Jan 10 '24 19:01 ErikEJ

@ErikEJ Interesting! We'll see if it goes away once we update.

ajcvickers avatar Jan 10 '24 19:01 ajcvickers

@ErikEJ @roji Just saw this while using 5.1.4. 😠 😄

ajcvickers avatar Jan 17 '24 17:01 ajcvickers

Closing as I have not see the issue in main since this change from January.

ajcvickers avatar Apr 10 '24 11:04 ajcvickers