MySQL upgrade fails when upgrading CA Performance Center

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration

Issue/Introduction

As part of the upgrade, mysqld_upgade can fail to run as the mysql root password is not being properly password to the mysqld_upgrade command.  The following error would be seen in the /opt/CA/MySql/data/<hostname>.err file

2019-09-07T01:06:36.590921Z 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2019-09-07T01:06:36.590926Z 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2019-09-07T01:06:36.590949Z 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2019-09-07T01:06:36.590955Z 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade

Environment

Release : 3.7.0, 3.7.1, 3.7.2

Component : CA Performance Center

Cause

The mysql root password is not being properly password to the mysqld_upgrade during the upgrade to CA Performance Center 3.7.0, 3.7.1, or 3.7.2 from versions lower than 3.7.0

Resolution

1) Back up Performance Center per the documentaion:

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/performance-management/3-7/administrating/performance-center-administration/back-up-performance-center.html

2) Stop the CAPC services:

service caperfcenter_console stop

service caperfcenter_devicemanger stop

service caperfcenter_eventmanger stop

service caperfcenter_sso stop

3) Run:

/opt/CA/MySql/bin/mysql_upgrade -uroot -pnetqos --force

4) Start the CAPC services:

service caperfcenter_sso start

service caperfcenter_eventmanger start

service caperfcenter_devicemanger start

service caperfcenter_console start