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全量恢复,提示
请教下各位大佬们,谁遇到过这种情况,应该怎么处理?
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
