Postgresql "roll back the current transaction" 问题请教

niegc

请大侠指教：

------------------------------------------------------
-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

galylee

WARNING:  type attribute "externallength" not recognized
WARNING:  type attribute "externallength" not recognized
LOG:  server process (PID 3601) was terminated by signal 11: Segmentation fault

看起来是一个bug, 你的表的定义是咋样的。

zhanghb77

你是不是安装了一个扩展模块，该模块提供一个新的类型，那个扩展模块有bug，导致非法地址访问。

niegc

不是的，我是用slony进行数据复制，在Master 数据建了cluster之后才会出现这种情况，当我把master删掉之后就没有这种情况。

----------------------------------------------------------------------------------------------------

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.
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.
FATAL:  the database system is in recovery mode
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-02 17:06:29 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/BD52A40
LOG:  redo starts at 0/BD4CEBC
LOG:  record with zero length at 0/BD53600
LOG:  redo done at 0/BD535C4
LOG:  last completed transaction was at log time 2012-03-02 17:07:41.045273+08
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections

wang1352083

test_rep 的ddl语句贴出来.