You can also increase the log level of postgres in postgresql.conf to get more messages<br><br><div class="gmail_quote">2011/1/18 Stephen Woodbridge <span dir="ltr"><<a href="mailto:woodbri@swoodbridge.com">woodbri@swoodbridge.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Yeah, if your query requires too much memory to assemble and solve the graph, this can cause that problem. You might be able to solve the problem by allocating more memory to postgresql.<br>
<br>
-Steve W<div class="im"><br>
<br>
On 1/17/2011 9:57 PM, Daniel Kastl wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
What Worth mentions can be a solution.<br>
I also remember cases when a vacuum (and logout/login?) solved such a<br>
problem.<br>
But it can be also caused by pgRouting query.<br>
<br>
Did you take a look at the PostgreSQL log file?<br>
<br>
Daniel<br>
<br>
<br></div>
2011/1/18 Worth Lutz <<a href="mailto:wal3@mindspring.com" target="_blank">wal3@mindspring.com</a> <mailto:<a href="mailto:wal3@mindspring.com" target="_blank">wal3@mindspring.com</a>>><div><div></div><div class="h5">
<br>
<br>
I have seen that message and believe it is not related to pgRouting.<br>
<br>
I cannot remember the exact situation, but I think vacuuming the<br>
database was the solution.<br>
<br>
I also may have mis-remembered this.<br>
<br>
Worth<br>
<br>
*From: * <a href="mailto:pgrouting-users-bounces@lists.osgeo.org" target="_blank">pgrouting-users-bounces@lists.osgeo.org</a><br>
<mailto:<a href="mailto:pgrouting-users-bounces@lists.osgeo.org" target="_blank">pgrouting-users-bounces@lists.osgeo.org</a>><br>
[mailto:<a href="mailto:pgrouting-users-bounces@lists.osgeo.org" target="_blank">pgrouting-users-bounces@lists.osgeo.org</a><br>
<mailto:<a href="mailto:pgrouting-users-bounces@lists.osgeo.org" target="_blank">pgrouting-users-bounces@lists.osgeo.org</a>>] *On Behalf Of<br>
*Markus Innerebner<br>
*Sent:* Monday, January 17, 2011 12:59 PM<br>
*To:* pgRouting users mailing list<br>
*Subject:* [pgrouting-users] crash of driving_distance with large<br>
network<br>
<br>
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<br>
588F 6308<br>
sub 2048g/BF4877D0 2007-01-09<br>
</div></div></blockquote><div><div></div><div class="h5">
_______________________________________________<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><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Lorenzo Amato<br><a href="mailto:lorenzo.amato@geosdi.org">lorenzo.amato@geosdi.org</a><br><a href="mailto:lorenzotlc@gmail.com">lorenzotlc@gmail.com</a><br><a href="mailto:lorenzo.amato@nsdi.it">lorenzo.amato@nsdi.it</a><br>
<br>Consiglio Nazionale delle Ricerche<br>Istituto di Metodologie per l'Analisi Ambientale - geoSDI<br>