VMware Cloud Community
Ravindra01
Enthusiast
Enthusiast

Transaction (Process ID 106) was deadlocked on lock resources with another process : vRA 7.2 Logs

Hello All,

I see lot of errors in vRA Infra Logs as below , not sure what exactly it mean.  Is the dead lock on IAAS SQL server DB or in vRA postgress  DB ??

Is there any work around or solutions for this ??

Exception has been thrown by the target of an invocation.

Inner exception: The maximum number of transaction retry attempts, 40, was reached.

Inner exception: An error occurred while executing the command definition. See the inner exception for details.

Inner exception: Transaction (Process ID 106) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

0 Kudos
1 Reply
daphnissov
Immortal
Immortal

Is this a clustered environment? You may be having network issues or storage performance issues in some cases.

0 Kudos