[postgis-users] Re: pgrouting and postgis

[Daniel W]

Hello.

Maybe it will help. I found these logs, if I do the query:


terminate called after throwing an instance of 'std::bad_alloc'
  what():  St9bad_alloc
LOG:  server process (PID 13657) was terminated by signal 6
LOG:  terminating any other active server processes
WARNING:  terminating connection because of crash of another server process
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 memo
ry.
HINT:  In a moment you should be able to reconnect to the database and
repeat your command.
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted at 2008-06-10 22:52:32 CEST
LOG:  checkpoint record is at 0/37D04360
LOG:  redo record is at 0/37D04360; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 1883985; next OID: 2550772
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  record with zero length at 0/37D043A8
LOG:  redo is not required
LOG:  database system is ready


greets,
Daniel


On Tue, Jun 10, 2008 at 6:26 PM, Daniel W <gentoo.murray at gmail.com> wrote:
> Hello,
>
> i am new to Postgis and pgRouting and i am trying to route over some
> data, but it doesnt work for me.
>
> I installed a routing database with following commands as described in
> the pgrouting online tutorial
> (http://pgrouting.postlbs.org/wiki/Workshop-CreateRoutingDatabase).
>
> The data, which i want to use for routing, I got from the
> Openstreetmap projekt. I wrote me a program, which parse the xml file
> and write the data in a database.
> My Table with the name "subways" was created with the following command:
>
> CREATE TABLE subways (ID integer , startNode integer REFERENCES
> nodes(ID), endNode integer REFERENCES nodes(ID), cost double
> precision, name char(40), x1 double precision, y1 double precision, x2
> double precision,y2 double precision, PRIMARY KEY(ID, startNode,
> endNode));
>
> And the table looks like that:
>
> id= way id
> name = name of the street
> startnode, endnode are the IDs of the nodes
> x1,y1 are the coordinates of the startnode
> x2,y2 are the coordinates of the endnodenode
> cost = length of the way
>
>  id   | startnode |  endnode  |         cost         |
>  name                   |    x1     |     y1     |    x2     |     y2
> -------+-----------+-----------+----------------------+------------------------------------------+-----------+------------+-----------+------------
>    0 |    140530 |    140555 |      8.5403091715829 |
>                         | 8.3889675 | 53.0587826 |   8.28445 |
> 53.1030248
>    2 | 206374638 |  26870008 |    0.320998562351643 |
>                         | 8.2145964 | 53.1430959 | 8.2168197 |
> 53.1405356
>    3 | 201754820 |  92909800 |    0.172230180241359 | Industriestraße
>                         | 8.1939216 | 53.1498095 | 8.1965042 |
> 53.1497966
>    5 |  26869963 | 165748872 |   0.0268226987132517 |
> Heiligengeistwall                        | 8.2087014 | 53.1412273 |
> 8.208876 | 53.1414446
>    6 | 165748872 |  26869964 |   0.0208274380181027 |
> Heiligengeistwall                        |  8.208876 | 53.1414446 |
> 8.2090004 | 53.1416164
>
>
>
> (In another Table named nodes, i have every Point-ID with coordinates)
> If I try now the routing function A-Star.....
>
>
> SELECT * FROM shortest_path_astar('SELECT id, startnode as source,
> endnode as target, cost, x1, y1, x2, y2 from subways', 31567898,
> 96012788, false, false);
>
>
> ... I get following error code:
>
>
> server closed the connection unexpectedly
>        This probably means the server terminated abnormally
>        before or while processing the request.
> The connection to the server was lost. Attempting reset: Succeeded.
>
>
>
> I hope you can help me, my system is:
>
> Gentoo Linux 64 Bit
> postgresql  8.0.15
> postgis 1.3.1
> pgrouting 1.02
>
>
> Best regards,
> Daniel
>