<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=us-ascii">
<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: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:11.0pt;
font-family:"Calibri","sans-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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.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">Hello All,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am running the following version on both CentOS and Solaris 10:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"> 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"><o:p> </o:p></p>
<p class="MsoNormal">The following SQL causes a crash on both:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"> create table test (the_geom geometry);<o:p></o:p></p>
<p class="MsoNormal"> <b><span style="color:#204A87"> </span></b>insert into test(the_geom) values ('0103000020BB100000010000000E0000002F2FC03E3A146240D5A76620E0AF42C075ED66A1381462401CCF6740BDAF42C0980B016538146240E39A4C26B8AF42C0A8CA5246371462407E6DFDF49FAF42C0819AB56F49146240EA63F492B5AF42C0E17A14AE471462401D9DA9C601B042C04AE18B404614624074F7EFB03FB042C0E0C8F2642D1462405305A3923AB042C06EC5596C2E146240B06EBC3B32B042C0B294D16D2E14624022B4D43032B042C080F43C6E2E1462405175502E32B042C07DF43C6E2E1462406375502E32B042C04754A86E2E146240A536CC2B32B042C02F2FC03E3A146240D5A76620E0AF42C0');<o:p></o:p></p>
<p class="MsoNormal"> select St_IsValidReason(the_geom) from test; <o:p></o:p></p>
<p class="MsoNormal"> 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"><o:p> </o:p></p>
<p class="MsoNormal"> *** glibc detected *** postgres: plm25 plm25 [local] SELECT: free(): invalid next size (fast): 0x09a77228 ***<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Can anyone reproduce this? I can’t with my other install:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"> 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"><o:p> </o:p></p>
<p class="MsoNormal">Any ideas on how I could further troubleshoot?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif"">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><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>