Mon Aug 4 01:34:30 PDT 2008
- Previous message: [Slony1-general] how to determine if the slave is caught up/insync with the master
- Next message: [Slony1-general] REPAIR CONFIG function
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Stéphane A. Schildknecht a écrit : > Hi, > > Slony 1.2.13, PG 8.2.{7|9} > > I'm facing a really strange and annoying situation. > > After having unsubscribed a node (72) from replication of set 1 (issuing the > command "select _slonrep.unsubscribeset(1,72);" on node 72), I am trying to > resubscribe it to the set by issuing the command "select > _slonrep.subscribeset(1,71,72,'t');" on node 71. > > Trouble is averything seems to go well to a certain extent... Indeed, > subscription is done for tables, data are copied, but then I get the following > message : > > 2008-07-30 11:05:13 CEST ERROR remoteWorkerThread_1: "select > "_slonturf".setAddSequence_int(1, 2, '"public"."some_seq"', 'sequence > public.some_seq')" PGRES_FATAL_ERROR ERREUR: Slony-I: setAddSequence_int(): > sequence ID 2 has already been assigned > 2008-07-30 11:05:13 CEST WARN remoteWorkerThread_1: data copy for set 1 > failed - sleep 15 seconds > > Or, this sequence was not present in table _slonrep.sl_sequence before I issued > the subscribe_set() command. > Why does slon consider it to be already present now ? > What can I do now ? > > My replication scheme is as follows : > > In cascade, let's assume 1 -> 71 -> 72, to summary. > 72 is master for set 2 and last subscriber for set 1 (provider is 71, master is > node 1). Am I facing a bug, which could have been solved in 1.2 14 ? Or am I just doing something wrong ? Is there any piece of information I could give ? Regards, - -- Stéphane Schildknecht PostgreSQLFr : http://www.postgresql.fr Venez nous rencontrer le 4 octobre lors du plus important événement PostgreSQL francophone : http://www.pgday.fr -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFIlr8WA+REPKWGI0ERAmBAAJ9w1ytul0dYSP9wna28QcRwqbF3BQCfSdf2 djci8uR1jw4Iq8M1ekMdZLE= =ISTO -----END PGP SIGNATURE-----
- Previous message: [Slony1-general] how to determine if the slave is caught up/insync with the master
- Next message: [Slony1-general] REPAIR CONFIG function
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list