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/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 -- Alan Boudreault Mapgears http://www.mapgears.com
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
