Thu Jan 28 14:53:59 PST 2010
- Previous message: [Slony1-general] logtrigger/denyaccess triggers removed from master/slave
- Next message: [Slony1-general] new cluster issues.. banging head provider 2 is not an active forwarding node
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] logtrigger/denyaccess triggers removed from master/slave
- 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