-
Bug
-
Resolution: Unresolved
-
Major
-
3.2.4.Final, 3.3.1.Final, 3.4.0.Alpha1
-
None
-
False
-
-
False
When we see the INSERT and UPDATE for ID=11, those will be merged, but the LOB consolidation process only focuses on the column values, not the event metadata, so the UPDATE is folded into the INSERT, and the INSERT is left with a ROW_ID of all As.
And then when the ROLLBACK=1 is seen, we walk back through the transaction trying to find the event that we should discard by ROW_ID, but given that the UPDATE was folded into the INSERT and the INSERT only has a ROW_ID that is all As, we don't find a match, so we log a "Cannot undo ...." warning, and the event shows up in the target and isn't deleted/discarded; leading to a desync from source/sink.
When we fold UPDATE into INSERTs, we should update the ROW_ID reference if the're different and INSERT has the default dummy all As ROW_ID.
In our case in sink we see all the inserts/updates