ORA-600 [504], ..., [Transaction Branch Allocation] Error When Using XA [ID 868527.1]

ORA-600 [504], ..., [Transaction Branch Allocation] Error When Using XA [ID 868527.1]
   修改时间 08-SEP-2010     类型 PROBLEM     状态 MODERATED  

In this Document
  Symptoms
  Cause
  Solution
  References

Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:
Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.0 - Release: 11.1 to 11.2

Symptoms

ORA-600 [504],..., [66], [6], [transaction branch allocation] errors raised when using distributed transactions.  The trace file will show a call stack similar to the following:

ksl_level_check kslgetl ktcsbr kpotxst kpotxsking kpotxen ...

The process state dump will also show that the current session is already holding the 'transaction branch allocation' latch in module k2gget(), e.g.:

(latch info) wait_event=0 bits=42
holding (efd=4) 700000000026348 transaction branch allocation level=6
Location from where latch is held: ktccts.h LINE:592 ID:k2gget:before marking killed:
Context saved from call: 1152921504606827524
state=busy [holder orapid=70] wlstate=free [value=0]
holding (efd=4) 700000059e7f9a0 Child global tx hash mapping level=1 child#=23
...

Cause

This is due to unpublished bug:8607693 fixed in 12.1, 11.2.0.2 and 11.1.0.7.3, as identified in bug:8692822.
Solution
There is no workaround available to this problem which occurs when two or more sessions simultaneously attempt to rollback an XA transaction branch.  Thereforeplease check for availability of one-off patches for your specific version and platform via Patch:8607693.
References
BUG:8692822 - D INV INTERFACE ITEMS WITH PRE
NOTE:28104.1 - ORA-600 [504] "Trying to obtain a latch which is already held"

显示相关信息 相关内容
产品

    Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition

关键字
XA TRANSACTION; DISTRIBUTED TRANSACTIONS
错误
ORA-600[[504]; ORA-600[504]