[pgrouting-users] crash of driving_distance with large network

[lorenzo amato]

You can also increase the log level of postgres in postgresql.conf to get
more messages

2011/1/18 Stephen Woodbridge <woodbri at swoodbridge.com>

> 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
>>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>



-- 
Lorenzo Amato
lorenzo.amato at geosdi.org
lorenzotlc at gmail.com
lorenzo.amato at nsdi.it

Consiglio Nazionale delle Ricerche
Istituto di Metodologie per l'Analisi Ambientale - geoSDI
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20110118/94592212/attachment-0001.html