开发者社区> 问答> 正文

Greenplum新建的mirror无法启动

Greenplum在部署的时候没创建mirror,是后来加进去的.添加成功后,发现2个mirror无法启动,如新:

[gpadmin@gpm ~]$ gpstate -m
20190626:14:27:13:031156 gpstate:gpm:gpadmin-[INFO]:-Starting gpstate with args: -m
20190626:14:27:13:031156 gpstate:gpm:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.3.9.0 build 1'
20190626:14:27:13:031156 gpstate:gpm:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.3.9.0 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Aug 8 2016 05:36:26'
20190626:14:27:13:031156 gpstate:gpm:gpadmin-[INFO]:-Obtaining Segment details from master...
20190626:14:27:13:031156 gpstate:gpm:gpadmin-[INFO]:--------------------------------------------------------------
20190626:14:27:13:031156 gpstate:gpm:gpadmin-[INFO]:--Current GPDB mirror list and status
20190626:14:27:13:031156 gpstate:gpm:gpadmin-[INFO]:--Type = Group
20190626:14:27:13:031156 gpstate:gpm:gpadmin-[INFO]:--------------------------------------------------------------
20190626:14:27:13:031156 gpstate:gpm:gpadmin-[INFO]:- Mirror Datadir Port Status Data Status
20190626:14:27:13:031156 gpstate:gpm:gpadmin-[WARNING]:-gpseg2 /home/gpadmin/gpdata/gpdatam1/gpseg0 41000 Failed <<<<<<<<
20190626:14:27:13:031156 gpstate:gpm:gpadmin-[WARNING]:-gpseg2 /home/gpadmin/gpdata/gpdatam1/gpseg1 41001 Failed <<<<<<<<
20190626:14:27:13:031156 gpstate:gpm:gpadmin-[INFO]:- gpseg1 /home/gpadmin/gpdata/gpdatam1/gpseg2 41000 Passive Synchronized
20190626:14:27:13:031156 gpstate:gpm:gpadmin-[INFO]:- gpseg1 /home/gpadmin/gpdata/gpdatam1/gpseg3 41001 Passive Synchronized
20190626:14:27:13:031156 gpstate:gpm:gpadmin-[INFO]:--------------------------------------------------------------

20190626:14:27:13:031156 gpstate:gpm:gpadmin-[WARNING]:-2 segment(s) configured as mirror(s) have failed

然后用gprecoverseg -F全量恢复,提示

请教下各位大佬们,谁遇到过这种情况,应该怎么处理?

展开
收起
永远的SSS 2019-06-26 14:48:56 3374 0
0 条回答
写回答
取消 提交回答
问答排行榜
最热
最新

相关电子书

更多
PostgresChina2018_董红禹_SQL_Server迁移PG经验分享 立即下载
MongoShake -- Multi Active-Active and Cross-Region Disaster Recoverable MongoDB Service 立即下载
阿里云PostgreSQL、PPAS、HDB for PG生 立即下载