[pgrouting-users] crash of driving_distance with large network

Daniel Kastl daniel at georepublic.de
Mon Jan 17 21:57:57 EST 2011


What Worth mentions can be a solution.
I also remember cases when a vacuum (and logout/login?) solved such a
problem.
But it can be also caused by pgRouting query.

Did you take a look at the PostgreSQL log file?

Daniel


2011/1/18 Worth Lutz <wal3 at mindspring.com>

>  I have seen that message and believe it is not related to pgRouting.
>
> I cannot remember the exact situation, but I think vacuuming the database
> was the solution.
>
> I also may have mis-remembered this.
>
>
>
> Worth
>
>
>  ------------------------------
>
> *From:* pgrouting-users-bounces at lists.osgeo.org [mailto:
> pgrouting-users-bounces at lists.osgeo.org] *On Behalf Of *Markus Innerebner
> *Sent:* Monday, January 17, 2011 12:59 PM
> *To:* pgRouting users mailing list
> *Subject:* [pgrouting-users] crash of driving_distance with large network
>
>
>
> Hi all,
>
> I try to launch the driving_distance function with a large network
> consisting of 100,000 edges. Every time I launch the query, the server
> closes the connection unexpectedly.
>
> Any idea why? Is there a way to get a more precise error message?
> I only get as message: "Server closed the connection unexpectedly. This
> probably means the server terminated abnormally before or while
> processing the request"
>
>
> thanks
>
> --
> Ph D. Student Markus Innerebner
>
> DIS Research Group - Faculty of Computer Science
> Free University Bozen-Bolzano
>
> Dominikanerplatz 3 - Room 211
> I - 39100 Bozen
> Phone:  +39-0471-016143
> Mobile: +39-333-9392929
>
>
> gpg --fingerprint
> -------------------------------------
> pub   1024D/588F6308 2007-01-09
>        Key fingerprint = 6948 947E CBD2 89FD E773  E863 914F EB1B 588F 6308
> sub   2048g/BF4877D0 2007-01-09
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>  ------------------------------
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1191 / Virus Database: 1435/3386 - Release Date: 01/17/11
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>


-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: http://georepublic.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20110118/1c43aff0/attachment.html


More information about the Pgrouting-users mailing list