[mapserver-users] Coments about the Tickedt 3541

[Alan Boudreault]

Hmm... very strange. Although I am not able to reprodude it under Unix.... It 
seems to be an Oracle bug.

On September 22, 2010 03:35:38 am Jorge Bellido Diez wrote:
> We reproduced the same problem doing requets to the OCG Services using
> OpenLayers 2.8 or gvSig 1.1.2 Doing a getfeatureinfo to a Oracle layer of
> an WMS Service or getfeatrue to a Oracle layer of an WFS Service the
> Oracle Server produce a log file and a dump memory. Then I coud see
> duplicates values in my primary key, furthermore primary index still
> points to old data even though the user has no UPDATE-GRANTS. This
> behavior seems to be random
> 
> These are our configuration:
> - MS4W 3.0 Beta 10
> - MapServer 5.6.1
> - Personal Oracle Database 10g Release 10.2.0.1.0 - 64bit Production
> 
> This is the way we declare an Oracle Layer in the map file:
> ----------------
> LAYER
> 		STATUS ON
> 		CONNECTIONTYPE oraclespatial
> 		CONNECTION "admcarto/admcarto at ORA10GEX"
> 		NAME "PoligonosSigpac"
> 		PROJECTION
> 			"init=epsg:23030"
> 		END
> 
> 		TYPE POLYGON
> 		METADATA
> 			"wms_title"			  "Poligonos Sigpac 2009"
> 			"wms_srs"             "EPSG:23030"
> 			"wms_name"            "poligonos"
> 			"wms_server_version"  "1.1.1"
> 			"wms_format"          "image/png"
> 			"wms_transparent"     "true"
> 			"wms_extent"		  "470000 4700000 610000 4820000"
> 		END
> 
> 		DATA "GEOMETRY FROM (SELECT * FROM GV_SIGPAC_POL_ED50) USING UNIQUE 
gid
> SRID 82337"
> 
> 		CLASS
> 			NAME "Poligonos"
> 			STYLE
> 				OUTLINECOLOR 178 0 255
> 			END
> 			TEMPLATE "ttt_query.html"
> 		END
> END
> --------------
> 
> This is a little portion of one of this log files with the error code:
> 
> Dump file f:\oracle\admin\ora10gex\udump\ora10gex_ora_1408.trc
> Wed Sep 01 12:56:09 2010
> ORACLE V10.2.0.1.0 - 64bit Production vsnsta=0
> vsnsql=14 vsnxtr=3
> Personal Oracle Database 10g Release 10.2.0.1.0 - 64bit Production With the
> Partitioning, OLAP and Data Mining options Windows NT Version V5.2 Service
> Pack 2 CPU                 : 2 - type 8664, 1 Physical Cores
> Process Affinity    : 0x0000000000000000
> Memory (Avail/Total): Ph:1786M/4031M, Ph+PgF:5772M/7808M Instance name:
> ora10gex
> 
> Redo thread mounted by this instance: 1
> 
> Oracle process number: 19
> 
> Windows thread id: 1408, image: ORACLE.EXE (SHAD)
> 
> 
> *** SERVICE NAME:(ORA10GEX) 2010-09-01 12:56:09.919
> *** SESSION ID:(159.12216) 2010-09-01 12:56:09.919
> ********** Internal heap ERROR 17182 addr=000007FF985DDC24 *********
> ***** Dump of memory around addr 000007FF985DDC24:
> 7FF985DCC20          3CC3093F 090E2C10 09474557      [?..<.,..WEG.]
> 7FF985DCC30 535005C4 44511B43 3CC3093F 152B2D10  [..PSC.QD?..<.-+.]
> 
> ..
> ..
> ..
> 
> Permanent space    =  1732608
> ******************************************************
>  Hla: 255
> *** 2010-09-01 12:56:10.966
> ksedmp: internal or fatal error
> ORA-00600: internal error code, arguments: [17182], [0x7FF985DDC24], [],
> [], [], [], [], [] Current SQL statement for this session: SELECT gid,
> TER_HIST, AREA, PERIMETRO, GID, PROVINCIA, GEOMETRY FROM (SELECT * FROM
> GT_PROVINCIAS_ED50) WHERE SDO_FILTER( GEOMETRY, MDSYS.SDO_GEOMETRY(2003,
> :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates
> ),'querytype=window') = 'TRUE' ----- Call Stack Trace -----
> calling              call     entry                argument values in hex
> location             type     point                (? means dubious value)
> -------------------- -------- --------------------
> ----------------------------
> 
> ..
> ..
> ..
> 
> 
> 
> Thanks, Jorge.
> 
> 
> -----Mensaje original-----
> De: mapserver-users-bounces at lists.osgeo.org
> [mailto:mapserver-users-bounces at lists.osgeo.org] En nombre de Sumit Sharma
> Enviado el: miércoles, 15 de septiembre de 2010 17:05 Para:
> mapserver-users at lists.osgeo.org
> Asunto: [mapserver-users] Re: Problems with MapServer and Oracle Spatial
> 
> 
> Thanks for you response.
> As suggested by you I have created a ticket.
> Ticket number is 3541.
> -Sumit
> --
> View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/Problems-with-MapServer-and-Oracle-
> Spatial-tp5518303p5534732.html Sent from the Mapserver - User mailing list
> archive at Nabble.com. _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users

-- 
Alan Boudreault
Mapgears
http://www.mapgears.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100922/36653591/attachment-0001.html