解决金仓数据库KingbaseES sys_dump报错“missing chunk number XXX for toast value”的问题

1.查看损坏坏块的sql语句

DO $$ 

DECLARE

rec record; 

BEGIN

FOR rec in  SELECT * FROM pg_statistic loop

raise notice 'Parameter is: %', rec.ctid;

raise notice 'Parameter is: %', rec; 

END LOOP; 

END;

$$

LANGUAGE plpgsgl;

2.查询 toast 表对应的源表

test=# select oid,reltoastrelid ,relname from sys_class where oid=2619;


 oid  | reltoastrelid |   relname
------+---------------+--------------
 2619 |          2840 | sys_statistic
(1 row)

3.解决：

delete from pg_statistic where ctid = '(40，7)' ;

reindex  table  sys_toast_2619;
reindex  table  sys_statistic;
vacuum  analyze   sys_statistic;