xlog 过大占满磁盘，使用 pg_resetxlog 清除后无法启动 gp

愤世嫉俗的胖子 2022-04-07 13:22:48

gp 的 xlog 过大，磁盘占满，使用 https://www.cnblogs.com/qiannianyuan/p/pg_resetxlog.html 帖子清除 xlog 后无法启动 gp。报错：

20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Starting gpstart with args:
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Gathering information and validating the environment...
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 6.12.1 build commit:7ec4678f29dd922d7d44501f5fc344b5d0d4d49f Open Source'
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Greenplum Catalog Version: '301908232'
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Starting Master instance in admin mode
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Obtaining Segment details from master...
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Setting new master era
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Master Started...
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Shutting down master
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[WARNING]:-Skipping startup of segment marked down in configuration: on gpsegment1 directory /usr/local/gp/data/gp/gp1/gpseg0 <<<<<
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[WARNING]:-Skipping startup of segment marked down in configuration: on gpsegment1 directory /usr/local/gp/data/gp/gp2/gpseg1 <<<<<
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:---------------------------
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Master instance parameters
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:---------------------------
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Database = template1
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Master Port = 5432
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Master directory = /usr/local/gp/data/gp/master/gpseg-1
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Timeout = 600 seconds
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Master standby start = On
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:---------------------------------------
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:-Segment instances that will be started
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:---------------------------------------
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:- Host Datadir Port Role
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:- gpsegment2 /usr/local/gp/data/gp/gpm1/gpseg0 7000 Primary
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:- gpsegment2 /usr/local/gp/data/gp/gpm2/gpseg1 7001 Primary
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:- gpsegment2 /usr/local/gp/data/gp/gp1/gpseg2 6000 Primary
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:- gpsegment1 /usr/local/gp/data/gp/gpm1/gpseg2 7000 Mirror
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:- gpsegment2 /usr/local/gp/data/gp/gp2/gpseg3 6001 Primary
20220407:13:22:16:604167 gpstart:gpmaster:gpadmin-[INFO]:- gpsegment1 /usr/local/gp/data/gp/gpm2/gpseg3 7001 Mirror

Continue with Greenplum instance startup Yy|Nn (default=N):
> y
20220407:13:22:21:604167 gpstart:gpmaster:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait...
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[INFO]:-Process results...
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[ERROR]:-No segment started for content: 0.
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[INFO]:-dumping success segments: ['gpsegment1:/usr/local/gp/data/gp/gpm2/gpseg3:content=3:dbid=9:role=m:preferred_role=m:mode=s:status=u', 'gpsegment1:/usr/local/gp/data/gp/gpm1/gpseg2:content=2:dbid=8:role=m:preferred_role=m:mode=s:status=u', 'gpsegment2:/usr/local/gp/data/gp/gp1/gpseg2:content=2:dbid=4:role=p:preferred_role=p:mode=s:status=u', 'gpsegment2:/usr/local/gp/data/gp/gp2/gpseg3:content=3:dbid=5:role=p:preferred_role=p:mode=s:status=u']
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[INFO]:-DBID:7 FAILED host:'gpsegment2' datadir:'/usr/local/gp/data/gp/gpm2/gpseg1' with reason:'PG_CTL failed.'
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[INFO]:-DBID:6 FAILED host:'gpsegment2' datadir:'/usr/local/gp/data/gp/gpm1/gpseg0' with reason:'PG_CTL failed.'
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[INFO]:-----------------------------------------------------

20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[INFO]:- Successful segment starts = 4
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[WARNING]:-Failed segment starts = 2 <<<<<<<<
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[WARNING]:-Skipped segment starts (segments are marked down in configuration) = 2 <<<<<<<<
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[INFO]:-Successfully started 4 of 6 segment instances, skipped 2 other segments <<<<<<<<
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[WARNING]:-Segment instance startup failures reported
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[WARNING]:-Failed start 2 of 6 segment instances <<<<<<<<
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[WARNING]:-Review /home/gpadmin/gpAdminLogs/gpstart_20220407.log
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[INFO]:-----------------------------------------------------
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[WARNING]:-****************************************************************************
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[WARNING]:-There are 2 segment(s) marked down in the database
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[WARNING]:-To recover from this current state, review usage of the gprecoverseg
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[WARNING]:-management utility which will recover failed segment instance databases.
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[WARNING]:-****************************************************************************
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait...
20220407:13:22:22:604167 gpstart:gpmaster:gpadmin-[ERROR]:-gpstart error: Do not have enough valid segments to start the array.