ORA-00600 [kwqitnmphe:ltbagi] Errors even after the fix for Bug 17831758 and Bug 18536720 is in place (Doc ID 2002540.1)

Last updated on MAY 26, 2017

Applies to:

Oracle Database - Enterprise Edition
Information in this document applies to any platform.

Symptoms

The following error is reported in the Alert log:
ORA-00600: internal error code, arguments: [kwqitnmphe:ltbagi], [1], [0], [], [], [], [], [], [], [], [], []

The call stack in the trace file written by the error includes the following functions:
kwqitnmphe <- kwqmshise2 <- kwqitnmptme <- kwqmstmgr  <- kwqitmmit <- kwqitmmsgs <- kwqitptm <- kwqmnslv <- ksvrdp  <- opirip <- opidrv <- sou2o

The error occurs because there are still Historical Messages without a current Subscriber (a.k.a. orphaned entries in the History table), and can be confirmed by the following SQL statement:

select
sub_hist.NAME, sub_hist.SUBSCRIBER#, sub_hist.MSGID, msg.QUEUE, msg.MSG_STATE
from
AQ$_SYS$SERVICE_METRICS_TAB_H sub_hist,
AQ$SYS$SERVICE_METRICS_TAB msg
where
sub_hist.MSGID = msg.MSG_ID and
NOT EXISTS (select sub.SUBSCRIBER_ID from aq$_SYS$SERVICE_METRICS_TAB_s sub where sub_hist.subscriber# = sub.SUBSCRIBER_ID)
;

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