@atripp It has been uploaded
MF-60085
@MF-60085
Best posts made by MF-60085
Latest posts made by MF-60085
-
RE: ProGet 2023 Data Migration Failed
I'm fine to send it, but I think I would prefer a secure link. Thanks!
-
RE: ProGet 2023 Data Migration Failed
I tried the upgrade and then the data migration. Getting farther it seems, though, Here is my error:
Importing pkg:nuget/Hercules@1.0.100...Error reading package: 2627
14
1NuGet_ImportPackageVersion
116Violation of PRIMARY KEY constraint 'PK__NuGetPackageSymbols23'. Cannot insert duplicate key in object 'dbo.NuGetPackageSymbols23'. The duplicate key value is (1, 93294, 0x9c18e8644915d54881411a10e614137f, Hercules.Common.Constants.pdb, 1, Hercules).Retrying...Reading package #54390...Importing pkg:nuget/Hercules@1.0.100...Error reading package: 2627
141
NuGet_ImportPackageVersion116
Violation of PRIMARY KEY constraint 'PK__NuGetPackageSymbols23'. Cannot insert duplicate key in object 'dbo.NuGetPackageSymbols23'. The duplicate key value is (1, 93295, 0x9c18e8644915d54881411a10e614137f, Hercules.Common.Constants.pdb, 1, Hercules).Retrying...Reading package #54390...Importing pkg:nuget/Hercules@1.0.100...Error reading package: 262714
1NuGet_ImportPackageVersion
116Violation of PRIMARY KEY constraint 'PK__NuGetPackageSymbols23'. Cannot insert duplicate key in object 'dbo.NuGetPackageSymbols23'. The duplicate key value is (1, 93296, 0x9c18e8644915d54881411a10e614137f, Hercules.Common.Constants.pdb, 1, Hercules).Error importing data: Microsoft.Data.SqlClient.SqlException (0x80131904): 2627
141
NuGet_ImportPackageVersion116
Violation of PRIMARY KEY constraint 'PK__NuGetPackageSymbols23'. Cannot insert duplicate key in object 'dbo.NuGetPackageSymbols23'. The duplicate key value is (1, 93296, 0x9c18e8644915d54881411a10e614137f, Hercules.Common.Constants.pdb, 1, Hercules).at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__209_0(Task`1 result)
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
at Inedo.Data.DatabaseContext.DbResult.CreateAsync(DbCommand command, DatabaseContext context, DateTimeOffset startTime, Stopwatch stopwatch)
at Inedo.Data.DatabaseContext.ExecuteInternalAsync(String storedProcName, GenericDbParameter[] parameters)
at Inedo.Data.SqlServerDatabaseContext.ExecuteInternalAsync(String storedProcName, GenericDbParameter[] parameters)
at Inedo.Data.DatabaseContext.ExecuteNonQueryAsync(String storedProcName, GenericDbParameter[] parameters)
at Inedo.Data.DatabaseContext.ExecuteScalarAsync[TResult](String storedProcName, GenericDbParameter[] parameters, Int32 outParameterIndex)
at Inedo.ProGet.Feeds.NuGet.NuGetFeed.<>c__DisplayClass105_0.<<Inedo-ProGet-Feeds-ILegacyImportableFeed-ImportLegacyPackageDataAsync>b__6>d.MoveNext()
--- End of stack trace from previous location ---
at Inedo.ProGet.Feeds.StandardPackageFeed
3.<>c__DisplayClass47_0
1.<<ImportLegacyPackageDataAsync>g__importRow|1>d.MoveNext()--- End of stack trace from previous location ---
at Inedo.ProGet.Feeds.StandardPackageFeed
3.ImportLegacyPackageDataAsync[TOldRow](ImportLegacyPackageDataContext context, IEnumerable
1 oldRows, Func`2 importAsync, CancellationToken cancellationToken)at Inedo.ProGet.Feeds.NuGet.NuGetFeed.Inedo.ProGet.Feeds.ILegacyImportableFeed.ImportLegacyPackageDataAsync(ImportLegacyPackageDataContext context, CancellationToken cancellationToken)
at Inedo.ProGet.Executions.MigrateFeedsForProGet23Execution.ExecuteAsync(IManualExecutionContext context)
ClientConnectionId:f068233c-56cf-4d81-88da-eb29df11a3e9
Error Number:50000,State:42,Class:14
-
RE: ProGet 2023 Data Migration Failed
Thanks. I did try the migrate again with no feed selected but with some errors still. I will try the upgrade for the release today.
-
RE: ProGet 2023 Data Migration Failed
@MF-60085 sent mail to support@inedo.com with the migration log for this post upgrade retry.
-
RE: ProGet 2023 Data Migration Failed
I upgraded, which went fine. I still had the message about migration fail. I retried the migration and all it said about my feed was:
Debug: Skipping feed pangaea...
Error: Feed pangaea must be migrated later. -
RE: ProGet 2023 Data Migration Failed
I updated to Version 2023.0 (Build 73)
I retried the migration and it failed. I have an npm repo that migrated fine, and also a powershell repo that was fine. Just my nuget repo failed to migrate.
Error importing data: Microsoft.Data.SqlClient.SqlException (0x80131904): 8672
16
1NuGet_ImportPackageVersion
116`The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A MERGE statement cannot UPDATE/DELETE the same row of the target table multiple times. Refine the ON clause to ensure a target row matches at most one source row, or use the GROUP BY clause to group the source rows.at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__209_0(Task`1 result)
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
at Inedo.Data.DatabaseContext.DbResult.CreateAsync(DbCommand command, DatabaseContext context, DateTimeOffset startTime, Stopwatch stopwatch)
at Inedo.Data.DatabaseContext.ExecuteInternalAsync(String storedProcName, GenericDbParameter[] parameters)
at Inedo.Data.SqlServerDatabaseContext.ExecuteInternalAsync(String storedProcName, GenericDbParameter[] parameters)
at Inedo.Data.DatabaseContext.ExecuteNonQueryAsync(String storedProcName, GenericDbParameter[] parameters)
at Inedo.Data.DatabaseContext.ExecuteScalarAsync[TResult](String storedProcName, GenericDbParameter[] parameters, Int32 outParameterIndex)
at Inedo.ProGet.Feeds.NuGet.NuGetFeed.<>c__DisplayClass111_0.<<Inedo-ProGet-Feeds-ILegacyImportableFeed-ImportLegacyPackageDataAsync>b__6>d.MoveNext()
--- End of stack trace from previous location ---
at Inedo.ProGet.Feeds.StandardPackageFeed
3.<>c__DisplayClass47_0
1.<<ImportLegacyPackageDataAsync>g__importRow|1>d.MoveNext()--- End of stack trace from previous location ---
at Inedo.ProGet.Feeds.StandardPackageFeed
3.ImportLegacyPackageDataAsync[TOldRow](ImportLegacyPackageDataContext context, IEnumerable
1 oldRows, Func`2 importAsync, CancellationToken cancellationToken)at Inedo.ProGet.Feeds.NuGet.NuGetFeed.Inedo.ProGet.Feeds.ILegacyImportableFeed.ImportLegacyPackageDataAsync(ImportLegacyPackageDataContext context, CancellationToken cancellationToken)
at Inedo.ProGet.Executions.MigrateFeedsForProGet23Execution.ExecuteAsync(IManualExecutionContext context)
ClientConnectionId:6772c9e6-4da4-44fd-ba0e-d54dc7cb5d86
Error Number:50000,State:42,Class:16
-
ProGet 2023 Data Migration Failed
My upgrade failed to migrate the data. Would like to rollback to 2022 as the error suggests. Any guidance?