Copied to clipboard

Flag this post as spam?

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


  • Carlos 13 posts 132 karma points
    Jan 10, 2023 @ 21:48
    Carlos
    0

    DB Migration from v8.18.5 to v10 Fails

    Following this guide and am stuck on step 1: https://our.umbraco.com/documentation/Umbraco-Cloud/Upgrades/Migrating-from-8-to-10/#step-1-content-migration

    Steps completed:

    -Backup db hosting v8 project

    -Create a local v10 site

    -Update connection string in appsettings.json

    -Enabled unattended upgrades

    This is the error I receive: Website error The log shows the migration fails after the 'MigrateLogViewerQueriesFromFileToDb' step. Has anyone else ran into this issue?

    Thanks!

  • Carlos 13 posts 132 karma points
    Jan 10, 2023 @ 21:50
    Carlos
    0

    Log dump below:

    {"@t":"2023-01-10T21:38:47.5668607Z","@mt":"Database upgrade started","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.Install.DatabaseBuilder","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:47.6311576Z","@mt":"Starting '{MigrationName}'...","MigrationName":"Umbraco.Core","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:47.6312040Z","@mt":"At {OrigState}","OrigState":"{03482BB0-CF13-475C-845E-ECB8319DBE3C}","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:47.6324846Z","@mt":"Execute {MigrationType}","MigrationType":"UpdateCmsPropertyGroupIdSeed","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:47.6330462Z","@mt":"At {OrigState}","OrigState":"{622E5172-42E1-4662-AD80-9504AF5A4E53}","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:47.6330955Z","@mt":"Execute {MigrationType}","MigrationType":"ExternalLoginTableIndexesFixup","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:47.7747044Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":0,"Sql":"ALTER TABLE [umbracoExternalLogin] ALTER COLUMN [loginProvider] NVARCHAR(400) NOT NULL","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:47.7971539Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":1,"Sql":"CREATE NONCLUSTERED INDEX [IX_umbracoExternalLogin_LoginProvider] ON [umbracoExternalLogin] ([loginProvider],[userId])","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:47.8191427Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":2,"Sql":"CREATE NONCLUSTERED INDEX [IX_umbracoExternalLogin_ProviderKey] ON [umbracoExternalLogin] ([loginProvider],[providerKey])","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:47.8230835Z","@mt":"At {OrigState}","OrigState":"{10F7BB61-C550-426B-830B-7F954F689CDF}","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:47.8231446Z","@mt":"Execute {MigrationType}","MigrationType":"DictionaryTablesIndexes","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:47.9425813Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":3,"Sql":"DROP INDEX [IX_cmsDictionary_key] ON [cmsDictionary]","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:47.9601272Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":4,"Sql":"CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsDictionary_key] ON [cmsDictionary] ([key])","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:47.9647436Z","@mt":"SQL [{ContextIndex}]: {Sql}","ContextIndex":5,"Sql":"CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsLanguageText_languageId] ON [cmsLanguageText] ([languageId],[UniqueId])","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationContext","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:47.9679733Z","@mt":"At {OrigState}","OrigState":"{5AAE6276-80DB-4ACF-B845-199BC6C37538}","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:47.9680268Z","@mt":"Execute {MigrationType}","MigrationType":"MigrateLogViewerQueriesFromFileToDb","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:48.1249204Z","@mt":"Create table:\n {Sql}","Sql":"CREATE TABLE [umbracoLogViewerQuery] ([id] INTEGER NOT NULL IDENTITY(1,1),\n[name] NVARCHAR(255) NOT NULL,\n[query] NVARCHAR(255) NOT NULL)","SourceContext":"Umbraco.Cms.Persistence.SqlServer.Services.SqlServerSyntaxProvider","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:48.1515680Z","@mt":"Create Primary Key:\n {Sql}","Sql":"ALTER TABLE [umbracoLogViewerQuery] ADD CONSTRAINT [PK_umbracoLogViewerQuery] PRIMARY KEY CLUSTERED ([id])","SourceContext":"Umbraco.Cms.Persistence.SqlServer.Services.SqlServerSyntaxProvider","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:38:48.1567048Z","@mt":"Create Index:\n {Sql}","Sql":"CREATE UNIQUE NONCLUSTERED INDEX [IX_LogViewerQuery_name] ON [umbracoLogViewerQuery] ([name])","SourceContext":"Umbraco.Cms.Persistence.SqlServer.Services.SqlServerSyntaxProvider","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"INFO "}
    {"@t":"2023-01-10T21:39:18.4114553Z","@mt":"Exception ({InstanceId}).","@l":"Error","@x":"Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.\r\nOperation cancelled by user.\r\nThe statement has been terminated.\r\n ---> System.ComponentModel.Win32Exception (258): The wait operation timed out.\r\n   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n   at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCopyHandler)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinuedOnSuccess(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)\r\n   at NPoco.SqlServer.SqlBulkCopyHelper.BulkInsert[T](IDatabase db, IEnumerable`1 list, SqlBulkCopyOptions sqlBulkCopyOptions, InsertBulkOptions insertBulkOptions)\r\n   at NPoco.SqlServer.SqlBulkCopyHelper.BulkInsert[T](IDatabase db, IEnumerable`1 list, InsertBulkOptions insertBulkOptions)\r\n   at NPoco.Database.InsertBulk[T](IEnumerable`1 pocos, InsertBulkOptions options)\r\nClientConnectionId:913196c9-8a71-4194-bfd3-3509c6e1fc75\r\nError Number:-2,State:0,Class:11","InstanceId":"688a1e78","SourceContext":"Umbraco.Cms.Infrastructure.Persistence.UmbracoDatabase","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"ERROR"}
    {"@t":"2023-01-10T21:39:18.5179038Z","@mt":"Database configuration failed","@l":"Error","@x":"Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.\r\nOperation cancelled by user.\r\nThe statement has been terminated.\r\n ---> System.ComponentModel.Win32Exception (258): The wait operation timed out.\r\n   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n   at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCopyHandler)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinuedOnSuccess(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)\r\n   at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)\r\n   at NPoco.SqlServer.SqlBulkCopyHelper.BulkInsert[T](IDatabase db, IEnumerable`1 list, SqlBulkCopyOptions sqlBulkCopyOptions, InsertBulkOptions insertBulkOptions)\r\n   at NPoco.SqlServer.SqlBulkCopyHelper.BulkInsert[T](IDatabase db, IEnumerable`1 list, InsertBulkOptions insertBulkOptions)\r\n   at NPoco.Database.InsertBulk[T](IEnumerable`1 pocos, InsertBulkOptions options)\r\n   at Umbraco.Cms.Infrastructure.Migrations.Upgrade.V_9_0_0.MigrateLogViewerQueriesFromFileToDb.MigrateFileContentToDB()\r\n   at Umbraco.Cms.Infrastructure.Migrations.MigrationBase.Run()\r\n   at Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor.Execute(MigrationPlan plan, String fromState)\r\n   at Umbraco.Cms.Infrastructure.Migrations.Upgrade.Upgrader.Execute(IMigrationPlanExecutor migrationPlanExecutor, ICoreScopeProvider scopeProvider, IKeyValueService keyValueService)\r\n   at Umbraco.Cms.Infrastructure.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(UmbracoPlan plan)\r\nClientConnectionId:913196c9-8a71-4194-bfd3-3509c6e1fc75\r\nError Number:-2,State:0,Class:11","SourceContext":"Umbraco.Cms.Infrastructure.Migrations.Install.DatabaseBuilder","ProcessId":30028,"ProcessName":"iisexpress","ThreadId":1,"ApplicationId":"94c2084ae6c1f01f5c2f80848e2e314281b8d6f1","MachineName":"M020193","Log4NetLevel":"ERROR"}
    
  • Carlos 13 posts 132 karma points
    Jan 26, 2023 @ 19:40
    Carlos
    0

    Still haven't been able to move past this issue. Any help would be greatly appreciated!

  • Meni 281 posts 539 karma points
    Jan 26, 2023 @ 22:42
    Meni
    0

    first migrate to 9, then to 10

  • Carlos 13 posts 132 karma points
    Feb 08, 2023 @ 23:53
    Carlos
    100

    The issue was regarding a space issue in the database serverwhere the upgrade was being made.

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies