<div dir="ltr"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Can you reproduce this issue in Bucardo 5.6.0?</blockquote><div> </div><div>Would I need to re-add all my configurations, etc, to switch? Or could i just swap out some binaries and libs?</div><div><br></div><div><br></div><div><br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div style="font-size:12.8px"><span><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9.5pt;font-family:Arial;vertical-align:baseline;white-space:pre-wrap">--------------------------------</span></p><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9.5pt;font-family:Arial;font-weight:700;vertical-align:baseline;white-space:pre-wrap">Troy Denton, P. Eng.</span></p><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9.5pt;font-family:Arial;vertical-align:baseline;white-space:pre-wrap">Senior Telecom Analyst</span></p><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9.5pt;font-family:Arial;font-weight:700;vertical-align:baseline;white-space:pre-wrap">24-7 Intouch</span></p><br><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9.5pt;font-family:Arial;color:rgb(17,85,204);vertical-align:baseline;white-space:pre-wrap"><a href="tel:204.666.4651" target="_blank">204.666.4651</a></span><span style="font-size:9.5pt;font-family:Arial;vertical-align:baseline;white-space:pre-wrap"> | mobile</span></p><br><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><a href="http://24-7intouch.com/" target="_blank"><span style="font-size:9.5pt;font-family:Arial;color:rgb(17,85,204);vertical-align:baseline;white-space:pre-wrap">24-7intouch.com</span></a><span style="font-size:9.5pt;font-family:Arial;vertical-align:baseline;white-space:pre-wrap"> |</span><span style="font-size:9.5pt;font-family:Arial;color:rgb(17,85,204);vertical-align:baseline;white-space:pre-wrap"> </span><a href="mailto:tdenton@24-7intouch.com" target="_blank"><span style="font-size:9.5pt;font-family:Arial;color:rgb(17,85,204);vertical-align:baseline;white-space:pre-wrap">tdenton@24-7intouch.com</span></a></p><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:9.5pt;font-family:Arial;vertical-align:baseline;white-space:pre-wrap">240 Kennedy St | Winnipeg, Manitoba, Canada R3C 1T1</span></p><br><p dir="ltr" style="line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="font-size:7pt;font-family:Arial;vertical-align:baseline;white-space:pre-wrap">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.</span></p></span></div></div></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Mar 11, 2020 at 10:14 AM David Christensen <<a href="mailto:david@endpoint.com">david@endpoint.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br>
> > > 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.<br>
> > ><br>
> > > I've just manually transferred the data for now, but would like to know the correct process moving forward.<br>
> ><br>
> > 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?<br>
> ><br>
> > Which Bucardo version?<br>
<br>
Can you reproduce this issue in Bucardo 5.6.0?<br>
<br>
> > 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?<br>
> ><br>
> > The error I am getting is:<br>
> ><br>
> > "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.<br>
> Were there any more details in the log.bucardo file or the postgresql logs?<br>
> <br>
> I don't see any related info in the bucardo.log or postgresql log files. I tried recreating with a test table today and am getting the same behaviour - below are my steps:<br>
> <br>
> create table on both servers<br>
> populate data on one server (3 rows, very small)<br>
> bucardo add table public.test relgroup=bananaphone_herd db=bananaphone_wpg3<br>
> bucardo validate sync bananaphone_sync<br>
> bucardo update sync bananaphone_sync onetimecopy=2<br>
> bucardo kick bananaphone_sync<br>
> Check status after a few minutes<br>
> ======================================================================<br>
> Last good : Mar 05, 2020 10:04:56 (time to run: 1s)<br>
> Rows deleted/inserted : 0 / 0<br>
> Sync name : bananaphone_sync<br>
> Current state : Good<br>
> Source relgroup/database : bananaphone_herd / bananaphone_wpg3<br>
> Tables in sync : 10<br>
> Status : Active<br>
> Check time : None<br>
> Overdue time : 00:00:00<br>
> Expired time : 00:00:00<br>
> Stayalive/Kidsalive : Yes / Yes<br>
> Rebuild index : No<br>
> Autokick : Yes<br>
> Onetimecopy : Yes<br>
> Post-copy analyze : Yes<br>
> Last error: :<br>
> ======================================================================<br>
> <br>
> bucardo was not running for some reason??<br>
> bucardo start<br>
> bucardo status bananaphone_sync shows onetimecopy as no<br>
> re-set onetimecopy=2<br>
> re-kick the sync<br>
> status shows onetimecopy as "yes", but has not replicated<br>
> <br>
> <br>
> Does this look like the correct procedure?<br>
<br>
This does, though I’m wondering about that onetimecopy status; that would suggest that it hasn’t done the copy and it’s still pending.<br>
<br>
> I am not seeing anything in /var/log/bucardo.log related to the specified sync. I am seeing periodic warnings about a sync that I had initially created and later removed:<br>
> (25580) [Tue Mar 10 11:44:39 2020] MCP Warning: Unknown sync to be kicked: "tndb_sync1"<br>
<br>
These warnings would show up due to the kick trigger for that sync still being on the table.<br>
--<br>
David Christensen<br>
Senior Software and Database Engineer<br>
End Point Corporation<br>
<a href="mailto:david@endpoint.com" target="_blank">david@endpoint.com</a><br>
785-727-1171<br>
<br>
<br>
</blockquote></div>