[postgis-users] Weird GEOS problem

[João Gonçalves]

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> 
> [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 
> <mailto: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/3341f6a1/attachment.html>