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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general