ORA-00600 [QESHQBNEXTBUFFER.1] While Inserting into Table (Doc ID 421341.1)

Last updated on JUNE 13, 2013

Applies to:

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

Symptoms

Checked for currency 28 September 2012

 

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms