[pgrouting-dev] BDSP Crashes

Razequl Islam ziboncsedu at gmail.com
Sun Jul 1 02:18:17 PDT 2012


Hi Steve,
Bad news :(

As I mentioned, I already have a test application to read from text file,
it will be very helpful if you send me a csv file containing the graph.
Also please let me know if there is any error message. I am looking into my
code for a possible reason.

-Razequl

On Sun, Jul 1, 2012 at 3:19 AM, Stephen Woodbridge
<woodbri at swoodbridge.com>wrote:

> Hi Razequl,
>
> I tried a larger test and it crashed the server.
>
> You can test it like this:
>
> # fetch a test file from my server
> wget http://imaptools.com/dl/test.**tgz <http://imaptools.com/dl/test.tgz>
>
> # extract the tarfile into directory test
> tar xzf test.tgz
>
> # load the file into your test database into table "st"
> shp2pgsql -s 4326 -c -D -I -N skip test/bdsp-bug.shp st | psql -U user -h
> localhost mydatabase
>
> # get into psql or pgadmin and run the following
> psql -U user -h localhost mydatabase
> SELECT * FROM st, (
>               SELECT gid,the_geom
>                 FROM bidir_dijkstra_shortest_path(
>                   'SELECT link_id  as id,
>                            source::integer,
>                            target::integer,
>                            cost_time::double precision as cost ,
>                            rcost_time as reverse_cost
>                      FROM st a',
>                   1187405,
>                   1187508,
>                   true,
>                   true
>          ), st where edge_id = link_id
>     ) as rt
>     WHERE st.gid=rt.gid;
>
> This crashes my server!
>
> If you want to write a testmain.cpp, I can provide the graph data in a csv
> file that you could read in and pass to your code instead of the query to
> get the data from table st.
>
> -Steve
> ______________________________**_________________
> pgrouting-dev mailing list
> pgrouting-dev at lists.osgeo.org
> http://lists.osgeo.org/**mailman/listinfo/pgrouting-dev<http://lists.osgeo.org/mailman/listinfo/pgrouting-dev>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-dev/attachments/20120701/787344db/attachment.html>


More information about the pgrouting-dev mailing list