Skip site navigation (1) Skip section navigation (2)

why my postgresql auto crashed???

From: 赵 熠 <zhao_yi707(at)yahoo(dot)com(dot)cn>
To: pgsql-general(at)postgresql(dot)org
Subject: why my postgresql auto crashed???
Date: 2008-07-27 13:57:19
Message-ID: 131263.64839.qm@web15301.mail.cnb.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
hi, all
when I do the command from a sql file by psql client,
I got the message:
----
psql:/home/zhay/insert.sql:8: server closed the
connection unexpectedly
        This probably means the server terminated
abnormally
        before or while processing the request.
psql:/home/zhay/insert.sql:8: connection to server was
lost
----
my sql file is :
set search_path to lives;

insert into store_all select c.*, z.t from  (
        select b.*, y.t from (
                select a.*,  x.t from store a 
                        left join (select pid,
array_to_string(array_accum(anchor), ' ') as t
from recommend group by pid)x on x.pid = a.id
        )b left join (select pid,
array_to_string(array_accum(anchor), ' ') as
t from tag group by pid)y on y.pid = b.id
)c left join (select pid,
array_to_string(array_accum(anchor), ' ') as t
from categorie group by pid)z on z.pid = c.id;



so, I check the pg_log
-&#65279;----&#65279;-------
LOG:  server process (PID 4121) was terminated by
signal 6: Aborted
LOG:  terminating any other active server processes
WARNING:  terminating connection because of crash of
another server
process
DETAIL:  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.
HINT:  In a moment you should be able to reconnect to
the database and
repeat your command.
WARNING:  terminating connection because of crash of
another server
process
DETAIL:  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.
HINT:  In a moment you should be able to reconnect to
the database and
repeat your command.
WARNING:  terminating connection because of crash of
another server
process
DETAIL:  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.
HINT:  In a moment you should be able to reconnect to
the database and
repeat your command.
WARNING:  terminating connection because of crash of
another server
process
DETAIL:  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.
HINT:  In a moment you should be able to reconnect to
the database and
repeat your command.
WARNING:  terminating connection because of crash of
another server
process
DETAIL:  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.
HINT:  In a moment you should be able to reconnect to
the database and
repeat your command.
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted; last known up
at 2008-07-27
07:36:16 UTC
LOG:  database system was not properly shut down;
automatic recovery in
progress
FATAL:  the database system is in recovery mode
LOG:  redo starts at D/3FB00BC0
LOG:  record with zero length at D/3FB59898
LOG:  redo done at D/3FB59868
LOG:  last completed transaction was at log time
2008-07-27
07:40:53.70866+00
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections
----&#65279;----&#65279;----

thanks all.

regards.



      ___________________________________________________________ 
 雅虎邮箱,您的终生邮箱! 
http://cn.mail.yahoo.com/

pgsql-general by date

Next:From: dfxDate: 2008-07-27 17:36:57
Subject: How to get the real postgreql error from visual basic
Previous:From: 赵 熠Date: 2008-07-27 13:57:11
Subject: why my postgresql auto crashed???

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group