On Sat, May 30, 2009 at 3:53 AM, Sean Staats <sean at ftdna.com> wrote:
> 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: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

Does it keep looping?

You might be hitting Bug #62 (
http://www.slony.info/bugzilla/show_bug.cgi?id=62 ). Its repeatable if
you run out of disk space during replication, but there might be other
triggers too. If you search the archives, there is a thread about the
same error message roughly every month or two.

-- 
Stuart Bishop <stuart at stuartbishop.net>
http://www.stuartbishop.net/