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
```