Sean Staats sean at ftdna.com
Fri May 29 13:53:15 PDT 2009
The initial replication of all 165 tables appears to succeed.  When 
slony tries to replicate the first sequence, the following error is 
reported:
log snippet...
2009-05-29 15:39:05 CDT DEBUG1 copy_set 1
2009-05-29 15:39:05 CDT DEBUG1 remoteWorkerThread_1: connected to 
provider DB
2009-05-29 15:39:05 CDT DEBUG2 remoteWorkerThread_1: prepare to copy 
table "finch"."fs_category"
2009-05-29 15:39:05 CDT DEBUG2 remoteWorkerThread_1: prepare to copy 
table "finch"."fs_setting"
2009-05-29 15:39:05 CDT DEBUG2 remoteWorkerThread_1: prepare to copy 
table "finch"."fs_value"
2009-05-29 15:39:05 CDT DEBUG2 remoteWorkerThread_1: prepare to copy 
table "finch"."finch_user"
2009-05-29 15:39:05 CDT DEBUG2 remoteWorkerThread_1: prepare to copy 
table "finch"."primer"
<snip>
2009-05-29 15:39:06 CDT DEBUG2 remoteWorkerThread_1: prepare to copy 
table "finch"."cim_order_registry"
2009-05-29 15:39:06 CDT DEBUG2 remoteWorkerThread_1: prepare to copy 
table "finch"."config_master_table"
2009-05-29 15:39:06 CDT DEBUG2 remoteWorkerThread_1: all tables for set 
1 found on subscriber
2009-05-29 15:39:06 CDT DEBUG2 remoteWorkerThread_1: copy sequence 
"finch"."contig_sequence_id_seq"
2009-05-29 15:39:06 CDT ERROR  remoteWorkerThread_1: "select 
"_finch_cluster_1".setAddSequence_int(1, 1, 
'"finch"."contig_sequence_id_seq"', '')" PGRES_FATAL_ERROR ERROR:  
Slony-I: setAddSequence_int(): sequence ID 1 has already been assigned
2009-05-29 15:39:06 CDT WARN   remoteWorkerThread_1: data copy for set 1 
failed - sleep 60 seconds
WARNING:  there is no transaction in progress


I've created a 2-node cluster using the following slonik scripts:
preamble.slonik:
cluster name=cluster_1;
NODE 1 ADMIN CONNINFO = 'dbname=mydb host=host1 user=xxxx password=yyyy 
port=5432';
NODE 2 ADMIN CONNINFO = 'dbname=mydb host=host2 user=xxxx password=yyyy 
port=5432';

01-create_nodes.slonik:
include </home/foo/slony-setup/preamble.slonik>;
init cluster (id=1, comment='cluster_1 master');
store node (id=2, comment='cluster_1 subscriber');

02-store_paths.slonik:
include </home/foo/slony-setup/preamble.slonik>;
STORE PATH (SERVER=1, CLIENT=2, CONNINFO='dbname=mydb host=host1 
user=xxxx password=yyyy port=5432');
STORE PATH (SERVER=2, CLIENT=1, CONNINFO='dbname=mydb host=host2 
user=xxxx password=yyyy port=5432');

03-create_set.slonik:
include </home/foo/slony-setup/preamble.slonik>;
create set (id=1, origin=1, comment='cluster_1 Tables and Sequences');
# TABLES
set add table (set id=1, origin=1, id=1, full qualified name = 
'mydb.fs_category', comment='Table dependency level 0');
set add table (set id=1, origin=1, id=2, full qualified name = 
'mydb.fs_setting', comment='Table dependency level 0');
set add table (set id=1, origin=1, id=3, full qualified name = 
'mydb.fs_value', comment='Table dependency level 0');
set add table (set id=1, origin=1, id=4, full qualified name = 
'mydb.finch_user', comment='Table dependency level 1');
set add table (set id=1, origin=1, id=5, full qualified name = 
'mydb.primer', comment='Table dependency level 2');
set add table (set id=1, origin=1, id=6, full qualified name = 
'mydb.adb_marker', comment='Table dependency level 2');
set add table (set id=1, origin=1, id=7, full qualified name = 
'mydb.adb_sample', comment='Table dependency level 2');
<snip>
# SEQUENCES
set add sequence (set id=1, origin=1, id=1, full qualified name = 
'mydb.contig_sequence_id_seq', comment='');
set add sequence (set id=1, origin=1, id=2, full qualified name = 
'mydb.control_sample_seq', comment='');
set add sequence (set id=1, origin=1, id=3, full qualified name = 
'mydb.dbk_seq', comment='');
set add sequence (set id=1, origin=1, id=4, full qualified name = 
'mydb.dref_seq', comment='');
set add sequence (set id=1, origin=1, id=5, full qualified name = 
'mydb.email_seq', comment='');
set add sequence (set id=1, origin=1, id=6, full qualified name = 
'mydb.faddress_seq', comment='');
<snip>

** Note that there are a total of 165 tables and 100 sequences added to 
the set.

04-subscribe_set.slonik:
include </home/foo/slony-setup/preamble.slonik>;
subscribe set (id=1, provider=1, receiver=2, forward=yes);

I also tried adding the sequences to the set by starting their id values 
with 1001, but that got me the same results. 

Thanks in advance for your time and help!

Sean





More information about the Slony1-general mailing list