Copied to clipboard

Flag this post as spam?

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


  • Simon Dingley 1427 posts 3327 karma points c-trib
    Jun 06, 2016 @ 10:42
    Simon Dingley
    0

    Database Upgrade Fails with SQL Exception (Timeout Expired)

    I am upgrading a database from 7.2.8 to 7.4.3 and I keep hitting an exception which I am yet to overcome. I get a SQL timeout exception right after the following query is executed:

    2016-06-06 11:24:20,180 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 9: DELETE FROM [umbracoNode] WHERE [nodeObjectType] = '5555da4f-a123-42b2-4488-dcdfb25e4111'
    

    I tried running this query directly which took quite a long time but it did complete so I'm not sure if this is actually failing during this query execution or after.

    Each of the nodes it is trying to delete are stylesheet properties used for adding formatting options in TinyMce in case that is of any help.

    Here is the complete log from start to finish:

     2016-06-06 11:24:10,204 [P17852/D4/T30] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Executing installation step: DatabaseUpgrade
     2016-06-06 11:24:10,204 [P17852/D4/T30] INFO  Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep - Running 'Upgrade' service
     2016-06-06 11:24:10,204 [P17852/D4/T30] INFO  Umbraco.Core.DatabaseContext - Database upgrade started
     2016-06-06 11:24:10,204 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Initializing database migrations
     2016-06-06 11:24:10,256 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddRelationTypeForDocumentOnDelete' to context
     2016-06-06 11:24:10,266 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'CreateCacheInstructionTable' to context
     2016-06-06 11:24:10,678 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MigrateAndRemoveTemplateMasterColumn' to context
     2016-06-06 11:24:17,365 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MigrateStylesheetDataToFile' to context
     2016-06-06 11:24:17,368 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveStylesheetDataAndTables' to context
     2016-06-06 11:24:17,382 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveLanguageLocaleColumn' to context
     2016-06-06 11:24:17,389 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUniqueIdToHaveCorrectIndexType' to context
     2016-06-06 11:24:17,391 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddPublicAccessTables' to context
     2016-06-06 11:24:17,395 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'MovePublicAccessXmlDataToDb' to context
     2016-06-06 11:24:17,405 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveHelpTextColumn' to context
     2016-06-06 11:24:17,408 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddExternalLoginsTable' to context
     2016-06-06 11:24:17,418 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUserColumns' to context
     2016-06-06 11:24:17,421 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddMigrationTable' to context
     2016-06-06 11:24:17,551 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUniqueIdPropertyTypeColumn' to context
     2016-06-06 11:24:17,663 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddForeignKeysForLanguageAndDictionaryTables' to context
     2016-06-06 11:24:17,673 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveUmbracoLoginsTable' to context
     2016-06-06 11:24:17,682 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddServerRegistrationColumnsAndLock' to context
     2016-06-06 11:24:19,876 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'CleanUpCorruptedPublishedFlags' to context
     2016-06-06 11:24:19,878 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'UpdateUserLanguagesToIsoCode' to context
     2016-06-06 11:24:19,878 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'EnsureMigrationsTableIdentityIsCorrect' to context
     2016-06-06 11:24:19,885 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddDataDecimalColumn' to context
     2016-06-06 11:24:19,892 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUniqueIdPropertyTypeGroupColumn' to context
     2016-06-06 11:24:19,942 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'EnsureContentTypeUniqueIdsAreConsistent' to context
     2016-06-06 11:24:19,952 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'FixListViewMediaSortOrder' to context
     2016-06-06 11:24:19,968 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'RemoveParentIdPropertyTypeGroupColumn' to context
     2016-06-06 11:24:19,970 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Added UPGRADE migration 'AddUmbracoDeployTables' to context
     2016-06-06 11:24:19,971 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 1: INSERT INTO [umbracoRelationType] ([dual],[parentObjectType],[childObjectType],[name],[alias]) VALUES (0,'c66ba18e-eaf3-4cff-8a22-41b16d66a972','c66ba18e-eaf3-4cff-8a22-41b16d66a972','Relate Parent Document On Delete','relateParentDocumentOnDelete');
    
     2016-06-06 11:24:19,972 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 2: CREATE TABLE [umbracoCacheInstruction] ([id] INTEGER NOT NULL IDENTITY(1,1),
    [utcStamp] DATETIME NOT NULL,
    [jsonInstruction] NTEXT NOT NULL,
    [originated] NVARCHAR(500) NOT NULL)
    
     2016-06-06 11:24:19,974 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 3: ALTER TABLE [umbracoCacheInstruction] ADD CONSTRAINT [PK_umbracoCacheInstruction] PRIMARY KEY CLUSTERED ([id])
    
     2016-06-06 11:24:20,031 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 4: UPDATE cmsTemplate SET master = NULL WHERE [master] IS NOT NULL AND [master] NOT IN (SELECT nodeId FROM (SELECT * FROM cmsTemplate a) b)
    
     2016-06-06 11:24:20,078 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,083 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,083 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,084 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,084 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,085 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,085 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,085 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,086 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,086 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,087 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,087 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,088 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,088 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,088 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,089 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,089 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,090 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,090 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,090 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,091 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,095 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,102 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,105 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,106 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,107 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,107 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,107 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,108 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,108 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,109 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,109 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,110 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,110 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,113 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,114 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,114 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]nodeId
     2016-06-06 11:24:20,115 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,115 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,115 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,116 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,116 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,116 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,117 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,117 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,118 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,118 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,119 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,119 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,119 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,120 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,120 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,120 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,121 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,121 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,121 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,122 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,122 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,123 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,123 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,123 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,124 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,124 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,124 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,125 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,125 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,125 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE umbracoNode SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,128 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,132 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,147 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,147 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,148 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,148 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,149 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,149 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,150 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,150 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,151 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,151 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,152 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,152 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,152 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,153 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,153 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,154 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,154 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,154 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,155 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,156 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,157 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,158 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,158 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,159 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,159 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,160 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,160 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,161 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,161 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,161 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,162 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,162 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,163 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,163 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,163 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,164 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,164 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,165 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,165 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,165 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,166 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,166 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,167 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,168 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,168 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,168 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,169 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,169 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,170 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,170 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,171 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,171 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,171 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,172 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,172 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,172 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,173 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,173 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,174 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,174 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,174 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,175 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,175 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,176 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,176 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSevenThreeZero.MigrateAndRemoveTemplateMasterColumn - Executing sql statement: UPDATE [umbracoNode] SET [email protected] WHERE [email protected]
     2016-06-06 11:24:20,177 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 7: ALTER TABLE [cmsTemplate] DROP COLUMN [master]
    
     2016-06-06 11:24:20,179 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 8: DELETE FROM [cmsStylesheetProperty] WHERE 1 = 1
    
     2016-06-06 11:24:20,180 [P17852/D4/T30] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 9: DELETE FROM [umbracoNode] WHERE [nodeObjectType] = '5555da4f-a123-42b2-4488-dcdfb25e4111'
    
     2016-06-06 11:24:50,182 [P17852/D4/T30] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Database exception occurred
    System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    The statement has been terminated. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 279
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.<ExecuteNonQueryWithRetry>b__0()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args)
    ClientConnectionId:6309c0ee-9417-4268-9e1a-4a6e62cf28cb
    Error Number:-2,State:0,Class:11
     2016-06-06 11:24:50,186 [P17852/D4/T30] ERROR Umbraco.Core.DatabaseContext - Database configuration failed
    System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    The statement has been terminated. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 279
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.<ExecuteNonQueryWithRetry>b__0()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args)
       at Umbraco.Core.Persistence.Migrations.MigrationRunner.ExecuteMigrations(IMigrationContext context, Database database)
       at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade)
       at Umbraco.Core.DatabaseContext.UpgradeSchemaAndData(IMigrationEntryService migrationEntryService)
    ClientConnectionId:6309c0ee-9417-4268-9e1a-4a6e62cf28cb
    Error Number:-2,State:0,Class:11
     2016-06-06 11:24:50,187 [P17852/D4/T30] INFO  Umbraco.Core.DatabaseContext - The database schema validation produced the following summary: 
    The following tables were found in the database, but are not in the current schema:
    UFUserSecurity,UFDataSources,UFFormStates,UFPrevalueSourceSettings,UFDataSourceMappings,UFForms,UFWorkflowExecutionStates,UFWorkflows,UFRecordsXml,UFRecords,UFUserFormSecurity,UFPages,UFRecordFields,UFFieldsets,UFFields,UFFieldSettings,UFPrevalues,UFRecordDataString,UFRecordDataLongString,UFRecordDataInteger,UFRecordDataDateTime,UFRecordDataBit,BulkmanagerState,StandardValues,UFFieldConditions,UFFieldConditionRules,UCUserSettings,CommandLog,icUrlTracker,CMSImportState,CMSImportScheduledTask,CMSImportRelation,CMSImportMediaRelation,CMSImportScheduledItems,CMSImportCustomRelation,UFWorkflowsToForms,UFSettings,UFPrevalueSources,umbracoUserLogins,umbracoAccess,umbracoAccessRule,umbracoCacheInstruction,umbracoExternalLogin,umbracoMigration,umbracoDeployChecksum,umbracoDeployDependency
    
    The following columns were found in the database, but are not in the current schema:
    UFUserSecurity,User,UFUserSecurity,ManageDataSources,UFUserSecurity,ManagePreValueSources,UFUserSecurity,ManageWorkflows,UFUserSecurity,ManageForms,UFDataSources,Id,UFDataSources,Type,UFDataSources,Name,UFFormStates,State,UFPrevalueSourceSettings,PrevalueProvider,UFPrevalueSourceSettings,Key,UFPrevalueSourceSettings,Value,UFDataSourceMappings,DataSource,UFDataSourceMappings,DataSourceField,UFDataSourceMappings,Form,UFDataSourceMappings,PrevalueTable,UFDataSourceMappings,PrevalueKeyField,UFDataSourceMappings,PrevalueValueField,UFDataSourceMappings,DataType,UFDataSourceMappings,DefaultValue,UFForms,Id,UFForms,Name,UFForms,Created,UFForms,ManualApproval,UFForms,GotoPageOnSubmit,UFForms,MessageOnSubmit,UFForms,DataSource,UFForms,ShowValidationSummary,UFForms,HideFieldValidation,UFForms,RequiredErrorMessage,UFForms,InvalidErrorMessage,UFForms,FieldIndicationType,UFForms,Indicator,UFForms,Archived,UFForms,StoreRecordsLocally,UFForms,DisableDefaultStylesheet,UFForms,Entries,UFForms,Views,cmsContentVersion,LanguageLocale,UFWorkflowExecutionStates,Workflow,UFWorkflowExecutionStates,State,UFWorkflowExecutionStates,Form,UFWorkflows,Id,UFWorkflows,Name,UFWorkflows,Type,UFWorkflows,SortOrder,UFWorkflows,Active,UFWorkflows,Form,UFWorkflows,ExecutesOn,UFRecordsXml,id,UFRecordsXml,Form,UFRecordsXml,xml,UFRecordsXml,created,UFRecordsXml,Page,UFRecords,Id,UFRecords,Form,UFRecords,Created,UFRecords,Updated,UFRecords,State,UFRecords,currentPage,UFRecords,umbracoPageId,UFRecords,IP,UFRecords,MemberKey,cmsPropertyTypeGroup,parentGroupId,UFUserFormSecurity,User,UFUserFormSecurity,Form,UFUserFormSecurity,HasAccess,UFUserFormSecurity,SecurityType,UFUserFormSecurity,AllowInEditor,UFPages,Id,UFPages,Form,UFPages,SortOrder,UFPages,Caption,UFRecordFields,Key,UFRecordFields,Field,UFRecordFields,Record,UFRecordFields,DataType,UFFieldsets,Id,UFFieldsets,Page,UFFieldsets,SortOrder,UFFieldsets,Caption,UFFields,Id,UFFields,Fieldset,UFFields,Fieldtype,UFFields,PreValueProvider,UFFields,RegEx,UFFields,Mandatory,UFFields,SortOrder,UFFields,Caption,UFFields,DataSourceField,UFFields,ToolTip,UFFields,DefaultValue,UFFields,RequiredErrorMessage,UFFields,InvalidErrorMessage,UFFieldSettings,Field,UFFieldSettings,Key,UFFieldSettings,Value,UFPrevalues,Id,UFPrevalues,Field,UFPrevalues,Value,UFPrevalues,SortOrder,UFRecordDataString,Key,UFRecordDataString,Value,cmsTemplate,master,UFRecordDataLongString,Key,UFRecordDataLongString,Value,UFRecordDataInteger,Key,UFRecordDataInteger,Value,cmsPropertyType,helpText,UFRecordDataDateTime,Key,UFRecordDataDateTime,Value,UFRecordDataBit,Key,UFRecordDataBit,Value,BulkmanagerState,Id,BulkmanagerState,StateId,BulkmanagerState,Name,BulkmanagerState,ProviderId,BulkmanagerState,BindOnLoad,BulkmanagerState,UserId,BulkmanagerState,state,StandardValues,docTypeId,StandardValues,nodeId,UFFieldConditions,Id,UFFieldConditions,Field,UFFieldConditions,Enabled,UFFieldConditions,ActionType,UFFieldConditions,LogicType,UFFieldConditionRules,Id,UFFieldConditionRules,FieldCondition,UFFieldConditionRules,Field,UFFieldConditionRules,Operator,UFFieldConditionRules,Value,UCUserSettings,User,UCUserSettings,Key,UCUserSettings,Value,CommandLog,ID,CommandLog,DatabaseName,CommandLog,SchemaName,CommandLog,ObjectName,CommandLog,ObjectType,CommandLog,IndexName,CommandLog,IndexType,CommandLog,StatisticsName,CommandLog,PartitionNumber,CommandLog,ExtendedInfo,CommandLog,Command,CommandLog,CommandType,CommandLog,StartTime,CommandLog,EndTime,CommandLog,ErrorNumber,CommandLog,ErrorMessage,icUrlTracker,Id,icUrlTracker,OldUrl,icUrlTracker,OldUrlQueryString,icUrlTracker,OldRegex,icUrlTracker,RedirectRootNodeId,icUrlTracker,RedirectNodeId,icUrlTracker,RedirectUrl,icUrlTracker,RedirectHttpCode,icUrlTracker,RedirectPassThroughQueryString,icUrlTracker,Notes,icUrlTracker,Is404,icUrlTracker,Referrer,icUrlTracker,Inserted,icUrlTracker,ForceRedirect,CMSImportState,Id,CMSImportState,UniqueIdentifier,CMSImportState,Name,CMSImportState,ImportState,CMSImportState,Parent,CMSImportState,ImportProvider,CMSImportScheduledTask,ScheduleId,CMSImportScheduledTask,ScheduleGUID,CMSImportScheduledTask,ImportStateGUID,CMSImportScheduledTask,ScheduledTaskName,CMSImportScheduledTask,NotifyEmailAddress,CMSImportScheduledTask,ExecuteEvery,CMSImportScheduledTask,ExecuteDays,CMSImportScheduledTask,ExecuteHour,CMSImportScheduledTask,ExecuteMinute,CMSImportScheduledTask,ImportAsUser,CMSImportRelation,Id,CMSImportRelation,UmbracoID,CMSImportRelation,DataSourceKey,CMSImportRelation,ImportProvider,CMSImportRelation,Updated,CMSImportRelation,CustomId,CMSImportMediaRelation,Id,CMSImportMediaRelation,UmbracoMediaId,CMSImportMediaRelation,SourceUrl,CMSImportMediaRelation,ByteSize,CMSImportScheduledItems,ScheduledItemId,CMSImportScheduledItems,ScheduleldTaskId,CMSImportScheduledItems,ScheduledOn,CMSImportScheduledItems,ExecutedOn,CMSImportScheduledItems,InProgress,CMSImportCustomRelation,CustomRelationId,CMSImportCustomRelation,UmbracoId,CMSImportCustomRelation,Alias,CMSImportCustomRelation,DataSourceKey,CMSImportCustomRelation,RelatedId,UFWorkflowsToForms,Workflow,UFWorkflowsToForms,Form,UFSettings,Id,UFSettings,Key,UFSettings,Value,UFPrevalueSources,Id,UFPrevalueSources,Name,UFPrevalueSources,Type,umbracoUserLogins,contextID,umbracoUserLogins,userID,umbracoUserLogins,timeout,cmsPropertyTypeGroup,uniqueID,cmsPropertyType,UniqueID,cmsPropertyData,dataDecimal,umbracoUser,securityStampToken,umbracoUser,failedLoginAttempts,umbracoUser,lastLockoutDate,umbracoUser,lastPasswordChangeDate,umbracoUser,lastLoginDate,umbracoServer,isMaster,umbracoAccess,id,umbracoAccess,nodeId,umbracoAccess,loginNodeId,umbracoAccess,noAccessNodeId,umbracoAccess,createDate,umbracoAccess,updateDate,umbracoAccessRule,id,umbracoAccessRule,accessId,umbracoAccessRule,ruleValue,umbracoAccessRule,ruleType,umbracoAccessRule,createDate,umbracoAccessRule,updateDate,umbracoCacheInstruction,id,umbracoCacheInstruction,utcStamp,umbracoCacheInstruction,jsonInstruction,umbracoCacheInstruction,originated,umbracoExternalLogin,id,umbracoExternalLogin,userId,umbracoExternalLogin,loginProvider,umbracoExternalLogin,providerKey,umbracoExternalLogin,createDate,umbracoMigration,id,umbracoMigration,name,umbracoMigration,createDate,umbracoMigration,version,umbracoDeployChecksum,id,umbracoDeployChecksum,entityType,umbracoDeployChecksum,entityGuid,umbracoDeployChecksum,entityPath,umbracoDeployChecksum,localChecksum,umbracoDeployChecksum,compositeChecksum,umbracoDeployDependency,sourceId,umbracoDeployDependency,targetId,umbracoDeployDependency,mode
    
    The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:
    FK_cmsPropertyTypeGroup_cmsPropertyTypeGroup_id,FK_UFDataSourceMappings_UFDataSources,FK_UFDataSourceMappings_UFForms,FK_UFField_UFFieldsets,FK_UFFieldConditionRules_UFFieldConditions,FK_UFFieldConditionRules_UFFields,FK_UFFieldConditions_UFFields,FK_UFFieldsets_UFPages,FK_UFFieldSettings_UFFields,FK_UFForms_UFDataSources,FK_UFPages_UFForms,FK_UFPrevalues_UFFields,FK_UFPrevalueSettings_UFPrevalueProviders,FK_UFRecordDataBit_UFRecordFields,FK_UFRecordDataDateTime_UFRecordFields,FK_UFRecordDataInteger_UFRecordFields,FK_UFRecordDataLongString_UFRecordFields,FK_UFRecordDataString_UFRecordFields,FK_UFRecordFields_UFFields,FK_UFRecordFields_UFRecords,FK_UFRecords_UFForms,FK_UFRecordsXml_UFForms,FK_UFUserFormSecurity_UFForms,FK_UFWorkflowExecutionStates_UFFormStates,FK_UFWorkflows_UFForms,FK_umbracoNode_umbracoNode_id,FK_cmsContentType_umbracoNode_id,FK_cmsTemplate_umbracoNode,FK_cmsContent_umbracoNode_id,FK_cmsContentVersion_cmsContent_nodeId,FK_cmsDocument_cmsContent_nodeId,FK_cmsDocument_umbracoNode_id,FK_cmsDocument_cmsTemplate_nodeId,FK_cmsDocumentType_umbracoNode_id,FK_cmsDocumentType_cmsContentType_nodeId,FK_cmsDocumentType_cmsTemplate_nodeId,FK_cmsDataType_umbracoNode_id,FK_cmsDataTypePreValues_cmsDataType_nodeId,FK_cmsDictionary_cmsDictionary_id,FK_cmsLanguageText_umbracoLanguage_id,FK_cmsLanguageText_cmsDictionary_id,FK_umbracoDomains_umbracoNode_id,FK_cmsMacroProperty_cmsMacro_id,FK_cmsMemberType_cmsContentType_nodeId,FK_cmsMemberType_umbracoNode_id,FK_cmsMember2MemberGroup_cmsMember_nodeId,FK_cmsMember2MemberGroup_umbracoNode_id,FK_cmsContentXml_cmsContent_nodeId,FK_cmsPreviewXml_cmsContent_nodeId,FK_cmsPreviewXml_cmsContentVersion_VersionId,FK_cmsPropertyTypeGroup_cmsContentType_nodeId,FK_cmsPropertyType_cmsDataType_nodeId,FK_cmsPropertyType_cmsContentType_nodeId,FK_cmsPropertyType_cmsPropertyTypeGroup_id,FK_cmsPropertyData_umbracoNode_id,FK_cmsPropertyData_cmsPropertyType_id,FK_umbracoRelation_umbracoNode,FK_umbracoRelation_umbracoNode1,FK_umbracoRelation_umbracoRelationType_id,FK_cmsTagRelationship_cmsTags_id,FK_umbracoUser_umbracoUserType_id,FK_cmsTask_cmsTaskType_id,FK_cmsTask_umbracoNode_id,FK_cmsTask_umbracoUser,FK_cmsTask_umbracoUser1,FK_cmsContentType2ContentType_umbracoNode_parent,FK_cmsContentType2ContentType_umbracoNode_child,FK_cmsContentTypeAllowedContentType_cmsContentType,FK_cmsContentTypeAllowedContentType_cmsContentType1,FK_umbracoUser2app_umbracoUser_id,FK_umbracoUser2NodeNotify_umbracoUser_id,FK_umbracoUser2NodeNotify_umbracoNode_id,FK_umbracoUser2NodePermission_umbracoUser_id,FK_umbracoUser2NodePermission_umbracoNode_id,FK_umbracoAccess_umbracoNode_id,FK_umbracoAccess_umbracoNode_id1,FK_umbracoAccess_umbracoNode_id2,FK_umbracoAccessRule_umbracoAccess_id,FK_umbracoDeployDependency_umbracoDeployChecksum_id1,FK_umbracoDeployDependency_umbracoDeployChecksum_id2,PK_BulkmanagerState,PK_CMSImportCustomRelation,PK_CMSImportMediaRelation,PK_CMSImportRelation,PK_CMSImportScheduledItems,PK_CMSImportScheduledTask,PK_CMSImportState,PK_CommandLog,PK_icUrlTracker,PK_StandardValues,PK_UCUserSettings,PK_UFDataSourceMappings,PK_UFDataSources,PK_UFField,PK_UFFieldConditionRules,PK_UFFieldConditions,PK_UFFieldsets,PK_UFForms,PK_UFFormStates,PK_UFPages,PK_UFPrevalueProviders,PK_UFPrevalues,PK_UFPrevalueSettings,PK_UFRecordFields,PK_UFRecords,PK_UFRecordsXml,PK_UFUserFormSecurity,PK_UFUserSecurity,PK_UFWorkflowExecutionStates,PK_UFWorkflows,PK_UFWorkflowsToForms,PK_structure,PK_cmsContentType,PK_cmsTemplate,PK_cmsContent,PK_cmsContentVersion,PK_cmsDocument,PK_cmsDocumentType,PK_cmsDataType,PK_cmsDataTypePreValues,PK_cmsDictionary,PK_umbracoLanguage,PK_cmsLanguageText,PK_umbracoDomains,PK_umbracoLog,PK_cmsMacro,PK_cmsMacroProperty,PK_cmsMemberType,PK_cmsMember2MemberGroup,PK_cmsContentXml,PK_cmsPropertyTypeGroup,PK_cmsPropertyType,PK_cmsPropertyData,PK_umbracoRelationType,PK_umbracoRelation,PK_umbracoUserType,PK_user,PK_cmsTaskType,PK_cmsTask,PK_cmsContentTypeAllowedContentType,PK_user2app,PK_umbracoUser2NodeNotify,PK_umbracoUser2NodePermission,PK_umbracoAccess,PK_umbracoAccessRule,PK_umbracoCacheInstruction,PK_umbracoExternalLogin,PK_umbracoMigration,PK_umbracoDeployChecksum,PK_umbracoDeployDependency,IX_umbracoNodeTrashed,IX_umbracoNodeParentId,IX_umbracoNodeUniqueID,IX_umbracoNodeObjectType,IX_cmsContentType,IX_cmsContentType_icon,IX_cmsTemplate_nodeId,IX_cmsContent,IX_cmsContentVersion_ContentId,IX_cmsContentVersion_VersionId,IX_cmsDocument,IX_cmsDocument_published,IX_cmsDocument_newest,IX_cmsDataType_nodeId,IX_cmsDictionary_id,IX_umbracoLanguage_languageISOCode,IX_umbracoLog,IX_cmsMacroPropertyAlias,IX_cmsMacroProperty_Alias,IX_cmsPropertyTypeGroupUniqueID,IX_cmsPropertyTypeUniqueID,IX_cmsPropertyData,IX_cmsPropertyData_1,IX_cmsPropertyData_2,IX_cmsPropertyData_3,IX_cmsTags,IX_umbracoUser_userLogin,IX_cmsTaskType_alias,IX_computerName,IX_umbracoServer_isActive,IX_umbracoAccess_nodeId,IX_umbracoAccessRule,IX_umbracoMigration,IX_umbracoDeployChecksum
    
    The following indexes were found in the database, but are not in the current schema:
    cmsContent_PK_cmsContent,cmsContentType_PK_cmsContentType,cmsContentTypeAllowedContentType_PK_cmsContentTypeAllowedContentType,cmsContentVersion_PK__cmsContentVersion__00000000000001B6,cmsContentXml_PK_cmsContentXml,cmsDataType_PK_cmsDataType,cmsDataTypePreValues_PK_cmsDataTypePreValues,cmsDictionary_PK_cmsDictionary,cmsDocument_PK_cmsDocument,NonClusteredIndex-20140402-120255,cmsDocumentType_PK_cmsDocumentType,cmsLanguageText_PK_cmsLanguageText,cmsMacro_PK_macro,IX_cmsMacro_Alias,cmsMacroProperty_PK_macroProperty,cmsMember2MemberGroup_PK_cmsMember2MemberGroup,cmsMemberType_PK_cmsMemberType,cmsPropertyData_PK_cmsPropertyData,NonClusteredIndex-20141203-085947,cmsPropertyType_PK_cmsPropertyType,cmsTab_PK_cmsTab,cmsTask_PK_cmsTask,cmsTaskType_PK_cmsTaskType,cmsTemplate_PK_templates,IX_icUrlTracker,NonClusteredIndex-20140813-125549,umbracoDomains_PK_domains,umbracoLanguage_PK_language,umbracoLog_PK_umbracoLog,umbracoNode_PK_structure,umbracoRelation_PK_umbracoRelation,umbracoRelationType_PK_umbracoRelationType,umbracoUser_PK_user,umbracoUser2app_PK_user2app,umbracoUser2NodeNotify_PK_umbracoUser2NodeNotify,umbracoUser2NodePermission_PK_umbracoUser2NodePermission,IX_umbracoUserLogins_Index,umbracoUserType_PK_userType,IX_umbracoNodeParentId,IX_umbracoNodeObjectType,IX_cmsTemplate_nodeId,IX_cmsContentVersion_VersionId,IX_cmsDocument,IX_cmsDataType_nodeId,IX_cmsDictionary_id,IX_umbracoLanguage_languageISOCode,IX_umbracoLog,IX_cmsMacroPropertyAlias,IX_cmsPropertyTypeGroupUniqueID,IX_cmsPropertyTypeUniqueID,IX_cmsPropertyData,IX_cmsPropertyData_1,IX_cmsPropertyData_2,IX_cmsPropertyData_3,IX_umbracoUser_userLogin,IX_cmsTaskType_alias,IX_umbracoAccess_nodeId,IX_umbracoAccessRule,IX_umbracoMigration,IX_umbracoDeployChecksum
    
    The following unknown constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:
    cmsContent_FK_cmsContent_umbracoNode,cmsContent_PK_cmsContent,cmsContentType_FK_cmsContentType_umbracoNode,cmsContentType_PK_cmsContentType,cmsContentTypeAllowedContentType_PK_cmsContentTypeAllowedContentType,cmsContentVersion_PK__cmsContentVersion__00000000000001B6,cmsContentXml_PK_cmsContentXml,cmsDataType_PK_cmsDataType,cmsDataTypePreValues_PK_cmsDataTypePreValues,cmsDictionary_PK_cmsDictionary,cmsDocument_FK_cmsDocument_umbracoNode,cmsDocument_PK_cmsDocument,cmsDocumentType_PK_cmsDocumentType,cmsLanguageText_PK_cmsLanguageText,cmsMacro_PK_macro,cmsMacroProperty_PK_macroProperty,cmsMember2MemberGroup_PK_cmsMember2MemberGroup,cmsMemberType_PK_cmsMemberType,cmsPropertyData_FK_cmsPropertyData_umbracoNode,cmsPropertyData_PK_cmsPropertyData,cmsPropertyType_FK_cmsPropertyType_cmsTab,cmsPropertyType_PK_cmsPropertyType,cmsTab_PK_cmsTab,cmsTask_FK_cmsTask_cmsTaskType,cmsTask_PK_cmsTask,cmsTaskType_PK_cmsTaskType,cmsTemplate_FK_cmsTemplate_umbracoNode,cmsTemplate_PK_templates,umbracoDomains_PK_domains,umbracoLanguage_PK_language,umbracoLog_PK_umbracoLog,umbracoNode_FK_umbracoNode_umbracoNode,umbracoNode_PK_structure,umbracoRelation_PK_umbracoRelation,umbracoRelationType_PK_umbracoRelationType,umbracoUser_FK_user_userType,umbracoUser_PK_user,umbracoUser2app_FK_umbracoUser2app_umbracoUser,umbracoUser2app_PK_user2app,umbracoUser2NodeNotify_PK_umbracoUser2NodeNotify,umbracoUser2NodePermission_PK_umbracoUser2NodePermission,umbracoUserType_PK_userType
    
    
     2016-06-06 11:24:50,189 [P17852/D4/T30] ERROR Umbraco.Web.Install.Controllers.InstallApiController - Installation step DatabaseUpgrade failed.
    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: 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/UmbracoTraceLog.txt')
       at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model)
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction)
     2016-06-06 11:24:50,189 [P17852/D4/T30] INFO  Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 39985ms)
     2016-06-06 11:24:50,189 [P17852/D4/T30] ERROR Umbraco.Web.Install.Controllers.InstallApiController - An error occurred during installation step DatabaseUpgrade
    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: 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/UmbracoTraceLog.txt')
       at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model)
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction)
       at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)
    
  • Simon Dingley 1427 posts 3327 karma points c-trib
    Jun 06, 2016 @ 11:29
  • Simon Dingley 1427 posts 3327 karma points c-trib
    Jun 07, 2016 @ 11:46
    Simon Dingley
    10

    As a workaround I was able to overcome the error by adding an extended Connection Timeout to my connection string as follows:

    <add name="umbracoDbDSN" connectionString="server=(local);database=C032_Umbraco_Live_v7_upgrade;user id=umbraco;password=umbraco;Connection Timeout=3600" providerName="System.Data.SqlClient" />
    
Please Sign in or register to post replies

Write your reply to:

Draft