[Bucardo-general] Bucardo sync cause could not receive data from client: Connection reset by peer
Greg Sabino Mullane
greg at endpoint.com
Wed Jun 14 20:31:18 UTC 2017
> (25903) [Fri May 26 22:08:59 2017] KID (aa_sync) Delta count for
> name_01.public.personas : 18903143
> (23975) [Fri May 26 22:09:46 2017] CTL Warning: Kid 25903 is not
> responding, will respawn
My guess is that with a delta collection that large (18M rows!) Bucardo
is taking a really, really long time to walk through them, and some other
timeout is getting hit, causing the disconnection.
If that 18M represents almost all of the rows in the table, I would
try a bulk copy from one side to the other (assuming the table is
meant to be identical).
There are a number of ways to do so, but the simplest may be to stop
writes to the table via your application, truncate one side, then
copy the data from the other[1] (and setting session_replication_role
to 'replica' so you don't create more deltas). Once that is done, you
can also truncate the delta tables.
Test first on a dev box of course!
--
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20170614/1942b80c/attachment.sig>
More information about the Bucardo-general
mailing list