greenplum集群节点主机宕机恢复异常persistent serial number 28603383, TID (20,45))“,,0,,“xact.c“,1780,“Stack trace

背景:生产环境greenplum集群(greenplum 4.3.8)数据节点seg12主机上4个mirror及seg13主机上4个mirror实例(对应primary在seg12)发生异常(down),mirror实例宕机后短时间内seg12主机发生异常宕机(此时seg13上已经异常的4个实例对应4个primary主机宕机,即有4个实例对应主备均异常),集群无完整的数据副本已无法进行正常提供服务执行sql报错。此时集群8个mirror异常4个primary异常。

过程:紧急联系机房进行宕机主机恢复,主机未发现硬件类故障,正常开机。

1.执行gprecoverseg因存在4个实例主备均异常故无法进行恢复。

2.尝试gpstop -M fast停止集群进行,进行重启。集群停止后进行启动失败:

ERROR:-gpstart error: Do not have enough valid segments to start the array

3.查看启动异常实例日志

2021-09-28 18:23:13.605756 CST,,,p21903,th-1181391072,,,,0,,,seg-1,,,,,"LOG","00000","database system was not properly shut down; automatic recovery in progr

ess",,,,,,,0,,"xlog.c",6721,

2021-09-28 18:23:13.625746 CST,,,p21903,th-1181391072,,,,0,,,seg-1,,,,,"LOG","00000","redo starts at 2379/10E603E8",,,,,,,0,,"xlog.c",6853,

2021-09-28 18:23:13.949767 CST,,,p21903,th-1181391072,,,,0,,,seg-1,,,,,"LOG","00000","unexpected pageaddr 2378/C7418000 in log file 9081, segment 4, offset 5

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值