Hi Steve,<br>I am trying to download the csv but ending up with 404 Not Found error. Please confirm the URL works. I am also getting the same problem with <a href="http://imaptools.com/dl/test.tgz" target="_blank">http://imaptools.com/dl/test.tgz</a><br>
<br>-Razequl<br><br><div class="gmail_quote">On Sun, Jul 1, 2012 at 7:37 PM, Stephen Woodbridge <span dir="ltr"><<a href="mailto:woodbri@swoodbridge.com" target="_blank">woodbri@swoodbridge.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Razqequl,<br>
<br>
I have not looked into the reason, but my intuition it that it may be because this graph has about 50K edges so it will be larger than most anything that you generated by hand, and the edge and node numbers are very large because this is an extract from a 10s of million of edges graph. There were no error message other than the generic postgresql message the the server crashed. You will probably fine you have a segv in your test program.<br>
<br>
I can download a zipped copy of the csv file. The first row is the column names.<br>
<br>
<a href="http://imaptools.com/dl/bdsp-big-bug.zip" target="_blank">http://imaptools.com/dl/bdsp-<u></u>big-bug.zip</a><br>
<br>
-Steve<div class="im"><br>
<br>
On 7/1/2012 5:18 AM, Razequl Islam wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
Hi Steve,<br>
Bad news :(<br>
<br>
As I mentioned, I already have a test application to read from text<br>
file, it will be very helpful if you send me a csv file containing the<br>
graph. Also please let me know if there is any error message. I am<br>
looking into my code for a possible reason.<br>
<br>
-Razequl<br>
<br>
On Sun, Jul 1, 2012 at 3:19 AM, Stephen Woodbridge<br></div><div><div class="h5">
<<a href="mailto:woodbri@swoodbridge.com" target="_blank">woodbri@swoodbridge.com</a> <mailto:<a href="mailto:woodbri@swoodbridge.com" target="_blank">woodbri@swoodbridge.<u></u>com</a>>> wrote:<br>
<br>
Hi Razequl,<br>
<br>
I tried a larger test and it crashed the server.<br>
<br>
You can test it like this:<br>
<br>
# fetch a test file from my server<br>
wget <a href="http://imaptools.com/dl/test" target="_blank">http://imaptools.com/dl/test</a>. tgz<br>
<<a href="http://imaptools.com/dl/test.tgz" target="_blank">http://imaptools.com/dl/test.<u></u>tgz</a>><br>
<br>
# extract the tarfile into directory test<br>
tar xzf test.tgz<br>
<br>
# load the file into your test database into table "st"<br>
shp2pgsql -s 4326 -c -D -I -N skip test/bdsp-bug.shp st | psql -U<br>
user -h localhost mydatabase<br>
<br>
# get into psql or pgadmin and run the following<br>
psql -U user -h localhost mydatabase<br>
SELECT * FROM st, (<br>
SELECT gid,the_geom<br>
FROM bidir_dijkstra_shortest_path(<br>
'SELECT link_id as id,<br>
source::integer,<br>
target::integer,<br>
cost_time::double precision as cost ,<br>
rcost_time as reverse_cost<br>
FROM st a',<br>
1187405,<br>
1187508,<br>
true,<br>
true<br>
), st where edge_id = link_id<br>
) as rt<br>
WHERE st.gid=rt.gid;<br>
<br>
This crashes my server!<br>
<br>
If you want to write a testmain.cpp, I can provide the graph data in<br>
a csv file that you could read in and pass to your code instead of<br>
the query to get the data from table st.<br>
<br>
-Steve<br>
______________________________ _________________<br>
pgrouting-dev mailing list<br></div></div>
<a href="mailto:pgrouting-dev@lists.osgeo.org" target="_blank">pgrouting-dev@lists.osgeo.org</a> <mailto:<a href="mailto:pgrouting-dev@lists.osgeo.org" target="_blank">pgrouting-dev@lists.<u></u>osgeo.org</a>><br>
<a href="http://lists.osgeo.org/" target="_blank">http://lists.osgeo.org/</a> mailman/listinfo/pgrouting-dev<br>
<<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-dev</a><u></u>><div class="im"><br>
<br>
<br>
<br>
<br>
______________________________<u></u>_________________<br>
pgrouting-dev mailing list<br>
<a href="mailto:pgrouting-dev@lists.osgeo.org" target="_blank">pgrouting-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-dev</a><br>
<br>
</div></blockquote><div class="HOEnZb"><div class="h5">
<br>
<br>
______________________________<u></u>_________________<br>
pgrouting-dev mailing list<br>
<a href="mailto:pgrouting-dev@lists.osgeo.org" target="_blank">pgrouting-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-dev</a><br>
</div></div></blockquote></div><br>