Ole Wendland ole.wendland at werum.de
Tue Oct 26 03:12:28 PDT 2010
Hello,
I installed slony 2.0.4 and postgres 8.4 on Red Hat system and setup-up 
a Slony cluster with 3 nodes, lets call them n1,n2 and n3. Normal 
replication and switch over are working fine.
If the master n1 fails, then I do a failover on n2 and n3 and for them 
life go's on. My troubles starts if I try to reintegrate n1 as slave, on 
startup everything looks fine, than I subscribe him  new  for n2 which 
also looks fine.

"subscribe set ( id = 1, provider = 2, receiver = 1, forward = yes);"

  But when new set arrives at n1 I get following failure.

"select "_smv_ts_rep".setAddTable_int(1, 1, '"public"."role"', 
'role_pkey', 'role table'); " PGRES_FATAL_ERROR FEHLER:  Slony-I: 
setAddTable_int: table id 1 has already been assigned!"

A "REPAIR CONFIG ( SET ID = 1, EVENT NODE = 2);" had no effect on this 
issue.

I guess it is just a small thing which slipped my attention, but I'm 
very gratefully for every advise in this situation.

Greetings

Ole




More information about the Slony1-general mailing list