Re: PostgreSQL exception 0xC0000005

Le 23/06/2010 09:00, Rawan AlSaad a écrit :
> [...]
> 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???
>

You should better ask on a PostGIS mailing list.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com