[Bucardo-general] Questions about replication status
Greg Sabino Mullane
greg at endpoint.com
Tue Jan 24 17:42:51 UTC 2012
> [Sat Jan 21 20:06:02 2012] KID Action summary: 2:5101353
...
> spicesyncb0| S |RUN:47h8m10s>spicebillingdba0 |28097|50h10m56s|8s
...
> SELECT DISTINCT d.rowid AS "BUCARDO_ID", t.ap_sno
> ,ap_acct,ap_pin,ap_activedate,ap_expirydate,ap_currencycode,ap_initvalue,ap_value,ap_partnerid,ap_serviceid,ap_type,ap_status
> ,ap_userno,ap_concurrentlock,ap_assigndate,ap_rechargeable,ap_expiryperiod,ap_orderid,ap_postpaidlimit,ap_reserve
...
> I dont know what happening is the replication got failed or its still going on
Probably still going on. That's a lot of rows (5M!) for Bucardo to handle,
and the query is going to a very, very long time. You might want to
switch to fullcopy or otherwise get them in sync before adding Bucardo
to the mix. You will also have much better luck with Bucardo version 5:
pull from git to try it out or download the latest beta:
http://bucardo.org/wiki/Bucardo
--
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20120124/f463e78d/attachment.bin
More information about the Bucardo-general
mailing list