Opened 14 years ago

Last modified 14 years ago

#3339 new defect

wfs 1.1.0 getfeature is broken

Reported by: nsavard Owned by: mapserverbugs
Priority: normal Milestone:
Component: WFS Server Version: svn-trunk (development)
Severity: blocker Keywords: wfs1.1 getfeature
Cc: assefa, tomkralidis

Description

After updating to the latest revision the getfeature request returns an error saying that the sql request could not be built. See debug info below. This request used to work before. Yewondwossen I tested on your server, it works, but am not sure if it was updated recently.

Request: http://gw.lan.mapgears.com:8500/cgi-bin/mswfs110_ogc_cite?&service=WFS&version=1.1.0&request=getfeature&typename=sf:PrimitiveGeoFeature&namespace=xmlns

Debug info:

[Mon Feb 22 16:11:09 2010].833675 msPostGISParseData called.
[Mon Feb 22 16:11:09 2010].833692 msPostGISParseData: unique_column=id, srid=4326, geom_column_name=the_geom, table_name=primitivegeofeature
[Mon Feb 22 16:11:09 2010].833707 msPostGISBuildSQL called.
[Mon Feb 22 16:11:09 2010].833720 msPostGISBuildSQLItems called.
[Mon Feb 22 16:11:09 2010].833734 msPostGISBuildSQLItems: 9 items requested.
[Mon Feb 22 16:11:09 2010].833761 msPostGISBuildSQLFrom called.
[Mon Feb 22 16:11:09 2010].833775 msPostGISBuildSQLWhere called.
[Mon Feb 22 16:11:09 2010].833788 msPostGISBuildSQLSRID called.
[Mon Feb 22 16:11:09 2010].833800 msPostGISBuildSQLSRID: SRID provided (4326)
[Mon Feb 22 16:11:09 2010].833812 msPostGISBuildSQLBox called.
[Mon Feb 22 16:11:09 2010].833910 msPostGISBuildSQLBox: General error message. Bounding box digits truncated.
[Mon Feb 22 16:11:09 2010].833926 msPostGISBuildSQLWhere(): General error message. Unable to build box SQL.
[Mon Feb 22 16:11:09 2010].833953 msPostGISBuildSQL(): General error message. Failed to build SQL 'where'.
[Mon Feb 22 16:11:09 2010].833968 msPostGISLayerWhichShapes(): Query error. Failed to build query SQL.
[Mon Feb 22 16:11:09 2010].833982 msPostGISLayerFreeItemInfo called.
[Mon Feb 22 16:11:09 2010].833993 msPostGISLayerClose called: the_geom from primitivegeofeature USING UNIQUE id USING SRID=4326
[Mon Feb 22 16:11:09 2010].834005 msConnPoolRelease(PrimitiveGeoFeature,dbname=cite-wfs110 user=nsavard host=localhost port=5432 password=ttt123,0x808ad48)
[Mon Feb 22 16:11:09 2010].834020 msConnPoolClose(dbname=cite-wfs110 user=nsavard host=localhost port=5432 password=ttt123,0x808ad48)
[Mon Feb 22 16:11:09 2010].834107 msWFSGetFeature(): WFS server error. ms_error->code not found
[Mon Feb 22 16:11:09 2010].834790 mapserv request processing time (msLoadMap not incl.): 0.021s
[Mon Feb 22 16:11:09 2010].834833 msFreeMap(): freeing map at 0x805b1f8.
[Mon Feb 22 16:11:09 2010].834849 msPostGISLayerClose called: the_geom from primitivegeofeature USING UNIQUE id USING SRID=4326
[Mon Feb 22 16:11:09 2010].835042 freeLayer(): freeing layer at 0x8063050.
[Mon Feb 22 16:11:09 2010].835157 msPostGISLayerIsOpen called.
[Mon Feb 22 16:11:09 2010].835202 freeLayer(): freeing layer at 0x8063f28.
[Mon Feb 22 16:11:09 2010].835222 msPostGISLayerIsOpen called.
[Mon Feb 22 16:11:09 2010].835253 freeLayer(): freeing layer at 0x8064ed0.
[Mon Feb 22 16:11:09 2010].835266 msPostGISLayerIsOpen called.

Change History (2)

comment:1 by nsavard, 14 years ago

Severity: normalblocker

comment:2 by assefa, 14 years ago

Norm,

I think this bug is related to changes done in #3324.

There was another commit done r9866. One lines 920 and 940 the size of string has been increased from ..15... to ...26...

Please give it a try with the latest svn to see if it passes.

Note: See TracTickets for help on using tickets.