<HTML dir=ltr><HEAD>
<META content="text/html; charset=unicode" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18865">
<STYLE>font-face {
font-family: Cambria Math;
}
font-face {
font-family: Calibri;
}
font-face {
font-family: Tahoma;
}
font-face {
font-family: Myriad Pro;
}
P.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
LI.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
DIV.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"; FONT-SIZE: 12pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline;}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline;}
A:visited {
COLOR: purple; TEXT-DECORATION: underline;}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline;}
P {
FONT-FAMILY: "Times New Roman","serif"; MARGIN-LEFT: 0cm; FONT-SIZE: 12pt; MARGIN-RIGHT: 0cm;}
SPAN.EmailStyle18 {
FONT-FAMILY: "Myriad Pro","sans-serif"; COLOR: #0f243e;}
.MsoChpDefault {}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EL link=blue vLink=purple>
<DIV dir=ltr id=idOWAReplyText87985>
<DIV dir=ltr><FONT color=#000000 size=1 face=Arial>Hi Leo,</FONT></DIV>
<DIV dir=ltr><FONT size=1 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT size=1 face=Arial>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. </FONT></DIV>
<DIV dir=ltr><FONT size=1 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT size=1 face=Arial>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.</FONT></DIV>
<DIV dir=ltr><FONT size=1 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT size=1 face=Arial>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.</FONT></DIV>
<DIV dir=ltr><FONT size=1 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT size=1 face=Arial>Regards</FONT></DIV>
<DIV dir=ltr><FONT size=1 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT size=1 face=Arial>George</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@postgis.refractions.net on behalf of Paragon Corporation<BR><B>Sent:</B> Sun 12/13/2009 00:54<BR><B>To:</B> 'PostGIS Users Discussion'<BR><B>Subject:</B> Re: [postgis-users] Weird GEOS problem<BR></FONT><BR></DIV>
<DIV>
<DIV dir=ltr align=left><SPAN class=036364022-12122009><FONT color=#0000ff size=2 face=Arial>George,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=036364022-12122009><FONT color=#0000ff size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=036364022-12122009><FONT color=#0000ff size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=036364022-12122009><FONT color=#0000ff size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=036364022-12122009><FONT color=#0000ff size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=036364022-12122009><FONT color=#0000ff size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=036364022-12122009><FONT color=#0000ff size=2 face=Arial>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. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=036364022-12122009><FONT color=#0000ff size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=036364022-12122009><FONT color=#0000ff size=2 face=Arial>Leo</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=036364022-12122009><FONT color=#0000ff size=2 face=Arial></FONT></SPAN> </DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@postgis.refractions.net [mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>George Vlahakis<BR><B>Sent:</B> Friday, December 11, 2009 6:15 AM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users] Weird GEOS problem<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Myriad Pro','sans-serif'; COLOR: #0f243e; FONT-SIZE: 10pt" lang=EN-US>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.</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Myriad Pro','sans-serif'; COLOR: #0f243e; FONT-SIZE: 10pt" lang=EN-US></SPAN> </P>
<DIV style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt" lang=EN-US>From:</SPAN></B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt" lang=EN-US> postgis-users-bounces@postgis.refractions.net [mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Emilie Laffray<BR><B>Sent:</B> Friday, December 11, 2009 1:13 PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users] Weird GEOS problem</SPAN></P></DIV>
<P class=MsoNormal> </P>
<P style="MARGIN-BOTTOM: 12pt" class=MsoNormal> </P>
<DIV>
<P class=MsoNormal>2009/12/11 George Vlahakis <<A href="mailto:g.vlahakis@telenavis.com">g.vlahakis@telenavis.com</A>></P>
<DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt" lang=EN-US>Hi all,</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt" lang=EN-US></SPAN> </P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt" lang=EN-US>Probably nobody has seen this, but on a particular machine (Win XP) every 2-3 hours or so I am getting the following error:</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt" lang=EN-US></SPAN> </P>
<P><SPAN lang=EN-US>System.Data.Odbc.OdbcException: ERROR [XX000] ERROR: Error creating GEOS Coordinate Sequence; Error while executing the query</SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt" lang=EN-US></SPAN> </P></DIV></DIV></DIV>
<P class=MsoNormal>I might be wrong but you are using .NET? <BR>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.<BR><BR>Emilie Laffray</P></DIV></DIV></BODY></HTML>