My Oracle Support Banner

ORA-07445 [kgghtIterInit2()+146], ORA-07445 [drekmap()+1670] From PQ Text Index Creation (Doc ID 2728678.1)

Last updated on NOVEMBER 13, 2020

Applies to:

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

Symptoms

Parallel Text index creation during FULL DB IMPORT fails with errors:

Thu Feb 06 16:27:20 2020
Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x7F2EF502F000] [PC:0x51C84A6, drekmap()+1670] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_p001_267208.trc (incident=1195880):
ORA-07445: exception encountered: core dump [drekmap()+1670] [SIGSEGV] [ADDR:0x7F2EF502F000] [PC:0x51C84A6] [Invalid permissions for mapped object] []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/ORCL/incident/incdir_1195880/ORCL_p001_267208_i1195880.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x39BBE12, kgghtIterInit2()+146] [flags: 0x0, count: 2]
Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_p001_267208.trc (incident=1195881):
ORA-07445: exception encountered: core dump [kgghtIterInit2()+146] [SIGSEGV] [ADDR:0x0] [PC:0x39BBE12] [SI_KERNEL(general_protection)] []
ORA-07445: exception encountered: core dump [drekmap()+1670] [SIGSEGV] [ADDR:0x7F2EF502F000] [PC:0x51C84A6] [Invalid permissions for mapped object] []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/ORCL/incident/incdir_1195881/ORCL_p001_267208_i1195881.trc


Incident trace file shows:

----- Current SQL Statement for this session (sql_id=4skvmx0waw9sh) -----
select column_value from
table(cast(ctxsys.drvparx.ParallelPopuIndex(cursor(select /*+
DYNAMIC_SAMPLING(0) PARALLEL(base 8) FULL(base) NOCACHE(base) */ rowid, NULL,
NULL, NULL, NULL, 'N', base."VALOR"    from "ARCONTE"."ADVCTEXTCF" base),
:idxownid, :idxid, :idxown, :idxname, :ixpname,:popstate) as
sys.odcivarchar2list))

----- Call Stack Trace -----
drekmap drepprep dreb_populate drftpopx drftpara drexpmain spefcpfa


Issue is reproduced when manually creating the index with PARALLEL > 1:


Index is created successfully when PARALLEL=1.

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.