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 242 posts 478 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.

Please Sign in or register to post replies

Write your reply to:

Draft