Dear all,
I am having the following problem while using PostgreSQL 8.4 and PostGIS 1.5
when I run the following query:
SELECT * FROM shortest_path('SELECT id::int4, source::int4,
target::int4, cost from edges2',257180448,651912268, true, false);
The PostgreSQL server connection terminates and I am unable to reconnect to it
until I restart my PC.
The log file shows the following:
2010-06-22 21:13:48 ASTLOG: server process (PID 764) was terminated by
exception 0xC0000005
2010-06-22 21:13:48 ASTHINT: See C include file "ntstatus.h" for a description
of the hexadecimal value.
2010-06-22 21:13:48 ASTLOG: terminating any other active server processes
2010-06-22 21:13:48 ASTWARNING: terminating connection because of crash of
another server process
2010-06-22 21:13:48 ASTDETAIL: 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.
2010-06-22 21:13:48 ASTHINT: In a moment you should be able to reconnect to
the database and repeat your command.
2010-06-22 21:13:48 ASTWARNING: terminating connection because of crash of
another server process
2010-06-22 21:13:48 ASTDETAIL: 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.
2010-06-22 21:13:48 ASTHINT: In a moment you should be able to reconnect to
the database and repeat your command.
2010-06-22 21:13:48 ASTLOG: all server processes terminated; reinitializing
2010-06-22 21:13:58 ASTFATAL: pre-existing shared memory block is still in use
2010-06-22 21:13:58 ASTHINT: Check if there are any old server processes still
running, and terminate them.
Could anybody please help explaining for me what might be the cause for this
exception and how can I fix the problem???
Thanks,
Rawan
_________________________________________________________________
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
https://signup.live.com/signup.aspx?id=60969
