Mon Jun 1 08:38:02 PDT 2009
- Previous message: [Slony1-general] Initial replication of sequences is failing
- Next message: [Slony1-general] Initial replication of sequences is failing
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Thanks for all the responses. To quickly answer Stuart's question... Yes it keeps looping. Also, it doesn't appear that the system is running out of disk space. The root partition still has 27G free and the partition that contains the postgresql data has 261G free. I'll investigate Bug #62 in the meantime. Just to help with troubleshooting, I'll build another replication cluster and start the table IDs at 1 and the sequence IDs at 1001. Cheers! Sean Stuart Bishop wrote: > 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. > >
- Previous message: [Slony1-general] Initial replication of sequences is failing
- 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