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/admca...@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: [email protected]
[mailto:[email protected]] En nombre de Sumit Sharma
Enviado el: miércoles, 15 de septiembre de 2010 17:05
Para: [email protected]
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
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
