MMON Slave's "Auto-Flush Slave Action" Task Encounters ORA-07445 [ktsla_ins_chunk_main()+22]
(Doc ID 2973709.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.18.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
MMON Slave process acts "Auto-Flush Slave Action", ORA-07445 [ktsla_ins_chunk_main()+22] error occurs.
*** SERVICE NAME:(SYS$BACKGROUND) 2023-09-07T16:00:05.595852+08:00
*** MODULE NAME:(MMON_SLAVE) 2023-09-07T16:00:05.595857+08:00
*** ACTION NAME:(Auto-Flush Slave Action) 2023-09-07T16:00:05.595862+08:00
*** CLIENT DRIVER:(SERVER) 2023-09-07T16:00:05.595867+08:00
*** CONTAINER ID:(1) 2023-09-07T16:00:05.595872+08:00
[TOC00001]
ORA-07445: exception encountered: core dump [ktsla_ins_chunk_main()+22] [SIGSEGV] [ADDR:0x7FFE82AC89B0] [PC:0x22810B6] [Address not mapped to object] []
[TOC00001-END]
[TOC00004]
----- Current SQL Statement for this session (sql_id=batfd9dwfcb0g) -----
INSERT INTO wrh$_sqltext (sql_id, dbid, sql_text, command_type, snap_id, con_dbid, per_pdb) SELECT sqlid_kewrstx, :dbid, sqlfulltext_kewrstx, cmdtype_kewrstx, :lah_snap_id, con_dbid_kewrstx, con_id FROM x$kewrtsqltext sqltxt WHERE (1 = 1) AND ( sqltxt.con_id < 4099 )
[TOC00004-END]
[06]: ktsla_ins_chunk_main [Space]<-- Signaling
[07]: ktsla_split_ins_chunk [Space]
[08]: ktsla_split_chunk [Space]
[09]: ktsla_split_chunk_main [Space]
[10]: ktsla_fsb_best_fit_gsp [Space]
[11]: ktsla_fsb_gsp [Space]
[12]: ktsla_hbb_gsp [Space]
[13]: ktsla_hbb_gsp_main [Space]
[14]: ktsla_gsp_split [Space]
[15]: ktsla_cfsgsp_main [Space]
[16]: ktslagsp [Space]
[17]: ktsla_alloc_fsgr [Space]
[18]: ktsla_alloc_fsg [Space]
[19]: ktsla_ins_chunk [Space]
[20]: ktsla_ins_chunk_main [Space]
[21]: ktsl_pua_cfs_disp [Space]
[22]: ktsl_fill_dispenser_main_1 [Space]
[23]: ktsl_fill_dispenser_main [Space]
[24]: ktsl_dispenser_bkg_actions [Space]
[25]: ktsl_disp_gsp_driver_int [Space]
[26]: ktslagsp [Space]
[27]: ktslagsp_main [Space]
[28]: kdliAllocCache [LOB_INODE]
[29]: kdliAllocBlocks [LOB_INODE]
[30]: kdliAllocChunks [LOB_INODE]
[31]: kdliWriteInit [LOB_INODE]
[32]: kdliWriteV [LOB_INODE]
[33]: kdli_fwritev [LOB_INODE]
[34]: kdlxNXWrite [LOB_KDLX]
[35]: kdlx_write [LOB_KDLX]
[36]: kdlxdup_write1 [LOB_KDLXDUP]
[37]: kdlwWriteCallbackOld_pga [LOB_KDLW]
[38]: kdlw_write [LOB_KDLW]
[39]: kdld_write [Data]
[40]: kdla_write [LOB_KDLA]
[41]: kdlf_write [Data]
[42]: kdlfCopyBF2SF [Data]
[43]: kdlf_copy [Data]
[44]: koklCopyInt [LOB_Default]
[45]: kokliclo [LOB_Default]
[46]: koklcre [LOB_API]
[47]: kokleva [LOB_API]
[48]: evaopn2 []
[49]: qesltcEvalOutofLineCols [SQL_Execution]
*** MODULE NAME:(MMON_SLAVE) 2023-09-07T16:00:05.595857+08:00
*** ACTION NAME:(Auto-Flush Slave Action) 2023-09-07T16:00:05.595862+08:00
*** CLIENT DRIVER:(SERVER) 2023-09-07T16:00:05.595867+08:00
*** CONTAINER ID:(1) 2023-09-07T16:00:05.595872+08:00
[TOC00001]
ORA-07445: exception encountered: core dump [ktsla_ins_chunk_main()+22] [SIGSEGV] [ADDR:0x7FFE82AC89B0] [PC:0x22810B6] [Address not mapped to object] []
[TOC00001-END]
[TOC00004]
----- Current SQL Statement for this session (sql_id=batfd9dwfcb0g) -----
INSERT INTO wrh$_sqltext (sql_id, dbid, sql_text, command_type, snap_id, con_dbid, per_pdb) SELECT sqlid_kewrstx, :dbid, sqlfulltext_kewrstx, cmdtype_kewrstx, :lah_snap_id, con_dbid_kewrstx, con_id FROM x$kewrtsqltext sqltxt WHERE (1 = 1) AND ( sqltxt.con_id < 4099 )
[TOC00004-END]
[06]: ktsla_ins_chunk_main [Space]<-- Signaling
[07]: ktsla_split_ins_chunk [Space]
[08]: ktsla_split_chunk [Space]
[09]: ktsla_split_chunk_main [Space]
[10]: ktsla_fsb_best_fit_gsp [Space]
[11]: ktsla_fsb_gsp [Space]
[12]: ktsla_hbb_gsp [Space]
[13]: ktsla_hbb_gsp_main [Space]
[14]: ktsla_gsp_split [Space]
[15]: ktsla_cfsgsp_main [Space]
[16]: ktslagsp [Space]
[17]: ktsla_alloc_fsgr [Space]
[18]: ktsla_alloc_fsg [Space]
[19]: ktsla_ins_chunk [Space]
[20]: ktsla_ins_chunk_main [Space]
[21]: ktsl_pua_cfs_disp [Space]
[22]: ktsl_fill_dispenser_main_1 [Space]
[23]: ktsl_fill_dispenser_main [Space]
[24]: ktsl_dispenser_bkg_actions [Space]
[25]: ktsl_disp_gsp_driver_int [Space]
[26]: ktslagsp [Space]
[27]: ktslagsp_main [Space]
[28]: kdliAllocCache [LOB_INODE]
[29]: kdliAllocBlocks [LOB_INODE]
[30]: kdliAllocChunks [LOB_INODE]
[31]: kdliWriteInit [LOB_INODE]
[32]: kdliWriteV [LOB_INODE]
[33]: kdli_fwritev [LOB_INODE]
[34]: kdlxNXWrite [LOB_KDLX]
[35]: kdlx_write [LOB_KDLX]
[36]: kdlxdup_write1 [LOB_KDLXDUP]
[37]: kdlwWriteCallbackOld_pga [LOB_KDLW]
[38]: kdlw_write [LOB_KDLW]
[39]: kdld_write [Data]
[40]: kdla_write [LOB_KDLA]
[41]: kdlf_write [Data]
[42]: kdlfCopyBF2SF [Data]
[43]: kdlf_copy [Data]
[44]: koklCopyInt [LOB_Default]
[45]: kokliclo [LOB_Default]
[46]: koklcre [LOB_API]
[47]: kokleva [LOB_API]
[48]: evaopn2 []
[49]: qesltcEvalOutofLineCols [SQL_Execution]
Instance restart doesn't work, patch 33901904 doesn't help as well.
Changes
Applied 19.18 DBRU.
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 |