I have determined that the problem is more general than I have stated.
Simply put: there is an SQL Server request that is not completing and it is
blocking any requests to the same table made after it. I see a page level lock.
I can see a statement that is blocking/sleeping and then the one tha
I am not an expert at this, but i think this is what is happening:
- SLSB calls some method with transaction T1. In this T1 transaction, the
entity is inserted/updated (but not yet commited because the transaction is not
complete). During this flow, the @PostUpdate lifecycle method is called in