Hi,
 
I've a got a problem with subscribe set. I have done a set up with this
configuration in the past so I don't think it is my parameters (dbname
etc) that are wrong. I am settings up node number 3, where the origin is
node 1.
 
This is the error I get:
 
<stdin>:21: PGRES_FATAL_ERROR select "_sss_repcluster".subscribeSet(1,
1, 3, 'f');  - ERROR:  duplicate key violates unique constraint
"sl_path-pkey"
CONTEXT:  PL/pgSQL function "subscribeset_int" line 48 at SQL statement
PL/pgSQL function "subscribeset" line 60 at perform
ERROR launching node

 
This is my script:
sssname, csgname and nodenum are already defined in the script
(nodenum=3)  

 
SSSCONNINFO="'dbname=sss host=$SSSNAME user=postgres'"
CSGCONNINFO="'dbname=sss host=$CSGNAME user=postgres'"
 
slonik <<_EOF_
 
#-----------------------------------------------------------------------
--------
# define the namespace the replication system uses
#-----------------------------------------------------------------------
--------
cluster name = sss_repcluster;
#-----------------------------------------------------------------------
--------
# admin conninfo's are used by slonik to connect to the nodes.
# There is one entry for each node in the cluster, the syntax is that of
PQconnectdb in
# the C-API
#-----------------------------------------------------------------------
--------
node 1 admin conninfo = $SSSCONNINFO;
node $NODENUM admin conninfo = $CSGCONNINFO;
#-----------------------------------------------------------------------
--------
# Subscribe the new node to the set
#-----------------------------------------------------------------------
--------
subscribe set (id = 1, provider = 1, receiver = $NODENUM, forward = no);
wait for event (origin = all, confirmed = all, wait on = 1);
 
_EOF _
 
 
The error seems to be a problem with the internal subscribeset_int
function. I am using slony 1_1_0-rc1. Will it be fixed if I get the
latest release, or is it something I'm doing wrong?
 
Cheers,
Vicki


This message should be regarded as confidential. If you have received this email in error please notify the sender and destroy it immediately.
Statements of intent shall only become binding when confirmed in hard copy by an authorized signatory.


-- 
This message has been scanned for viruses and potentially
harmful content by StreamShield Protector.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050822/209fd0cc/attachment.html