[postgis-users] Weird GEOS problem

[George Vlahakis]

Hi Leo,
 
before even looking into the suggested, let me point out that the same application, with the same database on three different machines did not produce this error for the past two weeks (running non-stop). On this machine however as I mentioned it pops up every 2-3 hours or so. 
 
No mem increase detected and the query is one (any) of a set of three which are repeatedly called on a loop. As such I am inclined to believe it is an environment issue. Different OS would qualify for this as this is the only 32 bit XP, the others are Vista (64/32) and Win 2008 64.
 
I have now retired the machine for the farm, and I might retry formatting it in the future. As I didnt find any other references on the web on this error I wanted to give it a try here.
 
Regards
 
George

________________________________

From: postgis-users-bounces at postgis.refractions.net on behalf of Paragon Corporation
Sent: Sun 12/13/2009 00:54
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] Weird GEOS problem


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/20091213/dc44da07/attachment.html>