James Synge wrote:
I'm trying to debug a deadlock, and would like to better understand the names of the locks involved. For example:

      ROW, BUILD_REQUEST, (11,1)

My guess is that this means that I'm dealing with a lock on a row in the BUILD_REQUEST table, and that it is probably row 1 in block (or page?) 11. Can anyone confirm this?

Thanks,
James
Yes this indicates a ROW level lock on BUILD_REQUEST at page and row number (11,1)



Reply via email to