ORA-07445: Exception Encountered: Core Dump [mdgrb2v()+175] With Sdo_geor.reproject (Doc ID 1474642.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

While doing a reproject with sdo_geor.reproject we get

  ORA-07445: exception encountered: core dump [mdgrb2v()+175]

The problem is not reproducible at will

Sometimes it happens with a raster, and sometimes the same raster is successfully reprojected. It fails randomly on some rasters


This is the trace info:

Dump continued from file: D:\APP\ORACLE\diag\rdbms\raster\raster\trace\raster_ora_596.trc
ORA-07445: exception encountered: core dump [mdgrb2v()+175] [ACCESS_VIOLATION] [ADDR:0x12A95577A] [PC:0x146A8B8F7] [UNABLE_TO_READ] []

========= Dump for incident 124204 (ORA 7445 [mdgrb2v()+175]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x12A95577A] [PC:0x146A8B8F7, mdgrb2v()+175]


*** 2012-01-30 13:02:51.456
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=3070jwgqc5tw8) -----
declare
 gr sdo_georaster;
 lb blob;
 oArea sdo_geometry;
 oWin sdo_number_array;
begin
oWin:=sdo_number_array(588,303,1466,1276);
dbms_lob.createtemporary(lb,true);
select a.IMAGE into gr from RASTER.CDSM_IMAGES_10000_CL_S2053 a where a.IMAGE.rasterid = :1 and UPPER(a.IMAGE.rasterdatatable) = :2 ;
sdo_geor.reproject(gr,3, sdo_number_array(588,303,1466,1276),'0,1,2','resampling=BILINEAR','compression=NONE,interleaving=BIP',8307,lb,oArea,oWin,null);
:3 :=lb;
:4 :=oWin(1);
:5 :=oWin(2);
:6 :=oWin(3);
:7 :=oWin(4);
:8 :=oArea;
end;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object line object
 handle number name
000000047AA88C38 4034 package body MDSYS.SDO_GEOR_INT
00000004798EAA38 6584 package body MDSYS.SDO_GEOR
0000000346A5E8F0 10 anonymous block


mdgrb2v()+175 0000000000000000 004256D10 000000000 000000000
  0180A4EF0
mdgrtReprojectWindo CALL??? mdgrb2v() 4000000000000000
w()+5251 4008000000000000 000000002
  016BEAF08
mdgrtReproject()+32 CALL??? mdgrtReprojectWindo 0165801F0 0180C3B80 000000004
42 w()+4630 000000002
mdgrociReprojectToL CALL??? mdgrtReproject()+14 01655A0F0 0165801F0 0532007A8
OB()+4042 28 000000001
spefcmpa()+2453 CALL??? mdgrociReprojectToL 000000000 00112C018 000000000
  OB() 000000001
spefmccallstd()+298 CALL??? spefcmpa() 0180C8468 0180C80C0 0180C7D40
  0180C7090
pextproc()+47 CALL??? spefmccallstd() 0180C7D40 0180C7E70 0277FD4C0
  4575412C6
__PGOSF510_peftrust CALL??? pextproc() 0180C71F0 001152195 0277FD4C0
ed()+134 0000000A8
psdexsp()+288 CALL??? __PGOSF510_peftrust 0277FD4C0 00110D4D7 600100000
  ed() 01703A9D0
rpiswu2()+2711 CALL??? psdexsp() 0180C7C30 000000000
  C000000000 8180C0010
psdextp()+951 CALL??? rpiswu2() 47CBD9938 00000004D 47CBD99BC
  000000002
pefccal()+785 CALL??? psdextp() 0180C9610 0180C80C0 0180

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