元数据缺少的问题
 
通知
清除全部

元数据缺少的问题  


dingxh
帖子: 1
初出茅庐
已加入: 2月 前

环境:gpdb5.8, 

在一次gprecoverseg -r 之后,出现部分metadata不一致的情况。

Sql执行显示如下错误

 

gpcheckcat显示如下错误

 

20201106:11:48:58:031300 gpcheckcat:pc-smqbgp01:gpadmin-[INFO]:-[FAIL] Checking for missing or extraneous entries for pg_appendonly

20201106:11:48:58:031300 gpcheckcat:pc-smqbgp01:gpadmin-[ERROR]:-  pg_appendonly has 38 issue(s)

 

20201106:11:49:10:031300 gpcheckcat:pc-smqbgp01:gpadmin-[INFO]:-[FAIL] Checking for missing or extraneous entries for pg_class

20201106:11:49:10:031300 gpcheckcat:pc-smqbgp01:gpadmin-[ERROR]:-  pg_class has 777 issue(s)

20201106:11:49:15:031300 gpcheckcat:pc-smqbgp01:gpadmin-[INFO]:-[FAIL] Checking for missing or extraneous entries for pg_depend

20201106:11:49:15:031300 gpcheckcat:pc-smqbgp01:gpadmin-[ERROR]:-  pg_depend has 632 issue(s)

… …

 

SUMMARY REPORT

===================================================================

Completed 16 test(s) on database 'jc_yyzlfx' at 2020-11-06 11:50:32 with elapsed time 0:02:02

Found a total of 951 issue(s)

 

以及大量(770)个左右的 元数据缺少的问题:

        Missing relation metadata for {'oid': 38696802} on content 19 (pc-smqbgp07:40003)

1 Reply
小青梅
帖子: 46
Admin
青梅少侠
已加入: 8月 前

这个问题比较复杂,很难三言两语解释清楚呢,需要登录到机器上看,如果您是商业用户,建议您联系售后,会有专人为您解决。

回复

关注微信公众号

Greenplum中文社区

Greenplum官方微信群

扫码加入我们的技术讨论,请备注“网站”