Thu Jan 28 15:46:41 PST 2010
- Previous message: [Slony1-general] new cluster issues.. banging head provider 2 is not an active forwarding node
- Next message: [Slony1-general] new cluster issues.. banging head provider 2 is not an active forwarding node
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> subscribe set ( id = 1, provider = 1, receiver = 2, forward = yes);
> subscribe set ( id = 2, provider = 1, receiver = 2, forward = yes);
> subscribe set ( id = 3, provider = 1, receiver = 2, forward = yes);
>
> subscribe set ( id = 1, provider = 1, receiver = 3, forward = yes);
> subscribe set ( id = 2, provider = 1, receiver = 3, forward = yes);
> subscribe set ( id = 3, provider = 1, receiver = 3, forward = yes);
> subscribe set ( id = 1, provider = 2, receiver = 4, forward = yes);
>ERROR:
><stdin>:74: PGRES_FATAL_ERROR select "_cls".subscribeSet(1, 2, 4,
>'t'); - ERROR: Slony-I: subscribeSet(): provider 2 is not an active
>forwarding node for replication set 1
Try adding a
wait for event (origin = <origin_node>, confirmed = <subscriber_node>);
after _each_ of your subscribe commands.
eg:
subscribe set ( id = 1, provider = 1, receiver = 2, forward = yes);
wait for event (origin = 1 confirmed = 2);
subscribe set ( id = 2, provider = 1, receiver = 2, forward = yes);
wait for event (origin = 1 confirmed = 2);
...
...
...
subscribe set ( id = 3, provider = 1, receiver = 3, forward = yes);
wait for event (origin = 1 confirmed = 3);
subscribe set ( id = 1, provider = 2, receiver = 4, forward = yes);
Melvin Davidson
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100128/81501b4c/attachment.htm
- Previous message: [Slony1-general] new cluster issues.. banging head provider 2 is not an active forwarding node
- Next message: [Slony1-general] new cluster issues.. banging head provider 2 is not an active forwarding node
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list