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 laterInformation 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 |