ORA-600 [qerpxInitialize0] Occured In SQL with union all and Parallel with concatenate (Doc ID 1580875.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

  1. A query running with parallellism fails with:
    ORA-00600: internal error code, arguments: [qerpxInitialize0], [0], [], [], [], [], [], [], [], [], [], []


  2. Review of the generated tracefiles reveals a call stack similar to:
    ... <- $cold_qerpxInitiali <- qkaParallelizersTraverse <- qkaParallelizersTraverse <- qkaParallelizersTraverse <- qkaParallelizersTraverse <- qkaParallelizersTraverse <- qkaParallelizersTraverse <- qkaParallelizersTraverse <- qkaTraverseQknDescendents <- qkaTraverseQkn <- qkadrv2Post <- qkadrv2 <- opitca <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0 <- ...


  3. The failing query shows:
    SELECT
    /*+ PARALLEL(A, 4) */ LPAD(ROWNUM, 6) || ' ' || A.KWA_C || LPAD(A.ACSER, 9, '0') || ' ' || LPAD(A.NOW_DEP_AC_S, 2) || ' ' || LPAD(AC_GRBRNO, 4) || ' ' || LPAD(AC_JAN, 18) || ' ' || CUSNO || ' ' || NVL(A.MKDT, ' ') || ' ' || NVL(HJI_DT, ' ') || ' ' || GU_BNK_G || ' ' || GU_ACNO, 1
    FROM
    SDA_FDEP_MAS A,
    SDA_MOFD_MAS B
    WHERE
    A.KWA_C < 180
    OR A.KWA_C > 189
    AND B.KWA_C = A.KWA_C
    AND B.ACSER = A.ACSER ;

Changes

 none

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