Pivotal Knowledge Base

Follow

Vacuum error: "file seginfo for AO relation xxx (segno=1) is missing (appendonly_compaction.c:622)"

Environment

Pivotal Greenplum: 4.3.x

OS: RHEL 6.x

Symptom

Vacuum freezes on certain tables and returns an error 

file seginfo for AO relation xxxx 1663/xxx/xxx (segno=1) is missing (appendonly_compaction.c:622) 

Although, select/copy are being completed.

Resolution

Either re-distribute or re-create the table to resolve this issue

alter table “table_name" set with (reorganize =false) distributed randomly;
alter table "table_name" set with (reorganize =true) distributed by ("distribute_key"); 

Additional Information

For health check, we can generate a script to run vacuum against all user tables

select 'vacuum '||schemaname||'.'||tablename||';' from pg_tables where schemaname not in 
('pg_catalog','gp_toolkit','information_schema') and tablename not like '%_1_prt%';

Comments

Powered by Zendesk