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*

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



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20110805/c4060571/attachment.htm