On 7/8/2007 12:07 PM, angga erwina wrote:
> Help me please.....
> my slony-I 1.2.9
> postgre8.2.4
> i've installed pgbench and plpgsql
> I've make setup.sh like this, but there error messages like under this??

I don't see a "store node" command for node 2 in there.


Jan

> #!/bin/sh
> CLUSTER=test1
> MASTERDBNAME=pgbench_node1
> SLAVEDBNAME=pgbench_node2
> MASTERHOST=localhost
> SLAVEHOST=localhost
> SLONY_USER=postgres
> PGBENCH_USER=postgres
> /usr/local/pgsql/bin/slonik <<_EOF_
>     cluster name = $CLUSTER;
>     node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST 
> user=$SLONY_USER';
>     node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST 
> user=$SLONY_USER';
>     init cluster ( id = 1, comment = 'Node 1' );
>     table add key ( node id = 1, fully qualified name = 'public.history' );
>     create set ( id = 1, origin = 1, comment = 'All pgbench tables' );
>     set add table ( set id = 1, origin = 1,
>         id = 1, fully qualified name = 'public.accounts',
>         comment = 'Table accounts' );
>     set add table ( set id = 1, origin = 1,
>         id = 2, fully qualified name = 'public.branches',
>         comment = 'Table branches' );
>     set add table ( set id = 1, origin = 1,
>         id = 3, fully qualified name = 'public.tellers',
>         comment = 'Table tellers' );
>     set add table ( set id = 1, origin = 1,
>         id = 4, fully qualified name = 'public.history',
>         key = serial,
>         comment = 'Table history' );
>         store node ( id = 2, comment = 'Node 2' );
>     store path ( server = 1, client = 2,
>         conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST 
> user=$SLONY_USER');
>     store path ( server = 2, client = 1,
>         conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST user=$SLONY_USER');
>     store listen ( origin = 1, provider = 1, receiver = 2 );
>     store listen ( origin = 2, provider = 2, receiver = 1 );
> _EOF_
>  
> there  were  error messages like this
> <stdin>:4: Error: namespace "_test1" already exists in database of node 1
> <stdin>:4: ERROR: no admin conninfo for node 149930256
>  
>  
>  
> when i make the subscribe.sh like this
> #!/bin/sh
> CLUSTER=test1
> MASTERDBNAME=pgbench_node1
> SLAVEDBNAME=pgbench_node2
> MASTERHOST=localhost
> SLAVEHOST=localhost
> SLONY_USER=postgres
> PGBENCH_USER=postgres
> /usr/local/pgsql/bin/slonik <<_EOF_
>     cluster name = $CLUSTER;
>    node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST 
> user=$SLONY_USER';
>     node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST 
> user=$SLONY_USER';
>     subscribe set ( id = 1, provider = 1, receiver = 2, forward = no);
> _EOF_
>  
> there were  error messages like this :
> <stdin>:18: PGRES_FATAL_ERROR select "_test1".subscribeSet(1, 1, 2, 
> 'f');  - ERROR:  insert or update on table "sl_path" violates foreign 
> key constraint "pa_client-no_id-ref"
> DETAIL:  Key (pa_client)=(2) is not present in table "sl_node".
> CONTEXT:  SQL statement "INSERT INTO "_test1".sl_path (pa_server, 
> pa_client, pa_conninfo, pa_connretry) values ( $1 ,  $2 , '<event 
> pending>', 10)"
> PL/pgSQL function "subscribeset_int" line 53 at SQL statement
> SQL statement "SELECT  "_test1".subscribeSet_int( $1 ,  $2 ,  $3 ,  $4 )"
> PL/pgSQL function "subscribeset" line 63 at perform
>  
> so,what happend in my replicator?? and what should i do to solve this error
>  
> thank kyu
> regards,
> bayu
> 
> ------------------------------------------------------------------------
> TV dinner still cooling?
> Check out "Tonight's Picks" 
> <http://us.rd.yahoo.com/evt=49979/*http://tv.yahoo.com/> on Yahoo! TV.
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/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 #