Hello list.
<div><br></div><div>I am experiencing a problem where I am calling 2 pgrouting functions one after another and it is causing the postgresql server (9.1) to crash. (pgrouting version 1.05)</div><div><br></div><div>The first function I call is driving_distance, and the second is shortest_path_astar.</div>
<div><br></div><div>Here is the contents of my postgresql log:</div><div><br></div><div>=============================================</div><div><div>terminate called after throwing an instance of 'std::bad_alloc'</div>
<div> what(): std::bad_alloc</div><div>LOG: server process (PID 2587) was terminated by signal 6: Aborted</div><div>LOG: terminating any other active server processes</div><div>WARNING: terminating connection because of crash of another server process</div>
<div>DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.</div><div>HINT: In a moment you should be able to reconnect to the database and repeat your command.</div>
<div>WARNING: terminating connection because of crash of another server process</div><div>DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.</div>
<div>HINT: In a moment you should be able to reconnect to the database and repeat your command.</div><div>WARNING: terminating connection because of crash of another server process</div><div>DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.</div>
<div>HINT: In a moment you should be able to reconnect to the database and repeat your command.</div><div>WARNING: terminating connection because of crash of another server process</div><div>DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.</div>
<div>HINT: In a moment you should be able to reconnect to the database and repeat your command.</div><div>WARNING: terminating connection because of crash of another server process</div><div>DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.</div>
<div>HINT: In a moment you should be able to reconnect to the database and repeat your command.</div><div>LOG: all server processes terminated; reinitializing</div><div>LOG: database system was interrupted; last known up at 2012-03-23 21:51:38 EDT</div>
<div>LOG: database system was not properly shut down; automatic recovery in progress</div><div>LOG: redo starts at 13/E1D60</div><div>LOG: unexpected pageaddr 12/F8ED6000 in log file 19, segment 1, offset 15556608</div>
<div>LOG: redo done at 13/1ED5F90</div><div>LOG: last completed transaction was at log time 2012-03-23 21:51:38.166328-04</div><div>FATAL: the database system is in recovery mode</div><div>FATAL: the database system is in recovery mode</div>
<div>LOG: database system is ready to accept connections</div><div>LOG: autovacuum launcher started</div><div><br></div><div><br></div><div>//Restarted the server and ran my function again</div><div><br></div><div><br></div>
<div>terminate called after throwing an instance of 'std::bad_alloc'</div><div> what(): std::bad_alloc</div><div>LOG: server process (PID 7716) was terminated by signal 6: Aborted</div><div>LOG: terminating any other active server processes</div>
<div>WARNING: terminating connection because of crash of another server process</div><div>DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.</div>
<div>HINT: In a moment you should be able to reconnect to the database and repeat your command.</div><div>WARNING: terminating connection because of crash of another server process</div><div>DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.</div>
<div>HINT: In a moment you should be able to reconnect to the database and repeat your command.</div><div>WARNING: terminating connection because of crash of another server process</div><div>DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.</div>
<div>HINT: In a moment you should be able to reconnect to the database and repeat your command.</div><div>LOG: all server processes terminated; reinitializing</div><div>LOG: database system was interrupted; last known up at 2012-03-23 21:58:57 EDT</div>
<div>LOG: database system was not properly shut down; automatic recovery in progress</div><div>LOG: redo starts at 13/1F43238</div><div>LOG: unexpected pageaddr 12/F8F76000 in log file 19, segment 1, offset 16211968</div>
<div>LOG: redo done at 13/1F75F28</div><div>LOG: last completed transaction was at log time 2012-03-23 22:01:14.86379-04</div><div>LOG: database system is ready to accept connections</div><div>LOG: autovacuum launcher started</div>
</div><div><br></div><div>=============================================================</div><div><br></div><div>If I run driving_distance and shortest_path_astar independently of one another there is no problem whatsoever. If I use shortest_path_shooting_star, it works fine. In other words I can replace my call to shorest_path_astar with shortest_path_shooting_star after my driving_distance call and it works.</div>
<div><br></div><div>My use case for this scenario is that I want to first create a drive time polygon, and then calculate distances to points within the polygon from my centroid. </div><div><br></div><div>Thanks for any help!</div>
<div>-Steve</div>