Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Booting error - AddFormKeysAndIndexes migration #559

Closed
bjarnef opened this issue May 11, 2021 · 7 comments
Closed

Booting error - AddFormKeysAndIndexes migration #559

bjarnef opened this issue May 11, 2021 · 7 comments

Comments

@bjarnef
Copy link

bjarnef commented May 11, 2021

I have upgraded an Umbraco Cloud project til Umbraco 8.13.0 and Umbraco Forms 8.7.2, which works fine on development and live environment.

However when pulling changes down locally I get an "Boot Failed" error, which seems to be related to AddFormKeysAndIndexes in the migration. In have previous upgraded two other project to Umbraco 8.13.0 and Umbraco Forms 8.7.1 without issues. Locally these projects are using LocalDB, where the project is using SQL CE.

{"@t":"2021-05-11T21:35:05.1767823Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Booting Umbraco 8.13.0.","TimingId":"4e52887","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:05.1897473Z","@mt":"Booting site '{HostingSiteName}', app '{HostingApplicationID}', path '{HostingPhysicalPath}', server '{MachineName}'.","HostingSiteName":"mysite.dk","HostingApplicationID":"/LM/W3SVC/2/ROOT","HostingPhysicalPath":"C:\\VSProjects\\myproject\\MyProject.Web\\","MachineName":"LAPTOP-TVMJ2DRH","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:05.1947295Z","@mt":"IsAzureSql: false.","SourceContext":"Umbraco.Deploy.Cloud.Initializing.ConnectionStringInitializer","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:05.1967228Z","@mt":"Local database: configured with SqlCe.","SourceContext":"Umbraco.Deploy.Cloud.Initializing.ConnectionStringInitializer","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:05.1987181Z","@mt":"Local database: a SqlCe database exists, using SqlCe.","SourceContext":"Umbraco.Deploy.Cloud.Initializing.ConnectionStringInitializer","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:05.1987181Z","@mt":"Overriding settings with a SqlCe connection string.","SourceContext":"Umbraco.Deploy.Cloud.Initializing.ConnectionStringInitializer","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:05.2615459Z","@mt":"IsAzureSql: false.","SourceContext":"Umbraco.Deploy.Cloud.Initializing.DatabaseInitializer","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:05.2635390Z","@mt":"Configured with SqlCe database.","SourceContext":"Umbraco.Deploy.Cloud.Initializing.DatabaseInitializer","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:05.2675318Z","@mt":"Acquiring.","SourceContext":"Umbraco.Core.Runtime.MainDom","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:05.2695298Z","@mt":"Acquired.","SourceContext":"Umbraco.Core.Runtime.MainDom","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:05.9758504Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Resolving composer types.","TimingId":"a435cf8","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:06.2411012Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Resolved.","Duration":264,"TimingId":"a435cf8","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:07.2045231Z","@mt":"Registered with MainDom, localContentDbExists? {LocalContentDbExists}, localMediaDbExists? {LocalMediaDbExists}","LocalContentDbExists":true,"LocalMediaDbExists":true,"SourceContext":"Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:07.2055210Z","@mt":"Creating the content store, localContentDbExists? {LocalContentDbExists}","LocalContentDbExists":true,"SourceContext":"Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:07.2085134Z","@mt":"Creating the media store, localMediaDbExists? {LocalMediaDbExists}","LocalMediaDbExists":true,"SourceContext":"Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:07.7062238Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Loading content from local cache file","TimingId":"8d7ade0","SourceContext":"Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:07.7590867Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Completed.","Duration":52,"TimingId":"8d7ade0","SourceContext":"Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:07.8026740Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Loading media from local cache file","TimingId":"0c4e15e","SourceContext":"Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:07.8036286Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Completed.","Duration":1,"TimingId":"0c4e15e","SourceContext":"Umbraco.Web.PublishedCache.NuCache.PublishedSnapshotService","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:08.0506615Z","@mt":"Profiler is VoidProfiler, not profiling (must run debug mode to profile).","SourceContext":"Umbraco.Web.Logging.WebProfilerComponent","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.2195342Z","@mt":"Mapped {messageType} -> {queueName}","messageType":"Concorde.Messaging.Contracts.Messages.SendEditorInviteRequest","queueName":"concorde.mainservice.receiver","SourceContext":"Rebus.Routing.TypeBased.TypeBasedRouter","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.2205324Z","@mt":"Mapped {messageType} -> {queueName}","messageType":"Concorde.Messaging.Contracts.Messages.CopyAndCommitFilesWithIdentifierRequest","queueName":"concorde.mainservice.receiver","SourceContext":"Rebus.Routing.TypeBased.TypeBasedRouter","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.2205324Z","@mt":"Mapped {messageType} -> {queueName}","messageType":"Concorde.Messaging.Contracts.Messages.RemoveAndCommitFilesWithIdentifierRequest","queueName":"concorde.mainservice.receiver","SourceContext":"Rebus.Routing.TypeBased.TypeBasedRouter","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.2374860Z","@mt":"Bus {busName} started","busName":"Rebus 1","SourceContext":"Rebus.Bus.RebusBus","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.3821358Z","@mt":"Initializing Umbraco internal event handlers for cache refreshing.","SourceContext":"Umbraco.Web.Cache.DistributedCacheBinderComponent","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.4379877Z","@mt":"Adding examine event handlers for {RegisteredIndexers} index providers.","RegisteredIndexers":3,"SourceContext":"Umbraco.Web.Search.ExamineComponent","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.5501038Z","@mt":"Starting '{MigrationName}'...","MigrationName":"Deploy.Migration","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.5501038Z","@mt":"At {OrigState}","OrigState":"{737db8d6-c51c-47c8-8509-19320dcf9243}","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.5511034Z","@mt":"Done (pending scope completion).","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.5829896Z","@mt":"{StartMessage} [Timing {TimingId}]","StartMessage":"Start Cloud","TimingId":"e902a91","SourceContext":"Umbraco.Deploy.Cloud.DeployCloudComponent","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.5829896Z","@mt":"Starting :: Running locally","SourceContext":"Umbraco.Deploy.Cloud.DeployCloudComponent","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.5859807Z","@mt":"Started :: Running {edition} edition","edition":"Default","SourceContext":"Umbraco.Deploy.Cloud.DeployCloudComponent","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.5859807Z","@mt":"{EndMessage} ({Duration}ms) [Timing {TimingId}]","EndMessage":"Completed.","Duration":3,"TimingId":"e902a91","SourceContext":"Umbraco.Deploy.Cloud.DeployCloudComponent","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.5909686Z","@mt":"Subscribing to FileService and ContentService events","SourceContext":"Umbraco.Deploy.Cloud.LiveEditing.EventSubscriber","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.6333398Z","@mt":"Starting '{MigrationName}'...","MigrationName":"UmbracoForms","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.6333398Z","@mt":"At {OrigState}","OrigState":"1d084819-84ba-4ac7-b152-2c3d167d22bc","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.6333398Z","@mt":"Execute {MigrationType}","MigrationType":"AddRecordKeysAndIndexes","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.6931875Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":0,"Sql":"ALTER TABLE [UFRecordDataBit] ADD CONSTRAINT [PK_UFRecordDataBit] PRIMARY KEY ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Create.Expressions.CreateConstraintExpression","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.6991754Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":1,"Sql":"ALTER TABLE [UFRecordDataDateTime] ADD CONSTRAINT [PK_UFRecordDataDateTime] PRIMARY KEY ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Create.Expressions.CreateConstraintExpression","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.7021222Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":2,"Sql":"ALTER TABLE [UFRecordDataInteger] ADD CONSTRAINT [PK_UFRecordDataInteger] PRIMARY KEY ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Create.Expressions.CreateConstraintExpression","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.7051148Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":3,"Sql":"ALTER TABLE [UFRecordDataLongString] ADD CONSTRAINT [PK_UFRecordDataLongString] PRIMARY KEY ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Create.Expressions.CreateConstraintExpression","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.7171473Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":4,"Sql":"ALTER TABLE [UFRecordFields] ADD CONSTRAINT [FK_UFRecordFields_UFRecords_Record] FOREIGN KEY ([Record]) REFERENCES [UFRecords] ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateForeignKeyExpression","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.7221088Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":5,"Sql":"ALTER TABLE [UFRecordDataBit] ADD CONSTRAINT [FK_UFRecordDataBit_UFRecordFields_Key] FOREIGN KEY ([Key]) REFERENCES [UFRecordFields] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateForeignKeyExpression","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.7260583Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":6,"Sql":"ALTER TABLE [UFRecordDataDateTime] ADD CONSTRAINT [FK_UFRecordDataDateTime_UFRecordFields_Key] FOREIGN KEY ([Key]) REFERENCES [UFRecordFields] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateForeignKeyExpression","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.7300491Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":7,"Sql":"ALTER TABLE [UFRecordDataInteger] ADD CONSTRAINT [FK_UFRecordDataInteger_UFRecordFields_Key] FOREIGN KEY ([Key]) REFERENCES [UFRecordFields] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateForeignKeyExpression","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.7350375Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":8,"Sql":"ALTER TABLE [UFRecordDataLongString] ADD CONSTRAINT [FK_UFRecordDataLongString_UFRecordFields_Key] FOREIGN KEY ([Key]) REFERENCES [UFRecordFields] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateForeignKeyExpression","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.7440124Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":9,"Sql":"CREATE NONCLUSTERED INDEX [IX_UFRecordDataBit_Key] ON [UFRecordDataBit] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateIndexExpression","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.7499962Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":10,"Sql":"CREATE NONCLUSTERED INDEX [IX_UFRecordDataDateTime_Key] ON [UFRecordDataDateTime] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateIndexExpression","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.7560351Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":11,"Sql":"CREATE NONCLUSTERED INDEX [IX_UFRecordDataInteger_Key] ON [UFRecordDataInteger] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateIndexExpression","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.7649552Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":12,"Sql":"CREATE NONCLUSTERED INDEX [IX_UFRecordDataLongString_Key] ON [UFRecordDataLongString] ([Key])","SourceContext":"Umbraco.Core.Migrations.Expressions.Common.Expressions.CreateIndexExpression","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.7709838Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":13,"Sql":"ALTER TABLE [UFUserSecurity] ADD CONSTRAINT [PK_UFUserSecurity] PRIMARY KEY ([User])","SourceContext":"Umbraco.Core.Migrations.Expressions.Create.Expressions.CreateConstraintExpression","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.7739324Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":14,"Sql":"ALTER TABLE [UFUserFormSecurity] ADD CONSTRAINT [PK_UFUserFormSecurity] PRIMARY KEY ([Id])","SourceContext":"Umbraco.Core.Migrations.Expressions.Create.Expressions.CreateConstraintExpression","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.7799532Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":15,"Sql":"ALTER TABLE [UFUserFormSecurity] ADD CONSTRAINT [UK_UFUserFormSecurity_User_Form] UNIQUE ([User], [Form])","SourceContext":"Umbraco.Core.Migrations.Expressions.Create.Expressions.CreateConstraintExpression","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.7799532Z","@mt":"At {OrigState}","OrigState":"6822cdca-1dc4-4983-b189-9c45314e8747","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.7799532Z","@mt":"Execute {MigrationType}","MigrationType":"AddFormsDbStorage","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.8008989Z","@mt":"At {OrigState}","OrigState":"a4c1b3ba-7dc9-42b0-86db-1212d7e18431","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.8008989Z","@mt":"Execute {MigrationType}","MigrationType":"AddFormKeysAndIndexes","SourceContext":"Umbraco.Core.Migrations.MigrationPlan","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"INFO ","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.8048478Z","@mt":"Exception ({InstanceId}).","@l":"Error","@x":"System.InvalidCastException: Object must implement IConvertible.\r\n   at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)\r\n   at NPoco.MappingFactory.Map(DbDataReader dataReader, Object instance)\r\n   at NPoco.Database.<Read>d__156`1.MoveNext()","InstanceId":"0e1e0371","SourceContext":"Umbraco.Core.Persistence.UmbracoDatabase","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"ERROR","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:09.9531735Z","@mt":"{FailMessage} ({Duration}ms) [Timing {TimingId}]","@l":"Error","@x":"Umbraco.Core.Exceptions.BootFailedException: Boot failed. ---> System.InvalidCastException: Object must implement IConvertible.\r\n   at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)\r\n   at NPoco.MappingFactory.Map(DbDataReader dataReader, Object instance)\r\n   at NPoco.Database.<Read>d__156`1.MoveNext()\r\n   at NPoco.Database.<QueryImp>d__164`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Umbraco.Forms.Core.Migrations.FormsMigrationBase.GetDistinctRecordCount[TDto](String[] columns)\r\n   at Umbraco.Forms.Core.Migrations.FormsMigrationBase.ContainsDuplicates[TDto](String[] columns)\r\n   at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddUniqueConstraint[TDto](String table, String[] columns)\r\n   at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddUniqueConstraint[TDto](String table, String column)\r\n   at Umbraco.Forms.Core.Migrations.V_8_7_0.AddFormKeysAndIndexes.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.Forms.Core.Components.UmbracoFormsComponent.ExecuteDatabaseUpgrades()\r\n   at Umbraco.Forms.Core.Components.UmbracoFormsComponent.Initialize()\r\n   at Umbraco.Core.Composing.ComponentCollection.Initialize()\r\n   at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)\r\n   --- End of inner exception stack trace ---","FailMessage":"Boot failed.","Duration":4789,"TimingId":"4e52887","SourceContext":"Umbraco.Core.Runtime.CoreRuntime","ProcessId":1764,"ProcessName":"w3wp","ThreadId":45,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"ERROR","HttpRequestNumber":1,"HttpRequestId":"3c450c9f-4910-43f0-a1a7-bbcb791a8582"}
{"@t":"2021-05-11T21:35:10.0392344Z","@mt":"An unhandled exception occurred","@l":"Error","@x":"Umbraco.Core.Exceptions.BootFailedException: Boot failed: Umbraco cannot run. See Umbraco's log file for more details.\n\n-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.\n\n-> System.InvalidCastException: Object must implement IConvertible.\n   at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)\r\n   at NPoco.MappingFactory.Map(DbDataReader dataReader, Object instance)\r\n   at NPoco.Database.<Read>d__156`1.MoveNext()\r\n   at NPoco.Database.<QueryImp>d__164`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Umbraco.Forms.Core.Migrations.FormsMigrationBase.GetDistinctRecordCount[TDto](String[] columns)\r\n   at Umbraco.Forms.Core.Migrations.FormsMigrationBase.ContainsDuplicates[TDto](String[] columns)\r\n   at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddUniqueConstraint[TDto](String table, String[] columns)\r\n   at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddUniqueConstraint[TDto](String table, String column)\r\n   at Umbraco.Forms.Core.Migrations.V_8_7_0.AddFormKeysAndIndexes.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.Forms.Core.Components.UmbracoFormsComponent.ExecuteDatabaseUpgrades()\r\n   at Umbraco.Forms.Core.Components.UmbracoFormsComponent.Initialize()\r\n   at Umbraco.Core.Composing.ComponentCollection.Initialize()\r\n   at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)\r\n   at Umbraco.Core.Exceptions.BootFailedException.Rethrow(BootFailedException bootFailedException)\r\n   at System.Web.HttpApplication.SyncEventExecutionStep.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)","SourceContext":"Umbraco.Web.UmbracoApplicationBase","ProcessId":1764,"ProcessName":"w3wp","ThreadId":53,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"ERROR","HttpRequestNumber":2,"HttpRequestId":"dd0be07a-c448-468f-9b48-47147a9e95ff"}
{"@t":"2021-05-11T21:35:10.1800480Z","@mt":"An unhandled exception occurred","@l":"Error","@x":"Umbraco.Core.Exceptions.BootFailedException: Boot failed: Umbraco cannot run. See Umbraco's log file for more details.\n\n-> Umbraco.Core.Exceptions.BootFailedException: Boot failed.\n\n-> System.InvalidCastException: Object must implement IConvertible.\n   at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)\r\n   at NPoco.MappingFactory.Map(DbDataReader dataReader, Object instance)\r\n   at NPoco.Database.<Read>d__156`1.MoveNext()\r\n   at NPoco.Database.<QueryImp>d__164`1.MoveNext()\r\n   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)\r\n   at Umbraco.Forms.Core.Migrations.FormsMigrationBase.GetDistinctRecordCount[TDto](String[] columns)\r\n   at Umbraco.Forms.Core.Migrations.FormsMigrationBase.ContainsDuplicates[TDto](String[] columns)\r\n   at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddUniqueConstraint[TDto](String table, String[] columns)\r\n   at Umbraco.Forms.Core.Migrations.FormsMigrationBase.AddUniqueConstraint[TDto](String table, String column)\r\n   at Umbraco.Forms.Core.Migrations.V_8_7_0.AddFormKeysAndIndexes.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.Forms.Core.Components.UmbracoFormsComponent.ExecuteDatabaseUpgrades()\r\n   at Umbraco.Forms.Core.Components.UmbracoFormsComponent.Initialize()\r\n   at Umbraco.Core.Composing.ComponentCollection.Initialize()\r\n   at Umbraco.Core.Runtime.CoreRuntime.Boot(IRegister register, DisposableTimer timer)\r\n   at Umbraco.Core.Exceptions.BootFailedException.Rethrow(BootFailedException bootFailedException)\r\n   at System.Web.HttpApplication.SyncEventExecutionStep.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)","SourceContext":"Umbraco.Web.UmbracoApplicationBase","ProcessId":1764,"ProcessName":"w3wp","ThreadId":62,"AppDomainId":5,"AppDomainAppId":"LMW3SVC2ROOT","MachineName":"LAPTOP-TVMJ2DRH","Log4NetLevel":"ERROR","HttpRequestNumber":3,"HttpRequestId":"5ab5b487-ef89-4fd0-affb-88901adf84c8"}
@bjarnef bjarnef changed the title Booting error - Booting error - AddFormKeysAndIndexes migration May 11, 2021
@AndyButland
Copy link

Thanks for reporting @bjarnef . And yes, looks like this has revealed an issue with the migrations introduced in 8.7 to add various data integrity constraints, specifically in the checking for duplicates on SQL CE.

I've got a fix - do you think you'd have time to test it out for me on your local database just to confirm it solves the issue please? And if so I'll put out a patch release.

You can download the file here,

@bjarnef
Copy link
Author

bjarnef commented May 12, 2021

Hi @AndyButland

Thanks for having a quick look at this. I will test the fix right away :)

@bjarnef
Copy link
Author

bjarnef commented May 12, 2021

It seems to work 👍
The site is now booting correct and running 😎

@AndyButland
Copy link

Good to hear, thanks. We'll get this out in a patch next week.

@bjarnef
Copy link
Author

bjarnef commented May 12, 2021

Cool, can I deploy this assembly for now until a patch release is ready?

@AndyButland
Copy link

It has no other changes from 8.7.2, so should be fine from that perspective. Only concern though is that it as built in debug mode, so it might be better for that reason you just use it to get your local SQL CE environment working. In fact, once Umbraco has booted, and the migration has completed, you could go back to the 8.7.2 one as the code causing the problem won't execute again.

@bjarnef
Copy link
Author

bjarnef commented May 12, 2021

Okay, the only concern is if another developer need to clone the project from scratch, but currently it is only me working on this project. Alternatively it could be configurated with LocalDB, but I originally started the project before installing LocalDB on my machine. But the good thing is we discovered this bug 🙌

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants