ORA-7445 [KKMUPD()+5053] On Merge (Doc ID 1643604.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

The following error is encountered in the alert log and trace file :

ORA-07445: exception encountered: core dump [kkmupd()+5053] [SIGSEGV] [ADDR:0x0] [PC:0x1A50F8D] [SI_KERNEL(general_protection)] []


The trace file shows a MERGE statement similar to the below

ORA-07445: exception encountered: core dump [kkmupd()+5053] [SIGSEGV] [ADDR:0x0] [PC:0x1A50F8D] [SI_KERNEL(general_protection)] []

Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x1A50F8D, kkmupd()+5053] [flags: 0x0, count: 1]
Registers:
%rax: 0x0000000000000000 %rbx: 0x00000000d141dd68 %rcx: 0x00007fb9cde57530
%rdx: 0x00007fb9cde57c88 %rdi: 0x706f6371203a6665 %rsi: 0x0000000000000000
%rsp: 0x00007fff75f30ca0 %rbp: 0x00007fff75f34400 %r8: 0x0000000000000000
%r9: 0x00000000d141d888 %r10: 0x000000000a490e88 %r11: 0x0000000000000000
%r12: 0x00000000d141d888 %r13: 0x00007fb9cdfb1110 %r14: 0x00000000d141e228
%r15: 0x00007fb9cdfb45d0 %rip: 0x0000000001a50f8d %efl: 0x0000000000010202
kkmupd()+5034 (0x1a50f7a) test %r13,%r13
kkmupd()+5037 (0x1a50f7d) je 0x1a50fa1
kkmupd()+5039 (0x1a50f7f) mov 0x118(%r10),%rdi
kkmupd()+5046 (0x1a50f86) mov 0x118(%r13),%r9
> kkmupd()+5053 (0x1a50f8d) mov 0xd8(%rdi),%r8d
kkmupd()+5060 (0x1a50f94) cmp 0xd8(%r9),%r8d
kkmupd()+5067 (0x1a50f9b) jz 0x1a507ee
kkmupd()+5073 (0x1a50fa1) mov 0x38(%r10),%edi
kkmupd()+5077 (0x1a50fa5) test $0x400,%edi

----- Current SQL Statement for this session (sql_id=2jmmry2jg36fu) -----
MERGE INTO (SELECT..


The call stack section in the trace file includes functions like:

----- Incident Context Dump -----
Address: 0x7fb9ce17f5a8
Incident ID: 1175041
Problem Key: ORA 7445 [kkmupd()+5053]
Error: ORA-7445 [kkmupd()+5053] [SIGSEGV] [ADDR:0x0] [PC:0x1A50F8D] [SI_KERNEL(general_protection)] [] [] [] [] [] [] []
[00]: dbgexExplicitEndInc [diag_dde]
[01]: dbgeEndDDEInvocationImpl [diag_dde]
[02]: dbgeEndDDEInvocation [diag_dde]
[03]: ssexhd []
[04]: __sighandler []
[05]: kkmupd [SQL_Semantic]<-- Signaling
[06]: kkmups [SQL_Semantic]
[07]: opiprsdml []
[08]: opiprsdmlcb []
[09]: kkqcttcalo [SQL_Transform]
[10]: kkqctdrvIT [SQL_Transform]
[11]: apadrv [SQL_APA]
[12]: opitca []
[13]: kksFullTypeCheck [cursor]
[14]: rpiswu2 []
[15]: kksLoadChild [cursor]
...

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