I am getting some strage deadlock issues. First, I am getting a deadlock on a put command after i've issued a get with DB_RMW. And then after the deadlock with the debugging at a breakpoint, if I query the lock objects then I only get one entry
80000093 WRITE 2 HELD indexing.db page 3
How can I deadlock on a put if I've already got the write lock with the RMW. And then how can I deadlock with no other WAIT/HOLD in the table.
I also have the timeout set up very long to try to diagnose the deadlock but the LOCK_DEADLOCK response immediately (and it doesn't mark it as a deadlock in the summary count)
0 Number of deadlocks
50M Lock timeout value (50000000)