Skip to main content

Posts

Showing posts with the label updatereloid slony

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