<div dir="ltr">Hi,<br><br>I'm trying to replicate a postgresql
database 8.3 with 1TB data and about 20.000 tables using slony 2.2.3 but
I'm getting the following error in the middle of the process:<br><br>I created a main set with id number 1 and then small temporary sets were created and merged to the main set.<br><br>Currently
there are about 15.000 tables being replicated in the main set and when
I was adding another small set I got this error during the MERGE command:<br><br><div>2014-12-16 07:08:25 BRST CONFIG remoteWorkerThread_1: Begin COPY of table "8357_isarq"."wm_bco_pla"<br>NOTICE: truncate of "8357_isarq"."wm_bco_pla" succeeded<br>2014-12-16 07:08:25 BRST CONFIG remoteWorkerThread_1: 74168 bytes copied for table "8357_isarq"."wm_bco_pla"<br>NOTICE: Slony-I: Logswitch to sl_log_1 initiated<br>CONTEXT: SQL statement "SELECT "_slcluster".logswitch_start()"<br>PL/pgSQL function cleanupevent(interval) line 97 at PERFORM<br>2014-12-16 07:08:25 BRST INFO cleanupThread: 89.011 seconds for cleanupEvent()<br>2014-12-16 07:08:25 BRST ERROR remoteWorkerThread_1: "select "_slcluster".finishTableAfterCopy(15564);
analyze "8357_isarq"."wm_bco_pla"; " PGRES_FATAL_ERROR ERROR: could
not create unique index "pk_wm_bco_pla"<br>DETAIL: Key (bco_cod, pla_cod)=(399, 5056110) is duplicated.<br>CONTEXT: SQL statement "reindex table "8357_isarq"."wm_bco_pla""<br>PL/pgSQL function finishtableaftercopy(integer) line 26 at EXECUTE statement<br>2014-12-16 07:08:25 BRST WARN remoteWorkerThread_1: data copy for set 999 failed 108 times - sleep 60 seconds<br><br></div><div>The
error indicates "8357_isarq"."wm_bco_pla" has duplicated rows for
primary key (bco_cod, pla_cod)=(399, 5056110) but when I query the
table using this pk I got only one row:<br><br>select * from "8357_isarq"."wm_bco_pla" where bco_cod=399 and pla_cod = '5056110';<br> bco_cod | pla_cod | pla_des | ativo | conta_pai | pla_itlistserv | pla_ctacosif <br>---------+---------+---------------------------------------+-------+-----------+----------------+--------------<br> 399 | 5056110 | RENDAS TRANSACOES VISA ELETRON - HBBR | S | 5056004 | 1501 | 71799003<br>(1 row)<br><br></div><div>Slony
is trying to merge the temporary set to the main set every 60 seconds
and getting this error. I do not want to loose three days of replication
processing.<br><br></div><div>Is there anything I can do to fix this
error or at least can I remove this table from the temporary set and
work on this issue afterwards?<br><br></div>Thank you!<br clear="all"><br><br></div>