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