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
------------
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
------------
thanks all.
regards.
___________________________________________________________
雅虎邮箱,您的终生邮箱!
http://cn.mail.yahoo.com/