greenplum数据库无法启动 error: Do not have enough valid segments to start the array.

         greenplum数据库异常无法启动,启动报错error: Do not have enough valid segments to start the array.查看数据库日志报错FATAL","XX000","Global sequence number 20930983 less than maximum value 20930998 found in scan ('gp_persistent_relation_node') (cdbpersistentstore.c:600)"

启动报错信息如下:

20190327:00:29:14:014215 gpstart:mas:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait............
20190327:00:31:17:014215 gpstart:mas:gpadmin-[INFO]:-Process results...
20190327:00:31:17:014215 gpstart:mas:gpadmin-[ERROR]:-No segment started for content: 0.
20190327:00:31:17:014215 gpstart:mas:gpadmin-[INFO]:-dumping success segments: ['seg15:/data1/pg_system/mirror/gpseg53:content=53:dbid=135:mode=s:status=u', 'seg15:/data1/pg_system/mirror/gpseg52:content=52:dbid=134:mode=s:status=u', 'seg15:/data2/pg_system/primary/gpseg58:content=58:dbid=60:mode=s:status=u', 'seg15:/data2/pg_system/primary/gpseg59:content=59:dbid=61:mode=s:status=u', 'seg15:/data1/pg_system/primary/gpseg57:content=57:dbid=59:mode=s:status=u', 'seg15:/data1/pg_system/primary/gpseg56:content=56:dbid=58:mode=s:status=u', 'seg15:/data2/pg_system/mirror/gpseg54:content=54:dbid=136:mode=s:status=u', 'seg15:/data2/pg_system/mirror/gpseg55:content=55:dbid=137:mode=s:status=u', 'seg09:/data1/pg_system/mirror/gpseg28:content=28:dbid=110:mode=s:status=u', 'seg09:/data1/pg_system/mirror/gpseg29:content=29:dbid=111:mode=s:status=u', 'seg09:/data2/pg_system/mirror/gpseg30:content=30:dbid=112:mode=s:status=u', 'seg09:/data2/pg_system/mirror/gpseg31:content=31:dbid=113:mode=s:status=u', 'seg09:/data1/pg_system/primary/gpseg33:content=33:dbid=35:mode=s:status=u', 'seg09:/data1/pg_system/primary/gpseg32:content=32:dbid=34:mode=s:status=u', 'seg09:/data2/pg_system/primary/gpseg34:content=34:dbid=36:mode=s:status=u', 'seg09:/data2/pg_system/primary/gpseg35:content=35:dbid=37:mode=s:status=u', 'seg14:/data1/pg_system/mirror/gpseg48:content=48:dbid=130:mode=s:status=u', 'seg14:/data1/pg_system/mirror/gpseg49:content=49:dbid=131:mode=s:status=u', 'seg14:/data2/pg_system/primary/gpseg54:content=54:dbid=56:mode=s:status=u', 'seg14:/data2/pg_system/primary/gpseg55:content=55:dbid=57:mode=s:status=u', 'seg14:/data1/pg_system/primary/gpseg53:content=53:dbid=55:mode=s:status=u', 'seg14:/data1/pg_system/primary/gpseg52:content=52:dbid=54:mode=s:status=u', 'seg14:/data2/pg_system/mirror/gpseg50:content=50:dbid=132:mode=s:status=u', 'seg14:/data2/pg_system/mirror/gpseg51:content=51:dbid=133:mode=s:status=u', 'seg08:/data2/pg_system/mirror/gpseg27:content=27:dbid=109:mode=s:status=u', 'seg08:/data2/pg_system/mirror/gpseg26:content=26:dbid=108:mode=s:status=u', 'seg08:/data1/pg_system/mirror/gpseg24:content=24:dbid=106:mode=s:status=u', 'seg08:/data1/pg_system/mirror/gpseg25:content=25:dbid=107:mode=s:status=u', 'seg08:/data2/pg_system/primary/gpseg30:content=30:dbid=32:mode=s:status=u', 'seg08:/data2/pg_system/primary/gpseg31:content=31:dbid=33:mode=s:status=u', 'seg08:/data1/pg_system/primary/gpseg28:content=28:dbid=30:mode=s:status=u', 'seg08:/data1/pg_system/primary/gpseg29:content=29:dbid=31:mode=s:status=u', 'seg10:/data2/pg_system/mirror/gpseg34:content=34:dbid=116:mode=s:status=u', 'seg10:/data2/pg_system/mirror/gpseg35:content=35:dbid=117:mode=s:status=u', 'seg10:/data1/pg_system/primary/gpseg37:content=37:dbid=39:mode=s:status=u', 'seg10:/data1/pg_system/primary/gpseg36:content=36:dbid=38:mode=s:status=u', 'seg10:/data1/pg_system/mirror/gpseg33:content=33:dbid=115:mode=s:status=u', 'seg10:/data1/pg_system/mirror/gpseg32:content=32:dbid=114:mode=s:status=u', 'seg10:/data2/pg_system/primary/gpseg38:content=38:dbid=40:mode=s:status=u', 'seg10:/data2/pg_system/primary/gpseg39:content=39:dbid=41:mode=s:status=u', 'seg18:/data1/pg_system/pr

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值