ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

MySQL upgrade failed while upgrading NFA from 9.3.6 to 9.5.0

book

Article ID: 145786

calendar_today

Updated On:

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:
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