Event_log error(s):
=============
Warning: Mismatch() partial rollback - messages counts mismatch(59:38) in session 5 [sp_opst_mt (for o.xxx-o.xxx queue xxx-04)/19271]
Notice: Transaction history for mismatch logged in /oradata/log/xxx_fb_19271_5.log. [sp_opst_mt (for o.xxx-o.xxxqueue xxx-04)/19271]
Warning: partial rollback - rowid mismatch (AAA+s5AD0AAAE5kAAr:AAA+srADgAAAKUyABX) in session 5 [sp_opst]
Capture miscalculates the forward and backward operations when the transaction is a rollback. This leads to the poster unable to roll back this transaction and thus producing the error.
WORKAROUND:
Version 5.3.1 and 5.3.2:
1) Run qview -p to automatically release the rollback transaction
2) Contact Shareplex support to manually release the rollback transaction
3) Upgrade Shareplex to version 5.3.3 after performing step 1 or 2
Additionally, in version 5.3.2, a new parameter (SP_OPO_CONTINUE_ON_MISMATCH) has been introduced. Setting this parameter value to 1 will allow post to continue on rowid mismatch.
sp_ctrl> set param SP_OPO_CONTINUE_ON_MISMATCH 1
sp_ctrl> start post
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy