[mapserver-dev] msOracleSpatialLayerGetShape could not fetch specified record - WFS Filter

Thu Jun 16 11:29:20 EDT 2011

Hi list.  I have a strange error with WFS POST query on mapserver 6.0 and
Oracle 10g.  I have two queries that it gives me the same number of
records.  But the first one crash and I try to find why?  Is this a problem
with data, with my query or a bug?

Here mapserver log...

This one crash:

[Thu Jun 16 10:47:46 2011].849332 msOracleSpatialLayerWhichShape
s. Using this Sql to retrieve the data: SELECT IDMAO, NO_PERM,
NO_PERM_LOCA_NUM, NO_PERM_EXPL, NOPCL, NODIAG, MES_TYPE, PCL_TYPE, SUP_CUL,
SUP_NOR, SUP_TOT, SUP_HA, NOPCLTRI, DRAINAGE, NO_PERM_NUM, PROCOD,
PRCSUPMAO, SUPMAO, SUPDECL, SUPMAOORI, ASSURE, NB_CULT, VOLSRCCMS, DGN,
LOD_LOCANUM, STATUT, STATUT_X, ANNEE, IDTRANS, DT_PROD, DT_MOD, DT_VAL,
USG_PROD, USG_MOD, USG_VAL, VER_NORME, ECL_NUM, IDIMG_1, IDIMG_2, IDIMG_3,
IDIMG_4, CTD_X, CTD_Y, CTD_Z, FUSEAU, CODGEO, MUS_CO_GEO, CODUTM, ZCOL1,
ZCOL3, DESCRIPTION, SHAPEOID, SAS_SHAPEOID, CDS_SHAPEOID, CDX_ID, SAD_ID,
SAM_ID, SAX_ID, NOP_SHAPEOID, OBJECTID, VERSION, ID_TERR, rownum, geom FROM
sagr_v_sdo WHERE   ( (NO_PERM_NUM= 82776)  AND  ( (NODIAG= 1)  AND  (
(ANNEE= 2011)  AND  (STATUT= 'ACT') ) ) )
[Thu Jun 16 10:47:46 2011].849348 msOracleSpatialLayerWhichShapes. Bind
values: srid:4326   minx:-83.414878   miny:42.585122  maxx:-53.585122
maxy:63.414878
[Thu Jun 16 10:47:46 2011].849457 msOracleSpatialLayerWhichShapes getting
ordinate definition.
[Thu Jun 16 10:47:46 2011].851214 msOracleSpatialLayerWhichShapes converting
to OCIColl.
[Thu Jun 16 10:47:46 2011].851440 msOracleSpatialLayerWhichShapes bind by
name and object.
[Thu Jun 16 10:47:46 2011].851456 msOracleSpatialLayerWhichShapes name and
object now bound.
[Thu Jun 16 10:47:47 2011].256210 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 0
[Thu Jun 16 10:47:47 2011].256472 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 1
[Thu Jun 16 10:47:47 2011].256553 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 2
[Thu Jun 16 10:47:47 2011].256652 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 3
[Thu Jun 16 10:47:47 2011].256792 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 4
[Thu Jun 16 10:47:47 2011].256871 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 5
[Thu Jun 16 10:47:47 2011].256954 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 6
[Thu Jun 16 10:47:47 2011].257033 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 7
[Thu Jun 16 10:47:47 2011].257119 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 8
[Thu Jun 16 10:47:47 2011].257208 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 9
[Thu Jun 16 10:47:47 2011].257279 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 10
[Thu Jun 16 10:47:47 2011].257358 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 11
[Thu Jun 16 10:47:47 2011].257428 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 12
[Thu Jun 16 10:47:47 2011].257497 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 13
[Thu Jun 16 10:47:47 2011].257583 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 14
[Thu Jun 16 10:47:47 2011].257675 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 15
[Thu Jun 16 10:47:47 2011].257763 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 16
[Thu Jun 16 10:47:47 2011].257838 msOracleSpatialLayerNextShape on layer
0x8553318, row_num: 17
[Thu Jun 16 10:47:47 2011].258352 msOracleSpatialLayerNextShape on layer
0x8553318, Fetched 0 more rows (17 total)
[Thu Jun 16 10:47:47 2011].261058 msOracleSpatialLayerGetShape was called.
Using the record = 0 of 17. (shape: 5028718 should equal pkey: 5028718)
[Thu Jun 16 10:47:47 2011].261084 msOracleSpatialLayerGetShape: Fetching
result from DB start: 0 end:-1 record: 0
[Thu Jun 16 10:47:50 2011].978549 msOracleSpatialLayerGetShape:
OracleSpatial error. ORA-03113: fin de fichier sur canal de communication

[Thu Jun 16 10:47:50 2011].978584 msOracleSpatialLayerGetShape():
OracleSpatial error. msOracleSpatialLayerGetShape could not fetch specified
record.

This one work fine ...

[Thu Jun 16 10:55:51 2011].403830 msOracleSpatialLayerWhichShapes. Using
this Sql to retrieve the data: SELECT IDMAO, NO_PERM, NO_PERM_LOCA_NUM,
NO_PERM_EXPL, NOPCL, NODIAG, MES_TYPE, PCL_TYPE, SUP_CUL, SUP_NOR, SUP_TOT,
SUP_HA, NOPCLTRI, DRAINAGE, NO_PERM_NUM, PROCOD, PRCSUPMAO, SUPMAO, SUPDECL,
SUPMAOORI, ASSURE, NB_CULT, VOLSRCCMS, DGN, LOD_LOCANUM, STATUT, STATUT_X,
ANNEE, IDTRANS, DT_PROD, DT_MOD, DT_VAL, USG_PROD, USG_MOD, USG_VAL,
VER_NORME, ECL_NUM, IDIMG_1, IDIMG_2, IDIMG_3, IDIMG_4, CTD_X, CTD_Y, CTD_Z,
FUSEAU, CODGEO, MUS_CO_GEO, CODUTM, ZCOL1, ZCOL3, DESCRIPTION, SHAPEOID,
SAS_SHAPEOID, CDS_SHAPEOID, CDX_ID, SAD_ID, SAM_ID, SAX_ID, NOP_SHAPEOID,
OBJECTID, VERSION, ID_TERR, rownum, geom FROM sagr_v_sdo WHERE   (
(NO_PERM_NUM= 82776)  AND  ( (ANNEE= 2011)  AND  (STATUT= 'ACT') ) )
[Thu Jun 16 10:55:51 2011].403847 msOracleSpatialLayerWhichShapes. Bind
values: srid:4326   minx:-83.414878   miny:42.585122  maxx:-53.585122
maxy:63.414878
[Thu Jun 16 10:55:51 2011].403955 msOracleSpatialLayerWhichShapes getting
ordinate definition.
[Thu Jun 16 10:55:51 2011].405614 msOracleSpatialLayerWhichShapes converting
to OCIColl.
[Thu Jun 16 10:55:51 2011].405910 msOracleSpatialLayerWhichShapes bind by
name and object.
[Thu Jun 16 10:55:51 2011].405928 msOracleSpatialLayerWhichShapes name and
object now bound.
[Thu Jun 16 10:55:51 2011].811085 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 0
[Thu Jun 16 10:55:51 2011].811347 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 1
[Thu Jun 16 10:55:51 2011].811450 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 2
[Thu Jun 16 10:55:51 2011].811546 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 3
[Thu Jun 16 10:55:51 2011].811636 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 4
[Thu Jun 16 10:55:51 2011].811708 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 5
[Thu Jun 16 10:55:51 2011].811779 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 6
[Thu Jun 16 10:55:51 2011].811864 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 7
[Thu Jun 16 10:55:51 2011].811936 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 8
[Thu Jun 16 10:55:51 2011].812020 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 9
[Thu Jun 16 10:55:51 2011].812110 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 10
[Thu Jun 16 10:55:51 2011].812190 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 11
[Thu Jun 16 10:55:51 2011].812291 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 12
[Thu Jun 16 10:55:51 2011].812371 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 13
[Thu Jun 16 10:55:51 2011].812519 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 14
[Thu Jun 16 10:55:51 2011].812623 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 15
[Thu Jun 16 10:55:51 2011].812701 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 16
[Thu Jun 16 10:55:51 2011].812804 msOracleSpatialLayerNextShape on layer
0x87b42a0, row_num: 17
[Thu Jun 16 10:55:51 2011].813314 msOracleSpatialLayerNextShape on layer
0x87b42a0, Fetched 0 more rows (17 total)
[Thu Jun 16 10:55:51 2011].815880 msOracleSpatialLayerGetShape was called.
Using the record = 0 of 17. (shape: 5028720 should equal pkey: 5028720)
[Thu Jun 16 10:55:51 2011].815906 msOracleSpatialLayerGetShape: Fetching
result from DB start: 0 end:-1 record: 0
[Thu Jun 16 10:55:51 2011].819632 msOracleSpatialLayerGetShape was called.
Using the record = 1 of 17. (shape: 5028721 should equal pkey: 5028721)
[Thu Jun 16 10:55:51 2011].820750 msOracleSpatialLayerGetShape was called.
Using the record = 2 of 17. (shape: 5028722 should equal pkey: 5028722)
[Thu Jun 16 10:55:51 2011].821585 msOracleSpatialLayerGetShape was called.
Using the record = 3 of 17. (shape: 5028723 should equal pkey: 5028723)
[Thu Jun 16 10:55:51 2011].822336 msOracleSpatialLayerGetShape was called.
Using the record = 4 of 17. (shape: 5028724 should equal pkey: 5028724)
[Thu Jun 16 10:55:51 2011].822934 msOracleSpatialLayerGetShape was called.
Using the record = 5 of 17. (shape: 5028725 should equal pkey: 5028725)
[Thu Jun 16 10:55:51 2011].823609 msOracleSpatialLayerGetShape was called.
Using the record = 6 of 17. (shape: 5028726 should equal pkey: 5028726)
[Thu Jun 16 10:55:51 2011].824308 msOracleSpatialLayerGetShape was called.
Using the record = 7 of 17. (shape: 5028727 should equal pkey: 5028727)
[Thu Jun 16 10:55:51 2011].824912 msOracleSpatialLayerGetShape was called.
Using the record = 8 of 17. (shape: 5028728 should equal pkey: 5028728)
[Thu Jun 16 10:55:51 2011].825664 msOracleSpatialLayerGetShape was called.
Using the record = 9 of 17. (shape: 5028729 should equal pkey: 5028729)
[Thu Jun 16 10:55:51 2011].826465 msOracleSpatialLayerGetShape was called.
Using the record = 10 of 17. (shape: 5028730 should equal pkey: 5028730)
[Thu Jun 16 10:55:51 2011].827179 msOracleSpatialLayerGetShape was called.
Using the record = 11 of 17. (shape: 5028731 should equal pkey: 5028731)
[Thu Jun 16 10:55:51 2011].827928 msOracleSpatialLayerGetShape was called.
Using the record = 12 of 17. (shape: 5028733 should equal pkey: 5028733)
[Thu Jun 16 10:55:51 2011].828699 msOracleSpatialLayerGetShape was called.
Using the record = 13 of 17. (shape: 5028715 should equal pkey: 5028715)
[Thu Jun 16 10:55:51 2011].830029 msOracleSpatialLayerGetShape was called.
Using the record = 14 of 17. (shape: 5028714 should equal pkey: 5028714)
[Thu Jun 16 10:55:51 2011].831003 msOracleSpatialLayerGetShape was called.
Using the record = 15 of 17. (shape: 5028717 should equal pkey: 5028717)
[Thu Jun 16 10:55:51 2011].831687 msOracleSpatialLayerGetShape was called.
Using the record = 16 of 17. (shape: 5028718 should equal pkey: 5028718)
[Thu Jun 16 10:55:51 2011].832687 msOracleSpatialLayerClose was called.
Layer: 0x87b42a0, Layer name: SAGR_V_SDO. Layer connection: zzz/zzz at zzz
[Thu Jun 16 10:55:51 2011].833843 msOracleSpatialLayerClose. Cleaning
layerinfo handlers.

thank's a lot

-- 
Simon Mercier
Consultant en géomatique
www.mgeospatial.com
linkedIn : http://ca.linkedin.com/in/simonmercier
twitter : http://twitter.com/simonmercier
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-dev/attachments/20110616/88b549a5/attachment.html