Home > Archive > Slony1 PostgreSQL Replication > August 2005 > Moving multiple sets causes slon to terminate









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Moving multiple sets causes slon to terminate
Ujwal S. Setlur

2005-08-10, 8:25 pm

Hi,

I am testing the controlled switching of roles between
master and slave nodes. I have two sets that are being
subscribed to. I switch roles for both sets with the
following script:

slonik <<_EOF_

cluster name =3D $CLUSTERNAME;

node $REMOTENODEID admin conninfo =3D
'dbname=3D$REMOTEDBN
AME host=3D$REMOTEHOST
user=3D$REPLICATIONU
SER';
node $LOCALNODEID admin conninfo =3D
'dbname=3D$LOCALDBNA
ME host=3D$LOCALHOST
user=3D$REPLICATIONU
SER';

# Move set 1
lock set (id =3D 1, origin =3D $REMOTENODEID);
wait for event (origin =3D $REMOTENODEID,
confirmed =3D $LOCALNODEID);
move set (id =3D 1, old origin =3D $REMOTENODEID,
new origin =3D $LOCALNODEID);
wait for event (origin =3D $REMOTENODEID,
confirmed =3D $LOCALNODEID);

# Move set 2
lock set (id =3D 2, origin =3D $REMOTENODEID);
wait for event (origin =3D $REMOTENODEID,
confirmed =3D $LOCALNODEID);
move set (id =3D 2, old origin =3D $REMOTENODEID,
new origin =3D $LOCALNODEID);
wait for event (origin =3D $REMOTENODEID,
confirmed =3D $LOCALNODEID);

_EOF_

However, this script causes the slon process on the
old origin to terminate with the following error:

localListenThread: MOVE_SET but no provider found for
set 2

If I move only one set, it works fine. I tried
reversing the order of the sets being moved, but it
still fails on the second set being moved.

Any ideas?

Thanks,

Ujwal
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com