[postgis-users] PosGis shutdown with request using within

[Markus Schaber]

Hi, Xavier,

Xavier Mauclaire wrote:

> The system becomes instable and i've to to do a hard reset of the machine
> I can't stop the process neither with postgresql restart not pgctl -m ...
> Under window a can restart the service BUT i've got to do that to kill the
> postmaster process linked to th request
> This request uses 99 pourcent of the CPU and the connection is usually
> broken after sometimes

You should be able to kill the backend process via the task manager.

Some "within" queries may need lots of CPU time for complex polygons.

That the query shutdowns the Postmaster process seems to be a bug.

Can you try to identify some pairs of geometries that forthe the
Postmaster to shutdown?

And can you run isvalid() against all geometries involved, to make shure
they're all valid?

Thanks,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org