Hi,

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:

I created a main set with id number 1 and then small temporary sets were
created and merged to the main set.

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:

2014-12-16 07:08:25 BRST CONFIG remoteWorkerThread_1: Begin COPY of table
"8357_isarq"."wm_bco_pla"
NOTICE:  truncate of "8357_isarq"."wm_bco_pla" succeeded
2014-12-16 07:08:25 BRST CONFIG remoteWorkerThread_1: 74168 bytes copied
for table "8357_isarq"."wm_bco_pla"
NOTICE:  Slony-I: Logswitch to sl_log_1 initiated
CONTEXT:  SQL statement "SELECT "_slcluster".logswitch_start()"
PL/pgSQL function cleanupevent(interval) line 97 at PERFORM
2014-12-16 07:08:25 BRST INFO   cleanupThread:   89.011 seconds for
cleanupEvent()
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"
DETAIL:  Key (bco_cod, pla_cod)=(399, 5056110) is duplicated.
CONTEXT:  SQL statement "reindex table "8357_isarq"."wm_bco_pla""
PL/pgSQL function finishtableaftercopy(integer) line 26 at EXECUTE statement
2014-12-16 07:08:25 BRST WARN   remoteWorkerThread_1: data copy for set 999
failed 108 times - sleep 60 seconds

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:

select * from "8357_isarq"."wm_bco_pla" where bco_cod=399 and pla_cod =
'5056110';
 bco_cod | pla_cod |                pla_des                | ativo |
conta_pai | pla_itlistserv | pla_ctacosif
---------+---------+---------------------------------------+-------+-----------+----------------+--------------
     399 | 5056110 | RENDAS TRANSACOES VISA ELETRON - HBBR | S     |
5056004   |           1501 | 71799003
(1 row)

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.

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?

Thank you!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20141216/ee794a36/attachment.htm