- 论坛徽章:
- 0
|
请大侠指教:
------------------------------------------------------
-bash-3.2$ psql -d edu_ngc -U ngc
psql (9.1.1)
Type "help" for help.
edu_ngc=# select * from test_rep
edu_ngc-# ;
a | b
---+---
(0 rows)
edu_ngc=# insert into test_rep values('1','1');
The connection to the server was lost. Attempting reset: Succeeded.
edu_ngc=# insert into test_rep values('1','1');
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.
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
edu_ngc=# insert into test_rep values('1','1');
The connection to the server was lost. Attempting reset: Failed.
!> \q
-bash-3.2$ vi logfile
LOG: redo starts at 0/6205C84
LOG: record with zero length at 0/6246434
LOG: redo done at 0/62463F8
LOG: last completed transaction was at log time 2012-03-01 17:06:23.320053+08
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
WARNING: type attribute "externallength" not recognized
WARNING: type attribute "externallength" not recognized
LOG: server process (PID 3601) was terminated by signal 11: Segmentation fault
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.
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted; last known up at 2012-03-01 17:11:32 CST
LOG: database system was not properly shut down; automatic recovery in progress
LOG: consistent recovery state reached at 0/6254AB8
LOG: redo starts at 0/6254AB8
LOG: record with zero length at 0/659A058
LOG: redo done at 0/659A01C
LOG: last completed transaction was at log time 2012-03-01 17:14:26.504769+08
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
LOG: server process (PID 3611) was terminated by signal 11: Segmentation fault
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.
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted; last known up at 2012-03-01 17:14:36 CST
LOG: database system was not properly shut down; automatic recovery in progress
FATAL: the database system is in recovery mode
LOG: consistent recovery state reached at 0/659A0A8
LOG: record with zero length at 0/659A0A8
LOG: redo is not required
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
|
|