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-boun...@postgis.refractions.net [mailto:postgis-users-boun...@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-boun...@postgis.refractions.net [mailto:postgis-users-boun...@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.vlaha...@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
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
