FATAL slon_node_health_check() returned false - fatal health problem!

Hi ,


If you are getting the above error in Slony(It's new feature in Slony 2.1 which checks the slony catalogs), then try to execute the below query.

select tab_id, tab_relname, tab_nspname,tab_set from  "_Slonyschema".sl_table t where not exists (select 1 from pg_catalog.pg_class c, pg_catalog.pg_namespace n where c.oid = t.tab_reloid and c.relname = t.tab_relname and c.relnamespace = n.oid and n.nspname = t.tab_nspname)

If gives any entries then use the following function to fix the Slony catalogs.

Select _Slonyschema.updatereloid(<SETID>,<NODEID>);

(OR)


Use REPAIR CONFIG SLONIK

REPAIR CONFIG (
  SET ID = 1,
  EVENT NODE = 2
);

--Dinesh