The upgrade of CABI 7.1.1 to 7.9.1.x is stalled on MySQL upgrade stage

Products

• DX NetOps

Issue/Introduction

When upgrading a CABI machine that uses MySQL as a local data repository, the installation can be stuck during the MySQL upgrade phase.

This problem can happen if using both GUI or silent installation methods.

Environment

Release : CABI 7.9.1.x

Cause

Looking at the CABI installation log file created in /tmp directory (CABusinessIntelligence_install_yyyy_mm_dd_hh_mm_ss.log) during the installation, we can see thay the installation process is waiting for an external info input:

------------------------------
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 - check-dbtype-for-upgrade-pro:
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 - 
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 - do-install-upgrade-test:
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 -      [echo] Checking DBMS host and port:
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 -      [echo] About to validate port: localhost:3306
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 -      [echo]   Port 3306 is OK
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 -      [echo] Done validating port: localhost:3306
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 -      [echo] Validating administrative database connection at jdbc:mysql://localhost:3306/mysql. Phase: [test]
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 - [advanced-sql] Executing commands
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 - [advanced-sql] 1 of 1 SQL statements executed successfully
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 -      [echo] Connection OK
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 -      [echo] Validating JasperServer database connection at jdbc:mysql://localhost:3306/jasperserver?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true&tinyInt1isBit=false. Phase: [test]
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 - [advanced-sql] Executing commands
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 - [advanced-sql] 1 of 1 SQL statements executed successfully
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 -      [echo] Connection OK
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 - 
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 - do-pre-upgrade-test:
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 - 
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 - pre-upgrade-test-pro:
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 - 
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 - upgrade-js-pro-db-minimal:
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 - 
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 - upgrade-7.5-7.8-pro:
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 -      [echo]  
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 -      [echo]  currentSqlDir = /install/Cabi791/buildomatic/install_resources/sql/mysql 
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 -      [echo]  dbType = mysql 
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 -      [echo]  
2022-10-06 13:44:24 INFO  JasperInstaller.conditionCheck():201 -     [input] This operation may not be rolled back. Enter 'y' to continue or 'n' to cancel the upgrade operation. Default is 'n' (y, [n])
------------------------------

Resolution

The MySQL support requires additional validation and fixing the installer. This is already planned to be available in the next CABI version to be released.