Cannot show quota information with "Error: Unable to retrieve limits information." after upgrading VIO from 5.x to 7.0
book
Article ID: 321794
calendar_today
Updated On:
Products
VMwareVMware Integrated OpenStack
Issue/Introduction
Symptoms:
In opening Horizon GUI, quota information in top view for a project cannot be displayed with "Error: Unable to retrieve limits information."
In running "openstack quota list --project PROJECT --network --detail", you get an error "Request Failed: internal server error while processing your request."
This issue is caused by remaining entries for FWaaSv1 on neutron.quotas table. In addition to 'firewall', the following records might be also problematic: member, pool, loadbalancer, listener and healthmonitor.
Resolution
This is a known issue in upgrading VIO.
Workaround: This issue can be fixed by deleting unnecessary entries from neutron.quotas table. For example, the following steps are needed in the above case:
Login to mariadb: osctl exec -it mariadb-server-0 -- mysql --defaults-file=/etc/mysql/admin_user.cnf
Use neutron table in mariadb: use neutron;
Check the current table: select * from quotas;
Delete entries: delete from quotas where resource='firewall';
Additional Information
Impact/Risks: Warning: This procedure modifies the database. Ensure to take a backup of the deployment before proceeding. See Backup and Restore