PostgreSQL exception 0xC0000005

Поиск
Список
Период
Сортировка
От Rawan AlSaad
Тема PostgreSQL exception 0xC0000005
Дата
Msg-id SNT119-W448C541AC460FC5611EA9B90C50@phx.gbl
обсуждение исходный текст
Ответы Re: PostgreSQL exception 0xC0000005  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgadmin-support
<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> 

В списке pgadmin-support по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: SQL Help going to EnterpriseDB site
Следующее
От: valgog
Дата:
Сообщение: Activity window of Server Status throws an error for PostgreSQL 8.2.1 server