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

[Barry O'Donovan (INEX)]

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
> 


-- 

Kind regards,
Barry O'Donovan
INEX

https://www.inex.ie/support/
+353 1 531 3339