My Oracle Support Banner

Select with Group By Clause in Subquery Fails with ORA-7445 [QESHLOADROWFORGBY] (Doc ID 2067684.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Select fails with next errors in the alert log:

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x8] [PC:0x91F2051, qeshLoadRowForGBY()+825] [flags: 0x0, count: 1]
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_ora_9864.trc  (incident=31907):
ORA-07445: exception encountered: core dump [qeshLoadRowForGBY()+825] [SIGSEGV] [ADDR:0x8] [PC:0x91F2051] [Address not mapped to object]


The query has a subselect that contains a group by clause in its own where clause.

The trace file shows characteristics like:

*** 2015-10-16 13:47:58.760
*** SESSION ID:(148.17763) 2015-10-16 13:47:58.760
*** CLIENT ID:() 2015-10-16 13:47:58.760
*** SERVICE NAME:(<service_name>) 2015-10-16 13:47:58.760
*** MODULE NAME:(SQL Developer) 2015-10-16 13:47:58.760
*** ACTION NAME:() 2015-10-16 13:47:58.760
 
Dump continued from file: /u01/app/oracle/diag/rdbms/cimprd/cimprd1/trace/cimprd1_ora_20544.trc
ORA-07445: exception encountered: core dump [qeshLoadRowForGBY()+825] [SIGSEGV] [ADDR:0x8] [PC:0x91F2051] [Address not mapped to object] []

========= Dump for incident 43834 (ORA 7445 [qeshLoadRowForGBY()+825]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x8] [PC:0x91F2051, qeshLoadRowForGBY()+825] [flags: 0x0, count: 1]
Registers:
%rax: 0x0000000000000002 %rbx: 0x00007f24fabb79b8 %rcx: 0x0000000000000001
%rdx: 0x00007f24f9670748 %rdi: 0x0000000000000000 %rsi: 0x00007f24fa2bf982
%rsp: 0x00007fffb36928d0 %rbp: 0x00007fffb3692990  %r8: 0x0000000000000002
 %r9: 0x0000000000000001 %r10: 0x000000000000bda9 %r11: 0x0000000004849e40
%r12: 0x00007f24fabbb040 %r13: 0x0000000000000000 %r14: 0x0000000000000000
%r15: 0x0000000000007fff %rip: 0x00000000091f2051 ïl: 0x0000000000010246
  qeshLoadRowForGBY()+803 (0x91f203b) jmp 0x91f2276
  qeshLoadRowForGBY()+808 (0x91f2040) cmp $2,êx
  qeshLoadRowForGBY()+811 (0x91f2043) jnz 0x91f226d
  qeshLoadRowForGBY()+817 (0x91f2049) mov 0x1a0(%r12),%r13
> qeshLoadRowForGBY()+825 (0x91f2051) mov 0x8(%r13),%r14
  qeshLoadRowForGBY()+829 (0x91f2055) test %r13,%r13
  qeshLoadRowForGBY()+832 (0x91f2058) jz 0x91f2480
  qeshLoadRowForGBY()+838 (0x91f205e) movzwl 0x10(%r13),êx
  qeshLoadRowForGBY()+843 (0x91f2063) test $0x1,%al

*** 2015-10-16 13:47:58.791
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=dp9ja4byhfcpb) -----
/* + NO_PARALLEL */SELECT distinct
  <COL1>,
  <COL2>,
 .....
FROM <TABLE_NAME>

----- Call Stack Trace -----

... qeshLoadRowForGBY qerghRowP kdstf01001010010km kdsttgr qertbFetch qerghFetch subsr1 evaopn3 qesSageInitAndCheckLog qesSageInitAndCheckLog qesSageInitAndCheckLog qertbFetch qerghFetch opifch2 kpoal8 opiodr ...


...
============
Plan Table
============
------------------------------------------------------+-----------------------------------+
| Id  | Operation                     | Name          | Rows  | Bytes | Cost  | Time      |
------------------------------------------------------+-----------------------------------+
| 0   | SELECT STATEMENT              |               |       |       |   89K |           |
| 1   |  HASH UNIQUE                  |               |     1 |   102 |   89K |  00:18:14 |
| 2   |   TABLE ACCESS STORAGE FULL   | <TABLE_NAME>|     1 |   102 |   28K |  00:06:45 |
| 3   |    HASH GROUP BY              |               |  315K | 5349K |   30K |  00:06:15 |
| 4   |     TABLE ACCESS STORAGE FULL | <TABLE_NAME>|  360K | 6126K |   29K |  00:06:52 |
------------------------------------------------------+-----------------------------------+

 

Changes

New user SQL.

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.