Granthana Biswas <granthana.biswas@...> 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@...
> 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
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
