[Spce-user] Cleanup.pl script broken in mr8.5.4 ?

[Walter Klomp]

Hi,

I found some issue…

SELECT NAME, ROW_FORMAT FROM information_schema.INNODB_SYS_TABLES
WHERE NAME LIKE ‘cdr%’;


shows that the row_format between the partitions and the new tables
generated are different  (dynamic vs compact respectively)


Is that something that needs looking at?




On 22 Aug 2021 at 2:14:42 AM, Walter Klomp <walter at myrepublic.net> wrote:

> Hi,
>
> 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:
>
> root at sipwise-8:/var/backup# ngcp-cleanup-acc
> 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.
>
> 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;
> then I ran the command again, and I see the following error... So I am
> guessing something is going wrong with the cleanup script?
>
> root at sipwise-8:/var/backup# ngcp-cleanup-acc
> INFO  backup_partition: table cdr_tag_data_202103 already exists, fallback
> to the table backup method
> 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.
>
> by the way, now the cdr_tag_data_202103 is filled with data
> but cdr_mos_data_202103 is empty
>
> Any suggestions, or is this a known bug?
>
> Thanks
> Walter
>
>

-- 
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 here 
<https://myrepublic.net/sg/legal/terms-of-use-policies/privacy-policy/>.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20210822/9710fdcc/attachment-0002.html>