>>=A0 sequence ID 1 has already been assigned

There's your big clue! You probably have two sequences somewhere in the con=
fig with the same sequence ID. If you cannot resolve this by reviewing, the=
n please attach your initialization script for another set of eyes to check.
FYI, even though it's permitted to have sequences with the same ID as a tab=
le, I always start my sequences with an offset of 1000 from table ID's just=
 to make tracking easier.

Melvin Davidson =

 Home 720-870-9595 =

 =A0=A0=A0 Cell 720-320-0155  =





--- On Fri, 5/29/09, Sean Staats <sean at ftdna.com> wrote:

From: Sean Staats <sean at ftdna.com>
Subject: [Slony1-general] Initial replication of sequences is failing
To: slony1-general at lists.slony.info
Date: Friday, May 29, 2009, 2:53 PM

The initial replication of all 165 tables appears to succeed.=A0 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 f=
ound 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=A0 remoteWorkerThread_1: "select "_finch_clus=
ter_1".setAddSequence_int(1, 1, '"finch"."contig_sequence_id_seq"', '')" PG=
RES_FATAL_ERROR ERROR:=A0 Slony-I: setAddSequence_int(): sequence ID 1 has =
already been assigned
2009-05-29 15:39:06 CDT WARN=A0=A0=A0remoteWorkerThread_1: data copy for se=
t 1 failed - sleep 60 seconds
WARNING:=A0 there is no transaction in progress


I've created a 2-node cluster using the following slonik scripts:
preamble.slonik:
cluster name=3Dcluster_1;
NODE 1 ADMIN CONNINFO =3D 'dbname=3Dmydb host=3Dhost1 user=3Dxxxx password=
=3Dyyyy port=3D5432';
NODE 2 ADMIN CONNINFO =3D 'dbname=3Dmydb host=3Dhost2 user=3Dxxxx password=
=3Dyyyy port=3D5432';

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

02-store_paths.slonik:
include </home/foo/slony-setup/preamble.slonik>;
STORE PATH (SERVER=3D1, CLIENT=3D2, CONNINFO=3D'dbname=3Dmydb host=3Dhost1 =
user=3Dxxxx password=3Dyyyy port=3D5432');
STORE PATH (SERVER=3D2, CLIENT=3D1, CONNINFO=3D'dbname=3Dmydb host=3Dhost2 =
user=3Dxxxx password=3Dyyyy port=3D5432');

03-create_set.slonik:
include </home/foo/slony-setup/preamble.slonik>;
create set (id=3D1, origin=3D1, comment=3D'cluster_1 Tables and Sequences');
# TABLES
set add table (set id=3D1, origin=3D1, id=3D1, full qualified name =3D 'myd=
b.fs_category', comment=3D'Table dependency level 0');
set add table (set id=3D1, origin=3D1, id=3D2, full qualified name =3D 'myd=
b.fs_setting', comment=3D'Table dependency level 0');
set add table (set id=3D1, origin=3D1, id=3D3, full qualified name =3D 'myd=
b.fs_value', comment=3D'Table dependency level 0');
set add table (set id=3D1, origin=3D1, id=3D4, full qualified name =3D 'myd=
b.finch_user', comment=3D'Table dependency level 1');
set add table (set id=3D1, origin=3D1, id=3D5, full qualified name =3D 'myd=
b.primer', comment=3D'Table dependency level 2');
set add table (set id=3D1, origin=3D1, id=3D6, full qualified name =3D 'myd=
b.adb_marker', comment=3D'Table dependency level 2');
set add table (set id=3D1, origin=3D1, id=3D7, full qualified name =3D 'myd=
b.adb_sample', comment=3D'Table dependency level 2');
<snip>
# SEQUENCES
set add sequence (set id=3D1, origin=3D1, id=3D1, full qualified name =3D '=
mydb.contig_sequence_id_seq', comment=3D'');
set add sequence (set id=3D1, origin=3D1, id=3D2, full qualified name =3D '=
mydb.control_sample_seq', comment=3D'');
set add sequence (set id=3D1, origin=3D1, id=3D3, full qualified name =3D '=
mydb.dbk_seq', comment=3D'');
set add sequence (set id=3D1, origin=3D1, id=3D4, full qualified name =3D '=
mydb.dref_seq', comment=3D'');
set add sequence (set id=3D1, origin=3D1, id=3D5, full qualified name =3D '=
mydb.email_seq', comment=3D'');
set add sequence (set id=3D1, origin=3D1, id=3D6, full qualified name =3D '=
mydb.faddress_seq', comment=3D'');
<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=3D1, provider=3D1, receiver=3D2, forward=3Dyes);

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

Thanks in advance for your time and help!

Sean



_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general



      =

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090529/=
f3d71642/attachment.htm