Fri Jul 6 03:26:59 PDT 2007
- Previous message: [Slony1-general] tutorial for the beginner
- Next message: [Slony1-general] Bug: slonik sometimes incorrectly splits its command by "; "
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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?? #!/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 ____________________________________________________________________________________ Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out. http://answers.yahoo.com/dir/?link=list&sid=396545433
- Previous message: [Slony1-general] tutorial for the beginner
- Next message: [Slony1-general] Bug: slonik sometimes incorrectly splits its command by "; "
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list