My Oracle Support Banner

ORA-07445 [drexrfetch()+5104] from a CONTAINS query (Doc ID 2642137.1)

Last updated on FEBRUARY 26, 2020

Applies to:

Oracle Text - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

A large application query that includes a subquery with a CONTAINS clause terminates with an ORA-03113 and an error in the alert.log:

Incident 263719 created, dump file: /u01/oracle/.../incident/incdir_263719/ORCL_ora_5890_i263719.trc
ORA-07445: exception encountered: core dump [drexrfetch()+5104] [SIGSEGV] [ADDR:0x0] [PC:0x10D92D670] [Address not mapped to object] []


The trace file shows the failing query is:

----- Current SQL Statement for this session (sql_id=12abcde459gh) -----
SELECT  *
 FROM
 (
  SELECT bq.relevance_score Relevance,
         bq.inventory_item_id INVENTORY_ITEM_ID,
         msikfv.organization_id ORGANIZATION_ID,
         ...
         av.TEXT_BASE_ATTRIBUTE5 TEXT_BASE_ATTRIBUTE5
   FROM (
          SELECT ctxh.inventory_item_id,
                 ctxh.po_line_id,
                 ...,
                 ctxh.suggested_quantity,
                 ctxh.s relevance_score,
                 1 as is_item_available,
                 ...
                 ctxh.committed_amount as committed_amount
          FROM (
                   select score(1) s, c.*
                   from icx_cat_items_ctx_hdrs_tlp c
                   where contains(c.ctx_desc, :INTERMEDIA_KEY2, 1) > 0
                ) ctxh
           WHERE ctxh.req_template_name = :REQ_TEMPLATE_NAME_KEY1 AND
                 contains(ctxh.ctx_desc, :INTERMEDIA_KEY1, 1) > 0 AND
                 ICX_CAT_UTIL_PVT.is_item_valid_for_search( ctxh.source_type, ...) = 1
        ) bq ,
        po_system_parameters_all psp, mtl_units_of_measure_tl muomtl,
        ...

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.