[postgis-users] Signal 11: Segmentation fault

[Sandro Santilli]

Sounds like a bad bug recently discovered and already fixed in the 
repository. You'll have to upgrade to 1.5.5, but it isn't out yet.

If you filed a bug it may put some more pressure to the release manager :)

--strk;

On Thu, Jul 19, 2012 at 05:37:12PM +0100, Rebecca Clarke wrote:
> Hi there
> 
> I'm running Postgresql 8.4 with postgis 1.5.
> I have a table that contains roughly 2000 records.
> The geometry in the table is a polygon.
> 
> I can run the following query with no problems
> 
> select the_geom from mytable;
> 
> However when I run something like this:
> 
> select st_centroid(the_geom) from mytable;
> 
> or
> 
> select st_isvalid(the_geom) from mytable;
> 
> I get the following error everytime:
> 
> 2012-07-19 17:23:47 BST LOG:  server process (PID 19445) was terminated by
> signal 11: Segmentation fault
> 2012-07-19 17:23:47 BST LOG:  terminating any other active server processes
> 2012-07-19 17:23:47 BST LOG:  all server processes terminated;
> reinitializing
> 2012-07-19 17:23:47 BST LOG:  database system was interrupted; last known
> up at 2012-07-19 17:23:33 BST
> 2012-07-19 17:23:47 BST LOG:  database system was not properly shut down;
> automatic recovery in progress
> 2012-07-19 17:23:47 BST LOG:  record with zero length at 1406/B6388B94
> 2012-07-19 17:23:47 BST LOG:  redo is not required
> 2012-07-19 17:23:47 BST LOG:  autovacuum launcher started
> 2012-07-19 17:23:47 BST LOG:  database system is ready to accept connections
> 
> 
> If I limit the query to 100 records it works.
> 
> In the same table I have another geometry that is a point. When I run the
> st_isvalid against that, it does not error.
> 
> What is strange is this has only just started happening. I thought it was a
> hardware issue, so I completely dumped the database and recreated it on
> another server but the issue persisted. I'm not sure what I have done wrong.
> 
> 
> The data originates from an mdb. The geom's were stored as OLE Objects.
> When I imported them into postgres they were bytea. I converted them with
> st_geomfromewkb(the_geom).
> 
> Any help or directions on where I can go to figure out how to solve this
> issue would be great.
> 
> Thanks
> 
> Rebecca