We have two tracking event processors configured which sends messages to two different messaging queues. But, we encounters the following exception often from TEP’s
Transaction (Process ID) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
org.hibernate.exception.LockAcquisitionException: could not execute query. Preparing for retry in 1s.
org.hibernate.exception.LockAcquisitionException: could not load an entity.
Axon Framework Version: 4.0.3
DB: SQL Server 2012
Token store: Having clustered index with processor_name and segment (which i think does row level locking)
Can anyone help me in configuring the token store table to avoid this deadlock scenario?