Hi all,

I have to add new tables to a replicating set.
I can create a new set, adding tables to it, subscribing it.
But, when trying to merge the two sets, i got the following error :
<stdin>:48: PGRES_FATAL_ERROR select "_replic".mergeSet(1, 2);  - 
ERREUR:  Slony-I: subscriber lists of set 1 and 2 are different

Waiting a while and retrying to only merge the sets works.

Why isn't the WAIT ON EVENT command successful in waiting for 
subscription before trying the merge operation ?
Or is something else wrong in my script ?

Thanks.

S at S

#################################################################

#!/bin/sh
slonik << EOF
        cluster name = replic;
        node 1 admin conninfo = 'dbname=replication host=upmc1 
user=postgres';
        node 2 admin conninfo = 'dbname=replication host=upmc2 
user=postgres';


        CREATE SET (ID=2, ORIGIN=1, COMMENT='SET TEMPORAIRE');

        WAIT FOR EVENT( ORIGIN = 1, CONFIRMED = 2, TIMEOUT = 0 );

        SET ADD TABLE (SET ID=2, ORIGIN=1, ID=2914168, FULLY QUALIFIED 
NAME = 'public.sogo_utilisateur1_privcal', COMMENT='');
        SET ADD TABLE (SET ID=2, ORIGIN=1, ID=2914161, FULLY QUALIFIED 
NAME = 'public.sogo_utilisateur1_privcal_quick', COMMENT='');
        SET ADD TABLE (SET ID=2, ORIGIN=1, ID=2914182, FULLY QUALIFIED 
NAME = 'public.sogo_utilisateur1_contacts', COMMENT='');
        SET ADD TABLE (SET ID=2, ORIGIN=1, ID=2914175, FULLY QUALIFIED 
NAME = 'public.sogo_utilisateur1_contacts_quick', COMMENT='');

        WAIT FOR EVENT( ORIGIN = 1, CONFIRMED = 2, TIMEOUT = 0 );

# "TABLES CREEES"

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

        WAIT FOR EVENT( ORIGIN = 1, CONFIRMED = 2, TIMEOUT = 0 );

# "SET SOUSCRIT"

        MERGE SET ( ID=1, ADD ID=2, ORIGIN=1);

# "SET MERGES"

EOF

-- 
St?phane SCHILDKNECHT

LINAGORA
30 rue Saint Augustin 75002 PARIS
Tel : +33(0)1 58 18 68 28
fax : +33(0)1 58 18 68 29
http://www.linagora.com