ORA-7445 [Kgwsfin] on Update of Table With Deferrable Constraint (Doc ID 956702.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

A combination of INSERT and UPDATE on a table with deferrable constraint enabled, results in:

ORA-07445: [kgwsfin()+192] [SIGSEGV] [Address not mapped to object] [0x100000004] [] []

with call stack similar to:

kgwsfin, kxcbexi, kauupd, updrow, qerupRowProcedure, qerupFetch, updaul


Changes

The problem occurs at INSERT followed by an UPDATE on a table, after adding a constraint with 'DEFERRABLE INITIALLY DEFERRED USING INDEX'.

Hint:
Use dictionary view ALL/DBA/USER_CONSTRAINTS, column DEFERRABLE to check if constraint is deferrable or not.


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