MySQL upgrade failed while upgrading NFA from 9.3.6 to 9.5.0

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

NFA MySQL upgrade failed. Error message as application is upgraded but MySQL database is not upgraded.

mysql_upgrade: [ERROR] 1146: Table 'mysql.innodb_table_stats' doesn't exist

Environment

Release: 9.3.6

OS: Windows

 

Resolution

Please follow this:

https://stackoverflow.com/questions/37856155/mysql-upgrade-failed-innodb-tables-doesnt-exist

And then re rerun the MySQL upgrade.

mysql_upgrade --defaults-file="~\CA\NFA\Netflow\bin\netqosmy.ini" -P 3307 -u root --verbose --upgrade-system-tables