[mapserver-users] Coments about the Tickedt 3541

[Jorge Bellido Diez]

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