Recovery (bring GPDB up) from "FATAL:Global sequence number 1131954 less than maximum value 1131958
来源:互联网 发布:c语言编译器用什么编 编辑:程序博客网 时间:2024/05/21 19:34
"Recovery (bring GPDB up) from "FATAL:Global sequence number 1131954 less than maximum value 1131958 found in scan ('gp_persistent_relation_node')""
GPDB is down due to crash recovery failure with the following error message:
2012-03-06 02:35:30.275573 CST,,,p20291,th-101075200,,,,0,,,seg-1,,,,,"FATAL","XX000","Global sequence number 1131954 less than maxi
mum value 1131958 found in scan ('gp_persistent_relation_node')(cdbpersistentstore.c:487)",,,,,,,0,,"cdbpersistentstore.c",487,"Sta
ck trace:
1 0xa3338a postgres <symbol not found> (elog.c:454)
2 0xa350f8 postgres elog_finish (elog.c:1365)
3 0xb7ad2e postgres PersistentStore_InitScanUnderLock (cdbpersistentstore.c:487)
4 0xb6587e postgres PersistentFileSysObj_StartupInitScan (cdbpersistentfilesysobj.c:642)
5 0x508775 postgres StartupXLOG (xlog.c:6891)
6 0x510aed postgres StartupProcessMain (xlog.c:10341)
7 0x584d05 postgres AuxiliaryProcessMain (bootstrap.c:452)
8 0x84b774 postgres <symbol not found> (postmaster.c:7062)
9 0x84b95a postgres StartMasterOrPrimaryPostmasterProcesses (postmaster.c:1558)
10 0x85af20 postgres doRequestedPrimaryMirrorModeTransitions (primary_mirror_mode.c:1631)
11 0x8560e0 postgres PostmasterMain (postmaster.c:2108)
12 0x76530a postgres main (main.c:212)
13 0x7f7cf8649bc6 libc.so.6 __libc_start_main (??:0)
14 0x475089 postgres <symbol not found> (??:0)
A solution exists for this issue, but intervention from EMC technical support personnel is required. Contact the EMC Customer Support Center, or your service representative for technical assistance and quote this solution ID (emc293101).
Before taking any action, please contact the experienced or senior Greenplum support engineer to assist you in implementing the fix.
A new GUC "gp_persistent_repair_global_sequence" has been introduced to use the scanned maximum value as the current global sequence number. As a result, the GPDB is brought up. No catalog inconsistency is introduced with the recovery procedure.
Set this parameter on every segment that experiences this error:
gp_crash_recovery_abort_suppress_fatal=on
Immediately after starting the database, it is strongly advised to run gpcheckcat to find and fix the inconsistency. Please look for assistance in interpreting and fixing the issues reported in the gpcheckcat output.
GPDB is down due to crash recovery failure with the following error message:
2012-03-06 02:35:30.275573 CST,,,p20291,th-101075200,,,,0,,,seg-1,,,,,"FATAL","XX000","Global sequence number 1131954 less than maxi
mum value 1131958 found in scan ('gp_persistent_relation_node')(cdbpersistentstore.c:487)",,,,,,,0,,"cdbpersistentstore.c",487,"Sta
ck trace:
1 0xa3338a postgres <symbol not found> (elog.c:454)
2 0xa350f8 postgres elog_finish (elog.c:1365)
3 0xb7ad2e postgres PersistentStore_InitScanUnderLock (cdbpersistentstore.c:487)
4 0xb6587e postgres PersistentFileSysObj_StartupInitScan (cdbpersistentfilesysobj.c:642)
5 0x508775 postgres StartupXLOG (xlog.c:6891)
6 0x510aed postgres StartupProcessMain (xlog.c:10341)
7 0x584d05 postgres AuxiliaryProcessMain (bootstrap.c:452)
8 0x84b774 postgres <symbol not found> (postmaster.c:7062)
9 0x84b95a postgres StartMasterOrPrimaryPostmasterProcesses (postmaster.c:1558)
10 0x85af20 postgres doRequestedPrimaryMirrorModeTransitions (primary_mirror_mode.c:1631)
11 0x8560e0 postgres PostmasterMain (postmaster.c:2108)
12 0x76530a postgres main (main.c:212)
13 0x7f7cf8649bc6 libc.so.6 __libc_start_main (??:0)
14 0x475089 postgres <symbol not found> (??:0)
A solution exists for this issue, but intervention from EMC technical support personnel is required. Contact the EMC Customer Support Center, or your service representative for technical assistance and quote this solution ID (emc293101).
Before taking any action, please contact the experienced or senior Greenplum support engineer to assist you in implementing the fix.
A new GUC "gp_persistent_repair_global_sequence" has been introduced to use the scanned maximum value as the current global sequence number. As a result, the GPDB is brought up. No catalog inconsistency is introduced with the recovery procedure.
Set this parameter on every segment that experiences this error:
gp_crash_recovery_abort_suppress_fatal=on
Immediately after starting the database, it is strongly advised to run gpcheckcat to find and fix the inconsistency. Please look for assistance in interpreting and fixing the issues reported in the gpcheckcat output.
0 0
- Recovery (bring GPDB up) from "FATAL:Global sequence number 1131954 less than maximum value 1131958
- Bring up lab --from Leo Li
- Bring Up
- Bring Up
- From now on,I will bring up my sprit!
- XDMCP fatal error: Session declined Maximum number of open sessions from your host reached
- svn: E210004: Number is larger than maximum
- svn: Number is larger than maximum
- svn: E210004: Number is larger than maximum
- Basic Bring up(2)-Bring Up
- Get prime numbers nearby a number less than 10^10
- The number of points is less than required for feature
- The number of points is less than required for feature
- Getting Perfect Number Less than 10000 With C++
- Android System Bring Up
- android 4.0 bring up
- Android camera bring up
- bring up LCD
- Qt在Windows下的三种编程环境搭建
- 关于Duilib的扩展——“拖放”实现(一)
- 第八章思维导图
- 基于Qt的画板程序编写
- java代码两个数组的并运算
- Recovery (bring GPDB up) from "FATAL:Global sequence number 1131954 less than maximum value 1131958
- 关于ORA-1658错误和用户表空间配额
- 〈数据结构〉课程设计综合题目 (题目一部分调试展示)
- 学生管理系统
- Why Database-to-Hadoop Connectors are Fundamentally Flawed and Entirely Unnecessary
- VS2013 MFC使用opencv3.0显示图片
- 仿射组合的几何形状
- 表空间配额和UNLIMITED TABLESPACE权限
- 初等矩阵左乘右乘 影响 矩阵 行列 变换