Issue ID:
Type
Bug
Title:
FIX: Replication errors on edge edition hub (regression from PG-2430)
Created:
8/17/2023 12:11:15 PM by Steve Dennis
Status:
Awaiting Release on 8/18/2023 3:18:53 PM
Last pulled:
8/18/2023 3:18:53 PM
Description:
PG-2430 introduces the following errors during replication. ``` Logged:8/13/2023 5:41:03 PM Level:Error Category:Feed Replication Message:Feed replication connection attempt failed for feed release_images: 2627`14`1`ReplicationClients_CreateOrUpdateEntry`33`Violation of UNIQUE KEY constraint 'UQ__ReplicationClients'. Cannot insert duplicate key in object 'dbo.ReplicationClients'. The duplicate key value is (55, proget.repo.genetronic.corp). Details:Stack trace: Microsoft.Data.SqlClient.SqlException (0x80131904): 2627`14`1`ReplicationClients_CreateOrUpdateEntry`33`Violation of UNIQUE KEY constraint 'UQ__ReplicationClients'. Cannot insert duplicate key in object 'dbo.ReplicationClients'. The duplicate key value is (55, proget.repo.genetronic.corp). at Microsoft.Data.SqlClient.SqlCommand.<>c.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.ProGet.WebApplication.SimpleHandlers.FeedSync.FeedSyncHandler.ProcessRequestInternalAsync(AhHttpContext context) ClientConnectionId:885f0add-772a-4913-8243-16c7d1730368 Error Number:50000,State:42,Class:14 Request details: IP address: proget.repo.genetronic.corp User agent: ProGet/23.0.14.17 (Microsoft Windows NT 10.0.14393.0) Headers: X-ProGet-ClientSyncMode: PullOnly Logged:8/13/2023 5:40:43 PM Level:Error Category:Feed Replication Message:Feed replication connection attempt failed for feed dev_images: 512`16`1`ReplicationClients_CreateOrUpdateEntry`27`Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. Details:Stack trace: Microsoft.Data.SqlClient.SqlException (0x80131904): 512`16`1`ReplicationClients_CreateOrUpdateEntry`27`Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. at Microsoft.Data.SqlClient.SqlCommand.<>c.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.ProGet.WebApplication.SimpleHandlers.FeedSync.FeedSyncHandler.ProcessRequestInternalAsync(AhHttpContext context) ClientConnectionId:53bb9605-a3e9-43cb-8871-3dca091de484 Error Number:50000,State:42,Class:16 Request details: IP address: proget.repo.genetronic.corp User agent: ProGet/23.0.14.17 (Microsoft Windows NT 10.0.17763.0) Headers: X-ProGet-ClientSyncMode: PullOnly ```