ORA-00600 [KGLBRK-BAD-LOCK] IN JOB QUEUE PROCESS DURING PROPAGATION (Doc ID 889745.1)

Last updated on MAY 15, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.


Symptoms

Propagation job fails with ORA-600 [KGLBRK-BAD-LOCK] and trace files generated with following error stack.

Sample trace file:

ORA-600: internal error code, arguments: [kglbrk-bad-lock], [0x365952A8],
[], [], [], [], [], [], [], [], [], []
kwqjaq: Reduced kwqjpr (Excp Handler):
kwqjwdrop: enter{
kwqjwdrop: checking schedule ("AQBQADM"."CO51", "AQBQADM"."CO54"@AQ$_LOCAL)
kwqjschupd: enter{
.
*** 2008-02-20 17:16:10.728
----- Current SQL Statement for this session (sql_id=8az1s9vjf7zk4) -----
call SYS.DBMS_AQADM_SYS.aq$_propagation_procedure (
:0,:1,:2,:3,:4,:5,:6,:7,:8,:9 )

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x3b498f3c 7552 package body SYS.DBMS_AQADM_SYS
0x3b498f3c 7954 package body SYS.DBMS_AQADM_SYS
<- psdextp  <- pefccal  <- pefcal  <- pevm_FCAL  <- pfrinstr_FCAL
<- pfrrun_no_tool  <- pfrrun  <- plsql_run  <- peidxr_run  <- peidxexe
<- kkxdexe  <- kkxmpexe  <- kgmexwi  <- kgmexec  <- evapls
<- evaopn2  <- kkxmexcs   <- opiexe  <- kpoal8   <- opiodr
<- kpoodr  <- upirtrc <- kpurcsc  <- kpuexec  <- OCIStmtExecute <- jslvec_execcb1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms