<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:0 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:10.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="en-GE" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:Helvetica;mso-fareast-language:EN-US">Hello,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:Helvetica;mso-fareast-language:EN-US">Thank you for your response.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:Helvetica;mso-fareast-language:EN-US">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></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:Helvetica;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:Helvetica;mso-fareast-language:EN-US">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:Helvetica;mso-fareast-language:EN-US">Levan<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-size:12.0pt;color:black">From:
</span></b><span style="font-size:12.0pt;color:black">Jon Jensen <jon@endpointdev.com><br>
<b>Date: </b>Friday, 24 December 2021 at 23:29<br>
<b>To: </b>bucardo-general@bucardo.org <bucardo-general@bucardo.org>, Levani Gventsadze <lgventsadze@oroinc.com><br>
<b>Subject: </b>Re: [Bucardo-general] Problem when copying big table<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt">Levani,<br>
<br>
Do you have earlier logs prior to this point? It looks to me like your <br>
ERROR: cited here is a continued transaction error state that began <br>
earlier, and this COPY is not your actual problem. Are there other ERROR: <br>
lines in your log prior to this?<br>
<br>
In any case I would not expect an INSERT to work where a COPY doesn't <br>
work. They should behave the same.<br>
<br>
Jon<br>
<br>
<br>
On Fri, 24 Dec 2021, Levani Gventsadze wrote:<br>
<br>
> Hello all,<br>
> We are having an issue with bucardo v5.6 when copying big database table.<br>
> The problem gets aborted without any useful information in the log ( we tried increasing the log level).<br>
> Here’s what we get every time we try to copy that big table:<br>
><br>
> < 2021-12-23 10:17:28.860 UTC > CONTEXT: COPY oro_product, line 521577<br>
> < 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>
,"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>
> < 2021-12-23 10:17:28.861 UTC > ERROR: current transaction is aborted, commands ignored until end of transaction block<br>
> < 2021-12-23 10:17:28.861 UTC > STATEMENT: DEALLOCATE dbdpg_p6534_2<br>
><br>
> 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>
><br>
> Does anyone have any ideas to help us identify the problem and try to solve it?<br>
><br>
><br>
> Thank you in advance.<br>
><br>
<br>
-- <br>
Jon Jensen<br>
End Point Corporation<br>
<a href="https://www.endpointdev.com/">https://www.endpointdev.com/</a><o:p></o:p></span></p>
</div>
</div>
</body>
</html>