{"action":"opened","issue":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/1971","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/1971/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/1971/comments","events_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/1971/events","html_url":"https://github.com/aspnet/EntityFramework/issues/1971","id":65781680,"number":1971,"title":"Tests are failing because of timeouts","user":{"login":"victorhurdugaci","id":5921642,"avatar_url":"https://avatars.githubusercontent.com/u/5921642?v=3","gravatar_id":"","url":"https://api.github.com/users/victorhurdugaci","html_url":"https://github.com/victorhurdugaci","followers_url":"https://api.github.com/users/victorhurdugaci/followers","following_url":"https://api.github.com/users/victorhurdugaci/following{/other_user}","gists_url":"https://api.github.com/users/victorhurdugaci/gists{/gist_id}","starred_url":"https://api.github.com/users/victorhurdugaci/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/victorhurdugaci/subscriptions","organizations_url":"https://api.github.com/users/victorhurdugaci/orgs","repos_url":"https://api.github.com/users/victorhurdugaci/repos","events_url":"https://api.github.com/users/victorhurdugaci/events{/privacy}","received_events_url":"https://api.github.com/users/victorhurdugaci/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-04-01T21:22:02Z","updated_at":"2015-04-01T21:22:02Z","closed_at":null,"body":"There are some EF tests that keep timing out on different build agents. It is pretty bad because the entire run of 15K tests is marked as failed because 1-10 EF tests fail.\r\n\r\nHere is an example of a build that has one single EF test failed:\r\nhttps://aspnet-ci.cloudapp.net/viewLog.html?buildId=263&tab=buildResultsDiv&buildTypeId=XPlat_Windows_Win10_Universe\r\n\r\n```\r\nBuiltInDataTypesSqlServerTest.Can_insert_and_read_back_all_nullable_data_types_with_values_set_to_non_null\r\n\r\nSystem.Data.SqlClient.SqlException : Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.\r\n ---- System.ComponentModel.Win32Exception : The wait operation timed out\r\n    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)\r\n    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)\r\n    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n    at Microsoft.Data.Entity.Relational.SqlStatementExecutor.<>c__DisplayClass7_0.<ExecuteNonQuery>b__0() in C:\\BuildAgent\\work\\35116a8defcd3a21\\Universe\\EntityFramework\\src\\EntityFramework.Relational\\SqlStatementExecutor.cs:line 125\r\n    at Microsoft.Data.Entity.Relational.SqlStatementExecutor.Execute(IRelationalConnection connection, Func`1 action) in C:\\BuildAgent\\work\\35116a8defcd3a21\\Universe\\EntityFramework\\src\\EntityFramework.Relational\\SqlStatementExecutor.cs:line 168\r\n    at Microsoft.Data.Entity.Relational.SqlStatementExecutor.ExecuteNonQuery(IRelationalConnection connection, DbTransaction transaction, IEnumerable`1 sqlBatches) in C:\\BuildAgent\\work\\35116a8defcd3a21\\Universe\\EntityFramework\\src\\EntityFramework.Relational\\SqlStatementExecutor.cs:line 116\r\n    at Microsoft.Data.Entity.SqlServer.SqlServerDataStoreCreator.Create() in C:\\BuildAgent\\work\\35116a8defcd3a21\\Universe\\EntityFramework\\src\\EntityFramework.SqlServer\\SqlServerDataStoreCreator.cs:line 45\r\n    at Microsoft.Data.Entity.Relational.Migrations.Migrator.Execute(IEnumerable`1 sqlBatches, Boolean ensureDatabase) in C:\\BuildAgent\\work\\35116a8defcd3a21\\Universe\\EntityFramework\\src\\EntityFramework.Relational\\Migrations\\Migrator.cs:line 310\r\n    at Microsoft.Data.Entity.Relational.Migrations.Migrator.ApplyMigrations(String targetMigration) in C:\\BuildAgent\\work\\35116a8defcd3a21\\Universe\\EntityFramework\\src\\EntityFramework.Relational\\Migrations\\Migrator.cs:line 157\r\n    at Microsoft.Data.Entity.Relational.RelationalDatabase.ApplyMigrations() in C:\\BuildAgent\\work\\35116a8defcd3a21\\Universe\\EntityFramework\\src\\EntityFramework.Relational\\RelationalDatabase.cs:line 35\r\n    at Microsoft.Data.Entity.SqlServer.FunctionalTests.SqlServerMigrationsTest.<Empty_Migration_Creates_Database>d__0.MoveNext() in C:\\BuildAgent\\work\\35116a8defcd3a21\\Universe\\EntityFramework\\test\\EntityFramework.SqlServer.FunctionalTests\\SqlServerMigrationsTest.cs:line 26\r\n --- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n    at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n --- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n --- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n ----- Inner Stack Trace -----\r\n```\r\n\r\nI talked to @bricelam and he suggested making the connection string configurable so we can use SQL express instead. In the end, any solution that unblocks the CI works.\r\n\r\ncc @divega "}}