ORA-7445 [KKQSTERF()+744] [SIGSEGV] On Select With Connect By

(Doc ID 784896.1)

Last updated on NOVEMBER 10, 2014

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7
This problem can occur on any platform.
Oracle Server Enterprise Edition - Version: 11.1.0.7

Symptoms

Error ORA-07445: exception encountered: core dump [kkqsterf()+660] [SIGSEGV] is reported to the instance alert.log on select statements that use a join and a connect by clause.

 SELECT ZZ.RESOURCE_ID ,
  ZZ.PARENT_RESOURCE_ID,
  ZZ.SORT_ORDER        ,
  ZZ.BALLOT_NUM        ,
  ZZ.ENTRD_BY_CUST_NUM ,
  ZZ.UPDTD_BY_CUST_NUM ,
  ZZ.BALLOT_COMMENT_GEN_NUM
   FROM resource_usage ru
JOIN resource_repository ZZ
     ON rr.resource_id     = ZZ.resource_id
AND ZZ.appl_cd             = 'WALK'
AND ZZ.hier_cd             = 'TABBZ2'
AND ZZ.prod_cd             = 'AX243' 
CONNECT BY prior ZZ.resource_id = ZZ.parent_resource_id START
WITH ZZ.parent_resource_id = 36868

The call stack list in the trace file will have the following functions listed.

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- ssexhd 
<- kkqsterf <- kkqstrtedrv <- qksqbApplyToQbcLoc <- qksqbApplyToQbc
<- kkqdrv <- opiSem <- opiDeferredSem <- opitca <- kksFullTypeCheck
<- rpiswu2 <- kksSetBindType <- kksfbc <- opiexe <- kpoal8 <- opiodr 
<- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real 
<- ssthrdmain <- main <- libc_start_main <- start

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