[PostGIS] error

[tbonfort]

Reporter: tomkralidis Date: 2005/12/15 - 05:16

When downloading latest CVS on 13 December 2005, the last change made on
mappostgis.c gives back a segfault on a WFS GetFeature against a PostGIS connection.

The best info I got was from the httpd error_log:

[Tue Dec 13 10:39:12 2005] [error] [client 199.212.16.10] [Tue Dec 13 10:39:12
2005].406069
[Tue Dec 13 10:39:12 2005] [error] [client 199.212.16.10] msPOSTGISLayerClose
datastatement: the_geom from (select service_endpoints.lang as lang,
service_endpoints.organization as organiz
ation,service_endpoints.logourl as
logourl,service_endpoints.endpoint_getresource as
endpoint_getresource,service_endpoints.service_type as
service_type,service_endpoints.service_version a
s service_version,service_resources.the_geom as
the_geom,service_resources.resource_id as
resource_id,service_resources.service_id as service_id,service_resources.name as
name,service_reso
urces.title as title,service_resources.abstract as
abstract,service_resources.keywords as keywords,service_resources.dataurl as
dataurl,service_resources.metadataurl as metadataurl,service
_resources.legendurl as legendurl,service_resources.scale_min as
scale_min,service_resources.scale_max as scale_max,service_resources.srs as
srs,service_endpoints.format_list as format_lis
t,service_resources.style_list as style_list,service_resources.time_extent as
time_extent,service_resources.queryable as queryable from service_resources
inner join service_endpoints on se
rvice_endpoints.service_id = service_resources.service_id) as t using unique
resource_id
[Tue Dec 13 10:39:12 2005] [error] [client 199.212.16.10] [Tue Dec 13 10:39:12
2005].409291
[Tue Dec 13 10:39:12 2005] [error] [client 199.212.16.10] msPOSTGISLayerClose --
query_result is NULL
[Tue Dec 13 10:39:12 2005] [error] [client 199.212.16.10] [Tue Dec 13 10:39:12
2005].409720
[Tue Dec 13 10:39:12 2005] [error] [client 199.212.16.10]
msConnPoolRelease(service_resources,user=postgres dbname=devgeodb,0x82f9990)
[Tue Dec 13 10:39:12 2005] [error] [client 199.212.16.10] [Tue Dec 13 10:39:12
2005].410259
[Tue Dec 13 10:39:12 2005] [error] [client 199.212.16.10]
msConnPoolClose(user=postgres dbname=devgeodb,0x82f9990)
[Tue Dec 13 10:39:12 2005] [error] [client 199.212.16.10] [Tue Dec 13 10:39:12
2005].412877
[Tue Dec 13 10:39:12 2005] [error] [client 199.212.16.10] msPOSTGISLayerOpen
called datastatement: the_geom from (select service_endpoints.lang as lang,
service_endpoints.organization as o
rganization,service_endpoints.logourl as
logourl,service_endpoints.endpoint_getresource as
endpoint_getresource,service_endpoints.service_type as
service_type,service_endpoints.service_ver
sion as service_version,service_resources.the_geom as
the_geom,service_resources.resource_id as
resource_id,service_resources.service_id as service_id,service_resources.name as
name,servic
e_resources.title as title,service_resources.abstract as
abstract,service_resources.keywords as keywords,service_resources.dataurl as
dataurl,service_resources.metadataurl as metadataurl,s
ervice_resources.legendurl as legendurl,service_resources.scale_min as
scale_min,service_resources.scale_max as scale_max,service_resources.srs as
srs,service_endpoints.format_list as form
at_list,service_resources.style_list as style_list,service_resources.time_extent
as time_extent,service_resources.queryable as queryable from service_resources
inner join service_endpoints
 on service_endpoints.service_id = service_resources.service_id) as t using
unique resource_id
[Tue Dec 13 10:39:12 2005] [error] [client 199.212.16.10] [Tue Dec 13 10:39:12
2005].416072
[Tue Dec 13 10:39:12 2005] [error] [client 199.212.16.10] MSPOSTGISLayerOpen --
shared connection not available.
[Tue Dec 13 10:39:12 2005] [error] [client 199.212.16.10]
/usr/local/wwwsites/apache/devgeo.cciw.ca/cgi-bin/mapserv/owscat: line 4:  6878
Segmentation fault      ./mapserv
[Tue Dec 13 10:39:12 2005] [error] [client 199.212.16.10] Premature end of
script headers: owscat

[tbonfort]

Author: tomkralidis Date: 2005/12/15 - 06:12

I'm not sure what happened (there's been some commits in the last couple of
days), but I can't see this problem anymore.  I'll leave this open for a couple
of days and do more testing just in case.

[tbonfort]

Author: tomkralidis Date: 2005/12/21 - 16:07

Gremlins.  Closing.