[pgrouting-users] crash of driving_distance with large network

Stephen Woodbridge woodbri at swoodbridge.com
Mon Jan 17 22:43:38 EST 2011


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.

-Steve W

On 1/17/2011 9:57 PM, Daniel Kastl wrote:
> 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 <mailto: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>
>     [mailto: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


More information about the Pgrouting-users mailing list