Tory M Blue tmblue at gmail.com
Thu Jan 28 14:53:59 PST 2010
I have a simplified configuration that I'm trying to debug, since a
more complicated has the same issues. I'm getting an error  "Slony-I:
subscribeSet(): provider 2 is not an active forwarding node for
replication set 1"

Now I'm nor sure what I'm missing, my guess it's uber easy but I'm
just stepping on my own toes. What I want to configure is a 5 box
configuration (actually want to make it a tad more dynamic), but for
conversation sake a 5 box cluster, 1 master, 2 slaves and the 2 slaves
talk to another set of queryslaves.

The configuration I'm debugging is a simple master to slave with 2
queryslaves. And I can't figure out what I'm missing, nor if I really
need paths back to the origin (Masterhost) from the query nodes.

Can you see something totally wrong with my path and listeners info here?

        store path (server = 1, client = 2, conninfo='dbname=clsdb
host=devidb03 user=postgres password=secure');
        store path (server = 2, client = 1, conninfo='dbname=clsdb
host=devidb04 user=postgres password=secure');
        store path (server = 1, client = 3, conninfo='dbname=clsdb
host=devidb03 user=postgres password=secure');
        store path (server = 3, client = 1, conninfo='dbname=clsdb
host=devidb05 user=postgres password=secure');
        store path (server = 2, client = 4, conninfo='dbname=clsdb
host=devidb04 user=postgres password=secure');
        store path (server = 4, client = 2, conninfo='dbname=clsdb
host=devqdb03 user=postgres password=secure');
        store path (server = 1, client = 4, conninfo='dbname=clsdb
host=devidb03 user=postgres password=secure');
        store path (server = 4, client = 1, conninfo='dbname=clsdb
host=devqdb03 user=postgres password=secure');
        store path (server = 2, client = 3, conninfo='dbname=clsdb
host=devidb04 user=postgres password=secure');
        store path (server = 3, client = 2, conninfo='dbname=clsdb
host=devidb05 user=postgres password=secure');
        store path (server = 3, client = 4, conninfo='dbname=clsdb
host=devidb05 user=postgres password=secure');
        store path (server = 4, client = 3, conninfo='dbname=clsdb
host=devqdb03 user=postgres password=secure');

        store listen (origin=1, provider = 1, receiver =3);
        store listen (origin=1, provider = 1, receiver =2);
        store listen (origin=1, provider = 2, receiver =4);
        store listen (origin=2, provider = 2, receiver =1);
        store listen (origin=2, provider = 1, receiver =3);
        store listen (origin=2, provider = 2, receiver =4);
        store listen (origin=3, provider = 3, receiver =1);
        store listen (origin=3, provider = 1, receiver =2);
        store listen (origin=3, provider = 1, receiver =4);
        store listen (origin=4, provider = 2, receiver =1);
        store listen (origin=4, provider = 4, receiver =2);
        store listen (origin=4, provider = 1, receiver =3);

    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);


1-Masternode
2-Slavenode
3-Qslave1
4-Qslave2

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

Thanks
Tory


More information about the Slony1-general mailing list