[Bucardo-general] onetimecopy in bucardo 5

[Troy Denton]

>
> > On Mar 5, 2020, at 10:13 AM, Troy Denton <tdenton at 24-7intouch.com>
> wrote:
> >
> > Is onetimecopy still supported in bucardo 5?  I'm adding new tables to
> an existing sync and want to copy over those tables.  The tables exist on
> both machines, with data existing in one of them. I can't seem to make it
> work, steps I followed:
> >
> > bucardo add table <table> relgroup=<relgroup> db=<db>
> > bucardo validate sync <the sync that uses this relgroup>
> > bucardo update sync <the sync that uses this relgroup> onetimecopy=2
> > bucardo kick <the sync that uses this relgroup>
> >
> > Never saw the data copy over, or the 'one time copy' in the status go to
> false.  I tried reloading that sync [i got an error], stopping/starting
> bucardo, and then the status said that onetimecopy was false, but my data
> had not transferred.
> >
> > I've just manually transferred the data for now, but would like to know
> the correct process moving forward.
>
> It *should* work, though I’m curious what error the you mentioned was.  I
> assume the target table was completely empty first if you were trying to
> use onetimecopy=2?
>
> Which Bucardo version?
>

Hey David, The target table was completely empty.  There are other tables
in the same relgroup that would not have been completely empty though -
could that be the misunderstanding?

The error I am getting is:

"Reloading sync tndb_sync...Reload of sync tndb_sync failed; reload
response message never received".  I just tried it now and got the same
result.

I am running bucardo 5.5.0

--------------------------------

Troy Denton, P. Eng.

Senior Telecom Analyst

24-7 Intouch

204.666.4651 | mobile

24-7intouch.com | tdenton at 24-7intouch.com

240 Kennedy St | Winnipeg, Manitoba, Canada R3C 1T1

Confidentiality Note: This e-mail message and any attachments to it are
intended only for the named recipients and may contain legally privileged
and/or confidential information. If you are not one of the intended
recipients, please do not duplicate or forward this e-mail message and
immediately delete it from your computer.


On Thu, Mar 5, 2020 at 10:15 AM David Christensen <david at endpoint.com>
wrote:

> > On Mar 5, 2020, at 10:13 AM, Troy Denton <tdenton at 24-7intouch.com>
> wrote:
> >
> > Is onetimecopy still supported in bucardo 5?  I'm adding new tables to
> an existing sync and want to copy over those tables.  The tables exist on
> both machines, with data existing in one of them. I can't seem to make it
> work, steps I followed:
> >
> > bucardo add table <table> relgroup=<relgroup> db=<db>
> > bucardo validate sync <the sync that uses this relgroup>
> > bucardo update sync <the sync that uses this relgroup> onetimecopy=2
> > bucardo kick <the sync that uses this relgroup>
> >
> > Never saw the data copy over, or the 'one time copy' in the status go to
> false.  I tried reloading that sync [i got an error], stopping/starting
> bucardo, and then the status said that onetimecopy was false, but my data
> had not transferred.
> >
> > I've just manually transferred the data for now, but would like to know
> the correct process moving forward.
>
> It *should* work, though I’m curious what error the you mentioned was.  I
> assume the target table was completely empty first if you were trying to
> use onetimecopy=2?
>
> Which Bucardo version?
>
> Best,
>
> David
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20200305/180709a5/attachment-0001.htm>