On 1/17/2005 1:00 PM, John Sidney-Woollett wrote:

> Can anyone explain what this error means:
> 
> ./replicate_subscribe.sh
> <stdin>:10: PGRES_FATAL_ERROR select "_bpixreplicate".subscribeSet(1, 1, 
> 2, 'f');  - ERROR:  Slony-I: set 1 not found

You try to subscribe before the set creation has propagated onto node 2. 
Look for "wait for event" and put that into the script that creates the 
set, so that it doesn't terminate before the set is known to node 2.


Jan

> 
> Help?!
> 
> John Sidney-Woollett
> 
> Here's the subscribe script that is causing the error when it is executed.
> 
> =======================================
> slonik script to subscribe to set
> =======================================
> #!/bin/bash
> 
> /usr/local/pgsql/bin/slonik << _END_
> 
> # define the cluster namespace
> cluster name = bpixreplicate;
> 
> # define two nodes connection information
> node 1 admin conninfo = 'dbname=bpix_live host=host1 user=postgres';
> node 2 admin conninfo = 'dbname=bpix_live host=host2 user=postgres';
> 
> # node 2 subscribes to set 1 (node 1 to node 2)
> subscribe set (id=1, provider=1, receiver=2, forward=no);
> 
> _END_
> 
> 
> Here is the data in the "master" database in the "_bpixreplicate" schema
> 
> select * from _bpixreplicate.sl_set;
>   set_id | set_origin | set_locked |   set_comment
> --------+------------+------------+-----------------
>        1 |          1 |            | bpix statistics
> 
> and
> 
> select * from _bpixreplicate.sl_table ;
>   tab_id | tab_reloid | tab_set |     tab_idxname      | tab_altered | 
>        tab_comment
> --------+------------+---------+----------------------+-------------+----------------------------
>        1 |      17415 |       1 | stdayalbumstats_pkey | t           | 
> statistics.stdayalbumstats
>        2 |      17417 |       1 | sthitstats_pkey      | t           | 
> statistics.sthitstats
>        3 |      17489 |       1 | stsession_pkey       | t           | 
> statistics.stsession
>        4 |      17504 |       1 | sturllog_pkey        | t           | 
> statistics.sturllog
> 
> 
> And here is the script to set replication up
> 
> =======================================
> slonik script to setup replication
> =======================================
> #!/bin/bash
> 
> /usr/local/pgsql/bin/slonik << _END_
> 
> # define the cluster namespace
> cluster name = bpixreplicate;
> 
> # define two nodes connection information
> node 1 admin conninfo = 'dbname=bpix_live host=host1 user=postgres';
> node 2 admin conninfo = 'dbname=bpix_live host=host2 user=postgres';
> 
> # create the first node and cluster
> # this is the master
> init cluster (id=1, comment='host1 Master 7.4.4');
> 
> # create the second slave node
> store node (id=2, comment='host2 Slave 7.4.6');
> 
> # create the replication sets
> create set (id=1, origin=1, comment='bpix statistics');
> set add table (set id=1, origin=1, id=1, full qualified 
> name='statistics.stdayalbumstats');
> set add table (set id=1, origin=1, id=2, full qualified 
> name='statistics.sthitstats');
> set add table (set id=1, origin=1, id=3, full qualified 
> name='statistics.stsession');
> set add table (set id=1, origin=1, id=4, full qualified 
> name='statistics.sturllog');
> 
> # define the paths between the servers
> store path (server=1, client=2, conninfo='dbname=bpix_live host=host1 
> user=postgres');
> store path (server=2, client=1, conninfo='dbname=bpix_live host=host2 
> user=postgres');
> 
> # define the listeners and who provides the master data
> store listen (origin=1, provider=1, receiver=2);
> store listen (origin=2, provider=2, receiver=1);
> 
> # node 2 subscribes to set 1 (node 1 to node 2)
> #subscribe set (id=1, provider=1, receiver=2, forward=no);
> 
> _END_
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #