On 11-08-05 04:38 PM, Rene Romero Benavides wrote:
> Hello everybody and greetings from México City.
>
> *slony version: 2.0.7 with postgresql 9.0.4 running on debian squeeze
> (and same issue arises with opensuse 11.04)*
> I get the following message when trying to subscribe a node to a
> replication set:
>
> *<stdin>:4: row number 0 is out of range 0..-1
> Segmentation fault*
>

I don't see a 'create set(....)'  slonik command anywhere in the below 
output.  The altperl script slonik_create_set command generates this. 
Did you forget to run it befure you tried subscribing?

(if this is the case and slonik is generating a segmentation fault 
instead of a useful error message then that is a bug)

Steve

> the slony instructions (generated with perltools) that caused this error:/
> /-----------------------------------------------------------------------------------------------------
> /cluster name = slony_cluster;
> node 1 admin conninfo='host=10.0.0.142 dbname=pgbench user=postgres
> port=5432 password=postgres';
> node 2 admin conninfo='host=10.0.0.140 dbname=pgbenchslave user=postgres
> port=5432 password=postgres';
> try {
> subscribe set (id = 1, provider = 1, receiver = 2, forward = yes);
> }
> on error {
> exit 1;
> }
> echo 'Subscribed nodes to set 1';/
> -----------------------------------------------------------------------------------------------------
>
> And my slon_tools.conf
> -----------------------------------------------------------------------------------------------------
>
> if ($ENV{"SLONYNODES"}) {
> require $ENV{"SLONYNODES"};
> } else {
>
> $CLUSTER_NAME = 'slony_cluster';
>
> $LOGDIR = '/var/log/slony1';
>
> $MASTERNODE = 1;
>
> $DEBUGLEVEL = 2;
>
> add_node(node => 1,
> host => '10.0.0.142',
> dbname => 'pgbench',
> port => 5432,
> user => 'postgres',
> password => 'postgres');
>
> add_node(node => 2,
> host => '10.0.0.140',
> dbname => 'pgbenchslave',
> port => 5432,
> user => 'postgres',
> password => 'postgres');
> }
>
>
> $SLONY_SETS = {
> "set1" => {
> "set_id" => 1,
> "table_id" => 1,
> "sequence_id" => 1,
> "pkeyedtables" => [
> 'pgbench_tellers',
> 'pgbench_history',
> 'pgbench_accounts',
> 'pgbench_branches'
> ],
> },
> };
>
> if ($ENV{"SLONYSET"}) {
> require $ENV{"SLONYSET"};
> }
> # Please do not add or change anything below this point.
> 1;
> -----------------------------------------------------------------------------------------------------
> When I fire up the script I get:
> 2011-08-05 15:26:20 CDT LOG: unexpected EOF on client connection
> on the slon logs from the master node (where I'm calling it from)
>
> I've checked connectivity between nodes and everything is alright. I've
> ran other scripts such as slonik_uninstall_nodes, slonik_drop_node, and
> slonik_add_node and they're executed successfully.
>
> The cluster was previously initialized with:
> -----------------------------------------------------------------------------------------------------------------------
> # INIT CLUSTER
> cluster name = slony_cluster;
> node 1 admin conninfo='host=10.0.0.142 dbname=pgbench user=postgres
> port=5432 password=postgres';
> node 2 admin conninfo='host=10.0.0.140 dbname=pgbenchslave user=postgres
> port=5432 password=postgres';
> init cluster (id = 1, comment = 'Node 1 - pgbench at 10.0.0.142');
>
> # STORE NODE
> store node (id = 2, event node = 1, comment = 'Node 2 -
> pgbenchslave at 10.0.0.140');
> echo 'Set up replication nodes';
>
> # STORE PATH
> echo 'Next: configure paths for each node/origin';
> store path (server = 1, client = 2, conninfo = 'host=10.0.0.142
> dbname=pgbench user=postgres port=5432 password=postgres');
> store path (server = 2, client = 1, conninfo = 'host=10.0.0.140
> dbname=pgbenchslave user=postgres port=5432 password=postgres');
> echo 'Replication nodes prepared';
> echo 'Please start a slon replication daemon for each node';
> -----------------------------------------------------------------------------------------------------------------------
> The slon daemon is running on both nodes.
>
> Any help will be highly appreciated. Thanks
>
>
>
>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general