Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • vijaya shivgand 23 posts 122 karma points
    Jan 07, 2020 @ 21:25
    vijaya shivgand
    0

    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.

  • Amir Khan 1054 posts 2178 karma points
    Jan 07, 2020 @ 22:26
    Amir Khan
    1

    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

  • Joep 70 posts 470 karma points
    Jan 08, 2020 @ 08:44
    Joep
    1

    Hey , you can add a connection timeout to your SQL connection string in your web.config. connection timeout = {Milliseconds}

  • vijaya shivgand 23 posts 122 karma points
    Jan 13, 2020 @ 16:03
    vijaya shivgand
    0

    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).

  • Joep 70 posts 470 karma points
    Jan 13, 2020 @ 16:07
    Joep
    0

    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

  • vijaya shivgand 23 posts 122 karma points
    Jan 13, 2020 @ 16:10
    vijaya shivgand
    0

    Thanks for reply , I do have back up of old DB. i will start migration with new DB which i copied .

  • vijaya shivgand 23 posts 122 karma points
    Jan 13, 2020 @ 19:35
    vijaya shivgand
    0

    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/')

  • Brett Spencer 84 posts 254 karma points
    Jan 13, 2020 @ 20:33
    Brett Spencer
    0

    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.

  • vijaya shivgand 23 posts 122 karma points
    Jan 14, 2020 @ 19:24
    vijaya shivgand
    0

    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

  • prial 9 posts 78 karma points
    Feb 17, 2020 @ 19:18
    prial
    0

    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
    }
    
  • Steve Megson 148 posts 940 karma points MVP c-trib
    Feb 18, 2020 @ 10:42
    Steve Megson
    0

    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.

  • prial 9 posts 78 karma points
    Feb 18, 2020 @ 14:10
    prial
    0

    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

  • Steve Megson 148 posts 940 karma points MVP c-trib
    Feb 19, 2020 @ 12:40
    Steve Megson
    0

    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.

  • prial 9 posts 78 karma points
    Feb 19, 2020 @ 19:30
    prial
    0

    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.

  • Steve Megson 148 posts 940 karma points MVP c-trib
    Feb 20, 2020 @ 09:29
    Steve Megson
    0

    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.

  • prial 9 posts 78 karma points
    Feb 20, 2020 @ 11:53
    prial
    0

    The dll would be good. Positive I’d not be allowed to share the db.

  • Steve Megson 148 posts 940 karma points MVP c-trib
    Feb 20, 2020 @ 12:53
    Steve Megson
    0

    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.

  • prial 9 posts 78 karma points
    Feb 26, 2020 @ 19:31
    prial
    0

    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
    }
    
  • prial 9 posts 78 karma points
    Feb 26, 2020 @ 19:38
    prial
    0

    Here is the last few lines before the crash

    {"@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"}
    
  • prial 9 posts 78 karma points
    Feb 26, 2020 @ 20:34
    prial
    0

    Here is the last few lines before the crash

    {"@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");
    
  • Steve Megson 148 posts 940 karma points MVP c-trib
    Feb 27, 2020 @ 11:03
    Steve Megson
    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.

  • prial 9 posts 78 karma points
    Feb 27, 2020 @ 16:17
    prial
    0

    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.

    enter image description here

  • Genc Kastrati 71 posts 325 karma points
    Feb 25, 2020 @ 11:55
    Genc Kastrati
    0

    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!

  • prial 9 posts 78 karma points
    Feb 26, 2020 @ 19:31
    prial
    0

    I tried that and still didn't help.

  • Ebin 9 posts 78 karma points
    Feb 27, 2020 @ 12:58
    Ebin
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft