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

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 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 /u01/app/oracle/diag/rdbms/cimprd/cimprd2/trace/cimprd2_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:(cimprd_imat) 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 %efl: 0x0000000000010246
  qeshLoadRowForGBY()+803 (0x91f203b) jmp 0x91f2276
  qeshLoadRowForGBY()+808 (0x91f2040) cmp $2,%eax
  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),%eax
  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
  PARTY_ID,
  DATE_OF_BIRTH,
  GENDER_TYPE,
  NAME_TITLE_TYPE,
  NAME_INITIALS,
  NAME_FIRST_NAME,
  NAME_MIDDLE_NAMES,
  NAME_FAMILY_NAME,
  NAME_PREFERRED,
  CIM_MODIFIED_DTS,
  SOURCE_SYSTEM,
  SOURCE_SYSTEM_TRANSACTION_ID,
  SOURCE_SYSTEM_USERNAME
FROM SODSPRD01.SVM_INDIVIDUAL
where (cim_modified_dts, party_id) =  (select  max(cim_modified_dts), party_id
                           from SODSPRD01.SVM_INDIVIDUAL
                           where trunc(cim_modified_dts) < sysdate-3
                           --and party_id in (1034992)
                           group by party_id)
--and party_id in (1034992)

----- 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   | SVM_INDIVIDUAL|     1 |   102 |   28K |  00:06:45 |
| 3   |    HASH GROUP BY              |               |  315K | 5349K |   30K |  00:06:15 |
| 4   |     TABLE ACCESS STORAGE FULL | SVM_INDIVIDUAL|  360K | 6126K |   29K |  00:06:52 |
------------------------------------------------------+-----------------------------------+

 

Changes

New user SQL.

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