ORA-600 - [17147] - QESNHGBYALLOCEXCPWA:WAP - query having aggregation with listagg
(Doc ID 3071182.1)
Last updated on FEBRUARY 09, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 19.25.0.0.0 to 19.25.0.0.0 [Release 19]Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A to N/A [Release N/A]
Gen 2 Exadata Cloud at Customer - Version N/A to N/A [Release All Releases]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A to N/A
Information in this document applies to any platform.
Symptoms
Error:
ORA-00600: internal error code, arguments: [17147], [0x7FFFF058D738], [], [], [], [], [], [], [], [], [], []
Trace file shows:
Decoding of possible comments in or near previous range
[0x7ffff058b608] = 0x1454bf80 ==> qesnhScanCtxAlloc.bufp
[0x7ffff058b630] = 0x1454bf68 ==> qesnhScanCtxAlloc.size
[0x7ffff058b658] = 0x1454bf50 ==> qesnhScanCtxAlloc.scx
[0x7ffff058b7d8] = 0x1454b3b4 ==> qesnhGBYAllocExcpWA:wap
Chunk 7ffff058b7c8 sz= 8048 NEXT CHUNK'S PREVIOUS POINTER NOT POINTING TO CURRENT CHUNK
Main Stack:
kgherror_flag <- kghfrf <- qesnhCloseHTI <- qerghFreeHashTable <- qerghFetch
<- qerstFetch <- qervwFetch <- qerstFetch <- qergsFetch <- qerstFetch <- rwsfcd
<- qerstFetch <- qerltFetch <- qerstFetch <- insdlexe <- insExecStmtExecIniEngine
ORA-00600: internal error code, arguments: [17147], [0x7FFFF058D738], [], [], [], [], [], [], [], [], [], []
Trace file shows:
Decoding of possible comments in or near previous range
[0x7ffff058b608] = 0x1454bf80 ==> qesnhScanCtxAlloc.bufp
[0x7ffff058b630] = 0x1454bf68 ==> qesnhScanCtxAlloc.size
[0x7ffff058b658] = 0x1454bf50 ==> qesnhScanCtxAlloc.scx
[0x7ffff058b7d8] = 0x1454b3b4 ==> qesnhGBYAllocExcpWA:wap
Chunk 7ffff058b7c8 sz= 8048 NEXT CHUNK'S PREVIOUS POINTER NOT POINTING TO CURRENT CHUNK
Main Stack:
kgherror_flag <- kghfrf <- qesnhCloseHTI <- qerghFreeHashTable <- qerghFetch
<- qerstFetch <- qervwFetch <- qerstFetch <- qergsFetch <- qerstFetch <- rwsfcd
<- qerstFetch <- qerltFetch <- qerstFetch <- insdlexe <- insExecStmtExecIniEngine
Changes
Applied 19.25 DBRU patch.
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 |