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
Release : 21.2
Component :
The $SPECROOT/mysql/bin/mysqld process was 0 bytes in size.
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.