<html><body><div dir="ltr">Hi,<div><br></div><div dir="ltr">I found some issue…</div><div dir="ltr"><br></div><div dir="ltr"><pre class="note" style="margin-left:8px;word-wrap:break-word;font-size:12px">SELECT NAME, ROW_FORMAT FROM information_schema.INNODB_SYS_TABLES WHERE NAME LIKE ‘cdr%’;</pre><pre class="note" style="margin-left:8px;word-wrap:break-word;font-size:12px"><br></pre><pre class="note" style="margin-left:8px;word-wrap:break-word;font-size:12px" dir="ltr">shows that the row_format between the partitions and the new tables generated are different (dynamic vs compact respectively)</pre><pre class="note" style="margin-left:8px;word-wrap:break-word;font-size:12px" dir="ltr"><br></pre><pre class="note" style="margin-left:8px;word-wrap:break-word;font-size:12px" dir="ltr">Is that something that needs looking at?</pre><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><table border="0" cellspacing="0" cellpadding="0" width="400" style="font-family:Helvetica;width:259.8pt"><tbody><tr><td valign="top" style="padding:0in"><br></td></tr></tbody></table></div></div></div><div dir="ltr">
<br><br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On 22 Aug 2021 at 2:14:42 AM, Walter Klomp <<a href="mailto:walter@myrepublic.net">walter@myrepublic.net</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">
<div dir="ltr">Hi,<div><br></div><div>I have upgraded from mr6.5.8 to mr8.5.4 a few months back but it seems the cleanup script doesn't work anymore. I did not see any cdr-files created anymore in /var/backup/cdr. so I ran the following:</div><div><br></div><div>root@sipwise-8:/var/backup# ngcp-cleanup-acc<br>ERROR error: Cannot exchange partition cdr_tag_data -> cdr_tag_data_202103: Non matching attribute 'ROW_FORMAT' between partition and table at /usr/share/perl5/NGCP/Cleanup.pm line 453.</div><div><br></div><div>I checked in MySQL and the table was there, and empty. So I dropped cdr_tag_data_202103 and recreated it with the command create table cdr_tag_data_202103 like cdr_tag_data;</div><div>then I ran the command again, and I see the following error... So I am guessing something is going wrong with the cleanup script?</div><div> </div><div>root@sipwise-8:/var/backup# ngcp-cleanup-acc<br>INFO backup_partition: table cdr_tag_data_202103 already exists, fallback to the table backup method<br>ERROR error: Cannot exchange partition cdr_mos_data -> cdr_mos_data_202103: Non matching attribute 'ROW_FORMAT' between partition and table at /usr/share/perl5/NGCP/Cleanup.pm line 453.</div><div><br></div><div>by the way, now the cdr_tag_data_202103 is filled with data</div><div>but cdr_mos_data_202103 is empty</div><div><br></div><div>Any suggestions, or is this a known bug?</div><div><br><div>Thanks</div><div>Walter</div><div><br></div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"></div></div></div>
</blockquote>
</div>
</div>
</div></div></body></html>
<br>
<span style="color:rgb(34,34,34);font-family:sans-serif;background-color:rgb(255,255,255)"><font size="1"><span style="font-family:Arial;color:rgb(102,102,102);font-style:italic;vertical-align:baseline;white-space:pre-wrap">The contents of this email and any attachments are confidential and may also be privileged. You must not disseminate the contents of this email and any attachments without permission of the sender. If you have received this email by mistake, please delete all copies and inform the sender immediately. You may refer to our company's Privacy Policy </span><span style="color:rgb(102,102,102);font-family:Arial;font-style:italic;vertical-align:baseline;white-space:pre-wrap"><a href="https://myrepublic.net/sg/legal/terms-of-use-policies/privacy-policy/" target="_blank">here</a></span><span style="font-family:Arial;color:rgb(102,102,102);font-style:italic;vertical-align:baseline;white-space:pre-wrap">.</span></font></span>