ORA-07445 [drexrfetch()+5104] from a CONTAINS query
(Doc ID 2642137.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Text - Version 11.2.0.4 and laterInformation 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] []
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,
...
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 |