Spectrum SRM Upgrade failed due to mysql.cus
search cancel

Spectrum SRM Upgrade failed due to mysql.cus

book

Article ID: 236536

calendar_today

Updated On:

Products

CA Spectrum DX NetOps

Issue/Introduction

After upgrading Spectrum OneClick Report Manager SRM box, mysql is not working

We see this in the logs:

This is in the tomcat log:

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Mar 07, 2022 19:38:18.444 - Could not initialize MySQL connection, retry in 5 seconds: Communications link failure

This is in the MYSQL.OUT:

Couldn't exec process: /opt/CA/Spectrum/mysql/bin//mysqld: Exec format error

This is in the install log:

********** Started: Mon Mar  7 18:40:51 2022 **********
running Custom Script Install-Tools/CUS/mysql.cus
 Error(s) occurred. Please see /opt/CA/Spectrum/Install-Tools/LOGS/21.2.8.0.32_20220307/mysql.log.

Script Install-Tools/CUS/mysql.cus has FAILED

This is in the mysql.log:

******* Upgrading mysql *******

 stop_mysqld --login-path=myclient
Shutting down mysqld...
******* Starting mysql *******
 wait_for_mysql_to_actually_startup upgrade mysql --login-path=myclient
Waiting for mysql to start up... --login-path=myclient
Waiting for mysql to start up... try count 1 
.....
Waiting for mysql to start up... try count 50 
Final attempt to reach mysql... 
**^G Error during mysqladmin --defaults-file=/opt/CA/Spectrum/mysql/my-spectrum.cnf --login-path=myclient ping

Environment

Release : 21.2

Component :

Cause

The $SPECROOT/mysql/bin/mysqld process was 0 bytes in size.

Resolution

You need to copy the contents of the installer to the original directory.  To do that:

1.  Rename or delete the $SPECROOT/mysq/bin directory.
2.  Create the $SPECROOT/mysql/bin directory
3.  Copy the contents of $SPECROOT/mysql/new/bin to $SPECROOT/mysql/bin
4.  Run the installer again.

Optionally, you can copy the contents of $SPECROOT/mysql/bin from an already upgraded and working server.