I have a problem where my replication is hung,  I don't really know where to start....  This table is in set "38", most everything is in set "1", it looks like set 38 isn't "caught up"  in the ordering.
Any Idea's on how to repair this?  Is this problem because the set's are not merged? Can I merge the sets? Version is slony1-1.2.15 on postgres 8.3


2010-06-01 09:11:53 PDT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 574847
2010-06-01 09:11:53 PDT DEBUG2 remoteWorkerThread_50: forward confirm 60,574847 received by 50
2010-06-01 09:11:53 PDT DEBUG2 remoteWorkerThread_40: SYNC 33381140 processing
2010-06-01 09:11:53 PDT DEBUG2 remoteWorkerThread_40: syncing set 38 with 4 table(s) from provider 40
2010-06-01 09:11:53 PDT DEBUG2  ssy_action_list length: 0
2010-06-01 09:11:53 PDT DEBUG2 remoteWorkerThread_40: syncing set 1 with 139 table(s) from provider 40
2010-06-01 09:11:53 PDT DEBUG2  ssy_action_list length: 0
2010-06-01 09:11:53 PDT DEBUG2 remoteWorkerThread_40: current local log_status is 0
2010-06-01 09:11:53 PDT DEBUG2 remoteWorkerThread_40_40: current remote log_status = 1
2010-06-01 09:11:53 PDT DEBUG2 remoteHelperThread_40_40: 0.008 seconds delay for first row
2010-06-01 09:11:53 PDT ERROR  remoteWorkerThread_40: "update only "public"."review" set zipcode_id='80203' where id='1026409';
update only "public"."review" set zipcode_id='80203' where id='1026401';
update only "public"."review" set zipcode_id='80203' where id='1008795';
update only "public"."review" set zipcode_id='80203' where id='1008048';
update only "public"."review" set zipcode_id='80203' where id='1007445';
insert into "public"."company_zip_updated" (id,company_id,zipcode_id) values ('1205','30149282','80122');
update only "public"."merchant" set zipcode_id='80203' where id='905955';
update only "public"."advertisement" set zipcode_id='80203' where id='1467390';
update only "public"."advertisement" set zipcode_id='80203' where id='1375973';
update only "public"."advertisement" set zipcode_id='80203' where id='1389545';
" ERROR:  duplicate key value violates unique constraint "company_zip_updated_company_id_key"
 - qualification was: where log_origin = 40 and (  (
 log_tableid in (158,159,160,161)
    and (log_xid < '622094999')
    and (log_xid >= '622094987')
) or (
    log_tableid in (124,121,117,118,6,22,23,25,26,31,32,43,44,45,46,55,56,57,59,78,115,79,106,114,116,3,4,5,9,11,12,13,14,15,1,7,2,8,16,17,27,28,29,33,34,36,39,40,41,42,47,48,49,50,51,52,53,54,61,63,64,65,69,71,72,74,75,76,77,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,107,108,109,110,111,112,113,119,120,123,122,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157)
    and (log_xid < '622094999')
    and (log_xid >= '622094987')
) )
2010-06-01 09:11:53 PDT DEBUG2 remoteHelperThread_40_40: 0.016 seconds until close cursor
2010-06-01 09:11:53 PDT DEBUG2 remoteHelperThread_40_40: inserts=1 updates=79 deletes=0
2010-06-01 09:11:53 PDT ERROR  remoteWorkerThread_40: SYNC aborted


Here is the table definition

 Table "public.company_zip_updated"
   Column   |  Type   |                            Modifiers                             
------------+---------+------------------------------------------------------------------
 id         | integer | not null default nextval('company_zip_updated_id_seq'::regclass)
 company_id | integer | not null
 zipcode_id | integer | not null
Indexes:
    "company_zip_updated_pkey" PRIMARY KEY, btree (id)
    "company_zip_updated_company_id_key" UNIQUE, btree (company_id)
Foreign-key constraints:
    "company_zip_updated_company_id_fkey" FOREIGN KEY (company_id) REFERENCES company(id) ON DELETE CASCADE
    "company_zip_updated_zipcode_id_fkey" FOREIGN KEY (zipcode_id) REFERENCES zipcode(zip) ON DELETE CASCADE
Triggers:
    _mc_cluster_logtrigger_161 AFTER INSERT OR DELETE OR UPDATE ON company_zip_updated FOR EACH ROW EXECUTE PROCEDURE _mc_cluster.logtrigger('_mc_cluster', '161', 'kvv')