Spectrum upgrade failure

[FlekKontrec]

Hi,

I'm using Spectrum 10.4.1 installed on 2 Windows 2016 servers (1 SS and 1 OC). I've upgraded SS successfully to v22.2.5 but OC upgrade failed. In the log files it can be seen that MySQL has been upgraded but it cannot start. I cannot start it manually either. Eventually this causes upgrade to fail.

Log files are attached.

Can you please help me find out the reason of failure?

Regards

Attachment(s)

logs.rar   158 KB 1 version

[Joseph Ackley]

There was an issue running the mysql.cus script during the install:

********** Started: Tue Apr  4 13:51:15 2023 **********
running Custom Script Install-Tools/CUS/mysql.cus
 Error(s) occurred. Please see D:/win32app/Spectrum/Install-Tools/LOGS/22.2.5.0.36_20230404/mysql.log.

Please upload a copy of the D:/win32app/Spectrum/Install-Tools/LOGS/22.2.5.0.36_20230404/mysql.log for review.

Joe

[FlekKontrec]

Here it is.

Attachment(s)

mysql.log   4 KB 1 version

[Joseph Ackley]

I see the following error in the log file:

Final attempt to reach mysql... 
**^G Error during mysqladmin --defaults-file=D:/win32app/Spectrum/mysql/my-spectrum.cnf --login-path=myclient ping

Please check out the following two knowledge articles for resolution.

https://knowledge.broadcom.com/external/article?articleId=236536
https://knowledge.broadcom.com/external/article?articleId=188298

Joe

[FlekKontrec]

First link doesn't apply because mysqld is not 0 bytes and there is no $SPECROOT/mysql/new/bin dir.
I'm checking about AV software on the server but I wouldn't say this is the issue because SS upgrade went well and MySQL was successfully upgraded.

[Joseph Ackley]

The AV may not cause an issue on one system but may on another.

As a point of general practice, AV should be disabled for the install.

Joe

[FlekKontrec]

Apart from AV, is there something else that could be the cause here?

[Joseph Ackley]

Not that I am aware of.

Is mysql running after the install?

If so, try rerunning the installation.

Joe

[FlekKontrec]

No, it's not running and it cannot be started.

[Joseph Ackley]

Unfortunately the only two things I am aware of are the ones in the knowledge articles I sent previously.

If you are running AV software, please disable it and retry the install.

Joe

[FlekKontrec]

AV software was disabled but upgrade again failed. MySQL cannot start. I'm attaching the MySQL err file, maybe it can give some clue.

Attachment(s)

oc1.err.txt   634 KB 1 version

[Joseph Ackley]

This is a different error.

Please review knowledge article https://knowledge.broadcom.com/external/article?articleId=261563 for the solution.

Joe

[FlekKontrec]

So I need to move the $SPECROOT/mysql directory to mysql_old and try to install Spectrum?

[Joseph Ackley]

Correct

[FlekKontrec]

This procedure succeeded:
1. Took a mysqldump of the reporting db in 10.4.1.
./mysqldump.exe --opt --routines --ignore-table=reporting.v_active_user_model --ignore-table=reporting.v_alarm_activity --ignore-table=reporting.v_ncm_config_diff --ignore-table=reporting.v_security_string_accessibility_by_landscape--ignore-table=reporting.v_user_report_security --compress -uroot -p<root_pw> --databases reporting > reporting_backup.sql
2. Moved the $SPECROOT/mysql directory to mysql_old and upgraded Spectrum.
3. Imported reporting db dump.
./mysql.exe -uroot -p<root_pw> reporting < reporting_backup.sql

[Joseph Ackley]

Outstanding!