Greenplum segment级问题的排查

咖啡机常见问题：电源问题排查 #生活技巧# #居家生活技巧# #电器维修技巧# #咖啡机使用教程#

标签

PostgreSQL , Greenplum , segment , utility

背景

有些时候，我们在使用Greenplum时，你会发现明明连接数是够的，但是报错的时候segment连接满无法正确连接，因为对外的接口都是MASTER，如果发现这里问题如何排查？

00000 LOG: Failed connection to seg0

00000 STATEMENT: INSERT INTO gps_track(

58M01 LOG: (58M01) Master unable to connect to seg0 with options : FATAL: Sorry, too many clients already

58M01 STATEMENT: INSERT INTO gps_track(

00000 LOG: Failed connection to seg1

00000 STATEMENT: INSERT INTO gps_track(

58M01 LOG: (58M01) Master unable to connect to seg1 with options : FATAL: Sorry, too many clients already

58M01 STATEMENT: INSERT INTO gps_track(

00000 LOG: The previous session was reset because its gang was disconnected (session id = 318465). The new session id = 318471

00000 STATEMENT: INSERT INTO gps_track(

00000 LOG: FTS rescanned, get new component databases info.

00000 STATEMENT: INSERT INTO gps_track(

00000 LOG: Failed connection to seg0

00000 STATEMENT: INSERT INTO gps_track(

58M01 LOG: (58M01) Master unable to connect to seg0 with options : FATAL: Sorry, too many clients already

58M01 STATEMENT: INSERT INTO gps_track(

00000 LOG: Failed connection to seg1

00000 STATEMENT: INSERT INTO gps_track(

58M01 LOG: (58M01) Master unable to connect to seg1 with options : FATAL: Sorry, too many clients already

58M01 STATEMENT: INSERT INTO gps_track(

00000 LOG: The previous session was reset because its gang was disconnected (session id = 318471). The new session id = 318482

00000 STATEMENT: INSERT INTO gps_track(

00000 LOG: no primary segworker group allocated

00000 STATEMENT: INSERT INTO gps_track(

XX000 ERROR: (XX000) Unexpected internal error (cdbgang.c:1636)

XX000 LOCATION: allocateWriterGang, cdbgang.c:1636

XX000 STATEMENT: INSERT INTO gps_track(

XX000 Traceback 0: postgres: port INSERT() [0x9099af]

XX000 Traceback 1: postgres: port INSERT(elog_internalerror+0x20) [0x90cdc0]

XX000

网址：Greenplum segment级问题的排查 https://www.yuejiaxmz.com/news/view/222264

相关内容

家庭电源闪停问题排查与解决建议
家居空调维修攻略：预防措施与问题排查建议
关于生活中节能减排知识的调查问卷 投票结果
【HBZ分享】Kafka中日志清理策略
民主生活会对照检查及问题自查通用材料.doc
幼儿园班级安全隐患排查报告（精选13篇）
oracle 清理lob set (lob字段)='n',ORACLE数据库使用的常见问题（三）
居民投资理财的现状问题调查研究
[三年级数学]生活中的搭配问题
排队中最短时间问题

随便看看