<div dir="ltr"><div style="padding:20px 0px 0px;font-size:0.875rem;font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif"><br><table cellpadding="0" style="border-collapse:collapse;margin-top:0px;width:auto;font-size:0.875rem;letter-spacing:0.2px;display:block"><tbody style="display:block"><tr style="height:auto;display:flex"><td style="white-space:nowrap;padding:0px;vertical-align:top;width:782.475px;line-height:20px;display:block;max-height:20px"><table cellpadding="0" style="border-collapse:collapse;table-layout:fixed;width:782.4px"><tbody><tr><td style="display:flex"><h3 style="overflow:hidden;font-size:0.75rem;font-weight:inherit;margin:inherit;text-overflow:ellipsis;letter-spacing:0.3px;color:rgb(95,99,104);line-height:20px"><span><span name="David Christensen" style="color:rgb(32,33,36);font-size:0.875rem;font-weight:bold;display:inline;vertical-align:top;letter-spacing:0.2px;line-height:20px">David Christensen</span></span></h3></td></tr></tbody></table></td><td style="text-align:right;white-space:nowrap;vertical-align:top;display:block;max-height:20px"><div style="padding:0px;display:flex"><img src="https://mail.google.com/mail/u/0/images/cleardot.gif" title="signature.asc" alt="Attachments" style="vertical-align:top;background:url("https://ci6.googleusercontent.com/proxy/UxiVTz00m7dnSY57aoei5eZVGMJjEzyO9VX2UopBnEzXySuA3O3YYG3BkoXoD1SVdBjFS9h0fgOJh1rEzIsblYwB_oj41L_UULEk2r_dUaJ2SFyhBc0Ffcp4-XStXf9T1o1Nnw=s0-d-e1-ft#https://www.gstatic.com/images/icons/material/system/1x/attachment_black_20dp.png") 50% 50%/20px no-repeat;height:20px;width:20px;opacity:0.54"><span id="m_-8003018421126858009gmail-:22x" title="Mar 6, 2020, 2:55 PM" alt="Mar 6, 2020, 2:55 PM" style="vertical-align:top;margin:0px;font-size:0.75rem;letter-spacing:0.3px;color:rgb(95,99,104);display:block;line-height:20px">Mar 6, 2020, 2:55 PM (4 days ago)</span><div title="Not starred" style="display:inline-block;height:20px;margin-left:20px;outline:0px"><span style="display:inline-flex;height:20px;text-align:center;width:20px;padding:0px;margin:0px;border:none;outline:none"></span></div></div></td><td style="text-align:right;white-space:nowrap;vertical-align:top;display:flex"></td><td rowspan="2" style="text-align:right;white-space:nowrap;vertical-align:top;display:block;max-height:20px"><div style="display:inline-flex;border-radius:2px 0px 0px 2px;font-size:0.875rem;text-align:center;margin:0px 0px 0px 20px;height:20px;line-height:18px;min-width:0px;outline:none;padding:0px;background:transparent;color:rgb(68,68,68);border:none"><img src="https://mail.google.com/mail/u/0/images/cleardot.gif" alt="" style="background:url("https://ci4.googleusercontent.com/proxy/-shEvx-z5X_fEDdygs_6-SdWItpUTEcgMhdi64S2gEQdlAw7AgDLgZgL9knwTZcLnco2HBKyc3r6-IyG2unMtUnM5sWrGcndeo8hVM0DtNVTZs1l-XeGQZwZSfEmbsM=s0-d-e1-ft#https://www.gstatic.com/images/icons/material/system/1x/reply_black_20dp.png") 50% 50%/20px no-repeat;height:20px;margin:0px;vertical-align:middle;width:20px;opacity:0.7;display:inline-block;padding:0px"></div><div id="m_-8003018421126858009gmail-:222" style="display:inline-flex;border-radius:0px 2px 2px 0px;font-size:0.875rem;text-align:center;margin:0px 0px 0px 20px;height:20px;line-height:18px;min-width:0px;outline:none;padding:0px;background:transparent;color:rgb(68,68,68);border:none"><img src="https://mail.google.com/mail/u/0/images/cleardot.gif" alt="" style="background:url("https://ci4.googleusercontent.com/proxy/mJzqsKRuAD8-RYamBI_7Gla-DDFv4vv104YshicxGbhIJ5c3poYrP_gV04dbMWFm4s90taCnijsbl0VRAhekiWC7qT8PwfU6Xsec1h5RCLfjmwpvJVHZju6oO6hoPRN0ehot=s0-d-e1-ft#https://www.gstatic.com/images/icons/material/system/1x/more_vert_black_20dp.png") 50% 50%/20px no-repeat;height:20px;width:20px;margin:0px;vertical-align:middle;opacity:0.7;display:inline-block;padding:0px"></div></td></tr><tr style="height:auto;display:flex"><td colspan="3"><table cellpadding="0" style="border-collapse:collapse;table-layout:fixed;white-space:nowrap;width:1120px"><tbody><tr><td style="overflow:visible;text-overflow:ellipsis;display:flex;line-height:20px"><div style="overflow:hidden;max-width:92%;display:inline-block"><span style="vertical-align:top;color:rgb(95,99,104);font-size:0.75rem;letter-spacing:0.3px;line-height:20px">to <span dir="ltr" name="me" style="vertical-align:top">me</span>, <span dir="ltr" name="bucardo-general" style="vertical-align:top">bucardo-general</span></span></div><div id="m_-8003018421126858009gmail-:22l" style="display:inline-flex;margin-left:4px;vertical-align:top;border:none;outline:none"><img src="https://mail.google.com/mail/u/0/images/cleardot.gif" alt="" style="background:url("https://ci4.googleusercontent.com/proxy/nb89mgvybzzZndT14BkrHFj720uLPihffvG-uYJWQeuNOIlAaEuJX2OF5zIeJW93m-jWsL29Bj47NrnC15FWxViax_xXJyrsYcybpLzsTh6neG4exOtFrkvICM9US-nnLQGMhxz4X00a=s0-d-e1-ft#https://www.gstatic.com/images/icons/material/system/1x/arrow_drop_down_black_20dp.png") 50% 50%/20px no-repeat;padding:0px;vertical-align:baseline;height:20px;width:20px;border:none;margin:0px 0px 0px auto;display:flex;opacity:0.54"></div></td></tr></tbody></table></td></tr></tbody></table></div><div id="m_-8003018421126858009gmail-:231" style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:medium"><div></div><div></div><div></div><div></div></div><div style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:medium"><div></div><div id="m_-8003018421126858009gmail-:22m"></div><div id="m_-8003018421126858009gmail-:22z" style="font-size:0.875rem;direction:ltr;margin:8px 0px 0px;padding:0px"><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" class="gmail_quote"><span style="color:rgb(80,0,80)">> On Mar 5, 2020, at 10:27 AM, Troy Denton <<a href="mailto:tdenton@24-7intouch.com" target="_blank">tdenton@24-7intouch.com</a>> wrote:<br></span><span style="color:rgb(80,0,80)">><br></span><span style="color:rgb(80,0,80)">> > On Mar 5, 2020, at 10:13 AM, Troy Denton <<a href="mailto:tdenton@24-7intouch.com" target="_blank">tdenton@24-7intouch.com</a>> wrote:<br></span><span style="color:rgb(80,0,80)">> ><br></span><span style="color:rgb(80,0,80)">> > 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:<br></span><span style="color:rgb(80,0,80)">> ><br></span><span style="color:rgb(80,0,80)">> > bucardo add table <table> relgroup=<relgroup> db=<db><br></span><span style="color:rgb(80,0,80)">> > bucardo validate sync <the sync that uses this relgroup><br></span><span style="color:rgb(80,0,80)">> > bucardo update sync <the sync that uses this relgroup> onetimecopy=2<br></span><span style="color:rgb(80,0,80)">> > bucardo kick <the sync that uses this relgroup><br></span><span style="color:rgb(80,0,80)">> ><br></span><span style="color:rgb(80,0,80)">> > 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></span><span style="color:rgb(80,0,80)">> ><br></span><span style="color:rgb(80,0,80)">> > I've just manually transferred the data for now, but would like to know the correct process moving forward.<br></span><span style="color:rgb(80,0,80)">><br></span><span style="color:rgb(80,0,80)">> 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></span><span style="color:rgb(80,0,80)">><br></span><span style="color:rgb(80,0,80)">> Which Bucardo version?<br></span><span style="color:rgb(80,0,80)">><br></span><span style="color:rgb(80,0,80)">> 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></span><span style="color:rgb(80,0,80)">><br></span><span style="color:rgb(80,0,80)">> The error I am getting is:<br></span><span style="color:rgb(80,0,80)">><br></span><span style="color:rgb(80,0,80)">> "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.</span><span style="color:rgb(80,0,80)"><br></span>Were there any more details in the log.bucardo file or the postgresql logs?</blockquote><div><br></div><div>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:</div><div><br></div><div>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></div><div><br></div><div><br></div><div>Does this look like the correct procedure? </div><div><br></div><div>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:</div><div>(25580) [Tue Mar 10 11:44:39 2020] MCP Warning: Unknown sync to be kicked: "tndb_sync1"<br></div><div><br></div></div></div><div><div dir="ltr" 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><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Mar 6, 2020 at 2:55 PM David Christensen <<a href="mailto:david@endpoint.com" target="_blank">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">> On Mar 5, 2020, at 10:27 AM, Troy Denton <<a href="mailto:tdenton@24-7intouch.com" target="_blank">tdenton@24-7intouch.com</a>> wrote:<br>
> <br>
> > On Mar 5, 2020, at 10:13 AM, Troy Denton <<a href="mailto:tdenton@24-7intouch.com" target="_blank">tdenton@24-7intouch.com</a>> wrote:<br>
> ><br>
> > 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:<br>
> ><br>
> > bucardo add table <table> relgroup=<relgroup> db=<db><br>
> > bucardo validate sync <the sync that uses this relgroup><br>
> > bucardo update sync <the sync that uses this relgroup> onetimecopy=2<br>
> > bucardo kick <the sync that uses this relgroup><br>
> ><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>
> 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>
<br>
Were there any more details in the log.bucardo file or the postgresql logs?<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>
<br>
</blockquote></div>