Greenplum segment级问题的排查 - gp_session_role=utility (含csvlog日志格式解读)

标签

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