Local Propagation - Ora-00600 Kwqbdrcp101 Occurs After Instance Restart With Queue Spill (Doc ID 1403505.1)

Last updated on MAY 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Streams Local propagation or having a propagation job sending LCRs from a Streams Capture queue to
another separate queue on the same database where an Apply process will consume these LCRs

Queue spill is present on the Cpature queue. This may be due to a high workload of LCRs for the Capture
to process and the Apply process may have been stopped.

When instance the Oracle instance is stopped then restarted and following this action,  the propagation job
reports errors of form :

kwqpbdeq: Error 600 occured when deleting acked messagesfor queue:106939 destination:"STRMADMIN"."STRM_QUEUE_APPLY001"@AQ$_LOCAL
ORA-00600: internal error code, arguments: [kwqbdrcp101], [], [], [], [], [], [], [], [], [], [], []

Functions at the top of the stack in the associated incident trace file :

...

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