Hi everyone,
I have been on working on my slony-i issue and got parto of the
solution but once again i get an error message and dont really know
what to do next wirh it….
Now I have a new schema and have already got it working separately,
but I must join it…
I have a Cluster_1, which is the master of Cluster_2 and cluster_3, at
the same time Cluster_3 is the master node of Cluster_4 and Cluster_5,
but Cluster_3 must be linked to Cluster_1 for what I have created two
clusters (two scripts), and got them "working", but when I execute the
script where we specify the SUBSCRIBE SET I get an error message
C:\Archivos de programa\PostgreSQL\8.2\bin>slonik config2_M2.conf
config2_M2.conf:29: PGRES_FATAL_ERROR select
"_Cluster_M".subscribeSet(4, 4, 1,'t');  - ERROR:  Slony-I:
subscribeSet(): set 4 not found

I will really appreciate if anyone can help me out with this… please…

The scripts I am using are these:

First Cluster:
configM1.conf
################################################################################
cluster name=Cluster_1;

node 1 admin conninfo = 'dbname=DB_Cluster_1 host=127.0.0.1 user=root
password=root port=5435';
node 2 admin conninfo = 'dbname=DB_Cluster_2 host=127.0.0.1 user=root
password=root port=5436';
node 3 admin conninfo = 'dbname=DB_Cluster_3 host=127.0.0.1 user=root
password=root port=5437';

init cluster (id=1, comment='Nodo maestro del Cluster_2 y Cluster_3');

create set (id=1, origin=1, comment='aqui van todas las tablas del Cluster_1');

set add table (set id=1, origin=1, id=1, fully qualified
name='public.Personas', comment='tabla de Personas del Cluster_1');

store node (id=2, comment='Nodo esclavo Cluster_2');
store node (id=3, comment='Nodo esclavo Cluster_3');

store path (server=1, client=2, conninfo='dbname=DB_Cluster_1
host=127.0.0.1 user=root password=root port=5435');
store path (server=1, client=3, conninfo='dbname=DB_Cluster_1
host=127.0.0.1 user=root password=root port=5435');
store path (server=2, client=1, conninfo='dbname=DB_Cluster_2
host=127.0.0.1 user=root password=root port=5436');
store path (server=2, client=3, conninfo='dbname=DB_Cluster_2
host=127.0.0.1 user=root password=root port=5436');
store path (server=3, client=1, conninfo='dbname=DB_Cluster_3
host=127.0.0.1 user=root password=root port=5437');
store path (server=3, client=2, conninfo='dbname=DB_Cluster_3
host=127.0.0.1 user=root password=root port=5437');

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

Config2_M1.conf
################################################################################
cluster name=Cluster_1;

node 1 admin conninfo = 'dbname=DB_Cluster_1 host=127.0.0.1 user=root
password=root port=5435';
node 2 admin conninfo = 'dbname=DB_Cluster_2 host=127.0.0.1 user=root
password=root port=5436';
node 3 admin conninfo = 'dbname=DB_Cluster_3 host=127.0.0.1 user=root
password=root port=5437';

SUBSCRIBE SET (ID=1, PROVIDER=1, RECEIVER=2, FORWARD=YES);
SUBSCRIBE SET (ID=1, PROVIDER=1, RECEIVER=3, FORWARD=YES);
################################################################################

Cluster 2:
configM2.conf
################################################################################
cluster name=Cluster_M;

node 4 admin conninfo = 'dbname=DB_Cluster_1 host=127.0.0.1 user=root
password=root port=5435';
node 1 admin conninfo = 'dbname=DB_Cluster_3 host=127.0.0.1 user=root
password=root port=5437';
node 2 admin conninfo = 'dbname=DB_Cluster_4 host=127.0.0.1 user=root
password=root port=5438';
node 3 admin conninfo = 'dbname=DB_Cluster_5 host=127.0.0.1 user=root
password=root port=5439';

init cluster (id=1, comment='Nodo maestro del Cluster_4 y Cluster_5');

create set (id=1, origin=1, comment='aqui van todas las tablas del Cluster_3');

set add table (set id=1, origin=1, id=1, fully qualified
name='public.Personas', comment='tabla de Personas del Cluster_3');

store node (id=4, comment='nodo esclavo-maestro Cluster_1');
store node (id=2, comment='Nodo esclavo Cluster_4');
store node (id=3, comment='Nodo esclavo Cluster_5');

store path (server=1, client=2, conninfo='dbname=DB_Cluster_3
host=127.0.0.1 user=root password=root port=5437');
store path (server=1, client=3, conninfo='dbname=DB_Cluster_3
host=127.0.0.1 user=root password=root port=5437');
store path (server=1, client=4, conninfo='dbname=DB_Cluster_3
host=127.0.0.1 user=root password=root port=5437');
store path (server=2, client=1, conninfo='dbname=DB_Cluster_4
host=127.0.0.1 user=root password=root port=5438');
store path (server=2, client=3, conninfo='dbname=DB_Cluster_4
host=127.0.0.1 user=root password=root port=5438');
store path (server=3, client=1, conninfo='dbname=DB_Cluster_5
host=127.0.0.1 user=root password=root port=5439');
store path (server=3, client=2, conninfo='dbname=DB_Cluster_5
host=127.0.0.1 user=root password=root port=5439');
store path (server=4, client=1, conninfo='dbname=DB_Cluster_1
host=127.0.0.1 user=root password=root port=5435');

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

Config2_M2.conf
################################################################################
cluster name=Cluster_M;

node 4 admin conninfo = 'dbname=DB_Cluster_1 host=127.0.0.1 user=root
password=root port=5435';
node 1 admin conninfo = 'dbname=DB_Cluster_3 host=127.0.0.1 user=root
password=root port=5437';
node 2 admin conninfo = 'dbname=DB_Cluster_4 host=127.0.0.1 user=root
password=root port=5438';
node 3 admin conninfo = 'dbname=DB_Cluster_5 host=127.0.0.1 user=root
password=root port=5439';

SUBSCRIBE SET (ID=4, PROVIDER=4, RECEIVER=1, FORWARD=YES);
SUBSCRIBE SET (ID=1, PROVIDER=1, RECEIVER=2, FORWARD=YES);
SUBSCRIBE SET (ID=1, PROVIDER=1, RECEIVER=3, FORWARD=YES);
################################################################################

I will really appreciate if anyone can help me out with it…

Jaison José González Chaux