ORA-07445: Exception Encountered: Core Dump [kkqctJuxtaposeGBP()+674] [SIGSEGV] [ADDR:0x0] [PC:0xAFB
(Doc ID 2121160.1)
Last updated on JULY 26, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Executing a (generated) select statement, this fails with error:
ORA-07445: exception encountered: core dump [kkqctJuxtaposeGBP()+674] [SIGSEGV] [ADDR:0x0] [PC:0xAFB9052] [Address not mapped to object] []
The trace file shows characteristics like:
----- Current SQL Statement for this session (sql_id=...) -----
SELECT
"<SCHEMA_NAME1>"."<TABLE_NAME1>" AS "<ALIAS1>" ,
"<SCHEMA_NAME12>"."<TABLE_NAME2>" AS "<ALIAS2>" ,
COUNT( * ) AS "<ALIAS3>" ,
SUM ( "F"."/BIC/CAS_AMNT" ) AS "<ALIAS4>"
FROM
"<TABLE_NAME3>" "<ALIAS5>"
JOIN
"<TABLE_NAME4>" "<ALIAS6>"
ON "<ALIAS5>" . "<COLUMN1>" = "ALIAS6" . "<COLUMN2>"
...
----- Call Stack Trace -----
... kkqctJuxtaposeGBP kkqctdrvVT kkqvtdir qksqbApplyToQbc kkqctdrvTD kkqvtdrv kkqdrv kkqctdrvIT apadrv opitca kksFullTypeCheck rpiswu2 kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0 kpoal8 opiodr ...
"<SCHEMA_NAME1>"."<TABLE_NAME1>" AS "<ALIAS1>" ,
"<SCHEMA_NAME12>"."<TABLE_NAME2>" AS "<ALIAS2>" ,
COUNT( * ) AS "<ALIAS3>" ,
SUM ( "F"."/BIC/CAS_AMNT" ) AS "<ALIAS4>"
FROM
"<TABLE_NAME3>" "<ALIAS5>"
JOIN
"<TABLE_NAME4>" "<ALIAS6>"
ON "<ALIAS5>" . "<COLUMN1>" = "ALIAS6" . "<COLUMN2>"
...
----- Call Stack Trace -----
... kkqctJuxtaposeGBP kkqctdrvVT kkqvtdir qksqbApplyToQbc kkqctdrvTD kkqvtdrv kkqdrv kkqctdrvIT apadrv opitca kksFullTypeCheck rpiswu2 kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0 kpoal8 opiodr ...
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 |