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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
