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.

CA performnace center upgrade fails

book

Article ID: 238111

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration

Issue/Introduction

we just did an upgrade from 21.2.2 to 21.2.9 on our production systems, but the Performance center install failed.

(in Performance_Center_Install log)

FATAL ERROR -     class com.ca.im.installanywhere.action.GenerateInstallFailure FatalInstallException: MySql is not running.

(in post_mysql_upgrade log)

Exception: com.ca.im.installanywhere.util.DbMigrateException: Unable to open database connection: (jdbc:mysql://localhost:3306/mysql?

 

 

 

 

Cause

The PostMysqlUpgrade step failed, as it could not connect to the MySql database

 

Environment

Release : 21.2.9

Component :

Resolution

Make sure you can login to the MySql database as both root and netqos, with the same password

if you are not able to, mysql may be hung. kill pid for mysql and then start mysql again

Rerun postmysqlupgrade as follows

Make sure all PC services are down except mysql.

Run
/opt/CA/PerformanceCenter/Tools/bin/npcshell.sh postmysqlupgrade --production --dbhost localhost --dbport 3306 --dbuser 'root' --origDbPass 'MyPasswordHere' --dbpass 'MyPasswordHere' --log /opt/CA/PerformanceCenter/InstallLogs/post_mysql_upgrade.log.

Once successful rerun the upgrade using CAPerformanceCenter.bin