Upgrade from 14.0.0 to 14.0.5 fails for database version

[Federica Santillo]

Hi team,

 

When upgrading Spotfire Server from 14.0.0 to 14.0.5 the Server fails to start because the database version does not get updated as required.

We have a deployment through Helm, so the upgrade is performed without running the upgradetool but directly changing the image version in the values.yaml.

Any help?

Here the error trace:

Spotfire Server 14.0.5 LTS (Build Version: 74.5.15312.57819, Build Date: 2024-09-12, Build ID: 58b27d9, Database Schema Version: 494) 2024-11-27T12:54:59.398842307+04:00 Using log configuration file logging-debug.properties 2024-11-27T12:54:59.404392629+04:00 Using hostname: 172.22.206.230 2024-11-27T12:55:02.139358403+04:00 Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

Error connecting to the specified data source: Trying to connect to a database with an incompatible version. 2024-11-27T12:56:05.373507011+04:00 The detected database schema version is: '493'. 2024-11-27T12:56:05.373517249+04:00 The required database schema version is: '494'.

 

If I try to manually change the SN_VERSION inside the database from 493 to 494 the Server starts fine.

Edited Thursday at 09:27 AM by Federica Santillo