[postgis-users] Weird GEOS problem

[George Vlahakis]

Same here. Thanks for replying however.

 

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Joao
Goncalves
Sent: Tuesday, December 15, 2009 10:17 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Weird GEOS problem

 

Yes, the connection resource object goes invalid and I need to create a
new one. I've also experienced server shut downs caused by this problem.
Funny, I added eactly the same solution drop and reconnect within a
tryCatch block. I'm guessing this is a server side/GEOS issue because it
tends to happen in very specific conditions, in my case when
geoproccessing is very intensive. Nevertheless, I have no real knowledge
on GEOS internals to figure this out. 




Did you also see that the connection is no longer valid from that point
on and you need to re-connect? I mean, even if you wait and try again,
it won't work. I have to resort in restarting the app but not I added
code to try to drop and re-connect. Haven't hit the prob yet to confirm
this solves it.

 

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
"Joao G."
Sent: Sunday, December 13, 2009 11:18 PM
To: PostGIS Users Discussion
Subject: [postgis-users] Weird GEOS problem

 

I also found this problem when issuing many queries per minute or when
performing multiple/time demanding distance calculations between complex
(multi)geometries. I use XP pro with R (RPostgreSQL lib) to connect to
PostgreSQL.

George Vlahakis escreveu: 

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/20091215/5ac53db7/attachment.html>