环境:gpdb5.8,
在一次gprecoverseg -r 之后,出现部分metadata不一致的情况。
Sql执行显示如下错误:
gpcheckcat显示如下错误
20201106031300 gpcheckcat-[FAIL] Checking for missing or extraneous entries for pg_appendonly
20201106031300 gpcheckcat- pg_appendonly has 38 issue(s)
20201106031300 gpcheckcat-[FAIL] Checking for missing or extraneous entries for pg_class
20201106031300 gpcheckcat- pg_class has 777 issue(s)
20201106031300 gpcheckcat-[FAIL] Checking for missing or extraneous entries for pg_depend
20201106031300 gpcheckcat- pg_depend has 632 issue(s)
… …
SUMMARY REPORT
===================================================================
Completed 16 test(s) on database 'jc_yyzlfx' at 2020-11-06 1132 with elapsed time 002
Found a total of 951 issue(s)
以及大量(770)个左右的 元数据缺少的问题:
Missing relation metadata for {'oid': 38696802} on content 19 (pc-smqbgp07:40003)