[ixpmanager] IXPManager v6.0.0 - Issue with mysql backup

[Marinos Dimolianis]

Hi Barry,

Removing MySQL views fixed our issue.

Thank you,

Marinos

On 1/19/2022 1:13 PM, Barry O'Donovan (INEX) wrote:
> Hi Marinos,
>
> it sounds like your views are out of date. E.g. see step 11 here:
>
> https://docs.ixpmanager.org/install/upgrading/
>
> (and similar for previous upgrade instructions for older versions of 
> IXP Manager).
>
> We've been removing a lot of legacy code that uses these are are about 
> 95+% done. You can safely drop those views:
>
> | view_cust_current_active             |
> | view_switch_details_by_custid        |
> | view_vlaninterface_details_by_custid |
>
> They are just MySQL VIEW queries and contain no data. You can then use 
> the instructions per step 11 above to recreate.
>
>  - Barry
>
>
>
> Marinos Dimolianis via ixpmanager wrote on 19/01/2022 10:39:
>> Hi all,
>> We recently upgraded from v5.8 to v6.0.0 and we bumped into a very 
>> strange issue with regards to the database backup process.
>>
>> Specifically, using the backup notes available in the IXPM website 
>> (https://docs.ixpmanager.org/usage/operational-notes/#backup-ixp-manager) 
>> mysqldump command returns the following error:
>>
>> /mysqldump: Couldn't execute 'SHOW FIELDS FROM 
>> `view_cust_current_active`': View 
>> 'ixpmanager6.view_cust_current_active' references invalid table(s) or 
>> column(s) or function(s) or definer/invoker of view lack rights to 
>> use them (1356)/
>>
>> Note that we didn't face any issue during the upgrade process. The 
>> most strange thing is that executing the same command for the 
>> database we used in IXPMv5.8 operates fine.
>>
>> Just to mention that before the upgrade backing up our database 
>> didn't provide any issues.
>>
>> Do you have any ideas since this issue doesn't allow us to correctly 
>> back up our database.
>>
>> P.S.
>>
>> Server version: 8.0.27 MySQL Community Server - GPL
>>
>> Kind Regards,
>>
>> Marinos
>>
>>
>>
>>
>>
>> _______________________________________________
>> INEX IXP Manager mailing list
>> ixpmanager at inex.ie
>> Unsubscribe or change options here: 
>> https://www.inex.ie/mailman/listinfo/ixpmanager
>>
>
>