Error during installation
The database failed to upgrade. ERROR: The database configuration failed with the following message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. Please check log file for additional information (can be found in '/App_Data/Logs/')
Did you try increasing the remote query timeout of the db in management studio? I've had this issue before with other upgrades. just want to make sure to put it back to something reasonable when you're done
I tried and passed the above error and now i am getting following error
Error during installation
The database failed to upgrade. ERROR: The database configuration failed with the following message: Invalid column name 'versionId'. Please check log file for additional information (can be found in '/App_Data/Logs/')
See the log for full details (logs can typically be found in the App_Data\Logs folder).
Do you have a backup of your'e old Database? I think this issue is occuring because it started the migration but didn't finish because of the time out.
hi Joep ,
I tried with copy of my DB , still I am getting following error
The database failed to upgrade. ERROR: The database configuration failed with the following message: Invalid column name 'versionId'. Please check log file for additional information (can be found in '/App_Data/Logs/')
How is it going? Does the log state the same error or does it have any further info?
Did you try to upgrade your Umbraco install to 7.15 and check for no errors? (I know the walk-through mentions 7.14) I have seen many changes since the article was written.
Log for me is giving an error like this. Going from version 7.15.3 to 8.5.3. I've tried using the umbraco pre-migration health check plugin to see if there might be any issues but everything checked out fine. This is the log with the first line of the error and the last normal line before the error. There are a few more lines in the error but it's mostly the same except for a line telling me what was found in the db that isn't in the schema such as UCondition tables and other pieces.
{
"@mt": "SQL [{ContextIndex}]: {Sql}",
"@t": "2020-02-17T15:09:43.2357184Z",
"AppDomainAppId": "LMW3SVC2ROOT",
"AppDomainId": 2,
"ContextIndex": 251,
"HttpRequestId": "6f0e7831-0e59-437c-af1a-5cc96a7c2c55",
"HttpRequestNumber": 7,
"Log4NetLevel": "INFO ",
"MachineName": "U",
"ProcessId": 28004,
"ProcessName": "iisexpress",
"SourceContext": "Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression",
"Sql": "ALTER TABLE [cmsDocument] ADD [edited] BIT NULL ",
"ThreadId": 11
}
"@l": "Error",
"@mt": "Exception ({InstanceId}).",
"@t": "2020-02-17T15:09:43.3955503Z",
"@x": "System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'versionId'.\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& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in C:\\projects\\dotnet\\src\\MiniProfiler.Shared\\Data\\ProfiledDbCommand.cs:line 272\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.<ExecuteNonQuery>b__31_0() in d:\\a\\1\\s\\src\\Umbraco.Core\\Persistence\\FaultHandling\\RetryDbConnection.cs:line 209\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.<>c__DisplayClass33_0`1.<Execute>b__0() in d:\\a\\1\\s\\src\\Umbraco.Core\\Persistence\\FaultHandling\\RetryDbConnection.cs:line 222\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) in d:\\a\\1\\s\\src\\Umbraco.Core\\Persistence\\FaultHandling\\RetryPolicy.cs:line 172\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.Execute[T](Func`1 f) in d:\\a\\1\\s\\src\\Umbraco.Core\\Persistence\\FaultHandling\\RetryDbConnection.cs:line 219\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.ExecuteNonQuery() in d:\\a\\1\\s\\src\\Umbraco.Core\\Persistence\\FaultHandling\\RetryDbConnection.cs:line 209\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.NPoco.IDatabaseHelpers.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\nClientConnectionId:8ef201e0-06c4-4a8c-af94-20a862fa9a50\r\nError Number:207,State:1,Class:16",
"AppDomainAppId": "LMW3SVC2ROOT",
"AppDomainId": 2,
"HttpRequestId": "6f0e7831-0e59-437c-af1a-5cc96a7c2c55",
"HttpRequestNumber": 7,
"InstanceId": "4afac129",
"Log4NetLevel": "ERROR",
"MachineName": "U",
"ProcessId": 28004,
"ProcessName": "iisexpress",
"SourceContext": "Umbraco.Core.Persistence.UmbracoDatabase",
"ThreadId": 11
}
Could you share the whole log file? I think I could cause this error on purpose by modifying the cmsPropertyData table to make the migration process skip some steps, but then the database wouldn't have been working in 7.15.3. Seeing the earlier steps in the log might let me narrow down what's happening.
Here is the file from the import I retired this morning. I've set it to expire in one day on pastebin because it was a long enough log I wanted to not make the thread difficult to read.
How strange, that all looks normal. As far as I can see, the query that's likely to be failing shouldn't be trying to use any versionId columns at all.
If you're able to share your database without revealing anything confidential, I'd be happy to take a closer look. Alternatively, I could give you a version of Umbraco.Core.dll that enables debug logging of database queries, which should show us exactly what the failing query is.
So I did get a much bigger log. Is there something I should look at in there? The obvious new line at the end part is a different stack trace withe the migration part pointing to Umbraco.Core.Migrations.Upgrade.V80_0.VariantsMigration.MigrateVersions()
{
"@l": "Debug",
"@mt": "At:\r\n{StackTrace}",
"@t": "2020-02-26T18:55:29.6665538Z",
"AppDomainAppId": "LMW3SVC2ROOT",
"AppDomainId": 2,
"HttpRequestId": "9f5b6d73-b098-418f-82c4-9dfd57aa45bb",
"HttpRequestNumber": 9,
"Log4NetLevel": "DEBUG",
"MachineName": "U",
"ProcessId": 18852,
"ProcessName": "iisexpress",
"SourceContext": "Umbraco.Core.Persistence.UmbracoDatabase",
"StackTrace": " at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)\r\n at System.Environment.get_StackTrace()\r\n at Umbraco.Core.Persistence.UmbracoDatabase.OnException(Exception ex)\r\n at NPoco.Database.OnExceptionInternal(Exception exception)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at NPoco.Database.Execute(Sql Sql)\r\n at NPoco.Database.Execute(String sql, Object[] args)\r\n at Umbraco.Core.Migrations.Upgrade.V_8_0_0.VariantsMigration.MigrateVersions()\r\n at Umbraco.Core.Migrations.Upgrade.V_8_0_0.VariantsMigration.Migrate()\r\n at Umbraco.Core.Migrations.MigrationBase.Umbraco.Core.Migrations.IMigration.Migrate()\r\n at Umbraco.Core.Migrations.MigrationPlan.Execute(IScope scope, String fromState, IMigrationBuilder migrationBuilder, ILogger logger)\r\n at Umbraco.Core.Migrations.Upgrade.Upgrader.Execute(IScopeProvider scopeProvider, IMigrationBuilder migrationBuilder, IKeyValueService keyValueService, ILogger logger)\r\n at Umbraco.Core.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(MigrationPlan plan)\r\n at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.ExecuteAsync(Object model) in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\InstallSteps\\DatabaseUpgradeStep.cs:line 43\r\n at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.<ExecuteStepAsync>d__14.MoveNext() in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\Controllers\\InstallApiController.cs:line 229\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStepAsync(InstallSetupStep step, JToken instruction)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.<PostPerformInstall>d__11.MoveNext() in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\Controllers\\InstallApiController.cs:line 99\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)\r\n at lambda_method(Closure , Object , Object[] )\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_3.<GetExecutor>b__3(Object instance, Object[] methodParameters)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.InvokeActionAsyncCore(HttpActionContext actionContext, CancellationToken cancellationToken)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.InvokeActionAsync(HttpActionContext actionContext, CancellationToken cancellationToken)\r\n at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.Controllers.ActionFilterResult.ExecuteAsync(CancellationToken cancellationToken)\r\n at System.Web.Http.Controllers.AuthorizationFilterResult.<>c__DisplayClass4_0.<ExecuteAsync>b__0()\r\n at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__3.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.Filters.AuthorizationFilterAttribute.ExecuteAuthorizationFilterAsyncCore(HttpActionContext actionContext, CancellationToken cancellationToken, Func`1 continuation)\r\n at System.Web.Http.Filters.AuthorizationFilterAttribute.System.Web.Http.Filters.IAuthorizationFilter.ExecuteAuthorizationFilterAsync(HttpActionContext actionContext, CancellationToken cancellationToken, Func`1 continuation)\r\n at System.Web.Http.Controllers.AuthorizationFilterResult.<>c__DisplayClass4_1.<ExecuteAsync>b__2()\r\n at System.Web.Http.Controllers.AuthorizationFilterResult.ExecuteAsync(CancellationToken cancellationToken)\r\n at System.Web.Http.ApiController.ExecuteAsync(HttpControllerContext controllerContext, CancellationToken cancellationToken)\r\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__15.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Net.Http.HttpMessageInvoker.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Web.Http.Dispatcher.HttpRoutingDispatcher.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Net.Http.DelegatingHandler.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Web.Http.HttpServer.<SendAsync>d__24.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.HttpServer.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Net.Http.HttpMessageInvoker.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Web.Http.WebHost.HttpControllerHandler.<ProcessRequestAsyncCore>d__12.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.WebHost.HttpControllerHandler.ProcessRequestAsyncCore(HttpContextBase contextBase)\r\n at System.Web.Http.WebHost.HttpControllerHandler.ProcessRequestAsync(HttpContext context)\r\n at System.Web.HttpTaskAsyncHandler.<>c__DisplayClass4_0.<System.Web.IHttpAsyncHandler.BeginProcessRequest>b__0()\r\n at System.Web.TaskAsyncHelper.BeginTask(Func`1 taskFunc, AsyncCallback callback, Object state)\r\n at System.Web.HttpTaskAsyncHandler.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)\r\n at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()\r\n at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)\r\n at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)\r\n at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)\r\n at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)\r\n at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)\r\n at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)\r\n at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)",
"ThreadId": 12
}
{"@t":"2020-02-26T18:55:28.6999888Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: DELETE FROM cmsDocument\r\nWHERE versionId NOT IN (SELECT (versionId) FROM cmsContentVersion WHERE [current] = 1) AND (published<>1 OR newest<>1)\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:28.7775060Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":250,"Sql":"ALTER TABLE [cmsDocument] DROP COLUMN [text];","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteColumnExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:28.7775060Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] DROP COLUMN [text];\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:28.8215034Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":251,"Sql":"ALTER TABLE [cmsDocument] DROP COLUMN [templateId];","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteColumnExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:28.8215034Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] DROP COLUMN [templateId];\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:28.8665040Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":252,"Sql":"ALTER TABLE [cmsDocument] DROP COLUMN [documentUser];","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteColumnExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:28.8665040Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] DROP COLUMN [documentUser];\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:28.9420324Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: select con.[name] as [constraintName]\r\nfrom sys.default_constraints con\r\njoin sys.columns col on con.object_id=col.default_object_id\r\njoin sys.tables tbl on col.object_id=tbl.object_id\r\nwhere tbl.[name]=@0 and col.[name]=@1;\r\n -- @0:cmsDocument @1:updateDate\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.0290333Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":253,"Sql":"ALTER TABLE [cmsDocument] DROP CONSTRAINT [DF_cmsDocument_updateDate]","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteDefaultConstraintExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.0290333Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] DROP CONSTRAINT [DF_cmsDocument_updateDate]\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.0720344Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":254,"Sql":"ALTER TABLE [cmsDocument] DROP COLUMN [updateDate];","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteColumnExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.0720344Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] DROP COLUMN [updateDate];\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.1160343Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":255,"Sql":"ALTER TABLE [cmsDocument] DROP COLUMN [versionId];","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteColumnExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.1160343Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] DROP COLUMN [versionId];\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.1620449Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: select con.[name] as [constraintName]\r\nfrom sys.default_constraints con\r\njoin sys.columns col on con.object_id=col.default_object_id\r\njoin sys.tables tbl on col.object_id=tbl.object_id\r\nwhere tbl.[name]=@0 and col.[name]=@1;\r\n -- @0:cmsDocument @1:newest\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.2060337Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":256,"Sql":"ALTER TABLE [cmsDocument] DROP CONSTRAINT [DF_cmsDocument_newest]","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteDefaultConstraintExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.2060337Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] DROP CONSTRAINT [DF_cmsDocument_newest]\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.2520330Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":257,"Sql":"ALTER TABLE [cmsDocument] DROP COLUMN [newest];","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteColumnExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.2520330Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] DROP COLUMN [newest];\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.2955529Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: SELECT TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION, COLUMN_DEFAULT, IS_NULLABLE, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = (SELECT SCHEMA_NAME())\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.3655516Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: SELECT TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION, COLUMN_DEFAULT, IS_NULLABLE, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = (SELECT SCHEMA_NAME())\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.4305570Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":258,"Sql":"ALTER TABLE [cmsDocument] ADD [edited] BIT NULL ","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.4305570Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] ADD [edited] BIT NULL \r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.4725581Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: UPDATE [cmsDocument] SET edited=0\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.6535513Z","@mt":"Exception ({InstanceId}).","@l":"Error","@x":"System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'versionId'.\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& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in C:\\projects\\dotnet\\src\\MiniProfiler.Shared\\Data\\ProfiledDbCommand.cs:line 272\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.<ExecuteNonQuery>b__31_0()\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.<>c__DisplayClass33_0`1.<Execute>b__0()\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.Execute[T](Func`1 f)\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.ExecuteNonQuery()\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.NPoco.IDatabaseHelpers.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\nClientConnectionId:06d53222-0b33-4b8a-9307-4198561737b9\r\nError Number:207,State:1,Class:16","InstanceId":"fbd2b8bb:170","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"ERROR","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.6665538Z","@mt":"At:\r\n{StackTrace}","@l":"Debug","StackTrace":" at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)\r\n at System.Environment.get_StackTrace()\r\n at Umbraco.Core.Persistence.UmbracoDatabase.OnException(Exception ex)\r\n at NPoco.Database.OnExceptionInternal(Exception exception)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at NPoco.Database.Execute(Sql Sql)\r\n at NPoco.Database.Execute(String sql, Object[] args)\r\n at Umbraco.Core.Migrations.Upgrade.V_8_0_0.VariantsMigration.MigrateVersions()\r\n at Umbraco.Core.Migrations.Upgrade.V_8_0_0.VariantsMigration.Migrate()\r\n at Umbraco.Core.Migrations.MigrationBase.Umbraco.Core.Migrations.IMigration.Migrate()\r\n at Umbraco.Core.Migrations.MigrationPlan.Execute(IScope scope, String fromState, IMigrationBuilder migrationBuilder, ILogger logger)\r\n at Umbraco.Core.Migrations.Upgrade.Upgrader.Execute(IScopeProvider scopeProvider, IMigrationBuilder migrationBuilder, IKeyValueService keyValueService, ILogger logger)\r\n at Umbraco.Core.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(MigrationPlan plan)\r\n at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.ExecuteAsync(Object model) in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\InstallSteps\\DatabaseUpgradeStep.cs:line 43\r\n at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.<ExecuteStepAsync>d__14.MoveNext() in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\Controllers\\InstallApiController.cs:line 229\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStepAsync(InstallSetupStep step, JToken instruction)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.<PostPerformInstall>d__11.MoveNext() in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\Controllers\\InstallApiController.cs:line 99\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)\r\n at lambda_method(Closure , Object , Object[] )\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_3.<GetExecutor>b__3(Object instance, Object[] methodParameters)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.InvokeActionAsyncCore(HttpActionContext actionContext, CancellationToken cancellationToken)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.InvokeActionAsync(HttpActionContext actionContext, CancellationToken cancellationToken)\r\n at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.Controllers.ActionFilterResult.ExecuteAsync(CancellationToken cancellationToken)\r\n at System.Web.Http.Controllers.AuthorizationFilterResult.<>c__DisplayClass4_0.<ExecuteAsync>b__0()\r\n at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__3.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.Filters.AuthorizationFilterAttribute.ExecuteAuthorizationFilterAsyncCore(HttpActionContext actionContext, CancellationToken cancellationToken, Func`1 continuation)\r\n at System.Web.Http.Filters.AuthorizationFilterAttribute.System.Web.Http.Filters.IAuthorizationFilter.ExecuteAuthorizationFilterAsync(HttpActionContext actionContext, CancellationToken cancellationToken, Func`1 continuation)\r\n at System.Web.Http.Controllers.AuthorizationFilterResult.<>c__DisplayClass4_1.<ExecuteAsync>b__2()\r\n at System.Web.Http.Controllers.AuthorizationFilterResult.ExecuteAsync(CancellationToken cancellationToken)\r\n at System.Web.Http.ApiController.ExecuteAsync(HttpControllerContext controllerContext, CancellationToken cancellationToken)\r\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__15.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Net.Http.HttpMessageInvoker.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Web.Http.Dispatcher.HttpRoutingDispatcher.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Net.Http.DelegatingHandler.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Web.Http.HttpServer.<SendAsync>d__24.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.HttpServer.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Net.Http.HttpMessageInvoker.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Web.Http.WebHost.HttpControllerHandler.<ProcessRequestAsyncCore>d__12.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.WebHost.HttpControllerHandler.ProcessRequestAsyncCore(HttpContextBase contextBase)\r\n at System.Web.Http.WebHost.HttpControllerHandler.ProcessRequestAsync(HttpContext context)\r\n at System.Web.HttpTaskAsyncHandler.<>c__DisplayClass4_0.<System.Web.IHttpAsyncHandler.BeginProcessRequest>b__0()\r\n at System.Web.TaskAsyncHelper.BeginTask(Func`1 taskFunc, AsyncCallback callback, Object state)\r\n at System.Web.HttpTaskAsyncHandler.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)\r\n at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()\r\n at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)\r\n at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)\r\n at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)\r\n at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)\r\n at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)\r\n at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)\r\n at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.6705499Z","@mt":"Database configuration failed","@l":"Error","@x":"System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'versionId'.\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& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in C:\\projects\\dotnet\\src\\MiniProfiler.Shared\\Data\\ProfiledDbCommand.cs:line 272\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.<ExecuteNonQuery>b__31_0()\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.<>c__DisplayClass33_0`1.<Execute>b__0()\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.Execute[T](Func`1 f)\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.ExecuteNonQuery()\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.NPoco.IDatabaseHelpers.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at NPoco.Database.Execute(Sql Sql)\r\n at NPoco.Database.Execute(String sql, Object[] args)\r\n at Umbraco.Core.Migrations.Upgrade.V_8_0_0.VariantsMigration.MigrateVersions()\r\n at Umbraco.Core.Migrations.Upgrade.V_8_0_0.VariantsMigration.Migrate()\r\n at Umbraco.Core.Migrations.MigrationBase.Umbraco.Core.Migrations.IMigration.Migrate()\r\n at Umbraco.Core.Migrations.MigrationPlan.Execute(IScope scope, String fromState, IMigrationBuilder migrationBuilder, ILogger logger)\r\n at Umbraco.Core.Migrations.Upgrade.Upgrader.Execute(IScopeProvider scopeProvider, IMigrationBuilder migrationBuilder, IKeyValueService keyValueService, ILogger logger)\r\n at Umbraco.Core.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(MigrationPlan plan)\r\nClientConnectionId:06d53222-0b33-4b8a-9307-4198561737b9\r\nError Number:207,State:1,Class:16","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"ERROR","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.6755556Z","@mt":"The database schema validation produced the following summary: {DbSchemaSummary}","DbSchemaSummary":"The following tables were found in the database, but are not in the current schema:\r\nGlobalConditions,RegisteredPredicates,UFRecords,UFRecordFields,UFRecordDataString,UFRecordDataLongString,UFRecordDataInteger,UFRecordDataBit,cmsContentXml,UFRecordDataDateTime,cmsPreviewXml,UFUserSecurity,UFUserFormSecurity,cmsPropertyData,uSyncSnapshotAudit,UCUserSettings,WorkflowSettings,WorkflowUserGroups,WorkflowUser2UserGroup,cmsTaskType,WorkflowUserGroupPermissions,cmsTask,WorkflowInstance,WorkflowTaskInstance,cmsContent,cmsContentVersion,cmsDocument,cmsMedia,cmsDataType,umbracoMigration,cmsDataTypePreValues,umbracoDomains,umbracoContent,umbracoContentVersion,umbracoMediaVersion,umbracoDocument,umbracoDataType,umbracoDomain,umbracoPropertyData,cmsContentNu,umbracoDocumentVersion,umbracoKeyValue,umbracoContentVersionCultureVariation,umbracoDocumentCultureVariation,umbracoContentSchedule\r\n \r\nThe following columns were found in the database, but are not in the current schema:\r\nUFRecords,CurrentPage,UFRecords,Form,UFRecords,UniqueId,UFRecordFields,Key,UFRecordFields,FieldId,UFRecordDataString,Key,UFRecordDataLongString,Key,UFRecordDataInteger,Key,UFRecordDataBit,Key,cmsPreviewXml,versionId,UFRecordDataDateTime,Key,UFUserFormSecurity,Form,cmsPropertyData,versionId,WorkflowInstance,Guid,WorkflowTaskInstance,WorkflowInstanceGuid,cmsContentVersion,VersionId,cmsDocument,versionId,cmsMedia,versionId,umbracoDomains,id,umbracoDomains,domainDefaultLanguage,umbracoDomains,domainRootStructureID,umbracoMigration,id,cmsDataTypePreValues,id,cmsDataTypePreValues,datatypeNodeId,cmsDataTypePreValues,sortorder,cmsDataType,pk,cmsDataType,nodeId,cmsDocument,templateId,cmsMedia,nodeId,cmsDocument,documentUser,cmsDocument,nodeId,cmsContentVersion,id,cmsContentVersion,ContentId,WorkflowTaskInstance,ActionedByUserId,cmsContent,pk,cmsContent,nodeId,cmsContent,contentType,WorkflowTaskInstance,GroupId,WorkflowTaskInstance,Id,WorkflowTaskInstance,Type,WorkflowTaskInstance,ApprovalStep,WorkflowTaskInstance,Status,cmsTask,id,cmsTask,taskTypeId,cmsTask,nodeId,cmsTask,parentUserId,cmsTask,userId,WorkflowInstance,Id,WorkflowInstance,NodeId,WorkflowInstance,Type,WorkflowInstance,TotalSteps,WorkflowInstance,AuthorUserId,WorkflowInstance,Status,WorkflowUser2UserGroup,Id,WorkflowUser2UserGroup,UserId,WorkflowUser2UserGroup,GroupId,cmsTaskType,id,WorkflowUserGroupPermissions,Id,WorkflowUserGroupPermissions,GroupId,WorkflowUserGroupPermissions,NodeId,WorkflowUserGroupPermissions,ContentTypeId,WorkflowUserGroupPermissions,Permission,WorkflowSettings,Id,WorkflowSettings,FlowType,WorkflowUserGroups,GroupId,cmsTags,ParentId,cmsPropertyData,id,cmsPropertyData,contentNodeId,uSyncSnapshotAudit,id,cmsPropertyData,propertytypeid,cmsPropertyData,dataInt,cmsPreviewXml,nodeId,UFUserFormSecurity,Id,UFUserFormSecurity,SecurityType,UFRecordDataInteger,Value,UFRecordDataBit,Id,cmsContentXml,nodeId,UFRecordDataLongString,Id,UFRecordDataDateTime,Id,UFRecordDataInteger,Id,UFRecordDataString,Id,UFRecordFields,Record,UFRecords,UmbracoPageId,RegisteredPredicates,Id,UFRecords,Id,GlobalConditions,Id,GlobalConditions,Created,GlobalConditions,LastUpdated,UFRecords,Created,UFRecords,Updated,cmsPreviewXml,timestamp,UFRecordDataDateTime,Value,uSyncSnapshotAudit,Applied,cmsPropertyData,dataDate,WorkflowInstance,CreatedDate,WorkflowInstance,CompletedDate,cmsTask,DateTime,WorkflowTaskInstance,CompletedDate,WorkflowTaskInstance,CreatedDate,cmsContentVersion,VersionDate,cmsDocument,releaseDate,cmsDocument,expireDate,cmsDocument,updateDate,umbracoMigration,createDate,cmsDataTypePreValues,value,cmsTemplate,design,cmsPropertyData,dataNtext,cmsPreviewXml,xml,cmsContentXml,xml,UFRecords,RecordData,UFRecordDataLongString,Value,GlobalConditions,Data,UFRecordDataBit,Value,UFUserSecurity,ManageDataSources,UFUserSecurity,ManagePreValueSources,UFUserSecurity,ManageWorkflows,UFUserSecurity,ManageForms,uSyncSnapshotAudit,IsLocal,UFUserFormSecurity,HasAccess,UFUserFormSecurity,AllowInEditor,WorkflowSettings,LockIfActive,WorkflowUserGroups,Deleted,WorkflowUserGroups,OfflineApproval,WorkflowSettings,SendNotifications,cmsTask,closed,cmsDocument,published,WorkflowTaskInstance,ActionedByAdmin,cmsDocument,newest,cmsPropertyData,dataDecimal,uSyncSnapshotAudit,Name,cmsPropertyData,dataNvarchar,UFUserFormSecurity,User,UCUserSettings,User,UCUserSettings,Key,UCUserSettings,Value,UFUserSecurity,User,UFRecordDataString,Value,UFRecordFields,Alias,UFRecordFields,DataType,RegisteredPredicates,Alias,UFRecords,State,UFRecords,IP,UFRecords,MemberKey,GlobalConditions,Guid,GlobalConditions,Name,cmsMedia,mediaPath,cmsDocument,text,cmsTask,Comment,WorkflowTaskInstance,Comment,WorkflowSettings,ExcludeNodes,WorkflowSettings,DefaultApprover,WorkflowSettings,Email,WorkflowSettings,EditUrl,WorkflowSettings,SiteUrl,WorkflowUserGroups,Description,WorkflowUserGroups,Name,WorkflowUserGroups,Alias,WorkflowUserGroups,GroupEmail,WorkflowInstance,AuthorComment,WorkflowUserGroupPermissions,Condition,cmsTaskType,alias,cmsMacro,macroPython,cmsMacro,macroScriptType,cmsMacro,macroScriptAssembly,cmsMacro,macroXSLT,umbracoDomains,domainName,cmsDataType,propertyEditorAlias,cmsDataType,dbType,cmsDataTypePreValues,alias,umbracoMigration,version,umbracoMigration,name,cmsContentType,isElement,cmsContentType,variations,umbracoContent,nodeId,umbracoContent,contentTypeId,umbracoContentVersion,id,umbracoContentVersion,nodeId,umbracoContentVersion,versionDate,umbracoContentVersion,userId,umbracoContentVersion,current,umbracoContentVersion,text,umbracoMediaVersion,id,umbracoMediaVersion,path,umbracoDocument,nodeId,umbracoDocument,published,umbracoDocument,edited,umbracoDataType,nodeId,umbracoDataType,propertyEditorAlias,umbracoDataType,dbType,umbracoDataType,config,umbracoLanguage,isDefaultVariantLang,umbracoLanguage,mandatory,umbracoLanguage,fallbackLanguageId,umbracoDomain,id,umbracoDomain,domainDefaultLanguage,umbracoDomain,domainRootStructureID,umbracoDomain,domainName,umbracoLog,entityType,umbracoLog,parameters,cmsMacro,macroSource,cmsMacro,macroType,cmsPropertyType,variations,umbracoPropertyData,id,umbracoPropertyData,versionId,umbracoPropertyData,propertyTypeId,umbracoPropertyData,languageId,umbracoPropertyData,segment,umbracoPropertyData,intValue,umbracoPropertyData,decimalValue,umbracoPropertyData,dateValue,umbracoPropertyData,varcharValue,umbracoPropertyData,textValue,cmsTags,languageId,umbracoRedirectUrl,culture,cmsContentNu,nodeId,cmsContentNu,published,cmsContentNu,data,cmsContentNu,rv,umbracoDocumentVersion,id,umbracoDocumentVersion,templateId,umbracoDocumentVersion,published,umbracoKeyValue,key,umbracoKeyValue,value,umbracoKeyValue,updated,umbracoContentVersionCultureVariation,id,umbracoContentVersionCultureVariation,versionId,umbracoContentVersionCultureVariation,languageId,umbracoContentVersionCultureVariation,name,umbracoContentVersionCultureVariation,date,umbracoContentVersionCultureVariation,availableUserId,umbracoDocumentCultureVariation,id,umbracoDocumentCultureVariation,nodeId,umbracoDocumentCultureVariation,languageId,umbracoDocumentCultureVariation,edited,umbracoDocumentCultureVariation,available,umbracoDocumentCultureVariation,published,umbracoDocumentCultureVariation,name,umbracoContentSchedule,id,umbracoContentSchedule,nodeId,umbracoContentSchedule,languageId,umbracoContentSchedule,date,umbracoContentSchedule,action\r\n \r\nThe following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:\r\nFK_cmsContent_cmsContentType_nodeId,FK_cmsContent_umbracoNode_id,FK_cmsContentVersion_cmsContent_nodeId,FK_cmsContentXml_cmsContent_nodeId,FK_cmsDataType_umbracoNode_id,FK_cmsDataTypePreValues_cmsDataType_nodeId,FK_cmsDocument_cmsContent_nodeId,FK_cmsDocument_cmsTemplate_nodeId,FK_cmsDocument_umbracoNode_id,FK_cmsMedia_cmsContent_nodeId,FK_cmsMedia_umbracoNode_id,FK_cmsMember_cmsContent_nodeId,FK_cmsMember_umbracoNode_id,FK_cmsPreviewXml_cmsContent_nodeId,FK_cmsPreviewXml_cmsContentVersion_VersionId,FK_cmsPropertyData_cmsPropertyType_id,FK_cmsPropertyData_umbracoNode_id,FK_cmsPropertyType_cmsDataType_nodeId,FK_cmsTags_cmsTags,FK_cmsTask_cmsTaskType_id,FK_cmsTask_umbracoNode_id,FK_cmsTask_umbracoUser,FK_cmsTask_umbracoUser1,FK_UFRecordDataBit_UFRecordFields_Key,FK_UFRecordDataDateTime_UFRecordFields_Key,FK_UFRecordDataInteger_UFRecordFields_Key,FK_UFRecordDataLongString_UFRecordFields_Key,FK_UFRecordDataString_UFRecordFields_Key,FK_umbracoDomains_umbracoNode_id,FK_umbracoNode_umbracoUser_id,FK_umbracoContent_umbracoNode_id,FK_umbracoContent_cmsContentType_NodeId,FK_umbracoContentVersion_umbracoContent_nodeId,FK_umbracoContentVersion_umbracoUser_id,FK_umbracoMediaVersion_umbracoContentVersion_id,FK_umbracoDocument_umbracoContent_nodeId,FK_umbracoDataType_umbracoNode_id,FK_umbracoLanguage_umbracoLanguage_id,FK_umbracoDomain_umbracoNode_id,FK_umbracoLog_umbracoUser_id,FK_cmsMember_umbracoContent_nodeId,FK_cmsPropertyType_umbracoDataType_nodeId,FK_umbracoPropertyData_umbracoContentVersion_id,FK_umbracoPropertyData_cmsPropertyType_id,FK_umbracoPropertyData_umbracoLanguage_id,FK_cmsTags_umbracoLanguage_id,FK_cmsContentNu_umbracoContent_nodeId,FK_umbracoDocumentVersion_umbracoContentVersion_id,FK_umbracoDocumentVersion_cmsTemplate_nodeId,FK_umbracoContentVersionCultureVariation_umbracoContentVersion_id,FK_umbracoContentVersionCultureVariation_umbracoLanguage_id,FK_umbracoContentVersionCultureVariation_umbracoUser_id,FK_umbracoDocumentCultureVariation_umbracoNode_id,FK_umbracoDocumentCultureVariation_umbracoLanguage_id,FK_umbracoContentSchedule_umbracoContent_nodeId,FK_umbracoContentSchedule_umbracoLanguage_id,PK_cmsContent,PK_cmsContentPreviewXml,PK_cmsContentVersion,PK_cmsContentXml,PK_cmsDataType,PK_cmsDataTypePreValues,PK_cmsDocument,PK_cmsMedia,PK_cmsPropertyData,PK_cmsTask,PK_cmsTaskType,PK_GlobalConditions,PK_RegisteredPredicates,PK_structure,PK_UCUserSettings,PK_UFRecordDataBit,PK_UFRecordDataDateTime,PK_UFRecordDataInteger,PK_UFRecordDataLongString,PK_UFRecordDataString,PK_UFRecordFields,PK_UFRecords,PK_umbracoDomains,PK_umbracoMigration,PK_uSyncSnapshotAudit,PK_WorkflowInstance,PK_WorkflowSettings,PK_WorkflowTaskInstance,PK_WorkflowUser2UserGroup,PK_WorkflowUserGroupPermissions,PK_WorkflowUserGroups,PK_umbracoNode,PK_umbracoContent,PK_umbracoContentVersion,PK_umbracoMediaVersion,PK_umbracoDocument,PK_umbracoDataType,PK_umbracoDomain,PK_umbracoPropertyData,PK_cmsContentNu,PK_umbracoDocumentVersion,PK_umbracoKeyValue,PK_umbracoContentVersionCultureVariation,PK_umbracoDocumentCultureVariation,PK_umbracoContentSchedule\r\n \r\nThe following indexes were found in the database, but are not in the current schema:\r\nIX_cmsContent,IX_cmsContentVersion_ContentId,IX_cmsContentVersion_VersionId,IX_cmsDataType_nodeId,IX_cmsDocument,IX_cmsDocument_newest,IX_cmsDocument_published,nci_wi_cmsDocument_7D825293816C2352E9FF93126D5E86EF,nci_wi_cmsDocument_C34F9FD3998E2BD0686747434D36A952,IX_cmsMedia,IX_cmsPropertyData_1,IX_cmsPropertyData_2,IX_cmsPropertyData_3,IX_cmsTaskType_alias,IX_databit_recordfield,IX_datadatetime_recordfield,IX_datainteger_recordfield,IX_datalongstring_recordfield,IX_datastring_recordfield,IX_umbracoMigration,IX_umbracoNodeObjectType,IX_umbracoNodeParentId,IX_umbracoNodePath,IX_umbracoNodeTrashed,IX_umbracoNodeUniqueID,IX_umbracoNode_UniqueId,IX_umbracoNode_ParentId,IX_umbracoNode_Path,IX_umbracoNode_Trashed,IX_umbracoNode_ObjectType,IX_umbracoMediaVersion,IX_umbracoDocument_Published,IX_umbracoLanguage_fallbackLanguageId,IX_umbracoPropertyData_VersionId,IX_umbracoPropertyData_PropertyTypeId,IX_umbracoPropertyData_LanguageId,IX_umbracoPropertyData_Segment,IX_cmsTags_LanguageId,IX_umbracoUserLogin_lastValidatedUtc,IX_umbracoContentVersionCultureVariation_VersionId,IX_umbracoContentVersionCultureVariation_LanguageId,IX_umbracoDocumentCultureVariation_NodeId,IX_umbracoDocumentCultureVariation_LanguageId\r\n \r\nThe following unknown constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:\r\nId\r\n \r\n","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.6775539Z","@mt":"Installation step {Step} failed.","@l":"Error","@x":"System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Invalid column name 'versionId'.\n Please check log file for additional information (can be found in '/App_Data/Logs/')\r\n at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.ExecuteAsync(Object model) in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\InstallSteps\\DatabaseUpgradeStep.cs:line 47\r\n --- End of inner exception stack trace ---\r\n at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.<ExecuteStepAsync>d__14.MoveNext() in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\Controllers\\InstallApiController.cs:line 236\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 at Umbraco.Web.Install.Controllers.InstallApiController.<PostPerformInstall>d__11.MoveNext() in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\Controllers\\InstallApiController.cs:line 104","Step":"DatabaseUpgrade","SourceContext":"Umbraco.Web.Install.Controllers.InstallApiController","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"ERROR","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.6785551Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Step completed","Duration":521760,"TimingId":"3953d93","SourceContext":"Umbraco.Web.Install.Controllers.InstallApiController","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.6785551Z","@mt":"An error occurred during installation step {Step}","@l":"Error","@x":"System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Invalid column name 'versionId'.\n Please check log file for additional information (can be found in '/App_Data/Logs/')\r\n at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.ExecuteAsync(Object model) in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\InstallSteps\\DatabaseUpgradeStep.cs:line 47\r\n --- End of inner exception stack trace ---\r\n at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.<ExecuteStepAsync>d__14.MoveNext() in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\Controllers\\InstallApiController.cs:line 236\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 at Umbraco.Web.Install.Controllers.InstallApiController.<PostPerformInstall>d__11.MoveNext() in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\Controllers\\InstallApiController.cs:line 104","Step":"DatabaseUpgrade","SourceContext":"Umbraco.Web.Install.Controllers.InstallApiController","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"ERROR","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:28.6999888Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: DELETE FROM cmsDocument\r\nWHERE versionId NOT IN (SELECT (versionId) FROM cmsContentVersion WHERE [current] = 1) AND (published<>1 OR newest<>1)\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:28.7775060Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":250,"Sql":"ALTER TABLE [cmsDocument] DROP COLUMN [text];","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteColumnExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:28.7775060Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] DROP COLUMN [text];\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:28.8215034Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":251,"Sql":"ALTER TABLE [cmsDocument] DROP COLUMN [templateId];","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteColumnExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:28.8215034Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] DROP COLUMN [templateId];\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:28.8665040Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":252,"Sql":"ALTER TABLE [cmsDocument] DROP COLUMN [documentUser];","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteColumnExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:28.8665040Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] DROP COLUMN [documentUser];\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:28.9420324Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: select con.[name] as [constraintName]\r\nfrom sys.default_constraints con\r\njoin sys.columns col on con.object_id=col.default_object_id\r\njoin sys.tables tbl on col.object_id=tbl.object_id\r\nwhere tbl.[name]=@0 and col.[name]=@1;\r\n -- @0:cmsDocument @1:updateDate\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.0290333Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":253,"Sql":"ALTER TABLE [cmsDocument] DROP CONSTRAINT [DF_cmsDocument_updateDate]","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteDefaultConstraintExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.0290333Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] DROP CONSTRAINT [DF_cmsDocument_updateDate]\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.0720344Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":254,"Sql":"ALTER TABLE [cmsDocument] DROP COLUMN [updateDate];","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteColumnExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.0720344Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] DROP COLUMN [updateDate];\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.1160343Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":255,"Sql":"ALTER TABLE [cmsDocument] DROP COLUMN [versionId];","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteColumnExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.1160343Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] DROP COLUMN [versionId];\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.1620449Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: select con.[name] as [constraintName]\r\nfrom sys.default_constraints con\r\njoin sys.columns col on con.object_id=col.default_object_id\r\njoin sys.tables tbl on col.object_id=tbl.object_id\r\nwhere tbl.[name]=@0 and col.[name]=@1;\r\n -- @0:cmsDocument @1:newest\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.2060337Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":256,"Sql":"ALTER TABLE [cmsDocument] DROP CONSTRAINT [DF_cmsDocument_newest]","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteDefaultConstraintExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.2060337Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] DROP CONSTRAINT [DF_cmsDocument_newest]\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.2520330Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":257,"Sql":"ALTER TABLE [cmsDocument] DROP COLUMN [newest];","SourceContext":"Umbraco.Core.Migrations.Expressions.Delete.Expressions.DeleteColumnExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.2520330Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] DROP COLUMN [newest];\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.2955529Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: SELECT TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION, COLUMN_DEFAULT, IS_NULLABLE, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = (SELECT SCHEMA_NAME())\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.3655516Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: SELECT TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION, COLUMN_DEFAULT, IS_NULLABLE, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = (SELECT SCHEMA_NAME())\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.4305570Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":258,"Sql":"ALTER TABLE [cmsDocument] ADD [edited] BIT NULL ","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.4305570Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: ALTER TABLE [cmsDocument] ADD [edited] BIT NULL \r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.4725581Z","@mt":"SQL Trace:\r\n{Sql}","@l":"Debug","Sql":"fbd2b8bb:170: UPDATE [cmsDocument] SET edited=0\r\n","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.6535513Z","@mt":"Exception ({InstanceId}).","@l":"Error","@x":"System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'versionId'.\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& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in C:\\projects\\dotnet\\src\\MiniProfiler.Shared\\Data\\ProfiledDbCommand.cs:line 272\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.<ExecuteNonQuery>b__31_0()\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.<>c__DisplayClass33_0`1.<Execute>b__0()\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.Execute[T](Func`1 f)\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.ExecuteNonQuery()\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.NPoco.IDatabaseHelpers.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\nClientConnectionId:06d53222-0b33-4b8a-9307-4198561737b9\r\nError Number:207,State:1,Class:16","InstanceId":"fbd2b8bb:170","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"ERROR","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.6665538Z","@mt":"At:\r\n{StackTrace}","@l":"Debug","StackTrace":" at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)\r\n at System.Environment.get_StackTrace()\r\n at Umbraco.Core.Persistence.UmbracoDatabase.OnException(Exception ex)\r\n at NPoco.Database.OnExceptionInternal(Exception exception)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at NPoco.Database.Execute(Sql Sql)\r\n at NPoco.Database.Execute(String sql, Object[] args)\r\n at Umbraco.Core.Migrations.Upgrade.V_8_0_0.VariantsMigration.MigrateVersions()\r\n at Umbraco.Core.Migrations.Upgrade.V_8_0_0.VariantsMigration.Migrate()\r\n at Umbraco.Core.Migrations.MigrationBase.Umbraco.Core.Migrations.IMigration.Migrate()\r\n at Umbraco.Core.Migrations.MigrationPlan.Execute(IScope scope, String fromState, IMigrationBuilder migrationBuilder, ILogger logger)\r\n at Umbraco.Core.Migrations.Upgrade.Upgrader.Execute(IScopeProvider scopeProvider, IMigrationBuilder migrationBuilder, IKeyValueService keyValueService, ILogger logger)\r\n at Umbraco.Core.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(MigrationPlan plan)\r\n at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.ExecuteAsync(Object model) in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\InstallSteps\\DatabaseUpgradeStep.cs:line 43\r\n at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.<ExecuteStepAsync>d__14.MoveNext() in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\Controllers\\InstallApiController.cs:line 229\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStepAsync(InstallSetupStep step, JToken instruction)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.<PostPerformInstall>d__11.MoveNext() in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\Controllers\\InstallApiController.cs:line 99\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)\r\n at lambda_method(Closure , Object , Object[] )\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_3.<GetExecutor>b__3(Object instance, Object[] methodParameters)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.InvokeActionAsyncCore(HttpActionContext actionContext, CancellationToken cancellationToken)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.InvokeActionAsync(HttpActionContext actionContext, CancellationToken cancellationToken)\r\n at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.Controllers.ActionFilterResult.ExecuteAsync(CancellationToken cancellationToken)\r\n at System.Web.Http.Controllers.AuthorizationFilterResult.<>c__DisplayClass4_0.<ExecuteAsync>b__0()\r\n at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__3.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.Filters.AuthorizationFilterAttribute.ExecuteAuthorizationFilterAsyncCore(HttpActionContext actionContext, CancellationToken cancellationToken, Func`1 continuation)\r\n at System.Web.Http.Filters.AuthorizationFilterAttribute.System.Web.Http.Filters.IAuthorizationFilter.ExecuteAuthorizationFilterAsync(HttpActionContext actionContext, CancellationToken cancellationToken, Func`1 continuation)\r\n at System.Web.Http.Controllers.AuthorizationFilterResult.<>c__DisplayClass4_1.<ExecuteAsync>b__2()\r\n at System.Web.Http.Controllers.AuthorizationFilterResult.ExecuteAsync(CancellationToken cancellationToken)\r\n at System.Web.Http.ApiController.ExecuteAsync(HttpControllerContext controllerContext, CancellationToken cancellationToken)\r\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__15.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Net.Http.HttpMessageInvoker.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Web.Http.Dispatcher.HttpRoutingDispatcher.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Net.Http.DelegatingHandler.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Web.Http.HttpServer.<SendAsync>d__24.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.HttpServer.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Net.Http.HttpMessageInvoker.SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)\r\n at System.Web.Http.WebHost.HttpControllerHandler.<ProcessRequestAsyncCore>d__12.MoveNext()\r\n at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)\r\n at System.Web.Http.WebHost.HttpControllerHandler.ProcessRequestAsyncCore(HttpContextBase contextBase)\r\n at System.Web.Http.WebHost.HttpControllerHandler.ProcessRequestAsync(HttpContext context)\r\n at System.Web.HttpTaskAsyncHandler.<>c__DisplayClass4_0.<System.Web.IHttpAsyncHandler.BeginProcessRequest>b__0()\r\n at System.Web.TaskAsyncHelper.BeginTask(Func`1 taskFunc, AsyncCallback callback, Object state)\r\n at System.Web.HttpTaskAsyncHandler.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)\r\n at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()\r\n at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)\r\n at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)\r\n at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)\r\n at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)\r\n at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)\r\n at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)\r\n at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)\r\n at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"DEBUG","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.6705499Z","@mt":"Database configuration failed","@l":"Error","@x":"System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'versionId'.\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& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in C:\\projects\\dotnet\\src\\MiniProfiler.Shared\\Data\\ProfiledDbCommand.cs:line 272\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.<ExecuteNonQuery>b__31_0()\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.<>c__DisplayClass33_0`1.<Execute>b__0()\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.Execute[T](Func`1 f)\r\n at Umbraco.Core.Persistence.FaultHandling.FaultHandlingDbCommand.ExecuteNonQuery()\r\n at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.NPoco.IDatabaseHelpers.ExecuteNonQueryHelper(DbCommand cmd)\r\n at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)\r\n at NPoco.Database.Execute(Sql Sql)\r\n at NPoco.Database.Execute(String sql, Object[] args)\r\n at Umbraco.Core.Migrations.Upgrade.V_8_0_0.VariantsMigration.MigrateVersions()\r\n at Umbraco.Core.Migrations.Upgrade.V_8_0_0.VariantsMigration.Migrate()\r\n at Umbraco.Core.Migrations.MigrationBase.Umbraco.Core.Migrations.IMigration.Migrate()\r\n at Umbraco.Core.Migrations.MigrationPlan.Execute(IScope scope, String fromState, IMigrationBuilder migrationBuilder, ILogger logger)\r\n at Umbraco.Core.Migrations.Upgrade.Upgrader.Execute(IScopeProvider scopeProvider, IMigrationBuilder migrationBuilder, IKeyValueService keyValueService, ILogger logger)\r\n at Umbraco.Core.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(MigrationPlan plan)\r\nClientConnectionId:06d53222-0b33-4b8a-9307-4198561737b9\r\nError Number:207,State:1,Class:16","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"ERROR","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.6755556Z","@mt":"The database schema validation produced the following summary: {DbSchemaSummary}","DbSchemaSummary":"The following tables were found in the database, but are not in the current schema:\r\nGlobalConditions,RegisteredPredicates,UFRecords,UFRecordFields,UFRecordDataString,UFRecordDataLongString,UFRecordDataInteger,UFRecordDataBit,cmsContentXml,UFRecordDataDateTime,cmsPreviewXml,UFUserSecurity,UFUserFormSecurity,cmsPropertyData,uSyncSnapshotAudit,UCUserSettings,WorkflowSettings,WorkflowUserGroups,WorkflowUser2UserGroup,cmsTaskType,WorkflowUserGroupPermissions,cmsTask,WorkflowInstance,WorkflowTaskInstance,cmsContent,cmsContentVersion,cmsDocument,cmsMedia,cmsDataType,umbracoMigration,cmsDataTypePreValues,umbracoDomains,umbracoContent,umbracoContentVersion,umbracoMediaVersion,umbracoDocument,umbracoDataType,umbracoDomain,umbracoPropertyData,cmsContentNu,umbracoDocumentVersion,umbracoKeyValue,umbracoContentVersionCultureVariation,umbracoDocumentCultureVariation,umbracoContentSchedule\r\n \r\nThe following columns were found in the database, but are not in the current schema:\r\nUFRecords,CurrentPage,UFRecords,Form,UFRecords,UniqueId,UFRecordFields,Key,UFRecordFields,FieldId,UFRecordDataString,Key,UFRecordDataLongString,Key,UFRecordDataInteger,Key,UFRecordDataBit,Key,cmsPreviewXml,versionId,UFRecordDataDateTime,Key,UFUserFormSecurity,Form,cmsPropertyData,versionId,WorkflowInstance,Guid,WorkflowTaskInstance,WorkflowInstanceGuid,cmsContentVersion,VersionId,cmsDocument,versionId,cmsMedia,versionId,umbracoDomains,id,umbracoDomains,domainDefaultLanguage,umbracoDomains,domainRootStructureID,umbracoMigration,id,cmsDataTypePreValues,id,cmsDataTypePreValues,datatypeNodeId,cmsDataTypePreValues,sortorder,cmsDataType,pk,cmsDataType,nodeId,cmsDocument,templateId,cmsMedia,nodeId,cmsDocument,documentUser,cmsDocument,nodeId,cmsContentVersion,id,cmsContentVersion,ContentId,WorkflowTaskInstance,ActionedByUserId,cmsContent,pk,cmsContent,nodeId,cmsContent,contentType,WorkflowTaskInstance,GroupId,WorkflowTaskInstance,Id,WorkflowTaskInstance,Type,WorkflowTaskInstance,ApprovalStep,WorkflowTaskInstance,Status,cmsTask,id,cmsTask,taskTypeId,cmsTask,nodeId,cmsTask,parentUserId,cmsTask,userId,WorkflowInstance,Id,WorkflowInstance,NodeId,WorkflowInstance,Type,WorkflowInstance,TotalSteps,WorkflowInstance,AuthorUserId,WorkflowInstance,Status,WorkflowUser2UserGroup,Id,WorkflowUser2UserGroup,UserId,WorkflowUser2UserGroup,GroupId,cmsTaskType,id,WorkflowUserGroupPermissions,Id,WorkflowUserGroupPermissions,GroupId,WorkflowUserGroupPermissions,NodeId,WorkflowUserGroupPermissions,ContentTypeId,WorkflowUserGroupPermissions,Permission,WorkflowSettings,Id,WorkflowSettings,FlowType,WorkflowUserGroups,GroupId,cmsTags,ParentId,cmsPropertyData,id,cmsPropertyData,contentNodeId,uSyncSnapshotAudit,id,cmsPropertyData,propertytypeid,cmsPropertyData,dataInt,cmsPreviewXml,nodeId,UFUserFormSecurity,Id,UFUserFormSecurity,SecurityType,UFRecordDataInteger,Value,UFRecordDataBit,Id,cmsContentXml,nodeId,UFRecordDataLongString,Id,UFRecordDataDateTime,Id,UFRecordDataInteger,Id,UFRecordDataString,Id,UFRecordFields,Record,UFRecords,UmbracoPageId,RegisteredPredicates,Id,UFRecords,Id,GlobalConditions,Id,GlobalConditions,Created,GlobalConditions,LastUpdated,UFRecords,Created,UFRecords,Updated,cmsPreviewXml,timestamp,UFRecordDataDateTime,Value,uSyncSnapshotAudit,Applied,cmsPropertyData,dataDate,WorkflowInstance,CreatedDate,WorkflowInstance,CompletedDate,cmsTask,DateTime,WorkflowTaskInstance,CompletedDate,WorkflowTaskInstance,CreatedDate,cmsContentVersion,VersionDate,cmsDocument,releaseDate,cmsDocument,expireDate,cmsDocument,updateDate,umbracoMigration,createDate,cmsDataTypePreValues,value,cmsTemplate,design,cmsPropertyData,dataNtext,cmsPreviewXml,xml,cmsContentXml,xml,UFRecords,RecordData,UFRecordDataLongString,Value,GlobalConditions,Data,UFRecordDataBit,Value,UFUserSecurity,ManageDataSources,UFUserSecurity,ManagePreValueSources,UFUserSecurity,ManageWorkflows,UFUserSecurity,ManageForms,uSyncSnapshotAudit,IsLocal,UFUserFormSecurity,HasAccess,UFUserFormSecurity,AllowInEditor,WorkflowSettings,LockIfActive,WorkflowUserGroups,Deleted,WorkflowUserGroups,OfflineApproval,WorkflowSettings,SendNotifications,cmsTask,closed,cmsDocument,published,WorkflowTaskInstance,ActionedByAdmin,cmsDocument,newest,cmsPropertyData,dataDecimal,uSyncSnapshotAudit,Name,cmsPropertyData,dataNvarchar,UFUserFormSecurity,User,UCUserSettings,User,UCUserSettings,Key,UCUserSettings,Value,UFUserSecurity,User,UFRecordDataString,Value,UFRecordFields,Alias,UFRecordFields,DataType,RegisteredPredicates,Alias,UFRecords,State,UFRecords,IP,UFRecords,MemberKey,GlobalConditions,Guid,GlobalConditions,Name,cmsMedia,mediaPath,cmsDocument,text,cmsTask,Comment,WorkflowTaskInstance,Comment,WorkflowSettings,ExcludeNodes,WorkflowSettings,DefaultApprover,WorkflowSettings,Email,WorkflowSettings,EditUrl,WorkflowSettings,SiteUrl,WorkflowUserGroups,Description,WorkflowUserGroups,Name,WorkflowUserGroups,Alias,WorkflowUserGroups,GroupEmail,WorkflowInstance,AuthorComment,WorkflowUserGroupPermissions,Condition,cmsTaskType,alias,cmsMacro,macroPython,cmsMacro,macroScriptType,cmsMacro,macroScriptAssembly,cmsMacro,macroXSLT,umbracoDomains,domainName,cmsDataType,propertyEditorAlias,cmsDataType,dbType,cmsDataTypePreValues,alias,umbracoMigration,version,umbracoMigration,name,cmsContentType,isElement,cmsContentType,variations,umbracoContent,nodeId,umbracoContent,contentTypeId,umbracoContentVersion,id,umbracoContentVersion,nodeId,umbracoContentVersion,versionDate,umbracoContentVersion,userId,umbracoContentVersion,current,umbracoContentVersion,text,umbracoMediaVersion,id,umbracoMediaVersion,path,umbracoDocument,nodeId,umbracoDocument,published,umbracoDocument,edited,umbracoDataType,nodeId,umbracoDataType,propertyEditorAlias,umbracoDataType,dbType,umbracoDataType,config,umbracoLanguage,isDefaultVariantLang,umbracoLanguage,mandatory,umbracoLanguage,fallbackLanguageId,umbracoDomain,id,umbracoDomain,domainDefaultLanguage,umbracoDomain,domainRootStructureID,umbracoDomain,domainName,umbracoLog,entityType,umbracoLog,parameters,cmsMacro,macroSource,cmsMacro,macroType,cmsPropertyType,variations,umbracoPropertyData,id,umbracoPropertyData,versionId,umbracoPropertyData,propertyTypeId,umbracoPropertyData,languageId,umbracoPropertyData,segment,umbracoPropertyData,intValue,umbracoPropertyData,decimalValue,umbracoPropertyData,dateValue,umbracoPropertyData,varcharValue,umbracoPropertyData,textValue,cmsTags,languageId,umbracoRedirectUrl,culture,cmsContentNu,nodeId,cmsContentNu,published,cmsContentNu,data,cmsContentNu,rv,umbracoDocumentVersion,id,umbracoDocumentVersion,templateId,umbracoDocumentVersion,published,umbracoKeyValue,key,umbracoKeyValue,value,umbracoKeyValue,updated,umbracoContentVersionCultureVariation,id,umbracoContentVersionCultureVariation,versionId,umbracoContentVersionCultureVariation,languageId,umbracoContentVersionCultureVariation,name,umbracoContentVersionCultureVariation,date,umbracoContentVersionCultureVariation,availableUserId,umbracoDocumentCultureVariation,id,umbracoDocumentCultureVariation,nodeId,umbracoDocumentCultureVariation,languageId,umbracoDocumentCultureVariation,edited,umbracoDocumentCultureVariation,available,umbracoDocumentCultureVariation,published,umbracoDocumentCultureVariation,name,umbracoContentSchedule,id,umbracoContentSchedule,nodeId,umbracoContentSchedule,languageId,umbracoContentSchedule,date,umbracoContentSchedule,action\r\n \r\nThe following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:\r\nFK_cmsContent_cmsContentType_nodeId,FK_cmsContent_umbracoNode_id,FK_cmsContentVersion_cmsContent_nodeId,FK_cmsContentXml_cmsContent_nodeId,FK_cmsDataType_umbracoNode_id,FK_cmsDataTypePreValues_cmsDataType_nodeId,FK_cmsDocument_cmsContent_nodeId,FK_cmsDocument_cmsTemplate_nodeId,FK_cmsDocument_umbracoNode_id,FK_cmsMedia_cmsContent_nodeId,FK_cmsMedia_umbracoNode_id,FK_cmsMember_cmsContent_nodeId,FK_cmsMember_umbracoNode_id,FK_cmsPreviewXml_cmsContent_nodeId,FK_cmsPreviewXml_cmsContentVersion_VersionId,FK_cmsPropertyData_cmsPropertyType_id,FK_cmsPropertyData_umbracoNode_id,FK_cmsPropertyType_cmsDataType_nodeId,FK_cmsTags_cmsTags,FK_cmsTask_cmsTaskType_id,FK_cmsTask_umbracoNode_id,FK_cmsTask_umbracoUser,FK_cmsTask_umbracoUser1,FK_UFRecordDataBit_UFRecordFields_Key,FK_UFRecordDataDateTime_UFRecordFields_Key,FK_UFRecordDataInteger_UFRecordFields_Key,FK_UFRecordDataLongString_UFRecordFields_Key,FK_UFRecordDataString_UFRecordFields_Key,FK_umbracoDomains_umbracoNode_id,FK_umbracoNode_umbracoUser_id,FK_umbracoContent_umbracoNode_id,FK_umbracoContent_cmsContentType_NodeId,FK_umbracoContentVersion_umbracoContent_nodeId,FK_umbracoContentVersion_umbracoUser_id,FK_umbracoMediaVersion_umbracoContentVersion_id,FK_umbracoDocument_umbracoContent_nodeId,FK_umbracoDataType_umbracoNode_id,FK_umbracoLanguage_umbracoLanguage_id,FK_umbracoDomain_umbracoNode_id,FK_umbracoLog_umbracoUser_id,FK_cmsMember_umbracoContent_nodeId,FK_cmsPropertyType_umbracoDataType_nodeId,FK_umbracoPropertyData_umbracoContentVersion_id,FK_umbracoPropertyData_cmsPropertyType_id,FK_umbracoPropertyData_umbracoLanguage_id,FK_cmsTags_umbracoLanguage_id,FK_cmsContentNu_umbracoContent_nodeId,FK_umbracoDocumentVersion_umbracoContentVersion_id,FK_umbracoDocumentVersion_cmsTemplate_nodeId,FK_umbracoContentVersionCultureVariation_umbracoContentVersion_id,FK_umbracoContentVersionCultureVariation_umbracoLanguage_id,FK_umbracoContentVersionCultureVariation_umbracoUser_id,FK_umbracoDocumentCultureVariation_umbracoNode_id,FK_umbracoDocumentCultureVariation_umbracoLanguage_id,FK_umbracoContentSchedule_umbracoContent_nodeId,FK_umbracoContentSchedule_umbracoLanguage_id,PK_cmsContent,PK_cmsContentPreviewXml,PK_cmsContentVersion,PK_cmsContentXml,PK_cmsDataType,PK_cmsDataTypePreValues,PK_cmsDocument,PK_cmsMedia,PK_cmsPropertyData,PK_cmsTask,PK_cmsTaskType,PK_GlobalConditions,PK_RegisteredPredicates,PK_structure,PK_UCUserSettings,PK_UFRecordDataBit,PK_UFRecordDataDateTime,PK_UFRecordDataInteger,PK_UFRecordDataLongString,PK_UFRecordDataString,PK_UFRecordFields,PK_UFRecords,PK_umbracoDomains,PK_umbracoMigration,PK_uSyncSnapshotAudit,PK_WorkflowInstance,PK_WorkflowSettings,PK_WorkflowTaskInstance,PK_WorkflowUser2UserGroup,PK_WorkflowUserGroupPermissions,PK_WorkflowUserGroups,PK_umbracoNode,PK_umbracoContent,PK_umbracoContentVersion,PK_umbracoMediaVersion,PK_umbracoDocument,PK_umbracoDataType,PK_umbracoDomain,PK_umbracoPropertyData,PK_cmsContentNu,PK_umbracoDocumentVersion,PK_umbracoKeyValue,PK_umbracoContentVersionCultureVariation,PK_umbracoDocumentCultureVariation,PK_umbracoContentSchedule\r\n \r\nThe following indexes were found in the database, but are not in the current schema:\r\nIX_cmsContent,IX_cmsContentVersion_ContentId,IX_cmsContentVersion_VersionId,IX_cmsDataType_nodeId,IX_cmsDocument,IX_cmsDocument_newest,IX_cmsDocument_published,nci_wi_cmsDocument_7D825293816C2352E9FF93126D5E86EF,nci_wi_cmsDocument_C34F9FD3998E2BD0686747434D36A952,IX_cmsMedia,IX_cmsPropertyData_1,IX_cmsPropertyData_2,IX_cmsPropertyData_3,IX_cmsTaskType_alias,IX_databit_recordfield,IX_datadatetime_recordfield,IX_datainteger_recordfield,IX_datalongstring_recordfield,IX_datastring_recordfield,IX_umbracoMigration,IX_umbracoNodeObjectType,IX_umbracoNodeParentId,IX_umbracoNodePath,IX_umbracoNodeTrashed,IX_umbracoNodeUniqueID,IX_umbracoNode_UniqueId,IX_umbracoNode_ParentId,IX_umbracoNode_Path,IX_umbracoNode_Trashed,IX_umbracoNode_ObjectType,IX_umbracoMediaVersion,IX_umbracoDocument_Published,IX_umbracoLanguage_fallbackLanguageId,IX_umbracoPropertyData_VersionId,IX_umbracoPropertyData_PropertyTypeId,IX_umbracoPropertyData_LanguageId,IX_umbracoPropertyData_Segment,IX_cmsTags_LanguageId,IX_umbracoUserLogin_lastValidatedUtc,IX_umbracoContentVersionCultureVariation_VersionId,IX_umbracoContentVersionCultureVariation_LanguageId,IX_umbracoDocumentCultureVariation_NodeId,IX_umbracoDocumentCultureVariation_LanguageId\r\n \r\nThe following unknown constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:\r\nId\r\n \r\n","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.6775539Z","@mt":"Installation step {Step} failed.","@l":"Error","@x":"System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Invalid column name 'versionId'.\n Please check log file for additional information (can be found in '/App_Data/Logs/')\r\n at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.ExecuteAsync(Object model) in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\InstallSteps\\DatabaseUpgradeStep.cs:line 47\r\n --- End of inner exception stack trace ---\r\n at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.<ExecuteStepAsync>d__14.MoveNext() in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\Controllers\\InstallApiController.cs:line 236\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 at Umbraco.Web.Install.Controllers.InstallApiController.<PostPerformInstall>d__11.MoveNext() in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\Controllers\\InstallApiController.cs:line 104","Step":"DatabaseUpgrade","SourceContext":"Umbraco.Web.Install.Controllers.InstallApiController","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"ERROR","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.6785551Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Step completed","Duration":521760,"TimingId":"3953d93","SourceContext":"Umbraco.Web.Install.Controllers.InstallApiController","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"INFO ","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
{"@t":"2020-02-26T18:55:29.6785551Z","@mt":"An error occurred during installation step {Step}","@l":"Error","@x":"System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Invalid column name 'versionId'.\n Please check log file for additional information (can be found in '/App_Data/Logs/')\r\n at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.ExecuteAsync(Object model) in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\InstallSteps\\DatabaseUpgradeStep.cs:line 47\r\n --- End of inner exception stack trace ---\r\n at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.<ExecuteStepAsync>d__14.MoveNext() in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\Controllers\\InstallApiController.cs:line 236\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 at Umbraco.Web.Install.Controllers.InstallApiController.<PostPerformInstall>d__11.MoveNext() in d:\\a\\1\\s\\src\\Umbraco.Web\\Install\\Controllers\\InstallApiController.cs:line 104","Step":"DatabaseUpgrade","SourceContext":"Umbraco.Web.Install.Controllers.InstallApiController","ProcessId":18852,"ProcessName":"iisexpress","ThreadId":12,"AppDomainId":2,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"U","Log4NetLevel":"ERROR","HttpRequestNumber":9,"HttpRequestId":"9f5b6d73-b098-418f-82c4-9dfd57aa45bb"}
I have downloaded the 8.5.3 tagged version of Umbraco from git and was pointing my project to use the code there. It seems to be failing on the command to set the new edited column on the documents table to 0
AddColumn<DocumentDto>(PreTables.Document, "edited", out var sqls);
Database.Execute($"UPDATE {SqlSyntax.GetQuotedTableName(PreTables.Document)} SET edited=0");
Well that's just weird. I'd hoped that it was getting to the next "set 'edited' to true whenever a 'non-published' property data is != a published one" step since that at least refers to columns called versionId. I really don't see how it can get that error from UPDATE cmsDocument SET edited=0. We've deleted the versionId column from cmsDocument at this point, but anything like indexes that depended on the column should have caused an error when the column was deleted.
I'm really confused on why it would be an issue there. I notice that versionId is the primary key on the table. Not sure if something needs to be done to change it to not be a primary key before deleting it. I noticed that the table doesn't even exist in the new db i created to see what's in 8.5.3. I'm wondering if the db is missing a migration somewhere.
step 2 : Then update your current Umbraco version say 7.12.3 to 7.15.0 through Nuget package manager .
step 3 : keep the current updated database
step 4 : Create a new visual studio mvc solution with .Net framework 4.7.2 latest
step 5 : Install Umbraco 8.0 in it . configure the database and Backoffice
step 6 :
Change the version 8.0.0 to 7.15.0 in the new created Visual studio solution wen.config file
step 7 : just change the Database connection in newly created Umbraco8 with previous 7.15.0 Database .
step 8 : just run the umbraco 8 . It will take too much time . because alter and update scripts are running in background .If you want to see it . just open App_Data -> Log folder there is umbracotracelog folder.
step 9 : if any error occured just repeat the step 1 - 8 again with fresh 7.12.3 Database
step 10 ; copy all the media , asset , view files and moved to 7.15.0 to umbraco 8
step 11 : Now there is a big change in code .. The code in 7.12.3 will not support 8 version
Recently I have started working on upgrading my client's Umbraco v7.15.4 website to Umbraco v8.6.3 (current latest version) and experienced a lot of problems.
In order to help my future self and fellow Umbraco Developers, I've written a blog about my experience with v8, hope it helps.
I am having the same problems upgrading from 7.15.5 to 8.6.3 and today trying 8.6.4. I would be happy to provide a BAK of the database and my log files if that will help with troubleshooting these upgrade issues that seem to be affecting a large number of users.
I just tried that and 7.15.5 to 8.2.1 did not work for me. The end of my log file is:
{"@t":"2020-08-11T16:10:20.1919381Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":10991,"Sql":"ALTER TABLE [cmsDocument] ADD [edited] BIT NULL ","SourceContext":"Umbraco.Core.Migrations.Expressions.Execute.Expressions.ExecuteSqlStatementExpression","ProcessId":20040,"ProcessName":"w3wp","ThreadId":13,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"EMLAPTOP1976","Log4NetLevel":"INFO ","HttpRequestNumber":7,"HttpRequestId":"eca9692b-961d-4e08-93e2-f952922ac825"}
{"@t":"2020-08-11T16:11:20.3660547Z","@mt":"Exception ({InstanceId}).","@l":"Error","@x":"System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): 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.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.SqlDataReader.TryConsumeMetaData()\r\n at System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)\r\n at NPoco.Database.ExecuteReaderHelper(DbCommand cmd)\r\n at NPoco.Database.ExecuteDataReader(DbCommand cmd)\r\n at NPoco.Database.<QueryImp>d__164`1.MoveNext()\r\n at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n at Umbraco.Core.Migrations.Upgrade.V_8_0_0.VariantsMigration.MigrateVersions()\r\n at Umbraco.Core.Migrations.Upgrade.V_8_0_0.VariantsMigration.Migrate()\r\n at Umbraco.Core.Migrations.MigrationBase.Umbraco.Core.Migrations.IMigration.Migrate()\r\n at Umbraco.Core.Migrations.MigrationPlan.Execute(IScope scope, String fromState, IMigrationBuilder migrationBuilder, ILogger logger)\r\n at Umbraco.Core.Migrations.Upgrade.Upgrader.Execute(IScopeProvider scopeProvider, IMigrationBuilder migrationBuilder, IKeyValueService keyValueService, ILogger logger)\r\n at Umbraco.Core.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(MigrationPlan plan)\r\nClientConnectionId:eae01200-cb8a-4bcb-a51c-231337a3325b\r\nError Number:-2,State:0,Class:11","InstanceId":"9eab2b3f","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":20040,"ProcessName":"w3wp","ThreadId":13,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"EMLAPTOP1976","Log4NetLevel":"ERROR","HttpRequestNumber":7,"HttpRequestId":"eca9692b-961d-4e08-93e2-f952922ac825"}
{"@t":"2020-08-11T16:11:46.1978137Z","@mt":"Database configuration failed","@l":"Error","@x":"System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): 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.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.SqlDataReader.TryConsumeMetaData()\r\n at System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)\r\n at NPoco.Database.ExecuteReaderHelper(DbCommand cmd)\r\n at NPoco.Database.ExecuteDataReader(DbCommand cmd)\r\n at NPoco.Database.<QueryImp>d__164`1.MoveNext()\r\n at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n at Umbraco.Core.Migrations.Upgrade.V_8_0_0.VariantsMigration.MigrateVersions()\r\n at Umbraco.Core.Migrations.Upgrade.V_8_0_0.VariantsMigration.Migrate()\r\n at Umbraco.Core.Migrations.MigrationBase.Umbraco.Core.Migrations.IMigration.Migrate()\r\n at Umbraco.Core.Migrations.MigrationPlan.Execute(IScope scope, String fromState, IMigrationBuilder migrationBuilder, ILogger logger)\r\n at Umbraco.Core.Migrations.Upgrade.Upgrader.Execute(IScopeProvider scopeProvider, IMigrationBuilder migrationBuilder, IKeyValueService keyValueService, ILogger logger)\r\n at Umbraco.Core.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(MigrationPlan plan)\r\nClientConnectionId:eae01200-cb8a-4bcb-a51c-231337a3325b\r\nError Number:-2,State:0,Class:11","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":20040,"ProcessName":"w3wp","ThreadId":13,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"EMLAPTOP1976","Log4NetLevel":"ERROR","HttpRequestNumber":7,"HttpRequestId":"eca9692b-961d-4e08-93e2-f952922ac825"}
{"@t":"2020-08-11T16:11:46.2037935Z","@mt":"The database schema validation produced the following summary: {DbSchemaSummary}","DbSchemaSummary":"The following tables were found in the database, but are not in the current schema:\r\ncmsTaskType,cmsTask,cmsContent,cmsContentVersion,cmsDocument,cmsDataType,cmsDataTypePreValues,umbracoDomains,cmsMedia,cmsContentXml,umbracoMigration,cmsPreviewXml,cmsPropertyData,umbracoContent,umbracoContentVersion,umbracoMediaVersion,umbracoDocument,umbracoDataType,umbracoDomain,umbracoPropertyData,cmsContentNu,umbracoDocumentVersion,umbracoKeyValue,umbracoContentVersionCultureVariation,umbracoDocumentCultureVariation,umbracoContentSchedule\r\n \r\nThe following columns were found in the database, but are not in the current schema:\r\ncmsTaskType,id,cmsTaskType,alias,cmsTask,closed,cmsTask,id,cmsTask,taskTypeId,cmsTask,nodeId,cmsTask,parentUserId,cmsTask,userId,cmsTask,DateTime,cmsTask,Comment,cmsTemplate,design,cmsContent,pk,cmsContent,nodeId,cmsContent,contentType,cmsContentVersion,id,cmsContentVersion,ContentId,cmsContentVersion,VersionId,cmsContentVersion,VersionDate,cmsDocument,nodeId,cmsDocument,published,cmsDocument,documentUser,cmsDocument,versionId,cmsDocument,text,cmsDocument,releaseDate,cmsDocument,expireDate,cmsDocument,updateDate,cmsDocument,templateId,cmsDocument,newest,cmsDataType,pk,cmsDataType,nodeId,cmsDataType,propertyEditorAlias,cmsDataType,dbType,cmsDataTypePreValues,id,cmsDataTypePreValues,datatypeNodeId,cmsDataTypePreValues,value,cmsDataTypePreValues,sortorder,cmsDataTypePreValues,alias,umbracoDomains,id,umbracoDomains,domainDefaultLanguage,umbracoDomains,domainRootStructureID,umbracoDomains,domainName,cmsMacro,macroScriptType,cmsMacro,macroScriptAssembly,cmsMacro,macroXSLT,cmsMacro,macroPython,cmsMedia,nodeId,cmsMedia,versionId,cmsMedia,mediaPath,cmsContentXml,nodeId,cmsContentXml,xml,umbracoMigration,id,umbracoMigration,name,umbracoMigration,version,umbracoMigration,createDate,cmsPreviewXml,nodeId,cmsPreviewXml,versionId,cmsPreviewXml,timestamp,cmsPreviewXml,xml,cmsPropertyData,id,cmsPropertyData,contentNodeId,cmsPropertyData,versionId,cmsPropertyData,propertytypeid,cmsPropertyData,dataInt,cmsPropertyData,dataDate,cmsPropertyData,dataNvarchar,cmsPropertyData,dataNtext,cmsPropertyData,dataDecimal,cmsTags,ParentId,cmsContentType,isElement,cmsContentType,variations,umbracoContent,nodeId,umbracoContent,contentTypeId,umbracoContentVersion,id,umbracoContentVersion,nodeId,umbracoContentVersion,versionDate,umbracoContentVersion,userId,umbracoContentVersion,current,umbracoContentVersion,text,umbracoMediaVersion,id,umbracoMediaVersion,path,umbracoDocument,nodeId,umbracoDocument,published,umbracoDocument,edited,umbracoDataType,nodeId,umbracoDataType,propertyEditorAlias,umbracoDataType,dbType,umbracoDataType,config,umbracoLanguage,isDefaultVariantLang,umbracoLanguage,mandatory,umbracoLanguage,fallbackLanguageId,umbracoDomain,id,umbracoDomain,domainDefaultLanguage,umbracoDomain,domainRootStructureID,umbracoDomain,domainName,umbracoLog,entityType,umbracoLog,parameters,cmsMacro,macroSource,cmsMacro,macroType,cmsPropertyType,variations,umbracoPropertyData,id,umbracoPropertyData,versionId,umbracoPropertyData,propertyTypeId,umbracoPropertyData,languageId,umbracoPropertyData,segment,umbracoPropertyData,intValue,umbracoPropertyData,decimalValue,umbracoPropertyData,dateValue,umbracoPropertyData,varcharValue,umbracoPropertyData,textValue,cmsTags,languageId,umbracoRedirectUrl,culture,cmsContentNu,nodeId,cmsContentNu,published,cmsContentNu,data,cmsContentNu,rv,umbracoDocumentVersion,id,umbracoDocumentVersion,templateId,umbracoDocumentVersion,published,umbracoKeyValue,key,umbracoKeyValue,value,umbracoKeyValue,updated,umbracoContentVersionCultureVariation,id,umbracoContentVersionCultureVariation,versionId,umbracoContentVersionCultureVariation,languageId,umbracoContentVersionCultureVariation,name,umbracoContentVersionCultureVariation,date,umbracoContentVersionCultureVariation,availableUserId,umbracoDocumentCultureVariation,id,umbracoDocumentCultureVariation,nodeId,umbracoDocumentCultureVariation,languageId,umbracoDocumentCultureVariation,edited,umbracoDocumentCultureVariation,available,umbracoDocumentCultureVariation,published,umbracoDocumentCultureVariation,name,umbracoContentSchedule,id,umbracoContentSchedule,nodeId,umbracoContentSchedule,languageId,umbracoContentSchedule,date,umbracoContentSchedule,action\r\n \r\nThe following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:\r\nFK_cmsContent_cmsContentType_nodeId,FK_cmsContent_umbracoNode_id,FK_cmsContentVersion_cmsContent_nodeId,FK_cmsContentXml_cmsContent_nodeId,FK_cmsDataType_umbracoNode_id,FK_cmsDataTypePreValues_cmsDataType_nodeId,FK_cmsDocument_cmsContent_nodeId,FK_cmsDocument_cmsTemplate_nodeId,FK_cmsDocument_umbracoNode_id,FK_cmsMedia_cmsContent_nodeId,FK_cmsMedia_umbracoNode_id,FK_cmsMember_cmsContent_nodeId,FK_cmsMember_umbracoNode_id,FK_cmsPreviewXml_cmsContent_nodeId,FK_cmsPreviewXml_cmsContentVersion_VersionId,FK_cmsPropertyData_cmsPropertyType_id,FK_cmsPropertyData_umbracoNode_id,FK_cmsPropertyType_cmsDataType_nodeId,FK_cmsTags_cmsTags,FK_cmsTask_cmsTaskType_id,FK_cmsTask_umbracoNode_id,FK_cmsTask_umbracoUser,FK_cmsTask_umbracoUser1,FK_umbracoDomains_umbracoNode_id,FK_umbracoExternalLogin_umbracoUser_id,FK_umbracoRedirectUrl,FK_umbracoNode_umbracoUser_id,FK_umbracoContent_umbracoNode_id,FK_umbracoContent_cmsContentType_NodeId,FK_umbracoContentVersion_umbracoContent_nodeId,FK_umbracoContentVersion_umbracoUser_id,FK_umbracoMediaVersion_umbracoContentVersion_id,FK_umbracoDocument_umbracoContent_nodeId,FK_umbracoDataType_umbracoNode_id,FK_umbracoLanguage_umbracoLanguage_id,FK_umbracoDomain_umbracoNode_id,FK_umbracoLog_umbracoUser_id,FK_cmsMember_umbracoContent_nodeId,FK_cmsPropertyType_umbracoDataType_nodeId,FK_umbracoPropertyData_umbracoContentVersion_id,FK_umbracoPropertyData_cmsPropertyType_id,FK_umbracoPropertyData_umbracoLanguage_id,FK_cmsTags_umbracoLanguage_id,FK_umbracoRedirectUrl_umbracoNode_uniqueID,FK_cmsContentNu_umbracoContent_nodeId,FK_umbracoDocumentVersion_umbracoContentVersion_id,FK_umbracoDocumentVersion_cmsTemplate_nodeId,FK_umbracoContentVersionCultureVariation_umbracoContentVersion_id,FK_umbracoContentVersionCultureVariation_umbracoLanguage_id,FK_umbracoContentVersionCultureVariation_umbracoUser_id,FK_umbracoDocumentCultureVariation_umbracoNode_id,FK_umbracoDocumentCultureVariation_umbracoLanguage_id,FK_umbracoContentSchedule_umbracoContent_nodeId,FK_umbracoContentSchedule_umbracoLanguage_id,PK_cmsContent,PK_cmsContentVersion,PK_cmsContentXml,PK_cmsDataType,PK_cmsDataTypePreValues,PK_cmsDocument,PK_cmsMedia,PK_cmsPreviewXml,PK_cmsPropertyData,PK_cmsTask,PK_cmsTaskType,PK_structure,PK_umbracoDomains,PK_umbracoMigrations,PK_umbracoNode,PK_umbracoContent,PK_umbracoContentVersion,PK_umbracoMediaVersion,PK_umbracoDocument,PK_umbracoDataType,PK_umbracoDomain,PK_umbracoPropertyData,PK_cmsContentNu,PK_umbracoDocumentVersion,PK_umbracoKeyValue,PK_umbracoContentVersionCultureVariation,PK_umbracoDocumentCultureVariation,PK_umbracoContentSchedule\r\n \r\nThe following indexes were found in the database, but are not in the current schema:\r\nIX_cmsContent,IX_cmsContentVersion_ContentId,IX_cmsContentVersion_VersionId,IX_cmsDataType_nodeId,IX_cmsDocument,IX_cmsDocument_newest,IX_cmsDocument_published,IX_cmsMedia,IX_cmsPropertyData_1,IX_cmsPropertyData_2,IX_cmsPropertyData_3,IX_cmsTaskType_alias,IX_umbracoMigration,IX_umbracoNodeObjectType,IX_umbracoNodeParentId,IX_umbracoNodePath,IX_umbracoNodeTrashed,IX_umbracoNode_ParentId,IX_umbracoNode_Path,IX_umbracoNode_Trashed,IX_umbracoNode_ObjectType,IX_umbracoMediaVersion,IX_umbracoDocument_Published,IX_umbracoLanguage_fallbackLanguageId,IX_umbracoPropertyData_VersionId,IX_umbracoPropertyData_PropertyTypeId,IX_umbracoPropertyData_LanguageId,IX_umbracoPropertyData_Segment,IX_cmsTags_LanguageId,IX_umbracoUserLogin_lastValidatedUtc,IX_umbracoContentVersionCultureVariation_VersionId,IX_umbracoContentVersionCultureVariation_LanguageId,IX_umbracoDocumentCultureVariation_NodeId,IX_umbracoDocumentCultureVariation_LanguageId\r\n \r\n","SourceContext":"Umbraco.Core.Migrations.Install.DatabaseBuilder","ProcessId":20040,"ProcessName":"w3wp","ThreadId":13,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"EMLAPTOP1976","Log4NetLevel":"INFO ","HttpRequestNumber":7,"HttpRequestId":"eca9692b-961d-4e08-93e2-f952922ac825"}
{"@t":"2020-08-11T16:11:46.2057860Z","@mt":"Installation step {Step} failed.","@l":"Error","@x":"System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.\n Please check log file for additional information (can be found in '/App_Data/Logs/')\r\n at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.ExecuteAsync(Object model)\r\n --- End of inner exception stack trace ---\r\n at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.<ExecuteStepAsync>d__14.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at Umbraco.Web.Install.Controllers.InstallApiController.<PostPerformInstall>d__11.MoveNext()","Step":"DatabaseUpgrade","SourceContext":"Umbraco.Web.Install.Controllers.InstallApiController","ProcessId":20040,"ProcessName":"w3wp","ThreadId":13,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"EMLAPTOP1976","Log4NetLevel":"ERROR","HttpRequestNumber":7,"HttpRequestId":"eca9692b-961d-4e08-93e2-f952922ac825"}
{"@t":"2020-08-11T16:11:46.2057860Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Step completed","Duration":2362784,"TimingId":"f20fa31","SourceContext":"Umbraco.Web.Install.Controllers.InstallApiController","ProcessId":20040,"ProcessName":"w3wp","ThreadId":13,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"EMLAPTOP1976","Log4NetLevel":"INFO ","HttpRequestNumber":7,"HttpRequestId":"eca9692b-961d-4e08-93e2-f952922ac825"}
{"@t":"2020-08-11T16:11:46.2057860Z","@mt":"An error occurred during installation step {Step}","@l":"Error","@x":"System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.\n Please check log file for additional information (can be found in '/App_Data/Logs/')\r\n at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.ExecuteAsync(Object model)\r\n --- End of inner exception stack trace ---\r\n at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n at Umbraco.Web.Install.Controllers.InstallApiController.<ExecuteStepAsync>d__14.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at Umbraco.Web.Install.Controllers.InstallApiController.<PostPerformInstall>d__11.MoveNext()","Step":"DatabaseUpgrade","SourceContext":"Umbraco.Web.Install.Controllers.InstallApiController","ProcessId":20040,"ProcessName":"w3wp","ThreadId":13,"AppDomainId":3,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"EMLAPTOP1976","Log4NetLevel":"ERROR","HttpRequestNumber":7,"HttpRequestId":"eca9692b-961d-4e08-93e2-f952922ac825"}
I do remember getting an error too but the upgrade went through anyway. In fact I ran this process probably +10 times to test and be sure, and each time after the 8.2.1 upgrade process, I ended up with some error yet the upgrade was completed. Maybe this is a different issue however, unfortunately I have not kept those logs to compare sorry :(
That looks like a timeout that should be fixed in 8.7.0, but until that is released there's a custom build of 8.2.0 here which includes the fix. If that works to get you upgraded to 8.2.0, you should then be able to upgrade to a standard build of 8.6.x.
That still didn't work for me. The initial error I received had to do with obsolete datatype members. I removed those and tried again and got the following error:
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Umbraco.Core.Exceptions.BootFailedException: Boot failed: Umbraco cannot run. See Umbraco's log file for more details.
-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.
-> System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: length
at CSharpTest.Net.IO.TransactedCompoundFile.Write(UInt32 handle, Byte[] bytes, Int32 offset, Int32 length)
at CSharpTest.Net.Storage.BTreeFileStoreV2.Update[T](IStorageHandle handleIn, ISerializer`1 serializer, T node)
at CSharpTest.Net.Collections.BPlusTree`2.StorageCache.OnItemRemoved(KeyValuePair`2 item)
at CSharpTest.Net.Collections.LurchTable`2.TryDequeue(Predicate`1 predicate, KeyValuePair`2& value)
at CSharpTest.Net.Collections.LurchTable`2.Insert[T](TKey key, T& value)
at CSharpTest.Net.Collections.BPlusTree`2.StorageCache.Update[TNode](IStorageHandle handle, ISerializer`1 serializer, TNode tnode)
at CSharpTest.Net.Collections.BPlusTree`2.NodeCacheBase.SaveChanges(NodePin pin)
at CSharpTest.Net.Collections.BPlusTree`2.NodeTransaction.PerformCommit()
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.AddEntry[T](TKey key, T& info)
at Umbraco.Web.PublishedCache.NuCache.ContentStore.Release(WriteLockInfo lockInfo, Boolean commit)
at Umbraco.Web.PublishedCache.NuCache.ContentStore.SetAll(IEnumerable`1 kits)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.LoadContentFromDatabaseLocked(IScope scope, Boolean onStartup)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.NotifyLocked(IEnumerable`1 payloads, Boolean& draftChanged, Boolean& publishedChanged)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.Notify(JsonPayload[] payloads, Boolean& draftChanged, Boolean& publishedChanged)
at Umbraco.Web.Compose.DatabaseServerRegistrarAndMessengerComposer.<>c.<GetDefaultOptions>b__0_0()
at Umbraco.Core.Sync.DatabaseServerMessenger.Initialize(IUmbracoDatabase database)
at Umbraco.Core.Sync.DatabaseServerMessenger.Boot()
at Umbraco.Core.Composing.ComponentCollection.Initialize()
at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[BootFailedException: Boot failed: Umbraco cannot run. See Umbraco's log file for more details.
-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.
-> System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: length
at CSharpTest.Net.IO.TransactedCompoundFile.Write(UInt32 handle, Byte[] bytes, Int32 offset, Int32 length)
at CSharpTest.Net.Storage.BTreeFileStoreV2.Update[T](IStorageHandle handleIn, ISerializer`1 serializer, T node)
at CSharpTest.Net.Collections.BPlusTree`2.StorageCache.OnItemRemoved(KeyValuePair`2 item)
at CSharpTest.Net.Collections.LurchTable`2.TryDequeue(Predicate`1 predicate, KeyValuePair`2& value)
at CSharpTest.Net.Collections.LurchTable`2.Insert[T](TKey key, T& value)
at CSharpTest.Net.Collections.BPlusTree`2.StorageCache.Update[TNode](IStorageHandle handle, ISerializer`1 serializer, TNode tnode)
at CSharpTest.Net.Collections.BPlusTree`2.NodeCacheBase.SaveChanges(NodePin pin)
at CSharpTest.Net.Collections.BPlusTree`2.NodeTransaction.PerformCommit()
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.AddEntry[T](TKey key, T& info)
at Umbraco.Web.PublishedCache.NuCache.ContentStore.Release(WriteLockInfo lockInfo, Boolean commit)
at Umbraco.Web.PublishedCache.NuCache.ContentStore.SetAll(IEnumerable`1 kits)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.LoadContentFromDatabaseLocked(IScope scope, Boolean onStartup)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.NotifyLocked(IEnumerable`1 payloads, Boolean& draftChanged, Boolean& publishedChanged)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.Notify(JsonPayload[] payloads, Boolean& draftChanged, Boolean& publishedChanged)
at Umbraco.Web.Compose.DatabaseServerRegistrarAndMessengerComposer.<>c.<GetDefaultOptions>b__0_0()
at Umbraco.Core.Sync.DatabaseServerMessenger.Initialize(IUmbracoDatabase database)
at Umbraco.Core.Sync.DatabaseServerMessenger.Boot()
at Umbraco.Core.Composing.ComponentCollection.Initialize()
at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)]
Umbraco.Core.Exceptions.BootFailedException.Rethrow(BootFailedException bootFailedException) +339
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +223
System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +220
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +94
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4200.0
Server Error in '/' Application.
Boot failed: Umbraco cannot run. See Umbraco's log file for more details.
-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.
-> System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: length
at CSharpTest.Net.IO.TransactedCompoundFile.Write(UInt32 handle, Byte[] bytes, Int32 offset, Int32 length)
at CSharpTest.Net.Storage.BTreeFileStoreV2.Update[T](IStorageHandle handleIn, ISerializer`1 serializer, T node)
at CSharpTest.Net.Collections.BPlusTree`2.StorageCache.OnItemRemoved(KeyValuePair`2 item)
at CSharpTest.Net.Collections.LurchTable`2.TryDequeue(Predicate`1 predicate, KeyValuePair`2& value)
at CSharpTest.Net.Collections.LurchTable`2.Insert[T](TKey key, T& value)
at CSharpTest.Net.Collections.BPlusTree`2.StorageCache.Destroy(IStorageHandle handle)
at CSharpTest.Net.Collections.BPlusTree`2.NodeCacheBase.SaveChanges(NodePin pin)
at CSharpTest.Net.Collections.BPlusTree`2.NodeTransaction.PerformCommit()
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.AddEntry[T](TKey key, T& info)
at Umbraco.Web.PublishedCache.NuCache.ContentStore.Release(WriteLockInfo lockInfo, Boolean commit)
at Umbraco.Web.PublishedCache.NuCache.ContentStore.SetAll(IEnumerable`1 kits)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.LoadContentFromDatabaseLocked(IScope scope, Boolean onStartup)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.NotifyLocked(IEnumerable`1 payloads, Boolean& draftChanged, Boolean& publishedChanged)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.Notify(JsonPayload[] payloads, Boolean& draftChanged, Boolean& publishedChanged)
at Umbraco.Web.Compose.DatabaseServerRegistrarAndMessengerComposer.<>c.<GetDefaultOptions>b__0_0()
at Umbraco.Core.Sync.DatabaseServerMessenger.Initialize(IUmbracoDatabase database)
at Umbraco.Core.Sync.DatabaseServerMessenger.Boot()
at Umbraco.Core.Composing.ComponentCollection.Initialize()
at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Umbraco.Core.Exceptions.BootFailedException: Boot failed: Umbraco cannot run. See Umbraco's log file for more details.
-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.
-> System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: length
at CSharpTest.Net.IO.TransactedCompoundFile.Write(UInt32 handle, Byte[] bytes, Int32 offset, Int32 length)
at CSharpTest.Net.Storage.BTreeFileStoreV2.Update[T](IStorageHandle handleIn, ISerializer`1 serializer, T node)
at CSharpTest.Net.Collections.BPlusTree`2.StorageCache.OnItemRemoved(KeyValuePair`2 item)
at CSharpTest.Net.Collections.LurchTable`2.TryDequeue(Predicate`1 predicate, KeyValuePair`2& value)
at CSharpTest.Net.Collections.LurchTable`2.Insert[T](TKey key, T& value)
at CSharpTest.Net.Collections.BPlusTree`2.StorageCache.Destroy(IStorageHandle handle)
at CSharpTest.Net.Collections.BPlusTree`2.NodeCacheBase.SaveChanges(NodePin pin)
at CSharpTest.Net.Collections.BPlusTree`2.NodeTransaction.PerformCommit()
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.AddEntry[T](TKey key, T& info)
at Umbraco.Web.PublishedCache.NuCache.ContentStore.Release(WriteLockInfo lockInfo, Boolean commit)
at Umbraco.Web.PublishedCache.NuCache.ContentStore.SetAll(IEnumerable`1 kits)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.LoadContentFromDatabaseLocked(IScope scope, Boolean onStartup)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.NotifyLocked(IEnumerable`1 payloads, Boolean& draftChanged, Boolean& publishedChanged)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.Notify(JsonPayload[] payloads, Boolean& draftChanged, Boolean& publishedChanged)
at Umbraco.Web.Compose.DatabaseServerRegistrarAndMessengerComposer.<>c.<GetDefaultOptions>b__0_0()
at Umbraco.Core.Sync.DatabaseServerMessenger.Initialize(IUmbracoDatabase database)
at Umbraco.Core.Sync.DatabaseServerMessenger.Boot()
at Umbraco.Core.Composing.ComponentCollection.Initialize()
at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[BootFailedException: Boot failed: Umbraco cannot run. See Umbraco's log file for more details.
-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.
-> System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: length
at CSharpTest.Net.IO.TransactedCompoundFile.Write(UInt32 handle, Byte[] bytes, Int32 offset, Int32 length)
at CSharpTest.Net.Storage.BTreeFileStoreV2.Update[T](IStorageHandle handleIn, ISerializer`1 serializer, T node)
at CSharpTest.Net.Collections.BPlusTree`2.StorageCache.OnItemRemoved(KeyValuePair`2 item)
at CSharpTest.Net.Collections.LurchTable`2.TryDequeue(Predicate`1 predicate, KeyValuePair`2& value)
at CSharpTest.Net.Collections.LurchTable`2.Insert[T](TKey key, T& value)
at CSharpTest.Net.Collections.BPlusTree`2.StorageCache.Destroy(IStorageHandle handle)
at CSharpTest.Net.Collections.BPlusTree`2.NodeCacheBase.SaveChanges(NodePin pin)
at CSharpTest.Net.Collections.BPlusTree`2.NodeTransaction.PerformCommit()
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.Insert[T](NodePin thisLock, TKey key, T& value, NodePin parent, Int32 parentIx)
at CSharpTest.Net.Collections.BPlusTree`2.AddEntry[T](TKey key, T& info)
at Umbraco.Web.PublishedCache.NuCache.ContentStore.Release(WriteLockInfo lockInfo, Boolean commit)
at Umbraco.Web.PublishedCache.NuCache.ContentStore.SetAll(IEnumerable`1 kits)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.LoadContentFromDatabaseLocked(IScope scope, Boolean onStartup)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.NotifyLocked(IEnumerable`1 payloads, Boolean& draftChanged, Boolean& publishedChanged)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.Notify(JsonPayload[] payloads, Boolean& draftChanged, Boolean& publishedChanged)
at Umbraco.Web.Compose.DatabaseServerRegistrarAndMessengerComposer.<>c.<GetDefaultOptions>b__0_0()
at Umbraco.Core.Sync.DatabaseServerMessenger.Initialize(IUmbracoDatabase database)
at Umbraco.Core.Sync.DatabaseServerMessenger.Boot()
at Umbraco.Core.Composing.ComponentCollection.Initialize()
at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)]
Umbraco.Core.Exceptions.BootFailedException.Rethrow(BootFailedException bootFailedException) +339
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +223
System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +220
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +94
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4200.0
So close. The 8.2.0 upgrade worked and ran. Then, when I attempted to upgrade to 8.6.4 the upgrade completed, then restarted with the following error:
Server Error in '/' Application.
Boot failed: Umbraco cannot run. See Umbraco's log file for more details.
-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.
-> System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: handle
at CSharpTest.Net.IO.TransactedCompoundFile.Read(UInt32 handle)
at CSharpTest.Net.Storage.BTreeFileStoreV2.OpenRoot(Boolean& isNew)
at CSharpTest.Net.Collections.BPlusTree`2.NodeCacheNone.LoadStorage()
at CSharpTest.Net.Collections.BPlusTree`2..ctor(BPlusTreeOptions`2 ioptions)
at Umbraco.Web.PublishedCache.NuCache.DataSource.BTree.GetTree(String filepath, Boolean exists)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.MainDomRegister()
at Umbraco.Core.Runtime.MainDom.Register(Action install, Action release, Int32 weight)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService..ctor(PublishedSnapshotServiceOptions options, IMainDom mainDom, IRuntimeState runtime, ServiceContext serviceContext, IPublishedContentTypeFactory publishedContentTypeFactory, IdkMap idkMap, IPublishedSnapshotAccessor publishedSnapshotAccessor, IVariationContextAccessor variationContextAccessor, IProfilingLogger logger, IScopeProvider scopeProvider, IDocumentRepository documentRepository, IMediaRepository mediaRepository, IMemberRepository memberRepository, IDefaultCultureAccessor defaultCultureAccessor, IDataSource dataSource, IGlobalSettings globalSettings, IEntityXmlSerializer entitySerializer, IPublishedModelFactory publishedModelFactory, UrlSegmentProviderCollection urlSegmentProviders)
at DynamicMethod(Object[] )
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope)
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter)
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms)
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency)
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter)
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod)
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter)
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter)
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1()
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope)
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter)
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms)
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency)
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter)
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod)
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter)
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter)
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1()
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope)
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter)
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms)
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency)
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter)
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod)
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter)
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms)
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter)
at LightInject.ServiceContainer.CreateDelegate(Type serviceType, String serviceName, Boolean throwError)
at LightInject.ServiceContainer.CreateDefaultDelegate(Type serviceType, Boolean throwError)
at LightInject.ServiceContainer.GetInstance(Type serviceType)
at Umbraco.Core.Composing.ComponentCollectionBuilder.CreateItem(IFactory factory, Type itemType)
at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Umbraco.Core.Composing.ComponentCollectionBuilder.CreateItems(IFactory factory)
at Umbraco.Core.Composing.CollectionBuilderBase`3.CreateCollection(IFactory factory)
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope)
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter)
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms)
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter)
at LightInject.ServiceContainer.CreateDelegate(Type serviceType, String serviceName, Boolean throwError)
at LightInject.ServiceContainer.CreateDefaultDelegate(Type serviceType, Boolean throwError)
at LightInject.ServiceContainer.GetInstance(Type serviceType)
at Umbraco.Core.FactoryExtensions.GetInstance[T](IFactory factory)
at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Umbraco.Core.Exceptions.BootFailedException: Boot failed: Umbraco cannot run. See Umbraco's log file for more details.
-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.
-> System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: handle
at CSharpTest.Net.IO.TransactedCompoundFile.Read(UInt32 handle)
at CSharpTest.Net.Storage.BTreeFileStoreV2.OpenRoot(Boolean& isNew)
at CSharpTest.Net.Collections.BPlusTree`2.NodeCacheNone.LoadStorage()
at CSharpTest.Net.Collections.BPlusTree`2..ctor(BPlusTreeOptions`2 ioptions)
at Umbraco.Web.PublishedCache.NuCache.DataSource.BTree.GetTree(String filepath, Boolean exists)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.MainDomRegister()
at Umbraco.Core.Runtime.MainDom.Register(Action install, Action release, Int32 weight)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService..ctor(PublishedSnapshotServiceOptions options, IMainDom mainDom, IRuntimeState runtime, ServiceContext serviceContext, IPublishedContentTypeFactory publishedContentTypeFactory, IdkMap idkMap, IPublishedSnapshotAccessor publishedSnapshotAccessor, IVariationContextAccessor variationContextAccessor, IProfilingLogger logger, IScopeProvider scopeProvider, IDocumentRepository documentRepository, IMediaRepository mediaRepository, IMemberRepository memberRepository, IDefaultCultureAccessor defaultCultureAccessor, IDataSource dataSource, IGlobalSettings globalSettings, IEntityXmlSerializer entitySerializer, IPublishedModelFactory publishedModelFactory, UrlSegmentProviderCollection urlSegmentProviders)
at DynamicMethod(Object[] )
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope)
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter)
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms)
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency)
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter)
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod)
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter)
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter)
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1()
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope)
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter)
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms)
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency)
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter)
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod)
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter)
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter)
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1()
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope)
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter)
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms)
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency)
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter)
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod)
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter)
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms)
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter)
at LightInject.ServiceContainer.CreateDelegate(Type serviceType, String serviceName, Boolean throwError)
at LightInject.ServiceContainer.CreateDefaultDelegate(Type serviceType, Boolean throwError)
at LightInject.ServiceContainer.GetInstance(Type serviceType)
at Umbraco.Core.Composing.ComponentCollectionBuilder.CreateItem(IFactory factory, Type itemType)
at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Umbraco.Core.Composing.ComponentCollectionBuilder.CreateItems(IFactory factory)
at Umbraco.Core.Composing.CollectionBuilderBase`3.CreateCollection(IFactory factory)
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope)
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter)
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms)
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter)
at LightInject.ServiceContainer.CreateDelegate(Type serviceType, String serviceName, Boolean throwError)
at LightInject.ServiceContainer.CreateDefaultDelegate(Type serviceType, Boolean throwError)
at LightInject.ServiceContainer.GetInstance(Type serviceType)
at Umbraco.Core.FactoryExtensions.GetInstance[T](IFactory factory)
at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[BootFailedException: Boot failed: Umbraco cannot run. See Umbraco's log file for more details.
-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.
-> System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: handle
at CSharpTest.Net.IO.TransactedCompoundFile.Read(UInt32 handle)
at CSharpTest.Net.Storage.BTreeFileStoreV2.OpenRoot(Boolean& isNew)
at CSharpTest.Net.Collections.BPlusTree`2.NodeCacheNone.LoadStorage()
at CSharpTest.Net.Collections.BPlusTree`2..ctor(BPlusTreeOptions`2 ioptions)
at Umbraco.Web.PublishedCache.NuCache.DataSource.BTree.GetTree(String filepath, Boolean exists)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.MainDomRegister()
at Umbraco.Core.Runtime.MainDom.Register(Action install, Action release, Int32 weight)
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService..ctor(PublishedSnapshotServiceOptions options, IMainDom mainDom, IRuntimeState runtime, ServiceContext serviceContext, IPublishedContentTypeFactory publishedContentTypeFactory, IdkMap idkMap, IPublishedSnapshotAccessor publishedSnapshotAccessor, IVariationContextAccessor variationContextAccessor, IProfilingLogger logger, IScopeProvider scopeProvider, IDocumentRepository documentRepository, IMediaRepository mediaRepository, IMemberRepository memberRepository, IDefaultCultureAccessor defaultCultureAccessor, IDataSource dataSource, IGlobalSettings globalSettings, IEntityXmlSerializer entitySerializer, IPublishedModelFactory publishedModelFactory, UrlSegmentProviderCollection urlSegmentProviders)
at DynamicMethod(Object[] )
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope)
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter)
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms)
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency)
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter)
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod)
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter)
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter)
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1()
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope)
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter)
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms)
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency)
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter)
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod)
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter)
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter)
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1()
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope)
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter)
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms)
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency)
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter)
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod)
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter)
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms)
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter)
at LightInject.ServiceContainer.CreateDelegate(Type serviceType, String serviceName, Boolean throwError)
at LightInject.ServiceContainer.CreateDefaultDelegate(Type serviceType, Boolean throwError)
at LightInject.ServiceContainer.GetInstance(Type serviceType)
at Umbraco.Core.Composing.ComponentCollectionBuilder.CreateItem(IFactory factory, Type itemType)
at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Umbraco.Core.Composing.ComponentCollectionBuilder.CreateItems(IFactory factory)
at Umbraco.Core.Composing.CollectionBuilderBase`3.CreateCollection(IFactory factory)
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope)
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter)
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms)
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter)
at LightInject.ServiceContainer.CreateDelegate(Type serviceType, String serviceName, Boolean throwError)
at LightInject.ServiceContainer.CreateDefaultDelegate(Type serviceType, Boolean throwError)
at LightInject.ServiceContainer.GetInstance(Type serviceType)
at Umbraco.Core.FactoryExtensions.GetInstance[T](IFactory factory)
at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)]
Umbraco.Core.Exceptions.BootFailedException.Rethrow(BootFailedException bootFailedException) +339
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +223
System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +220
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +94
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4200.0
I removed the App_Data\TEMP folder and was able to upgrade. I'm now running 8.6.4 and working on updating my templates and views. Hopefully the 8.7 will fix everything and I'll be able to use that when I'm ready to upgrade my production instance as this was a very long, multi-step process.
I have 8.6.4 running locally from the file system. However, when trying to run from Visual Studio the following message is shown:
Symbol loading for optimized module Umbraco.Core.dll was skipped because Just My Code is enabled
If I continue I get the following error:
Server Error in '/' Application.
Boot failed: Umbraco cannot run. See Umbraco's log file for more details.
-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.
-> System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: handle
at CSharpTest.Net.IO.TransactedCompoundFile.Read(UInt32 handle)
at CSharpTest.Net.Storage.BTreeFileStoreV2.OpenRoot(Boolean& isNew)
at CSharpTest.Net.Collections.BPlusTree`2.StorageCache.OpenRoot(Boolean& isNew)
at CSharpTest.Net.Collections.BPlusTree`2.NodeCacheNone.LoadStorage()
at CSharpTest.Net.Collections.BPlusTree`2..ctor(BPlusTreeOptions`2 ioptions)
at Umbraco.Web.PublishedCache.NuCache.DataSource.BTree.GetTree(String filepath, Boolean exists) in D:\a\1\s\src\Umbraco.Web\PublishedCache\NuCache\DataSource\BTree.cs:line 27
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.MainDomRegister() in D:\a\1\s\src\Umbraco.Web\PublishedCache\NuCache\PublishedSnapshotService.cs:line 173
at Umbraco.Core.Runtime.MainDom.Register(Action install, Action release, Int32 weight) in D:\a\1\s\src\Umbraco.Core\Runtime\MainDom.cs:line 85
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService..ctor(PublishedSnapshotServiceOptions options, IMainDom mainDom, IRuntimeState runtime, ServiceContext serviceContext, IPublishedContentTypeFactory publishedContentTypeFactory, IdkMap idkMap, IPublishedSnapshotAccessor publishedSnapshotAccessor, IVariationContextAccessor variationContextAccessor, IProfilingLogger logger, IScopeProvider scopeProvider, IDocumentRepository documentRepository, IMediaRepository mediaRepository, IMemberRepository memberRepository, IDefaultCultureAccessor defaultCultureAccessor, IDataSource dataSource, IGlobalSettings globalSettings, IEntityXmlSerializer entitySerializer, IPublishedModelFactory publishedModelFactory, UrlSegmentProviderCollection urlSegmentProviders) in D:\a\1\s\src\Umbraco.Web\PublishedCache\NuCache\PublishedSnapshotService.cs:line 127
at DynamicMethod(Object[] )
at LightInject.ServiceContainer.<>c__DisplayClass150_0.<WrapAsFuncDelegate>b__0() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3798
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4657
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 6169
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4656
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__1(IEmitter methodSkeleton) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3856
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4158
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4120
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4080
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4034
at LightInject.ServiceContainer.EmitNewInstanceWithDecorators(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3929
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__2(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3776
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4657
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 6169
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4656
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__1(IEmitter methodSkeleton) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3856
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4158
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4120
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4080
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4034
at LightInject.ServiceContainer.EmitNewInstanceWithDecorators(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3929
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__2(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3776
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4657
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 6169
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4656
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__1(IEmitter methodSkeleton) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3856
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4158
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4120
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4080
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4034
at LightInject.ServiceContainer.EmitNewInstanceWithDecorators(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3929
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__0(IEmitter methodSkeleton) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4646
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3856
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3776
at LightInject.ServiceContainer.CreateDelegate(Type serviceType, String serviceName, Boolean throwError) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4743
at LightInject.ServiceContainer.CreateDefaultDelegate(Type serviceType, Boolean throwError) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4705
at LightInject.ServiceContainer.GetInstance(Type serviceType) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3437
at Umbraco.Core.Composing.LightInject.LightInjectContainer.GetInstance(Type type) in D:\a\1\s\src\Umbraco.Core\Composing\LightInject\LightInjectContainer.cs:line 111
at Umbraco.Core.Composing.ComponentCollectionBuilder.CreateItem(IFactory factory, Type itemType) in D:\a\1\s\src\Umbraco.Core\Composing\ComponentCollectionBuilder.cs:line 33
at Umbraco.Core.Composing.CollectionBuilderBase`3.<>c__DisplayClass10_0.<CreateItems>b__0(Type x) in D:\a\1\s\src\Umbraco.Core\Composing\CollectionBuilderBase.cs:line 100
at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Umbraco.Core.Composing.CollectionBuilderBase`3.CreateItems(IFactory factory) in D:\a\1\s\src\Umbraco.Core\Composing\CollectionBuilderBase.cs:line 99
at Umbraco.Core.Composing.ComponentCollectionBuilder.CreateItems(IFactory factory) in D:\a\1\s\src\Umbraco.Core\Composing\ComponentCollectionBuilder.cs:line 25
at Umbraco.Core.Composing.CollectionBuilderBase`3.CreateCollection(IFactory factory) in D:\a\1\s\src\Umbraco.Core\Composing\CollectionBuilderBase.cs:line 117
at Umbraco.Core.Composing.LightInject.LightInjectContainer.<>c__DisplayClass20_0`1.<Register>b__0(IServiceFactory f) in D:\a\1\s\src\Umbraco.Core\Composing\LightInject\LightInjectContainer.cs:line 172
at DynamicMethod(Object[] )
at LightInject.ServiceContainer.<>c__DisplayClass150_0.<WrapAsFuncDelegate>b__0() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3798
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4657
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 6169
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4656
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__1(IEmitter methodSkeleton) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3856
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3776
at LightInject.ServiceContainer.CreateDelegate(Type serviceType, String serviceName, Boolean throwError) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4743
at LightInject.ServiceContainer.CreateDefaultDelegate(Type serviceType, Boolean throwError) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4705
at LightInject.ServiceContainer.GetInstance(Type serviceType) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3437
at Umbraco.Core.Composing.LightInject.LightInjectContainer.GetInstance(Type type) in D:\a\1\s\src\Umbraco.Core\Composing\LightInject\LightInjectContainer.cs:line 111
at Umbraco.Core.FactoryExtensions.GetInstance[T](IFactory factory) in D:\a\1\s\src\Umbraco.Core\FactoryExtensions.cs:line 22
at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer) in D:\a\1\s\src\Umbraco.Core\Runtime\CoreRuntime.cs:line 187
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Umbraco.Core.Exceptions.BootFailedException: Boot failed: Umbraco cannot run. See Umbraco's log file for more details.
-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.
-> System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: handle
at CSharpTest.Net.IO.TransactedCompoundFile.Read(UInt32 handle)
at CSharpTest.Net.Storage.BTreeFileStoreV2.OpenRoot(Boolean& isNew)
at CSharpTest.Net.Collections.BPlusTree`2.StorageCache.OpenRoot(Boolean& isNew)
at CSharpTest.Net.Collections.BPlusTree`2.NodeCacheNone.LoadStorage()
at CSharpTest.Net.Collections.BPlusTree`2..ctor(BPlusTreeOptions`2 ioptions)
at Umbraco.Web.PublishedCache.NuCache.DataSource.BTree.GetTree(String filepath, Boolean exists) in D:\a\1\s\src\Umbraco.Web\PublishedCache\NuCache\DataSource\BTree.cs:line 27
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.MainDomRegister() in D:\a\1\s\src\Umbraco.Web\PublishedCache\NuCache\PublishedSnapshotService.cs:line 173
at Umbraco.Core.Runtime.MainDom.Register(Action install, Action release, Int32 weight) in D:\a\1\s\src\Umbraco.Core\Runtime\MainDom.cs:line 85
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService..ctor(PublishedSnapshotServiceOptions options, IMainDom mainDom, IRuntimeState runtime, ServiceContext serviceContext, IPublishedContentTypeFactory publishedContentTypeFactory, IdkMap idkMap, IPublishedSnapshotAccessor publishedSnapshotAccessor, IVariationContextAccessor variationContextAccessor, IProfilingLogger logger, IScopeProvider scopeProvider, IDocumentRepository documentRepository, IMediaRepository mediaRepository, IMemberRepository memberRepository, IDefaultCultureAccessor defaultCultureAccessor, IDataSource dataSource, IGlobalSettings globalSettings, IEntityXmlSerializer entitySerializer, IPublishedModelFactory publishedModelFactory, UrlSegmentProviderCollection urlSegmentProviders) in D:\a\1\s\src\Umbraco.Web\PublishedCache\NuCache\PublishedSnapshotService.cs:line 127
at DynamicMethod(Object[] )
at LightInject.ServiceContainer.<>c__DisplayClass150_0.<WrapAsFuncDelegate>b__0() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3798
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4657
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 6169
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4656
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__1(IEmitter methodSkeleton) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3856
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4158
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4120
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4080
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4034
at LightInject.ServiceContainer.EmitNewInstanceWithDecorators(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3929
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__2(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3776
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4657
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 6169
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4656
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__1(IEmitter methodSkeleton) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3856
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4158
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4120
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4080
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4034
at LightInject.ServiceContainer.EmitNewInstanceWithDecorators(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3929
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__2(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3776
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4657
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 6169
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4656
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__1(IEmitter methodSkeleton) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3856
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4158
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4120
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4080
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4034
at LightInject.ServiceContainer.EmitNewInstanceWithDecorators(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3929
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__0(IEmitter methodSkeleton) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4646
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3856
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3776
at LightInject.ServiceContainer.CreateDelegate(Type serviceType, String serviceName, Boolean throwError) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4743
at LightInject.ServiceContainer.CreateDefaultDelegate(Type serviceType, Boolean throwError) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4705
at LightInject.ServiceContainer.GetInstance(Type serviceType) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3437
at Umbraco.Core.Composing.LightInject.LightInjectContainer.GetInstance(Type type) in D:\a\1\s\src\Umbraco.Core\Composing\LightInject\LightInjectContainer.cs:line 111
at Umbraco.Core.Composing.ComponentCollectionBuilder.CreateItem(IFactory factory, Type itemType) in D:\a\1\s\src\Umbraco.Core\Composing\ComponentCollectionBuilder.cs:line 33
at Umbraco.Core.Composing.CollectionBuilderBase`3.<>c__DisplayClass10_0.<CreateItems>b__0(Type x) in D:\a\1\s\src\Umbraco.Core\Composing\CollectionBuilderBase.cs:line 100
at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Umbraco.Core.Composing.CollectionBuilderBase`3.CreateItems(IFactory factory) in D:\a\1\s\src\Umbraco.Core\Composing\CollectionBuilderBase.cs:line 99
at Umbraco.Core.Composing.ComponentCollectionBuilder.CreateItems(IFactory factory) in D:\a\1\s\src\Umbraco.Core\Composing\ComponentCollectionBuilder.cs:line 25
at Umbraco.Core.Composing.CollectionBuilderBase`3.CreateCollection(IFactory factory) in D:\a\1\s\src\Umbraco.Core\Composing\CollectionBuilderBase.cs:line 117
at Umbraco.Core.Composing.LightInject.LightInjectContainer.<>c__DisplayClass20_0`1.<Register>b__0(IServiceFactory f) in D:\a\1\s\src\Umbraco.Core\Composing\LightInject\LightInjectContainer.cs:line 172
at DynamicMethod(Object[] )
at LightInject.ServiceContainer.<>c__DisplayClass150_0.<WrapAsFuncDelegate>b__0() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3798
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4657
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 6169
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4656
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__1(IEmitter methodSkeleton) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3856
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3776
at LightInject.ServiceContainer.CreateDelegate(Type serviceType, String serviceName, Boolean throwError) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4743
at LightInject.ServiceContainer.CreateDefaultDelegate(Type serviceType, Boolean throwError) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4705
at LightInject.ServiceContainer.GetInstance(Type serviceType) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3437
at Umbraco.Core.Composing.LightInject.LightInjectContainer.GetInstance(Type type) in D:\a\1\s\src\Umbraco.Core\Composing\LightInject\LightInjectContainer.cs:line 111
at Umbraco.Core.FactoryExtensions.GetInstance[T](IFactory factory) in D:\a\1\s\src\Umbraco.Core\FactoryExtensions.cs:line 22
at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer) in D:\a\1\s\src\Umbraco.Core\Runtime\CoreRuntime.cs:line 187
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[BootFailedException: Boot failed: Umbraco cannot run. See Umbraco's log file for more details.
-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.
-> System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: handle
at CSharpTest.Net.IO.TransactedCompoundFile.Read(UInt32 handle)
at CSharpTest.Net.Storage.BTreeFileStoreV2.OpenRoot(Boolean& isNew)
at CSharpTest.Net.Collections.BPlusTree`2.StorageCache.OpenRoot(Boolean& isNew)
at CSharpTest.Net.Collections.BPlusTree`2.NodeCacheNone.LoadStorage()
at CSharpTest.Net.Collections.BPlusTree`2..ctor(BPlusTreeOptions`2 ioptions)
at Umbraco.Web.PublishedCache.NuCache.DataSource.BTree.GetTree(String filepath, Boolean exists) in D:\a\1\s\src\Umbraco.Web\PublishedCache\NuCache\DataSource\BTree.cs:line 27
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService.MainDomRegister() in D:\a\1\s\src\Umbraco.Web\PublishedCache\NuCache\PublishedSnapshotService.cs:line 173
at Umbraco.Core.Runtime.MainDom.Register(Action install, Action release, Int32 weight) in D:\a\1\s\src\Umbraco.Core\Runtime\MainDom.cs:line 85
at Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService..ctor(PublishedSnapshotServiceOptions options, IMainDom mainDom, IRuntimeState runtime, ServiceContext serviceContext, IPublishedContentTypeFactory publishedContentTypeFactory, IdkMap idkMap, IPublishedSnapshotAccessor publishedSnapshotAccessor, IVariationContextAccessor variationContextAccessor, IProfilingLogger logger, IScopeProvider scopeProvider, IDocumentRepository documentRepository, IMediaRepository mediaRepository, IMemberRepository memberRepository, IDefaultCultureAccessor defaultCultureAccessor, IDataSource dataSource, IGlobalSettings globalSettings, IEntityXmlSerializer entitySerializer, IPublishedModelFactory publishedModelFactory, UrlSegmentProviderCollection urlSegmentProviders) in D:\a\1\s\src\Umbraco.Web\PublishedCache\NuCache\PublishedSnapshotService.cs:line 127
at DynamicMethod(Object[] )
at LightInject.ServiceContainer.<>c__DisplayClass150_0.<WrapAsFuncDelegate>b__0() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3798
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4657
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 6169
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4656
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__1(IEmitter methodSkeleton) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3856
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4158
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4120
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4080
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4034
at LightInject.ServiceContainer.EmitNewInstanceWithDecorators(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3929
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__2(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3776
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4657
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 6169
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4656
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__1(IEmitter methodSkeleton) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3856
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4158
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4120
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4080
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4034
at LightInject.ServiceContainer.EmitNewInstanceWithDecorators(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3929
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__2(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3776
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4657
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 6169
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4656
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__1(IEmitter methodSkeleton) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3856
at LightInject.ServiceContainer.EmitConstructorDependency(IEmitter emitter, Dependency dependency) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4158
at LightInject.ServiceContainer.EmitConstructorDependencies(ConstructionInfo constructionInfo, IEmitter emitter, Action`1 decoratorTargetEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4120
at LightInject.ServiceContainer.EmitNewInstanceUsingImplementingType(IEmitter emitter, ConstructionInfo constructionInfo, Action`1 decoratorTargetEmitMethod) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4080
at LightInject.ServiceContainer.EmitNewInstance(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4034
at LightInject.ServiceContainer.EmitNewInstanceWithDecorators(ServiceRegistration serviceRegistration, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3929
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__0(IEmitter methodSkeleton) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4646
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3856
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3776
at LightInject.ServiceContainer.CreateDelegate(Type serviceType, String serviceName, Boolean throwError) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4743
at LightInject.ServiceContainer.CreateDefaultDelegate(Type serviceType, Boolean throwError) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4705
at LightInject.ServiceContainer.GetInstance(Type serviceType) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3437
at Umbraco.Core.Composing.LightInject.LightInjectContainer.GetInstance(Type type) in D:\a\1\s\src\Umbraco.Core\Composing\LightInject\LightInjectContainer.cs:line 111
at Umbraco.Core.Composing.ComponentCollectionBuilder.CreateItem(IFactory factory, Type itemType) in D:\a\1\s\src\Umbraco.Core\Composing\ComponentCollectionBuilder.cs:line 33
at Umbraco.Core.Composing.CollectionBuilderBase`3.<>c__DisplayClass10_0.<CreateItems>b__0(Type x) in D:\a\1\s\src\Umbraco.Core\Composing\CollectionBuilderBase.cs:line 100
at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Umbraco.Core.Composing.CollectionBuilderBase`3.CreateItems(IFactory factory) in D:\a\1\s\src\Umbraco.Core\Composing\CollectionBuilderBase.cs:line 99
at Umbraco.Core.Composing.ComponentCollectionBuilder.CreateItems(IFactory factory) in D:\a\1\s\src\Umbraco.Core\Composing\ComponentCollectionBuilder.cs:line 25
at Umbraco.Core.Composing.CollectionBuilderBase`3.CreateCollection(IFactory factory) in D:\a\1\s\src\Umbraco.Core\Composing\CollectionBuilderBase.cs:line 117
at Umbraco.Core.Composing.LightInject.LightInjectContainer.<>c__DisplayClass20_0`1.<Register>b__0(IServiceFactory f) in D:\a\1\s\src\Umbraco.Core\Composing\LightInject\LightInjectContainer.cs:line 172
at DynamicMethod(Object[] )
at LightInject.ServiceContainer.<>c__DisplayClass150_0.<WrapAsFuncDelegate>b__0() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3798
at LightInject.ServiceContainer.<>c__DisplayClass198_0.<EmitLifetime>b__1() in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4657
at LightInject.PerContainerLifetime.GetInstance(Func`1 createInstance, Scope scope) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 6169
at LightInject.ServiceContainer.EmitLifetime(ServiceRegistration serviceRegistration, Action`1 emitMethod, IEmitter emitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4656
at LightInject.ServiceContainer.<>c__DisplayClass197_0.<ResolveEmitMethod>b__1(IEmitter methodSkeleton) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4649
at LightInject.ServiceContainer.<>c__DisplayClass153_0.<CreateEmitMethodWrapper>b__0(IEmitter ms) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3856
at LightInject.ServiceContainer.CreateDynamicMethodDelegate(Action`1 serviceEmitter) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3776
at LightInject.ServiceContainer.CreateDelegate(Type serviceType, String serviceName, Boolean throwError) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4743
at LightInject.ServiceContainer.CreateDefaultDelegate(Type serviceType, Boolean throwError) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 4705
at LightInject.ServiceContainer.GetInstance(Type serviceType) in C:\projects\lightinject\src\LightInject\LightInject.cs:line 3437
at Umbraco.Core.Composing.LightInject.LightInjectContainer.GetInstance(Type type) in D:\a\1\s\src\Umbraco.Core\Composing\LightInject\LightInjectContainer.cs:line 111
at Umbraco.Core.FactoryExtensions.GetInstance[T](IFactory factory) in D:\a\1\s\src\Umbraco.Core\FactoryExtensions.cs:line 22
at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer) in D:\a\1\s\src\Umbraco.Core\Runtime\CoreRuntime.cs:line 187]
Umbraco.Core.Exceptions.BootFailedException.Rethrow(BootFailedException bootFailedException) in D:\a\1\s\src\Umbraco.Core\Exceptions\BootFailedException.cs:80
Umbraco.Web.<>c.<Init>b__18_0(Object sender, EventArgs args) in D:\a\1\s\src\Umbraco.Web\UmbracoInjectedModule.cs:369
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +201
System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +132
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +73
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4200.0
It seems that to run in Visual Studio I get a boot error unless I delete the App_Data\TEMP folder before debugging. Is there a workaround for this final issue?
Migration from 7.14 to 8
Hi All, I am following steps written on https://our.umbraco.com/documentation/getting-started/setup/upgrading/migrating-to-v8 . But I am getting following error
Error during installation The database failed to upgrade. ERROR: The database configuration failed with the following message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. Please check log file for additional information (can be found in '/App_Data/Logs/')
Also log is not helping to debug the issue.
Did you try increasing the remote query timeout of the db in management studio? I've had this issue before with other upgrades. just want to make sure to put it back to something reasonable when you're done
Hey , you can add a connection timeout to your SQL connection string in your web.config.
connection timeout = {Milliseconds}
I tried and passed the above error and now i am getting following error
Error during installation The database failed to upgrade. ERROR: The database configuration failed with the following message: Invalid column name 'versionId'. Please check log file for additional information (can be found in '/App_Data/Logs/')
See the log for full details (logs can typically be found in the App_Data\Logs folder).
Hi,
Do you have a backup of your'e old Database? I think this issue is occuring because it started the migration but didn't finish because of the time out.
-Joep
Thanks for reply , I do have back up of old DB. i will start migration with new DB which i copied .
hi Joep , I tried with copy of my DB , still I am getting following error
The database failed to upgrade. ERROR: The database configuration failed with the following message: Invalid column name 'versionId'. Please check log file for additional information (can be found in '/App_Data/Logs/')
How is it going? Does the log state the same error or does it have any further info?
Did you try to upgrade your Umbraco install to 7.15 and check for no errors? (I know the walk-through mentions 7.14) I have seen many changes since the article was written.
I am using 7.15.1. I tried to update to 7.15.3 but unable to update and getting lots of error. Unable to do migration to 8+ Versions
Log for me is giving an error like this. Going from version 7.15.3 to 8.5.3. I've tried using the umbraco pre-migration health check plugin to see if there might be any issues but everything checked out fine. This is the log with the first line of the error and the last normal line before the error. There are a few more lines in the error but it's mostly the same except for a line telling me what was found in the db that isn't in the schema such as UCondition tables and other pieces.
Could you share the whole log file? I think I could cause this error on purpose by modifying the
cmsPropertyData
table to make the migration process skip some steps, but then the database wouldn't have been working in 7.15.3. Seeing the earlier steps in the log might let me narrow down what's happening.Here is the file from the import I retired this morning. I've set it to expire in one day on pastebin because it was a long enough log I wanted to not make the thread difficult to read.
FILE
How strange, that all looks normal. As far as I can see, the query that's likely to be failing shouldn't be trying to use any
versionId
columns at all.Well any insights to move forward would be appreciated. It's been something I've been trying to bang my head against for awhile now.
If you're able to share your database without revealing anything confidential, I'd be happy to take a closer look. Alternatively, I could give you a version of
Umbraco.Core.dll
that enables debug logging of database queries, which should show us exactly what the failing query is.The dll would be good. Positive I’d not be allowed to share the db.
This file should work with 8.5.3. You'll need to set the minimum log level to debug too. Expect it to make the log file much bigger.
So I did get a much bigger log. Is there something I should look at in there? The obvious new line at the end part is a different stack trace withe the migration part pointing to Umbraco.Core.Migrations.Upgrade.V80_0.VariantsMigration.MigrateVersions()
Here is the last few lines before the crash
Here is the last few lines before the crash
I have downloaded the 8.5.3 tagged version of Umbraco from git and was pointing my project to use the code there. It seems to be failing on the command to set the new edited column on the documents table to 0
Well that's just weird. I'd hoped that it was getting to the next "set 'edited' to true whenever a 'non-published' property data is != a published one" step since that at least refers to columns called versionId. I really don't see how it can get that error from
UPDATE cmsDocument SET edited=0
. We've deleted theversionId
column fromcmsDocument
at this point, but anything like indexes that depended on the column should have caused an error when the column was deleted.I'm really confused on why it would be an issue there. I notice that versionId is the primary key on the table. Not sure if something needs to be done to change it to not be a primary key before deleting it. I noticed that the table doesn't even exist in the new db i created to see what's in 8.5.3. I'm wondering if the db is missing a migration somewhere.
I had this happen with really large DBs that had tons of old versions of the page. I use this to clean up: https://gist.github.com/genckastrati/52413af6246078d6b9c35edf9a7ec4c0
Of course, make sure you have backups, dont do this on a live or production DB!
I tried that and still didn't help.
Did you solve it? I am having exactly the same issue that says:
and sort of log that you were getting.
I am trying to upgrade the database from 7.15.3 to 8.2.1.
step 1 : Just back up your source code
step 2 : Then update your current Umbraco version say 7.12.3 to 7.15.0 through Nuget package manager .
step 3 : keep the current updated database
step 4 : Create a new visual studio mvc solution with .Net framework 4.7.2 latest
step 5 : Install Umbraco 8.0 in it . configure the database and Backoffice
step 6 :
Change the version 8.0.0 to 7.15.0 in the new created Visual studio solution wen.config file
step 7 : just change the Database connection in newly created Umbraco8 with previous 7.15.0 Database .
step 8 : just run the umbraco 8 . It will take too much time . because alter and update scripts are running in background .If you want to see it . just open App_Data -> Log folder there is umbracotracelog folder.
step 9 : if any error occured just repeat the step 1 - 8 again with fresh 7.12.3 Database
step 10 ; copy all the media , asset , view files and moved to 7.15.0 to umbraco 8
step 11 : Now there is a big change in code .. The code in 7.12.3 will not support 8 version
Recently I have started working on upgrading my client's Umbraco v7.15.4 website to Umbraco v8.6.3 (current latest version) and experienced a lot of problems.
In order to help my future self and fellow Umbraco Developers, I've written a blog about my experience with v8, hope it helps.
I am having the same problems upgrading from 7.15.5 to 8.6.3 and today trying 8.6.4. I would be happy to provide a BAK of the database and my log files if that will help with troubleshooting these upgrade issues that seem to be affecting a large number of users.
Thank you,
Brad
I just managed to complete a migration but had to do an inbetween step by upgrading the database on 8.2.1 first. I.e. used this path:
7.15.5 > 8.2.1 > 8.6.3
Not ideal I know but it works.
I just tried that and 7.15.5 to 8.2.1 did not work for me. The end of my log file is:
I do remember getting an error too but the upgrade went through anyway. In fact I ran this process probably +10 times to test and be sure, and each time after the 8.2.1 upgrade process, I ended up with some error yet the upgrade was completed. Maybe this is a different issue however, unfortunately I have not kept those logs to compare sorry :(
That looks like a timeout that should be fixed in 8.7.0, but until that is released there's a custom build of 8.2.0 here which includes the fix. If that works to get you upgraded to 8.2.0, you should then be able to upgrade to a standard build of 8.6.x.
That still didn't work for me. The initial error I received had to do with obsolete datatype members. I removed those and tried again and got the following error:
That looks like this issue, caused by large property values. The fix suggested there is:
<add key="Umbraco.Web.PublishedCache.NuCache.BTree.BlockSize" value="8192" />
toappSettings
.App_Data\TEMP
.Still no luck. I received the following:
I increased the value to 32768 and was able to upgrade to 8.2.0. Now I'll try to get to the latest version.
So close. The 8.2.0 upgrade worked and ran. Then, when I attempted to upgrade to 8.6.4 the upgrade completed, then restarted with the following error:
I removed the App_Data\TEMP folder and was able to upgrade. I'm now running 8.6.4 and working on updating my templates and views. Hopefully the 8.7 will fix everything and I'll be able to use that when I'm ready to upgrade my production instance as this was a very long, multi-step process.
Thank you,
Brad
I have 8.6.4 running locally from the file system. However, when trying to run from Visual Studio the following message is shown:
If I continue I get the following error:
It seems that to run in Visual Studio I get a boot error unless I delete the App_Data\TEMP folder before debugging. Is there a workaround for this final issue?
is working on a reply...