[postgis-users] Signal 11: Segmentation fault

[Rebecca Clarke]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120719/ad791c0b/attachment.html>