免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 4393 | 回复: 4

Postgresql "roll back the current transaction" 问题请教 [复制链接]

论坛徽章:
0
发表于 2012-03-01 17:53 |显示全部楼层
请大侠指教:

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

论坛徽章:
0
发表于 2012-03-01 23:24 |显示全部楼层
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, 你的表的定义是咋样的。

论坛徽章:
0
发表于 2012-03-02 10:56 |显示全部楼层
你是不是安装了一个扩展模块,该模块提供一个新的类型,那个扩展模块有bug,导致非法地址访问。

论坛徽章:
0
发表于 2012-03-02 17:51 |显示全部楼层
不是的,我是用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

论坛徽章:
0
发表于 2012-03-19 22:09 |显示全部楼层
test_rep 的ddl语句贴出来.
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP