Fri May 29 13:53:15 PDT 2009
- Previous message: [Slony1-general] Problem running slonik on Solaris: slony1_funcs not found
- Next message: [Slony1-general] Initial replication of sequences is failing
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Problem running slonik on Solaris: slony1_funcs not found
- Next message: [Slony1-general] Initial replication of sequences is failing
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list