ORA-7445 [kxcbexi] Raised by Merge Statement (Doc ID 2023152.1)

Last updated on JULY 28, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Merge statement fails with next error in the alert log: 

ORA-07445: exception encountered: core dump [kxcbexi()+55] [SIGSEGV] [ADDR:0xC1] [PC:0x2117E7B] [Address not mapped to object] []


The concerned table has a unique constraint specified as “DEFERRABLE INITIALLY DEFERRED”.

The call stack from the trace file includes functions like:

... kxcbexi kauupd updrow qerusEvalUpdWhere qerusRop qervwRowProcedure qerflRop qerjoRowProcedure qertbFetchByRowID qerjoFetch qerflFetch qervwFetch rwsfcd qerusFetch updaul updThreePhaseExe upsexe opiexe ...


The issue reproduces on 11.2.0.3, 11.2.0.4, 12.1.0.1, 12.1.0.2.

Disabling the unique constraint will let the merge SQL complete without error.

The error also reproduces after applying patch 13990707 for a similar issue, but related to IOTs.
Objects for the current issue do not concern an IOT.

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