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

[Walter Klomp]

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/a7ded393/attachment.html>