What Worth mentions can be a solution.<div>I also remember cases when a vacuum (and logout/login?) solved such a problem.</div><div>But it can be also caused by pgRouting query.</div><div><br></div><div>Did you take a look at the PostgreSQL log file?</div>
<div><br></div><div>Daniel</div><div><br><br><div class="gmail_quote">2011/1/18 Worth Lutz <span dir="ltr"><<a href="mailto:wal3@mindspring.com">wal3@mindspring.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div lang="EN-US" link="blue" vlink="blue">
<div>
<p class="MsoNormal"><font size="3" color="blue" face="Comic Sans MS"><span style="font-size:12.0pt;font-family:"Comic Sans MS";color:blue">I have seen
that message and believe it is not related to pgRouting.</span></font></p>
<p class="MsoNormal"><font size="3" color="blue" face="Comic Sans MS"><span style="font-size:12.0pt;font-family:"Comic Sans MS";color:blue">I cannot
remember the exact situation, but I think vacuuming the database was the
solution. </span></font></p>
<p class="MsoNormal"><font size="3" color="blue" face="Comic Sans MS"><span style="font-size:12.0pt;font-family:"Comic Sans MS";color:blue">I also may have
mis-remembered this.</span></font></p>
<p class="MsoNormal"><font size="3" color="blue" face="Comic Sans MS"><span style="font-size:12.0pt;font-family:"Comic Sans MS";color:blue"> </span></font></p>
<p class="MsoNormal"><font size="3" color="blue" face="Comic Sans MS"><span style="font-size:12.0pt;font-family:"Comic Sans MS";color:blue">Worth</span></font></p>
<p class="MsoNormal"><font size="3" color="blue" face="Comic Sans MS"><span style="font-size:12.0pt;font-family:"Comic Sans MS";color:blue"> </span></font></p>
<div>
<div class="MsoNormal" align="center" style="text-align:center"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">
<hr size="2" width="100%" align="center">
</span></font></div>
<p class="MsoNormal"><b><font size="2" face="Tahoma"><span style="font-size:10.0pt;font-family:Tahoma;font-weight:bold">From:</span></font></b><font size="2" face="Tahoma"><span style="font-size:10.0pt;font-family:Tahoma"> <a href="mailto:pgrouting-users-bounces@lists.osgeo.org" target="_blank">pgrouting-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:pgrouting-users-bounces@lists.osgeo.org" target="_blank">pgrouting-users-bounces@lists.osgeo.org</a>] <b><span style="font-weight:bold">On Behalf Of </span></b>Markus Innerebner<br>
<b><span style="font-weight:bold">Sent:</span></b> Monday, January 17, 2011
12:59 PM<br>
<b><span style="font-weight:bold">To:</span></b> pgRouting users mailing list<br>
<b><span style="font-weight:bold">Subject:</span></b> [pgrouting-users] crash
of driving_distance with large network</span></font></p>
</div><div><div></div><div class="h5">
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font></p>
<p><font size="2" face="Times New Roman"><span style="font-size:10.0pt">Hi all,<br>
<br>
I try to launch the driving_distance function with a large network<br>
consisting of 100,000 edges. Every time I launch the query, the server<br>
closes the connection unexpectedly.<br>
<br>
Any idea why? Is there a way to get a more precise error message?<br>
I only get as message: "Server closed the connection unexpectedly. This<br>
probably means the server terminated abnormally before or while<br>
processing the request"<br>
<br>
<br>
thanks<br>
<br>
--<br>
Ph D. Student Markus Innerebner<br>
<br>
DIS Research Group - Faculty of Computer Science<br>
Free University Bozen-Bolzano<br>
<br>
Dominikanerplatz 3 - Room 211<br>
I - 39100 Bozen<br>
Phone: +39-0471-016143<br>
Mobile:
+39-333-9392929<br>
<br>
<br>
gpg --fingerprint<br>
-------------------------------------<br>
pub 1024D/588F6308 2007-01-09<br>
Key fingerprint = 6948 947E CBD2 89FD E773
E863 914F EB1B 588F 6308<br>
sub 2048g/BF4877D0 2007-01-09<br>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a></span></font>
</p>
</div></div><div class="MsoNormal" align="center" style="text-align:center"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">
<hr size="1" width="100%" noshade color="#aca899" align="center">
</span></font></div>
<p color="#000000"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">No virus found in this message.<br>
Checked by AVG - <a href="http://www.avg.com" target="_blank">www.avg.com</a><br>
Version: 10.0.1191 / Virus Database: 1435/3386 - Release Date: 01/17/11</span></font></p>
</div>
</div>
<br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><span style="font-family:arial, sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66, 99, 171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="http://georepublic.de/" style="color:rgb(66, 99, 171)" target="_blank">http://georepublic.de</a></span><br>
</div>