ORA-00600 [QESHQBNEXTBUFFER.1] While Inserting into Table
(Doc ID 421341.1)
Last updated on FEBRUARY 02, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.3 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
SQL statement is similar to:
INSERT INTO <table>
SELECT ....
FROM ( SELECT ...
FROM ...
WHERE ...
GROUP BY ... )
GROUP BY ...
UNION ALL
SELECT ....
FROM ( SELECT ...
FROM ...
WHERE ...
GROUP BY ... )
GROUP BY ...
Fails with
ORA-00600: internal error code, arguments: [qeshQBNextBuffer.1], [], [], [], [], [], [], []
Call stack in the generated trace file is:
ksedmp kgerinv kgeasnmierr qeshQBNextBuffer ksxb1inc qesaSetWAP qerghFetch rwsfcd
qeruaFetch rwsfcd insfch insdrv inscovexe insExecStmtExecIniEngine insexe
Plan table shows the use of HASH GROUP BY:
| Id | Operation |
------------------------------------------
| 0 | INSERT STATEMENT |
| 1 | UNION-ALL |
| 2 | HASH GROUP BY |
| 3 | VIEW |
| 4 | SORT GROUP BY |
| 5 | TABLE ACCESS BY INDEX ROWID |
| 6 | INDEX RANGE SCAN |
| 7 | HASH GROUP BY |
| 8 | VIEW |
| 9 | SORT GROUP BY |
| 10 | TABLE ACCESS BY INDEX ROWID |
| 11 | INDEX RANGE SCAN |
------------------------------------------
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 |
Cause |
Solution |