<html 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" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></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="EN-AU" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Fixed with on upgrade to GEOS 3.3.0.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Cheers,<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999">James Sewell </span><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999"><br>
</span><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999">Solutions Architect </span><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999"><br>
</span><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999">LISAsoft </span><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999"><o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div class="MsoNormal"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999">
<hr size="2" width="420" style="width:315.0pt" align="left">
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999">Ph: </span></b><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999">+61 3 8680 3250 <b>Fax: </b>+61 3 8680 3299 </span><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999"><br>
</span><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999">Level 9, 601 Bourke St, Melbourne Vic 3000<o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div class="MsoNormal"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999">
<hr size="2" width="420" style="width:315.0pt" align="left">
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#4F81BD"><a href="http://www.lisasoft.com/"><span style="color:#4F81BD;text-decoration:none">http://www.lisasoft.com</span></a></span><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999"><br>
<br>
</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> maplabs@light42.com [mailto:maplabs@light42.com]
<br>
<b>Sent:</b> Tuesday, 13 September 2011 12:30 PM<br>
<b>To:</b> postgis-devel@postgis.refractions.net; James Sewell<br>
<b>Subject:</b> ST_IsValidReason causes crash<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p>-------<o:p></o:p></p>
<p>Linux tone 2.6.32-5-amd64 #1 SMP Tue Jun 14 09:42:28 UTC 2011 x86_64 GNU/Linux<o:p></o:p></p>
<p><o:p> </o:p></p>
<p>POSTGIS="2.0.0SVN" GEOS="3.4.0dev-CAPI-1.8.0" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.8" USE_STATS<o:p></o:p></p>
<p><o:p> </o:p></p>
<p>no crash <o:p></o:p></p>
<p>-------<o:p></o:p></p>
<p>Linux aced 2.6.32-5-amd64 #1 SMP Tue Jun 14 09:42:28 UTC 2011 x86_64 GNU/Linux<o:p></o:p></p>
<p><o:p> </o:p></p>
<p>POSTGIS="1.5.3" GEOS="3.3.0-CAPI-1.7.0" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.8" USE_STATS<o:p></o:p></p>
<p><o:p> </o:p></p>
<p>no crash<o:p></o:p></p>
<p>-------<o:p></o:p></p>
<p><o:p> </o:p></p>
<p><o:p> </o:p></p>
<p><o:p> </o:p></p>
<p><o:p> </o:p></p>
<p>On Tue, 13 Sep 2011 11:39:55 +0930, James Sewell wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid black 1.5pt;padding:0cm 0cm 0cm 4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div id="html-message">
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hello All,<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">I am running the following version on both CentOS and Solaris 10:<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> POSTGIS="1.5.3" GEOS="3.1.1-CAPI-1.6.0" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.6.26" USE_STATS<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">The following SQL causes a crash on both:<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> create table test (the_geom geometry);<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">
<b><span style="color:#204A87"> </span></b>insert into test(the_geom) values ('0103000020BB100000010000000E0000002F2FC03E3A146240D5A76620E0AF42C075ED66A1381462401CCF6740BDAF42C0980B016538146240E39A4C26B8AF42C0A8CA5246371462407E6DFDF49FAF42C0819AB56F49146240EA63F492B5AF42C0E17A14AE471462401D9DA9C601B042C04AE18B404614624074F7EFB03FB042C0E0C8F2642D1462405305A3923AB042C06EC5596C2E146240B06EBC3B32B042C0B294D16D2E14624022B4D43032B042C080F43C6E2E1462405175502E32B042C07DF43C6E2E1462406375502E32B042C04754A86E2E146240A536CC2B32B042C02F2FC03E3A146240D5A76620E0AF42C0');<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> select St_IsValidReason(the_geom) from test;
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> select St_IsValidReason(the_geom) from test;<br>
<br>
The first IsValidReason works as expected, then the second causes a psql hang and I see the following in the logs (CentOS):<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> *** glibc detected *** postgres: plm25 plm25 [local] SELECT: free(): invalid next size (fast): 0x09a77228 ***<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Can anyone reproduce this? I can’t with my other install:<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> POSTGIS="1.5.2" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.6.1, 21 August 2008" LIBXML="2.7.6" USE_STATS<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Any ideas on how I could further troubleshoot?<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif"">Cheers,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999">James Sewell <br>
Solutions Architect <br>
LISAsoft </span><o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div class="MsoNormal"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999">
<hr size="2" width="420" style="width:315.0pt" align="left">
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999">Ph: </span></b><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999">+61
3 8680 3250 <b>Fax: </b>+61 3 8680 3299 </span><span style="font-size:9.0pt;font-family:"Verdana","sans-serif""><br>
<span style="color:#999999">Level 9, 601 Bourke St, Melbourne Vic 3000</span></span><o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div class="MsoNormal"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999">
<hr size="2" width="420" style="width:315.0pt" align="left">
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#999999"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#4F81BD"><a href="http://www.lisasoft.com/" target="_blank"><span style="color:#4F81BD;text-decoration:none">http://www.lisasoft.com</span></a></span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center">
</div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:gray">The contents of this email are confidential and may be subject to legal or professional privilege and copyright. No representation is made that this email is free
of viruses or other defects. If you have received this communication in error, you may not copy or distribute any part of it or otherwise disclose its contents to anyone. Please advise the sender of your incorrect receipt of this correspondence.</span><o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center">
</div>
<p class="MsoNormal"><br>
_______________________________________________<br>
postgis-devel mailing list<br>
postgis-devel@postgis.refractions.net<br>
<a href="http://webmail.light42.com/hwebmail/services/go.php?url=http%3A%2F%2Fpostgis.refractions.net%2Fmailman%2Flistinfo%2Fpostgis-devel" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-devel</a><o:p></o:p></p>
</blockquote>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<p><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1">The contents of this email are confidential and may be subject to legal or professional privilege and copyright. No representation is made that this email is free of viruses or other defects. If you have received this
communication in error, you may not copy or distribute any part of it or otherwise disclose its contents to anyone. Please advise the sender of your incorrect receipt of this correspondence.<br>
</font>
</body>
</html>