Failed to process the event type ReconciliationHasStartedEvent #1509

21/02/2026 08:33:29.0880 | Error |Correlation ID: 8074e1b4-93a7-4d98-a646-31ac642e80d6| Shared.EventStore.SubscriptionWorker.PersistentSubscription.EventAppeared | Failed to process the event type ReconciliationHasStartedEvent {"transactionId":"3b000886-7dd8-437b-b83d-73f89315904f","estateId":"435613ac-a468-47a3-ac4f-649d89764c22","merchantId":"ab1c99fb-1c6c-4694-9a32-b71be5d1da33","transactionDateTime":"2026-01-09T23:50:21.5239875+00:00"} Result was One or more event handlers have failed. Error Messages [Unique constraint violation
Cannot insert duplicate key row in object 'dbo.reconciliation' with unique index 'IX_reconciliation_TransactionId_MerchantId'. The duplicate key value is (3b000886-7dd8-437b-b83d-73f89315904f, ab1c99fb-1c6c-4694-9a32-b71be5d1da33).] | System.Exception