My Oracle Support Banner

When Flash Cache Enable For The Table Instance Reported ORA-07445: EXCEPTION ENCOUNTERED: CORE DUMP [KCLFLASH2LE()+199] (Doc ID 2740143.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

When Flash Cache Enable For The Table DB Instance Reported  ORA-07445: EXCEPTION ENCOUNTERED: CORE DUMP [KCLFLASH2LE()+199]

Db alert instance 1 alert_<DB_NAME>1.log
===============
2020-11-10T07:30:50.725175+01:00
TABLE <DB_NAME>_LDS_CCS.LD_CCS_PK_LOG_REPORT: ADDED INTERVAL PARTITION SYS_P1524062
(2174) VALUES LESS THAN (TO_DATE(' 2020-11-10 00:00:00', 'SYYYY-MM-DD
HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2020-11-10T07:31:01.326003+01:00
ARC1 (PID:3572): Archived Log entry 1488717 added for T-1.S-239241 ID
0x854f947e LAD:1
2020-11-10T07:31:26.521489+01:00
TABLE <DB_NAME>_LDS_CCS.LD_CCS_PK_MAIN_REPORT_NEW: ADDED INTERVAL PARTITION
SYS_P1524063 (1499) VALUES LESS THAN (TO_DATE(' 2020-11-10 00:00:00',
'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2020-11-10T07:31:28.508243+01:00
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xDB]
[PC:0x8596047, kclflash2le()+199] [flags: 0x0, count: 1]
Errors in file <ORACLE_BASE>/diag/rdbms/<DB_NAME>/<DB_NAME>1/trace/<DB_NAME>1_ora_22143.trc  
(incident=745154):
ORA-07445: exception encountered: core dump [kclflash2le()+199] [SIGSEGV]
[ADDR:0xDB] [PC:0x8596047] [Address not mapped to object] []
Incident details in:
<ORACLE_BASE>/diag/rdbms/<DB_NAME>/<DB_NAME>1/incident/incdir_745154/<DB_NAME>1_ora_22143_i745154.
trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2020-11-10T07:31:34.298907+01:00
Dumping diagnostic data in directory=[cdmp_20201110073134], requested by
(instance=1, osid=22143), summary=[incident=745154].
2020-11-10T07:32:36.186418+01:00
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xD0]
[PC:0x85960F0, kclflash2le()+368] [flags: 0x0, count: 1]
Errors in file <ORACLE_BASE>/diag/rdbms/<DB_NAME>/<DB_NAME>1/trace/<DB_NAME>1_ora_25251.trc  
(incident=745155):
ORA-07445: exception encountered: core dump [kclflash2le()+368] [SIGSEGV]
[ADDR:0xD0] [PC:0x85960F0] [Address not mapped to object] []
Incident details in:
<ORACLE_BASE>/diag/rdbms/<DB_NAME>/<DB_NAME>1/incident/incdir_745155/<DB_NAME>1_ora_25251_i745155.
trc

==============

<SID>_ora_22143_i745154.trc
========================
*** CLIENT DRIVER:(jdbcthin : 12.2.0.1.0) 2020-11-10T07:31:28.567157+01:00
 
[TOC00000]
Jump to table of contents
Dump continued from file:
<ORACLE_BASE>/diag/rdbms/<DB_NAME>/<DB_NAME>1/trace/<DB_NAME>1_ora_22143.trc
[TOC00001]
ORA-07445: exception encountered: core dump [kclflash2le()+199] [SIGSEGV]
[ADDR:0xDB] [PC:0x8596047] [Address not mapped to object] []

[TOC00001-END]
[TOC00002]
========= Dump for incident 745154 (ORA 7445 [kclflash2le]) ========
[TOC00003]
----- Beginning of Customized Incident Dump(s) -----
Dumping swap information
Memory (Avail / Total) = 132194.14M / 1547523.93M
Swap (Avail / Total) = 65527.82M /  65536.00M
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xDB]
[PC:0x8596047, kclflash2le()+199] [flags: 0x0, count: 1]
Registers:
%rax: 0x0000000000000000 %rbx: 0x0000000000000000 %rcx: 0x00007ffc51d249d0
%rdx: 0x00000032665bad10 %rdi: 0x0000000000000000 %rsi: 0x000000000000000f
%rsp: 0x00007ffc51d19170 %rbp: 0x00007ffc51d19680  %r8: 0x0000000000000264
 %r9: 0x000000000000000f %r10: 0x0000000000000010 %r11: 0x00000032645a63d0
%r12: 0x0000000000000026 %r13: 0x00007ffc51d23f78 %r14: 0x00007f67963409c0
%r15: 0x0000000000000026 %rip: 0x0000000008596047 ïl: 0x0000000000010246
  kclflash2le()+180 (0x8596034) xor ëx,ëx
  kclflash2le()+182 (0x8596036) mov -0x98(%rbp),%r9
  kclflash2le()+189 (0x859603d) mov êx,-0x28(%rbp)
  kclflash2le()+192 (0x8596040) mov 0x57a7cec1(%rip),%rdx
> kclflash2le()+199 (0x8596047) mov 0xcc(%r9),êx
  kclflash2le()+206 (0x859604e) mov %rax,%r10
  kclflash2le()+209 (0x8596051) mov 0xc0(%r9),%r8
  kclflash2le()+216 (0x8596058) mov %r8,%rdi
  kclflash2le()+219 (0x859605b) shr $0x20,%rdi

*** 2020-11-10T07:31:28.570307+01:00
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3,
mask=0x0)
[TOC00004]
----- Current SQL Statement for this session (sql_id=10nxb69udw8q2) -----
insert /*+ APPEND PARALLEL */ into <DB_NAME>_PA_MIS.BO_PK_MAIN
(
    IKTATOSZAM,
    ALLAPOT,
    STATUSZ,
    BEJELENTES_DATUMA,
    MEGOLDAS_DATUMA,
    MEGOLDO_NEVE,
    MEGOLDO_SZERV_EGYS,
    MEGOLDASI_CIKLUSIDO,
    TERMEKTIPUS,
    UGYFEL_SZEGMENS,
    BEERKEZESI_CSATORNA,
    K1,
    K2,
    K3,
    BEJELENTES_TIPUSA,
    JOGOSSAG,
    SULYOSSAG,
    VISSZATERO_PANASZ,
    HIBA_OKA1,
    HIBA_OKA2,
    ELUTASITAS_OKA,
    ELUTASITAS_OKA_EGYEB,
    JOVAIRT_OSSZEG,
    JOVAIRT_OSSZEG_DEVIZANEM,
    REKLAMALT_OSSZEG,
    REKLAMALT_OSSZEG_DEVIZANEM,
    UGYFELAZONOSITO1,
    UGYFELAZONOSITO2,
    UGYFEL_NEVE,
    UGYFEL_CIM_IRSZ,
    UGYFEL_CIM_VAROS,
    UGYFEL_CIM_UTCA_HSZ,
    UGYFEL_TELSZAM_KORZET,
    UGYFEL_TELSZAM,
    UGYFEL_TELSZAM_MELLEK,
    UGYFEL_EMAILCIM,
..
'[TOC00005]
----- Call Stack Trace -----
calling              call     entry                argument values in hex    
 
location             type     point                (? means dubious value)    
 
-------------------- -------- --------------------
----------------------------
ksedst1()+110        call     kgdsdst()            7F6791672F20 000000003
                                                   7F679166D260 ?
7F679166D378 ?
                                                   7F6791672A40 ? 000000083 ?
ksedst()+64          call     ksedst1()            000000001 000000001
                                                   7F679166D260 ?
7F679166D378 ?
                                                   7F6791672A40 ? 000000083 ?
dbkedDefDump()+2385  call     ksedst()             000000001 000000001 ?
9                                                  7F679166D260 ?
7F679166D378 ?
                                                   7F6791672A40 ? 000000083 ?
ksedmp()+593         call     dbkedDefDump()       000000003 000000003
                                                   7F679166D260 ?
7F679166D378 ?
                                                   7F6791672A40 ? 000000083 ?
ssexhd()+2687        call     ksedmp()             00000044F 000000003 ?
                                                   7F679166D260 ?
7F679166D378 ?
                                                   7F6791672A40 ? 000000083 ?
sslssSynchHdlr()+39  call     ssexhd()             00000000C 000000009
000000007
9                                                  000000011 7F6791673908
                                                   000000083 ?
sslsshandler()+105   call     sslssSynchHdlr()     000002000 000000000
000000000
                                                   000000011 ? 7F6791673908 ?
                                                   000000083 ?
__sighandler()       call     sslsshandler()       00000000B 7F67916744B0
                                                   7F6791674380 000000011 ?
                                                   7F6791673908 ? 000000083 ?
kclflash2le()+199    signal   __sighandler()       000000000 00000000F
                                                   32665BAD10 7FFC51D249D0 ?
                                                   000000264 ? 00000000F ?
kcl_flash2lev()+176  call     kclflash2le()        000000000 00000000F
000000000
                                                   7FFC51D249D0 000000264
                                                   000000003
kcbz_multi_file_get  call     kcl_flash2lev()      000000001 000000001
_locks()+900                                       7FFC51D21C5C 7FFC51D21C60
                                                   7F67963409C0 00000007F
kcbzibmlt()+81785    call     kcbz_multi_file_get  000000001 ? 7FFC51D20E48
                              _locks()             7FFC51D19730 ? 000000026 ?
                                                   7F67963409C0 ? 00000007F ?
kcbzib()+42653       call     kcbzibmlt()          000000001 000000000
000000000
                                                   000000001 7F67963409C0 ?
                                                   00000007F ?
kcbgtcr()+11324      call     kcbzib()             32098B1B58 000000000 ?
                                                   7F67963409C0 ? 000000001 ?
                                                   5600000003 000000264
ktecgsc()+72         call     kcbgtcr()            7FFC51D249D0 000000000
                                                   000000264 000000000
                                                   5600000003 ? 000000264 ?
ktecgetsh()+354      call     ktecgsc()            7FFC51D249D0 ? 000000003 ?
                                                   000000004 ? 7FFC51D248B0 ?
                                                   5600000003 ? 000000264 ?
ktecgshx()+33        call     ktecgetsh()          7FFC51D249D0 ? 000000003 ?
                                                   000000004 ? 7FFC51D248B0 ?
                                                   7F6700000264 311208DFC0 ?
kxfrPrefetch()+593   call     ktecgshx()           7FFC51D249D0 ? 000000003 ?
                                                   000000004 ? 7FFC51D248B0 ?
                                                   7F6700000264 ? 311208DFC0
?
kxfrExtInfo()+534    call     kxfrPrefetch()       7FFC51D250F0 CB93EEBBB62
                                                   000000000 7FFC51D248B0 ?
                                                   7F6700000264 ? 311208DFC0
?
kxfrialo()+2147      call     kxfrExtInfo()        7F678E64C058 7F678E47D010
                                                   000000000 ? 7FFC51D248B0 ?
                                                   7F6700000264 ? 311208DFC0
?
kxfralo()+448        call     kxfrialo()           000000001 000000002
000000002
                                                   921E6FF80 7F678E13F8D8
                                                   000000002
qerpxSetupAndAllocS  call     kxfralo()            000000001 000000002
000000002
laves()+539                                        921E6FF80 7F678E13F8D8
                                                   000000002
qerpx_rowsrc_start(  call     qerpxSetupAndAllocS  921E6FF80 7F67963409C0
)+1365                        laves()              7F6700000002 000000000
                                                   7FFC51D25F84 7F678E143B68
qerpxStart()+609     call     qerpx_rowsrc_start(  7FFC51D260F8 7F67963409C0
?
                              )                    7F6700000002 ? 000000000 ?
                                                   7FFC51D25F84 ?
7F678E143B68 ?
rwsstd()+497         call     qerpxStart()         921E7EBE8 7F678E11F260
                                                   000000001 000000000 ?
                                                   7FFC51D25F84 ?
7F678E143B68 ?
rwsstd()+497         call     rwsstd()             921E2F538 ? 7F678FD594F8 ?
                                                   000000001 000000000 ?
                                                   7FFC51D25F84 ?
7F678E143B68 ?
qerltStart()+759     call     rwsstd()             921E2F4E8 ? 7F678FD59540 ?
                                                   000000001 000000000 ?
                                                   7FFC51D25F84 ?
7F678E143B68 ?
insExecSubQueryIni(  call     qerltStart()         900000001 7F678FD5B1D0
)+321                                              000000001 000000000 ?
                                                   7FFC51D25F84 ?
7F678E143B68 ?
insExecStmtExecIniE  call     insExecSubQueryIni(  921E6A170 ? 921E2C3C0 ?
ngine()+76                    )                    000000001 ? 000000000 ?
                                                   7FFC51D25F84 ?
7F678E143B68 ?
insexe()+2269        call     insExecStmtExecIniE  921E6A170 ? 921E2C3C0 ?
                              ngine()              000000001 ? 000000000 ?
                                                   7FFC51D25F84 ?
7F678E143B68 ?
opiexe()+6552        call     insexe()             921E6A170 ? 921E2C3C0 ?
                                                   000000001 ? 000000000 ?
                                                   7FFC51D25F84 ?
7F678E143B68 ?
kpoal8()+2453        call     opiexe()             000000049 921E2C3C0 ?
                                                   7FFC51D27AB0 000000000 ?
                                                   7FFC51D25F84 ?
7F678E143B68 ?
opiodr()+1244        call     kpoal8()             00000005E 000000026
                                                   7FFC51D2B540 000000000 ?
                                                   7FFC51D25F84 ?
7F678E143B68 ?
ttcpip()+1239        call     opiodr()             00000005E 000000026
                                                   7FFC51D2B540 ? 000000000
                                                   7FFC51D25F84 ?
7F678E143B68 ?
opitsk()+1943        call     ttcpip()             7F679631A390 ? 0000005E0 ?
                                                   7FFC51D2B540 000000000 ?
                                                   7FFC51D2AF90 7FFC51D2B79C
opiino()+957         call     opitsk()             000000000 000000000
                                                   7FFC51D2B540 ? 000000000 ?
                                                   7FFC51D2AF90 ?
7FFC51D2B79C ?
opiodr()+1244        call     opiino()             00000003C 000000004
                                                   7FFC51D2D108 000000000 ?
                                                   7FFC51D2AF90 ?
7FFC51D2B79C ?
opidrv()+1091        call     opiodr()             00000003C 000000004
                                                   7FFC51D2D108 ? 000000000
                                                   7FFC51D2AF90 ?
7FFC51D2B79C ?
sou2o()+191          call     opidrv()             00000003C 000000004
                                                   7FFC51D2D108 000000000 ?
                                                   7FFC51D2AF90 ?
7FFC51D2B79C ?
opimai_real()+455    call     sou2o()              7FFC51D2D031 00000003C
                                                   000000004 7FFC51D2D108
                                                   7FFC51D2AF90 ?
7FFC51D2B79C ?
ssthrdmain()+423     call     opimai_real()        000000000 7FFC51D2D808
                                                   000000004 ? 7FFC51D2D108 ?
                                                   7FFC51D2AF90 ?
7FFC51D2B79C ?
main()+275           call     ssthrdmain()         000000000 000000002
                                                   7FFC51D2D808 000000001
                                                   000000000 7FFC51D2B79C ?
__libc_start_main()  call     main()               000000002 7FFC51D2DA28
+245                                               7FFC51D2D808 ? 000000001 ?
                                                   000000000 ? 7FFC51D2B79C ?
_start()+41          call     __libc_start_main()  000D6E880 000000002
                                                   7FFC51D2DA28 7F6791D0A545
?
                                                   000000000 ? 7FFC51D2B79C ?
[TOC00005-END]

 

Changes

 No changes done

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.