Since the end of last month we've noticed the amount of items pending to be synced with our cloud site increasing.
Current status: Pending items 34507
Errors:
2025-05-24 15:16:08,656 [.NET TP Worker] INFO LOGASSETJOURNALTRACKER ERROR Error occurred while processing the data: Transaction (Process ID 124) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Error deleting entity. Query: SET DATEFORMAT 'YMD'; DELETE FROM [tblChangeTracking] WHERE [RootEntityId] = 13 /* Asset */ AND [RootId] = '172083' Transaction (Process ID 124) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.at Lansweeper.Service.Syncer.RegularSync.ChangeTracking.ChangeTrackingRepository.DeleteEntityChangesAsync(String connectionString, ChangeTrackingKey trackingKey)
at Lansweeper.Service.Syncer.RegularSync.Contexts.BasePolicyContextManager`1.DeleteChangesOfDeletedEntities(SyncConfiguration syncConfiguration, IEnumerable`1 entitiesToDelete)
at Lansweeper.Service.Syncer.RegularSync.Contexts.BasePolicyContextManager`1.ProcessAndSendEntitiesAsync(IEnumerable`1 entitiesInContext, SyncConfiguration syncConfiguration, GrpcChannel channel, DateTime processTime)
at Lansweeper.Service.Syncer.RegularSync.Contexts.BasePolicyContextManager`1.ProcessChanges(SyncConfiguration syncConfiguration, RegularSyncInfo syncInfo, GrpcChannel channel, DateTime processTime, UpdateSyncConfiguration updateSyncConfiguration)
at Lansweeper.Service.Syncer.RegularSync.RegularSyncService.StartRegularSync(SyncConfiguration syncConfiguration, UpdateSyncConfiguration updateConfig, IObserver`1 statusObserver, GrpcChannel grpcChannel)
2025-05-28 12:37:53,370 [.NET TP Worker] INFO LOGLECJOBS ERROR LecMessageHandlerJob: an error occurred while trying to receive commands. Status(StatusCode="Unavailable", Detail="unavailable")
-*...*-
2025-05-29 15:23:43,104 [.NET TP Worker] INFO LOGLECJOBS ERROR LecMessageHandlerJob: an error occurred while trying to receive commands. Status(StatusCode="Unavailable", Detail="unavailable")
at Grpc.Net.Client.Internal.HttpContentClientStreamReader`2.MoveNextCore(CancellationToken cancellationToken)
at Lansweeper.Service.LECServiceAgent.BL.Jobs.LecMessageHandlerJob..MoveNext()
What can we do to fix the sync?