Granthana Biswas <granthana.biswas at ...> writes:

> 
> 
> 
> 
> 
> 
> 
> Hi, 
> I have configured Slony-II using altperl tools. I am trying to add a new
table to a running replication using following
steps:1. ./slonik_execute_script --config slon_tools.conf 1
/usr/pgsql-9.2/bin/test.sql | ./slonik             (sql file has only create
table command)
> 
> <stdin>:4: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"ddl_slony_pkey" for table "ddl_slony"2.
> Adding the table in the slon_tools.conf file as set2 below set1: "set2" =>
{       "set_id"       => 2,       "table_id"     => 2,       "sequence_id" 
=> 2,       "pkeyedtables" => ["public.ddl_slony"],
> 
>        "keyedtables"  => {},       "sequences"    => [],    },3. While
executing create set, I am getting the following error: ./slonik_create_set
-c slon_tools.conf 2 | ./slonik<stdin>:11: Subscription set 2
created<stdin>:12: Adding tables to the subscription set<stdin>:13:
PGRES_FATAL_ERROR lock table "_ms_prod_slony".sl_config_lock;select
"_ms_prod_slony".setAddTable(2, 2, 'public.ddl_slony', 'ddl_slony_pkey',
'Table public.ddl_slony with primary key');  - ERROR:  Slony-I:
setAddTable_int: table id 2 has already been assigned!
> 
> CONTEXT:  SQL statement "SELECT "_ms_prod_slony".setAddTable_int(p_set_id,
p_tab_id, p_fqname,                        p_tab_idxname,
p_tab_comment)"PL/pgSQL function
_ms_prod_slony.setaddtable(integer,integer,text,name,text) line 28 at PERFORM
> I tried the above by manually creating another table on both nodes and
adding and creating set as set3. Still facing the same issue.
> Can anybody point out where I am going wrong and how it should be fixed?
> Thanks,
> GB
> 
> 
> 
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at ...
> http://lists.slony.info/mailman/listinfo/slony1-general
> 


Hi Stephane,

Thank you for your response.

There are 61 tables in set1. I had added table id as 2 in set 2. Now I
changed it 62 and ran the slonik_create_set successfully.

Warm regards,
GB