But that doesn't explain why it's just started happening. Can you give me a link that tells me what the bug is. Cheers
On Thu, Jul 19, 2012 at 6:22 PM, Sandro Santilli <s...@keybit.net> wrote: > 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 >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users