8:26:20 AM (10.0.0.111)-SSL Disabled System.InvalidOperationException: This SqlTransaction has completed it is no longer usable.Īt .ZombieCheck()Īt .Commit()Īt () at .ZombieCheck()Īt () Here is some additional info from the sgvault.log file at the time of the deadlock: SPID: 149 ECID: 0 Statement Type: DELETE Line #: 30 SPID: 163 ECID: 0 Statement Type: INSERT Line #: 39 All of these are on the SgVault database. I've attached a screenshot from SQL Monitor showing the recent history of deadlocks. This is the SQL info from the latest instance. Is there something we can do to diagnose what's going on here? Or is this just related to how many users and transactions we have? I think these are related to Index maintenance on the SgVault database. Since we've upgraded to vault 6.1, we've been encountering fairly regular SQL deadlocks.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |