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