Return
-
Title
Post not moving on RAC getting: "Unexpected Oracle error: ORA-25402" -
Description
event_log has the below entries07/21/08 01:34 Process exited sp_opst (for o.SOURCE_SID-o.TARGET_SID queue NAME) [pid = 5861] - exit(1)07/21/08 01:34 Error: Unexpected Oracle error: ORA-25402: transaction must roll back. (object name:"TABLE_OWNER"."TABLE_NAME") [sp_opst (for o.SOURCE_SID-o.TARGET_SID queue NAME)/PID]07/21/08 01:34 Notice: ORA-25402: transaction must roll back. [sp_opst(osp)/PID] -
Cause
ORA-25402: transaction must roll backCause: A failure occured while a transaction was active on this connection.Action: The client must roll back.This may be some kind of network distrupion when the transection in progress. Check the network. This could also be a general problems. If network problem it is unlikely that the client would still be connected and able to issue a rollback. What Oracle wants is for the client to issue an explicit rollback statement.There is an Oracle bug that produces this error only confirmed to be in 9.2.0.3 where after Transaction Failover a commit or rollback incorrectly produces this error. According to the note a Select should produce this error. This would need to be a RAC system that uses transaction failoverfor this to apply: Note:2652886.8 Also TAF problem: Note:2652845.8 -
Resolution
Workround :
1) Debug post, to identify subque # and queue sequence # to discard -- See Solution SOL25
sp_ctrl> set param SP_OPO_DEBU_FLAG 0x01f000ff
2) start post
sp_ctrl> start post
3) monitor for post to stop by status command
sp_ctrl> status
4) When post stops, check post *opo* log for error "ORA-25402"
Example:
08-07-21 02:41:19.113049 3811 -152954656 OCI_ExecN: -1:ORA-25402: transaction must roll back
5) Find the subque# and queue # number for record that errored in poster *opo* log
Example:
Sque 2, seq 222284160637, mid 698473539, sqmid 484491547, mflags 0
6) Discard record --- See Solution SOL24445
Example:
discard 2 222284160637Note: Message discard will cause out of sync. The table needs to be resynced.
-
Additional Information
In RAC Environments