[postgis-users] Weird GEOS problem

[George Vlahakis]

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