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