http://www.slony.info/bugzilla/show_bug.cgi?id=62

           Summary: Initial subscription blocks with  "sequence ID <xxx> has
                    already been assigned"
           Product: Slony-I
           Version: 1.2
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: medium
         Component: core scripts
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: stuart at stuartbishop.net
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


If the database connection to the master database is killed during a
subscription operation, an ERROR will be logged:

2008-10-24 17:49:49 BST ERROR  remoteWorkerThread_1: "select
"_sl".tableHasSerialKey('"public"."translationrelicensingagreement"');"
2008-10-24 17:49:49 BST WARN   remoteWorkerThread_1: data copy for set 1 failed
- sleep 15 seconds

remoteWorkerThread doesn't want to give up however:

2008-10-24 17:52:35 BST DEBUG1 copy_set 1
2008-10-24 17:52:35 BST DEBUG1 remoteWorkerThread_1: connected to provider DB
2008-10-24 17:52:35 BST DEBUG2 remoteWorkerThread_1: prepare to copy table
"public"."announcement"

Eventually it will fail again, and continue to do so until the subscription
stopped and the cluster repaired:

2008-10-24 21:24:25 BST DEBUG2 remoteWorkerThread_1: all tables for set 1 found 
on subscriber
2008-10-24 21:24:25 BST DEBUG2 remoteWorkerThread_1: copy sequence
"public"."ann
ouncement_id_seq"
2008-10-24 21:24:25 BST ERROR  remoteWorkerThread_1: "select
"_sl".setAddSequence_int(1, 200, '"public"."announcement_id_seq"',
'public.announcement_id_seq')" PGRES_FATAL_ERROR ERROR:  Slony-I:
setAddSequence_int(): sequence ID 200 has already been assigned
2008-10-24 21:24:25 BST WARN   remoteWorkerThread_1: data copy for set 1 failed
- sleep 60 seconds


-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.