Обсуждение: PostgreSQL exception 0xC0000005

<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: 'Cambria','serif'; COLOR: #0070c0;
mso-ascii-theme-font:major-latin; mso-hansi-theme-font: major-latin"><font size="3">Dear all,</font></span><p
class="MsoNormal"style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: 'Cambria','serif'; COLOR: #0070c0;
mso-ascii-theme-font:major-latin; mso-hansi-theme-font: major-latin"><font size="3"> </font></span><p class="MsoNormal"
style="MARGIN:0in 0in 0pt"><span style="FONT-FAMILY: 'Cambria','serif'; COLOR: #0070c0; mso-ascii-theme-font:
major-latin;mso-hansi-theme-font: major-latin"><font size="3">I am having the following problem while using PostgreSQL
8.4and PostGIS 1.5 when I run the following query:</font></span><p class="MsoNormal" style="MARGIN: 0in 0in 0pt;
mso-layout-grid-align:none"><span style="FONT-FAMILY: 'Cambria','serif'; COLOR: #0070c0; mso-ascii-theme-font:
major-latin;mso-hansi-theme-font: major-latin; mso-bidi-font-family: 'Courier New'"><font size="3">SELECT * FROM
shortest_path('SELECTid::int4, source::int4, </font></span><p class="MsoNormal" style="MARGIN: 0in 0in 0pt;
mso-layout-grid-align:none"><span style="FONT-FAMILY: 'Cambria','serif'; COLOR: #0070c0; mso-ascii-theme-font:
major-latin;mso-hansi-theme-font: major-latin; mso-bidi-font-family: 'Courier New'"><font size="3"><span
style="mso-spacerun:yes">  </span>target::int4, cost from edges2',257180448,651912268, true, false);</font></span><p
class="MsoNormal"style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><span style="FONT-FAMILY: 'Cambria','serif';
COLOR:#0070c0; mso-ascii-theme-font: major-latin; mso-hansi-theme-font: major-latin; mso-bidi-font-family: 'Courier
New'"><fontsize="3"> </font></span><p class="MsoNormal" style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><font
size="3"><spanstyle="FONT-FAMILY: 'Cambria','serif'; COLOR: #0070c0; mso-ascii-theme-font: major-latin;
mso-hansi-theme-font:major-latin; mso-bidi-font-family: 'Courier New'">The PostgreSQL server connection terminates and
Iam unable to reconnect to it until I restart my PC.</span><span style="FONT-FAMILY: 'Cambria','serif';
mso-ascii-theme-font:major-latin; mso-hansi-theme-font: major-latin; mso-bidi-font-family: 'Courier
New'"></span></font><pclass="MsoNormal" style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><span
style="FONT-FAMILY:'Cambria','serif'; mso-ascii-theme-font: major-latin; mso-hansi-theme-font: major-latin;
mso-bidi-font-family:'Courier New'"><font size="3"> </font></span><p class="MsoNormal" style="MARGIN: 0in 0in 0pt;
mso-layout-grid-align:none"><span style="FONT-FAMILY: 'Cambria','serif'; COLOR: #0070c0; mso-ascii-theme-font:
major-latin;mso-hansi-theme-font: major-latin; mso-bidi-font-family: 'Courier New'"><font size="3">The log file shows
thefollowing:</font></span><p class="MsoNormal" style="MARGIN: 0in 0in 0pt; mso-layout-grid-align: none"><span
style="FONT-FAMILY:'Cambria','serif'; mso-ascii-theme-font: major-latin; mso-hansi-theme-font: major-latin;
mso-bidi-font-family:'Courier New'"><font size="3"> </font></span><p class="MsoNormal" style="MARGIN: 0in 0in
0pt"><spanstyle="FONT-FAMILY: 'Cambria','serif'; mso-ascii-theme-font: major-latin; mso-hansi-theme-font:
major-latin"><fontsize="3">2010-06-22 21:13:48 ASTLOG:<span style="mso-spacerun: yes">  </span>server process (PID 764)
wasterminated by <b><span style="COLOR: red">exception 0xC0000005</span></b></font></span><p class="MsoNormal"
style="MARGIN:0in 0in 0pt"><span style="FONT-FAMILY: 'Cambria','serif'; mso-ascii-theme-font: major-latin;
mso-hansi-theme-font:major-latin"><font size="3">2010-06-22 21:13:48 ASTHINT:<span style="mso-spacerun: yes"> 
</span>SeeC include file "ntstatus.h" for a description of the hexadecimal value.</font></span><p class="MsoNormal"
style="MARGIN:0in 0in 0pt"><span style="FONT-FAMILY: 'Cambria','serif'; mso-ascii-theme-font: major-latin;
mso-hansi-theme-font:major-latin"><font size="3">2010-06-22 21:13:48 ASTLOG:<span style="mso-spacerun: yes"> 
</span>terminatingany other active server processes</font></span><p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span
style="FONT-FAMILY:'Cambria','serif'; mso-ascii-theme-font: major-latin; mso-hansi-theme-font: major-latin"><font
size="3">2010-06-2221:13:48 ASTWARNING:<span style="mso-spacerun: yes">  </span>terminating connection because of crash
ofanother server process</font></span><p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY:
'Cambria','serif';mso-ascii-theme-font: major-latin; mso-hansi-theme-font: major-latin"><font size="3">2010-06-22
21:13:48ASTDETAIL:<span style="mso-spacerun: yes">  </span>The postmaster has commanded this server process to roll
backthe current transaction and exit, because another server process exited abnormally and possibly corrupted shared
memory.</font></span><pclass="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: 'Cambria','serif';
mso-ascii-theme-font:major-latin; mso-hansi-theme-font: major-latin"><font size="3">2010-06-22 21:13:48 ASTHINT:<span
style="mso-spacerun:yes">  </span>In a moment you should be able to reconnect to the database and repeat your
command.</font></span><pclass="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: 'Cambria','serif';
mso-ascii-theme-font:major-latin; mso-hansi-theme-font: major-latin"><font size="3">2010-06-22 21:13:48
ASTWARNING:<spanstyle="mso-spacerun: yes">  </span>terminating connection because of crash of another server
process</font></span><pclass="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: 'Cambria','serif';
mso-ascii-theme-font:major-latin; mso-hansi-theme-font: major-latin"><font size="3">2010-06-22 21:13:48 ASTDETAIL:<span
style="mso-spacerun:yes">  </span>The postmaster has commanded this server process to roll back the current transaction
andexit, because another server process exited abnormally and possibly corrupted shared memory.</font></span><p
class="MsoNormal"style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: 'Cambria','serif'; mso-ascii-theme-font:
major-latin;mso-hansi-theme-font: major-latin"><font size="3">2010-06-22 21:13:48 ASTHINT:<span style="mso-spacerun:
yes"> </span>In a moment you should be able to reconnect to the database and repeat your command.</font></span><p
class="MsoNormal"style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: 'Cambria','serif'; mso-ascii-theme-font:
major-latin;mso-hansi-theme-font: major-latin"><font size="3">2010-06-22 21:13:48 ASTLOG:<span style="mso-spacerun:
yes"> </span>all server processes terminated; reinitializing</font></span><p class="MsoNormal" style="MARGIN: 0in 0in
0pt"><spanstyle="FONT-FAMILY: 'Cambria','serif'; mso-ascii-theme-font: major-latin; mso-hansi-theme-font:
major-latin"><fontsize="3">2010-06-22 21:13:58 ASTFATAL:<span style="mso-spacerun: yes">  </span>pre-existing shared
memoryblock is still in use</font></span><p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY:
'Cambria','serif';mso-ascii-theme-font: major-latin; mso-hansi-theme-font: major-latin"><font size="3">2010-06-22
21:13:58ASTHINT:<span style="mso-spacerun: yes">  </span>Check if there are any old server processes still running, and
terminatethem.</font></span><p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY:
'Cambria','serif';mso-ascii-theme-font: major-latin; mso-hansi-theme-font: major-latin"><font
size="3"> </font></span><pclass="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: 'Cambria','serif';
mso-ascii-theme-font:major-latin; mso-hansi-theme-font: major-latin"><font size="3"> </font></span><p class="MsoNormal"
style="MARGIN:0in 0in 0pt"><span style="FONT-FAMILY: 'Cambria','serif'; COLOR: #0070c0; mso-ascii-theme-font:
major-latin;mso-hansi-theme-font: major-latin"><font size="3">Could anybody please help explaining for me what might be
thecause for this exception and how can I fix the problem???</font></span><p class="MsoNormal" style="MARGIN: 0in 0in
0pt"><spanstyle="FONT-FAMILY: 'Cambria','serif'; COLOR: #0070c0; mso-ascii-theme-font: major-latin;
mso-hansi-theme-font:major-latin"><font size="3"> </font></span><p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span
style="FONT-FAMILY:'Cambria','serif'; COLOR: #0070c0; mso-ascii-theme-font: major-latin; mso-hansi-theme-font:
major-latin"><fontsize="3">Thanks,</font></span><p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span
style="FONT-FAMILY:'Cambria','serif'; COLOR: #0070c0; mso-ascii-theme-font: major-latin; mso-hansi-theme-font:
major-latin"><fontsize="3">Rawan</font></span><p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span
style="FONT-FAMILY:'Cambria','serif'; mso-ascii-theme-font: major-latin; mso-hansi-theme-font: major-latin"><font
size="3"> </font></span><br/><hr />Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. <a
href="https://signup.live.com/signup.aspx?id=60969"target="_new">Sign up now.</a> 

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.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com