<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16466">
<STYLE>@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Myriad Pro;
}
@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
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; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
P {
FONT-FAMILY: "Times New Roman","serif"; MARGIN-LEFT: 0cm; FONT-SIZE: 12pt; MARGIN-RIGHT: 0cm; mso-style-priority: 99; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
FONT-FAMILY: "Myriad Pro","sans-serif"; COLOR: #0f243e; mso-style-type: personal-reply
}
.MsoChpDefault {
mso-style-type: export-only
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EL link=blue vLink=purple>
<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.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Myriad Pro','sans-serif'; COLOR: #0f243e; FONT-SIZE: 10pt"
lang=EN-US><o:p> </o:p></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<o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<P style="MARGIN-BOTTOM: 12pt" class=MsoNormal><o:p> </o:p></P>
<DIV>
<P class=MsoNormal>2009/12/11 George Vlahakis <<A
href="mailto:g.vlahakis@telenavis.com">g.vlahakis@telenavis.com</A>><o:p></o:p></P>
<DIV>
<DIV>
<P style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"
class=MsoNormal><SPAN style="FONT-SIZE: 10pt" lang=EN-US>Hi
all,</SPAN><o:p></o:p></P>
<P style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"
class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN><o:p></o:p></P>
<P style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"
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><o:p></o:p></P>
<P style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"
class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN><o:p></o:p></P>
<P><SPAN lang=EN-US>System.Data.Odbc.OdbcException: ERROR [XX000] ERROR: Error
creating GEOS Coordinate Sequence; Error while executing the
query</SPAN><o:p></o:p></P>
<P style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"
class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US> </SPAN><o:p></o:p></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<o:p></o:p></P></DIV></BODY></HTML>