[postgis-users] Re: pgrouting and postgis

[Daniel Kastl]

Hi Daniel,

Maybe http://pgrouting.postlbs.org/discussion is the better place for
this question.
That kind of error happened in a previous version of pgRouting, and I
thought it has been solved.

I never tried pgRouting on Gentoo Linux, so it could be a distribution
issue. If something is wrong with the data, it would help you could try
it with another Linux distribution.
In that case you could file a bug report (tickets) on the pgRouting site
(you need to register an account for that) and we will try to solve the
problem?

Daniel

PS: if the data is not too large, could you send me some of your data
for testing?



Daniel W schrieb:
> 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
>>
>>     
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>