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

最新推荐文章于 2023-06-10 21:42:42 发布

白家二公子

最新推荐文章于 2023-06-10 21:42:42 发布

阅读量593

点赞数

分类专栏：数据库 greenplum 文章标签： postgresql 数据库

本文链接：https://blog.youkuaiyun.com/Jun_ming/article/details/120115582

版权

起因：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