D
Dapeng Wu
Guest
Gus, As to 5): the "magic" trick to find RL_CXSP2, I don't think it's due to the jump note. Jump notes are transaction based, which means when a transaction rolls back, it only cares about the notes written by itself. In this case, RL_CXSP2 was written by trid 1002168778, but the transaction rolled back was 1002166296 which only had 8 notes and that's all that transaction needs to take care of. The reason why trid 1002166296 can find the new location of an index entry is done by an index B-tree lookup. In addition, RL_CXSP2 is a physical note, which will be just ignored during online transaction roll back. So even if trid 1002168778 rolls back, you won't find any compensation note of a RL_CXSP2 in its transaction undo note trace.
Continue reading...
Continue reading...