From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Rawan AlSaad <rawan(dot)alsaad(at)hotmail(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: PostgreSQL exception 0xC0000005 |
Date: | 2010-06-23 16:35:47 |
Message-ID: | 4C2237E3.1010901@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David Jarvis | 2010-06-25 08:25:35 | Bug: Overwrites incorrect file |
Previous Message | Dave Page | 2010-06-23 12:02:01 | Re: Activity window of Server Status throws an error for PostgreSQL 8.2.1 server |