My Oracle Support Banner

ORA-07445: Exception Encountered: Core Dump [kdzca_buffer()+4186] [SIGSEGV] [ADDR:0x0] (Doc ID 2987916.1)

Last updated on MAY 02, 2024

Applies to:

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

Symptoms

ORA-7445 [kdzca_buffer()+4186] in a Wnnn slave with no current cursor

Tracefile -- fspsprd1_w00v_171313_i247423.trc

*** 2023-06-06T20:47:20.673894-04:00
*** SESSION ID:(2346.60037) 2023-06-06T20:47:20.673910-04:00
*** CLIENT ID:() 2023-06-06T20:47:20.673916-04:00
*** SERVICE NAME:(SYS$BACKGROUND) 2023-06-06T20:47:20.673921-04:00
*** MODULE NAME:(KTSJ) 2023-06-06T20:47:20.673927-04:00
*** ACTION NAME:(KTSJ Slave) 2023-06-06T20:47:20.673932-04:00
*** CLIENT DRIVER:(SERVER) 2023-06-06T20:47:20.673938-04:00

[TOC00000]
Jump to table of contents
Dump continued from file:
/u02/app/oracle/diag/rdbms/fspsprd/fspsprd1/trace/fspsprd1_w00v_171313.trc
[TOC00001]
ORA-07445: exception encountered: core dump [kdzca_buffer()+4186] [SIGSEGV]
[ADDR:0x0] [PC:0x133DDE8A] [Address not mapped to object] []

[TOC00001-END]
[TOC00002]
========= Dump for incident 247423 (ORA 7445 [kdzca_buffer]) ========
[TOC00003]
----- Beginning of Customized Incident Dump(s) -----
Dumping swap information
Memory (Avail / Total) = 189065.37M / 515489.57M
Swap (Avail / Total) = 16371.25M / 16384.00M
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0]
[PC:0x133DDE8A, kdzca_buffer()+4186] [flags: 0x0, count: 1]
Registers:
%rax: 0x0000000000000000 %rbx: 0x0000000000000400 %rcx: 0x0000000000000000
%rdx: 0x0000000000000000 %rdi: 0x00007fed414009c0 %rsi: 0x0000000000000001
%rsp: 0x00007ffc4f7d6d90 %rbp: 0x00007ffc4f7d6e80 %r8: 0x0000000000000008
%r9: 0x0000000000000000 %r10: 0x0000000000000000 %r11: 0x0000000000000000
%r12: 0x0000000000000400 %r13: 0x0000000000000000 %r14: 0x0000000000000010
%r15: 0x00007fed373264c8 %rip: 0x00000000133dde8a %efl: 0x0000000000010202
kdzca_buffer()+4175 (0x133dde7f) inc %esi
kdzca_buffer()+4177 (0x133dde81) mov -0x68(%rbp),%r8d
kdzca_buffer()+4181 (0x133dde85) xor %ecx,%ecx
kdzca_buffer()+4183 (0x133dde87) shr %r8d
> kdzca_buffer()+4186 (0x133dde8a) mov (%rdx),%rdx
kdzca_buffer()+4189 (0x133dde8d) test %r8d,%r8d
kdzca_buffer()+4192 (0x133dde90) jbe 0x133ddeca
kdzca_buffer()+4194 (0x133dde92) mov -0xe8(%rbp),%esi
kdzca_buffer()+4200 (0x133dde98) lea (%rcx,%rcx),%r9d

*** 2023-06-06T20:47:20.677965-04:00
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3,
mask=0x0)
[TOC00004]
----- SQL Statement (None) -----
Current SQL information unavailable - no cursor.
[TOC00004-END]
. . .
(session) sid: 2346 ser: 60037 trans: (nil), creator: 0x1ae81ca7b0
flags: (0x8000051) USR/- flags2: (0xc0409) -/-/INC
flags_idl: (0x1) status: BSY/-/-/- kill: -/-/-/-
DID: 0001-00CD-000000020001-00CD-00000003, short-term DID:
txn branch: (nil)
edition#: 0 user#/name: 0/SYS
oct: 3, prv: 0, sql: 0x1ffac950d0, psql: 0x2055142fa0
stats: 0x19f7311d80, PX stats: 0x13533184
service name: SYS$BACKGROUND
Current Wait Stack:
0: waiting for 'IM populate completion'
=0x0, =0x0, =0x0
wait_id=1169566 seq_num=55169 snap_id=6068
wait times: snap=1.330216 sec, exc=4.420565 sec, total=5.592803 sec
wait times: max=infinite, heur=5.592803 sec
wait counts: calls=0 os=0
in_wait=1 iflags=0x15a0
Wait State:
fixed_waits=0 flags=0x23 boundary=(nil)/-1
Session Wait History:
elapsed time of 0.000000 sec since current wait
0: waited for 'library cache pin'
handle address=0x20dbee4838, pin address=0x1fe99c9b98,
100*mode+namespace=0x880002
wait_id=1175634 seq_num=55168 snap_id=1
wait times: snap=0.000068 sec, exc=0.000068 sec, total=0.000068 sec
wait times: max=0.000000 sec
wait counts: calls=2 os=2
occurred after 0.000000 sec of elapsed time

 

Changes

Moved from 19.13 on Supercluster to 19.19 on EXACC.
Using inmemory_size of 16G on Supercluster, and is using inmemory_size of 96G on each node in EXACC.

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.