Greenplum新建的mirror无法启动-问答-阿里云开发者社区-阿里云

开发者社区> 问答> 正文

Greenplum新建的mirror无法启动

永远的SSS 2019-06-26 14:48:56 1314

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全量恢复,提示

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

关系型数据库 C语言 PostgreSQL
分享到
取消 提交回答
全部回答(0)
数据库
使用钉钉扫一扫加入圈子
+ 订阅

分享数据库前沿,解构实战干货,推动数据库技术变革

推荐文章
相似问题