greenplum故障Crash recovery broadcast of the distributed transaction ‘Commit Prepared‘

起因:greemplum会话连接太多报错登录集群连接异常:too many clients already

过程:

1.无法登录数据库进行后台会话进程清理,清理进程后登陆数据库异常:

登录数据库异常提示:Crash recovery broadcast of the distributed transaction 'Commit Prepared' broadcast failed to one or more segments for  

查看日志信息:

2021-08-15 21:10:28 CST,367790046,con2746943,,seg-1,,,x367790046,sx1,"LOG","00000","DTM error (gathered 64 results from cmd 'Recovery Commit Prepared')","prepared transaction with identifier ""1627179994-0008480611"" is busy  (seg19 seg06:40003 pid=87221)",,,,,,0,,"cdbtm.c",2242

2021-08-15 21:10:28 CST,367790046,con2746943,,seg-1,,,x367790046,sx1,"FATAL","XX000","Crash recovery broadcast of the distributed transaction 'Commit Prepared' broadcast failed to one or more segments for gid = 1627179994-0008480611. (cdbtm.c:1123)",,,,,,,0,,"cdbtm.c",1123,"Stack trace:
1    0xb03bda postgres <symbol not found> (elog.c:502)
2    0xb05be8 postgres elog_finish (elog.c:1446)
3    0xcd2e44 postgres <symbol not found> (cdbtm.c:3237)
4    0xcd42cc postgres <symbol not found> (cdbtm.c:3349)
5    0xcd482d postgres initTM (cdbtm.c:1591)
6    0xb1c887 postgres InitPostgres (postinit.c:937)
7    0x9976a2 postgres PostgresMain (postgres.c:4380)
8    0x8f7abe postgres <symbol not found> (postmaster.c:665

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值