Ok thank you guys, after really dropping the hole DB it worked. I really hoped that I could avoid the step, but this seemed to be an illusion.
Greetings Ole Am 26.10.2010 12:12, schrieb Ole Wendland: > 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 > > > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general -- Ole Wendland, Dipl.-Ing. (FH) M. Sc. Software Engineer CIS (Communication& Information Systems) Werum Software& Systems AG Wulf-Werum-Straße 3 | 21337 Lüneburg Tel. +49(0)4131/8900-393 | Fax +49(0)4131/8900-20 mailto:[email protected] | http://www.werum.de USt-ID-Nr. DE 116 083 850 | RG Lüneburg HRB 2262 Vorsitzender des Aufsichtsrats: Johannes Zimmermann Vorstand: Hartmut Krome, Rüdiger Schlierenkämper, Hans-Peter Subel _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
