<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi all, <div class=""><br class=""></div><div class="">Is good to know two things:</div><div class="">- How much RAM do you have?<div class="">- Have your seen tables sync and syncrun in Bucardo database?, Both tables are storing status of the transactions.</div><div class="">- Could you export your database from posgresql without problems?</div><div class="">- Both instances are running same postgresSQL version and have same RAM and HD capacity (or almost the same).</div><div class="">- Did you check Bucardo service logs ? They might located in /var/log/bucardo (check your installation), here you can see what is the problem internally.</div><div class="">- Did you check if time/date is the same for both Machines?</div><div class=""><br class=""></div><div class="">Try these things and tell us.</div><div class=""><br class=""></div><div class="">Cheers,</div><div class="">Manu Parra.</div><div class=""><br class=""></div><div class=""><br class="">
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">On 25 Dec 2021, at 06:30, Levani Gventsadze <<a href="mailto:lgventsadze@oroinc.com" class="">lgventsadze@oroinc.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta charset="UTF-8" class=""><div class="WordSection1" style="page: WordSection1; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><div style="margin: 0cm; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 11pt; font-family: Helvetica;" class="">Hello,<o:p class=""></o:p></span></div><div style="margin: 0cm; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 11pt; font-family: Helvetica;" class="">Thank you for your response.<o:p class=""></o:p></span></div><div style="margin: 0cm; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 11pt; font-family: Helvetica;" class="">I will need to dive in the logs and get more than these, but I doubt it will help, because the regular method (dumping the data and then importing into the database ) works without problem.<o:p class=""></o:p></span></div><div style="margin: 0cm; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 11pt; font-family: Helvetica;" class=""><o:p class=""> </o:p></span></div><div style="margin: 0cm; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 11pt; font-family: Helvetica;" class="">Regards,<o:p class=""></o:p></span></div><div style="margin: 0cm; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span lang="EN-US" style="font-size: 11pt; font-family: Helvetica;" class="">Levan<o:p class=""></o:p></span></div><div style="margin: 0cm; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 11pt;" class=""><o:p class=""> </o:p></span></div><div style="border-style: solid none none; border-top-width: 1pt; border-top-color: rgb(181, 196, 223); padding: 3pt 0cm 0cm;" class=""><p class="MsoNormal" style="margin: 0cm 0cm 12pt; font-size: 10pt; font-family: Calibri, sans-serif;"><b class=""><span style="font-size: 12pt;" class="">From:<span class="Apple-converted-space"> </span></span></b><span style="font-size: 12pt;" class="">Jon Jensen <<a href="mailto:jon@endpointdev.com" class="">jon@endpointdev.com</a>><br class=""><b class="">Date:<span class="Apple-converted-space"> </span></b>Friday, 24 December 2021 at 23:29<br class=""><b class="">To:<span class="Apple-converted-space"> </span></b><a href="mailto:bucardo-general@bucardo.org" class="">bucardo-general@bucardo.org</a> <<a href="mailto:bucardo-general@bucardo.org" class="">bucardo-general@bucardo.org</a>>, Levani Gventsadze <<a href="mailto:lgventsadze@oroinc.com" class="">lgventsadze@oroinc.com</a>><br class=""><b class="">Subject:<span class="Apple-converted-space"> </span></b>Re: [Bucardo-general] Problem when copying big table<o:p class=""></o:p></span></p></div><div class=""><div style="margin: 0cm; font-size: 10pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 11pt;" class="">Levani,<br class=""><br class="">Do you have earlier logs prior to this point? It looks to me like your<span class="Apple-converted-space"> </span><br class="">ERROR: cited here is a continued transaction error state that began<span class="Apple-converted-space"> </span><br class="">earlier, and this COPY is not your actual problem. Are there other ERROR:<span class="Apple-converted-space"> </span><br class="">lines in your log prior to this?<br class=""><br class="">In any case I would not expect an INSERT to work where a COPY doesn't<span class="Apple-converted-space"> </span><br class="">work. They should behave the same.<br class=""><br class="">Jon<br class=""><br class=""><br class="">On Fri, 24 Dec 2021, Levani Gventsadze wrote:<br class=""><br class="">> Hello all,<br class="">> We are having an issue with bucardo v5.6 when copying big database table.<br class="">> The problem gets aborted without any useful information in the log ( we tried increasing the log level).<br class="">> Here’s what we get every time we try to copy that big table:<br class="">><br class="">> < 2021-12-23 10:17:28.860 UTC > CONTEXT: COPY oro_product, line 521577<br class="">> < 2021-12-23 10:17:28.860 UTC > STATEMENT: /* Bucardo 5.6.0 */COPY public.oro_product("id","organization_id","business_unit_owner_id","primary_unit_precision_id","brand_id","inventory_status_id","attribute_family_id","sku","sku_uppercase","name","name_uppercase","created_at","updated_at","variant_fields","status","type","is_featured","is_new_arrival","pagetemplate_id","category_id","taxcode_id","manageinventory_id","highlightlowinventory_id","inventorythreshold_id","lowinventorythreshold_id","minimumquantitytoorder_id","maximumquantitytoorder_id","decrementquantity_id","backorder_id","isupcoming_id","availability_date","serialized_data","book_type_id","bn_average_rating","bn_audience_age_from","bn_audience_age_to","bn_dimension_depth","bn_dimension_height","bn_dimension_weight","bn_dimension_width","bn_retail_price","bn_bisac_format","bn_dimension_unit","bn_dimension_weight_unit","bn_tax_id","bn_company_name","bn_display_edition_description","bn_url_keywords","bn_publication_date"<br class=""> ,"bn_author_bio","bn_edition_number","bn_image_version","bn_number_of_pages","bn_work_id","bn_discountable_flag","bn_large_print_ind","bn_shippable_flag","bn_audience_id","bn_language_desc_id","bn_display_format_id","bn_parent_format_id","bn_lexile","bn_lexile_value","bn_series_id","bn_series_number","bn_series_title","bn_contributors") FROM STDIN<br class="">> < 2021-12-23 10:17:28.861 UTC > ERROR: current transaction is aborted, commands ignored until end of transaction block<br class="">> < 2021-12-23 10:17:28.861 UTC > STATEMENT: DEALLOCATE dbdpg_p6534_2<br class="">><br class="">> We see this COPY command is utilizing the Postgres COP, is there a way to use INSERT instead (I am not sure if that will help though).<br class="">><br class="">> Does anyone have any ideas to help us identify the problem and try to solve it?<br class="">><br class="">><br class="">> Thank you in advance.<br class="">><br class=""><br class="">--<span class="Apple-converted-space"> </span><br class="">Jon Jensen<br class="">End Point Corporation<br class=""><a href="https://www.endpointdev.com/" style="color: blue; text-decoration: underline;" class="">https://www.endpointdev.com/</a><o:p class=""></o:p></span></div></div></div><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">_______________________________________________</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">Bucardo-general mailing list</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class=""><a href="mailto:Bucardo-general@bucardo.org" class="">Bucardo-general@bucardo.org</a></span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class=""><a href="https://bucardo.org/mailman/listinfo/bucardo-general" class="">https://bucardo.org/mailman/listinfo/bucardo-general</a></span></div></blockquote></div><br class=""></div></body></html>