[postgis-users] Weird GEOS problem

[Paragon Corporation]

George,
 
Which version of GEOS are you running?  We've never seen that particular
error before but could be caused by a malformed geometry that pops in every
3 hours or some sort of memory leak that only shows up with enough querying.
 
Also you know which query you are running to generate that error?  Checking
the PostgreSQL logs might help pinpoint that which is located in data\pg_log
directory.   I think that by default logs the query that caused the error
and the error.
 
You may need to increase what you are logging from postgresql.conf but I
forget off hand which settings those are that would be helpful. 
 
Leo
 

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of George
Vlahakis
Sent: Friday, December 11, 2009 6:15 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Weird GEOS problem



Ok thanks, I used to use npgsql but for spatial queries and binary geometry
retrieval I found it the opposite. It has been some time, but I will try it.

 

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Emilie
Laffray
Sent: Friday, December 11, 2009 1:13 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Weird GEOS problem

 

 

2009/12/11 George Vlahakis <g.vlahakis at telenavis.com>

Hi all,

 

Probably nobody has seen this, but on a particular machine (Win XP) every
2-3 hours or so I am getting the following error:

 

System.Data.Odbc.OdbcException: ERROR [XX000] ERROR: Error creating GEOS
Coordinate Sequence; Error while executing the query

 

I might be wrong but you are using .NET? 
If it is indeed the case, I would suggest dropping the use of odbc, and use
npgsql which provides a direct connection to the database. It should give
you better performance, and maybe extra stability.

Emilie Laffray

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091212/f5e830ce/attachment.html>